Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
Expand all | Collapse all

Configure SharePoint folder link in Flow Email body

Jump to Best Answer
  • 1.  Configure SharePoint folder link in Flow Email body

    Gold Contributor
    Posted Jan 30, 2021 01:57 PM
    Hi there,
    I have three flows where I need to send an email to the Requestor and others when their request has been Approved, Declined or approval timed out. I use a Compose statement to create the link to the folder and this works great when I add it to Approval Email actions "Item Link" - use the Output from Compose. Here is my Expression:
    substring(outputs('Get_CBR_properties')?['body/{Link}'],0,lastIndexOf(outputs('Get_CBR_properties')?['body/{Link}'],'/'))

    When I add it to the email body using HTML, however, it gets flaky. Here is how I format it in the email body:
    <a href="<OUTPUT>">Link to CBR and Supplemental Files</a>

    In many of the emails it's working great. However, in some of them, I've noticed after I have saved the Flow and go back to the body of the email these extra characters get added somehow and the URL breaks. Extra characters:
    "&lt;object custom="></a>

    I've tried both Chrome and Edge. I've tried disabling and enabling Experimental features. I keep having to change the email body HTML and it keeps breaking. Any advice? I need the link to the entire Folder, not just a link to the item.



    ------------------------------
    Beth Beck
    O365 Business Analyst
    Fort Myers FL
    ------------------------------


  • 2.  RE: Configure SharePoint folder link in Flow Email body
    Best Answer

    Gold Contributor
    Posted Jan 31, 2021 09:57 AM
    UPDATE - I found a workaround. See the resonse from "katika" in this post - Send Email (V2) Preview does not add hyperlinks to... - Page 4 - Power Platform Community (microsoft.com) It was posted approximately a week ago.


    ------------------------------
    Beth Beck
    O365 Business Analyst
    Fort Myers FL
    ------------------------------