Power Automate Specialist Needed -- 2
Budget: $10 – $30 CAD
I want to create a flow that runs when someone submits a Microsoft Form called “PCARD Receipt Submission.” The form includes a file upload question for a receipt.
I want to capture the exact file uploaded by the responder and generate a direct viewable link to that specific file — not the parent folder.
Then, I want to log the form responses plus that direct file link into an Excel table stored in my OneDrive.
I do not have premium features, so I cannot use "Sort array" or premium connectors. I also do not have access to “Link to item” in dynamic content.
The uploaded file is saved in this folder:
https://toysrusca-my.sharepoint.com/:f:/g/personal/spadafoa_toysrus_ca/EnlWVosHd0JGkqVVIo22KZIBeinyhIU4xddKpGz3Qkc2jw
I want the flow to grab the file name from the form, and manually stitch the file link together using this format:
https://toysrusca-my.sharepoint.com/:b:/g/personal/spadafoa_toysrus_ca/EnlWVosHd0JGkqVVIo22KZIBeinyhIU4xddKpGz3Qkc2jw/{filename}
Please show me how to build this step by step without looping, without premium features, and make sure the link points directly to the file uploaded — not to the folder.
I want to capture the exact file uploaded by the responder and generate a direct viewable link to that specific file — not the parent folder.
Then, I want to log the form responses plus that direct file link into an Excel table stored in my OneDrive.
I do not have premium features, so I cannot use "Sort array" or premium connectors. I also do not have access to “Link to item” in dynamic content.
The uploaded file is saved in this folder:
https://toysrusca-my.sharepoint.com/:f:/g/personal/spadafoa_toysrus_ca/EnlWVosHd0JGkqVVIo22KZIBeinyhIU4xddKpGz3Qkc2jw
I want the flow to grab the file name from the form, and manually stitch the file link together using this format:
https://toysrusca-my.sharepoint.com/:b:/g/personal/spadafoa_toysrus_ca/EnlWVosHd0JGkqVVIo22KZIBeinyhIU4xddKpGz3Qkc2jw/{filename}
Please show me how to build this step by step without looping, without premium features, and make sure the link points directly to the file uploaded — not to the folder.