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

Question

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.

Answer 1

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.