I have been able to do a for each and create shared links for all files in a sharepoint folder based on the ID property.
Where I am struggling is to take that output and update an excel file row so that each row gets a unique output. E.G I have an excel table with lets say 5 rows and 5 columns. All columns have an assigned name and there is a table present called Table 1.
Columns 1-4 have some form of data already input into them so it is strictly column 5 I need to update.
What my goal is for this process is to take the link that is created in the for each loop and update the empty cell in column 5 and then move to the next row and apply the next link.
I've been able to create a flow that will apply the first link to all rows in the column but then the flow continues and then the second link is applied to each row overwriting the previous entry and this goes on until all of the links gathered in the first loop are in each row.
Share
Report
All responses (
Answers (
53,442
