Hi @Mketcham6
Thank you for posting.
According to your description, you want to populate pdf hyperlink in Excel from Forms file submission.
I created a Flow can achieve it, you can refer to the screenshots as below:
This is my Form
Flow in details:
Please copy the following code into the Schema of Parse JSON：
{ "type": "array", "items": { "type": "object", "properties": { "name": { "type": "string" }, "link": { "type": "string" }, "id": { "type": "string" }, "type": {}, "size": { "type": "integer" }, "referenceId": { "type": "string" }, "driveId": { "type": "string" }, "status": { "type": "integer" }, "uploadSessionUrl": {} }, "required": [ "name", "link", "id", "type", "size", "referenceId", "driveId", "status", "uploadSessionUrl" ] } }
Greate share link by path from OneDrive for Business. The new folder for the Form named ‘Test File Upload’ is created at the path as shown in the screenshot below.
After selecting the folder path, use the following expression to access the file name:
Expression: first(body('Parse_JSON'))?['name']
Add a row into a table, fill in the Web URL to the corresponding cell.
When a new form is submitted as below:
The new row will be added into the excel with file link:
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
