I have recently began using power automate, primarily to export survey responses directly into a Sharepoint hosted excel file.

I created a simple automation with the following path:

1. [MS Forms] When a response is submitted (This is the automate trigger)

2. [MS Forms] Get response details (Collects the response in full)

3. [MS Excel] Add a row into a table (Adds a row and populates the table with the response)

4. [MS Outlook] Send an email (Notifies me with link to the excel table)

Within the form, I have the option for a user to upload a file within the response, this is usually a word document or a PDF document. This document is hosted on Sharepoint and we are provided with a URL to access the file.

However, within the excel file, the data is populated to the cell as below:

[{"name":"DOCUMENT NAME.docx","link":"FILE PATH URL","driveId":"DRIVE ID","status":1,"uploadSessionUrl":null}]

Is it possible to add and expression to my automation, which would only append the URL of the uploaded file within the excel table, example below:

"link":"FILE PATH URL"

Thank you for your help.

I have not attempted solution yet, as I’m not sure what to do.