How to get link from upload in MS Forms for email?

Vanessa 351 Reputation points
2024-06-12T21:57:24.1333333+00:00

I am using Power Automate to send an email with the responses and a link to the document from my MS Form.

The document link renders as:
[{"name":"testfile_NAME.docx","link":"https://xxxxxxx.sharepoint.com/sites/xxxxxxx/_layouts/15/Doc.aspx?sourcedoc=%7B7A8E4B7D-4849-4082-85D2-BDF5A5DF0EC0%7D&file=testfile&action=default&mobileredirect=true","id":"01ZZ2TZRD5JOHHUSKIQJAILUV56WS56DWA","type":null,"size":18394,"referenceId":"01ZZ2TZREBA2MBXT2ZJ5DJ2SLL3V4EM5TD","driveId":"b!2mlDgBuHy0GiXTUeWUbtDCgfu7_s9YFOu5JqnbUIWO-9I1sgaz-STJFxHtz7p_JV","status":1,"uploadSessionUrl":null}]

How to I extract just the link to put into the email?

Thanks.

SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
545 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yanli Jiang - MSFT 23,186 Reputation points Microsoft Vendor
    2024-06-13T05:35:04.12+00:00

    Hi @Vanessa ,

    According to your description, the issue is more related to Power Automate.

    Since Power Automate is currently not supported in the Q&A forum. I found a related post for your reference:

    https://powerusers.microsoft.com/t5/Building-Flows/Get-all-URL-of-uploaded-files-in-MS-Form-to-a-column-in/m-p/1999804

    If you still confuse about this issue, please start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.

    Thank you for your support and understanding!


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful