I have a flow that collects responses from a Form and populates the information in a spreadsheet. The form includes three questions to upload attachments, two are required and one is optional. The documents drop into a SharePoint library and I'm adding hyperlinks in the spreadsheet to access them. It took me a while, but I finally figured out how to parse the JSON for the attachments and accommodate the optional item. The flow is working as intended. The only piece I'm struggling with is that I've discovered all the hyperlinks point to the same document in the library, regardless of which parsing action I link them to.
Below is a screenshot of the flow as well as the action linking the form inputs with the excel fields. For the three attachments, I selected "Body link" from the appropriate Parse JSON action; however, when I click on the links in the spreadsheet all three call the same document, the last one that was input on the form. I'm not sure what I'm missing here so any help would be appreciated. Couple things to note - when I click on "Body link" the expression in the action changes to "Link". Also, when I added the "Link" to the action Power Automate automatically added the "For Each" actions and nested them. I tried to move the " For Each" actions directly under their respective Parse JSON actions and un-nest them, but then the flow failed. Not sure if these are factors or not.
6
Share
Report
All responses (
Answers (
