You’re offline. This is a read only version of the page.
Announcements
Hello. I have several spreadsheets in a Teams folder (sharepoint) in the branches and I need to consolidate all this information into just 1 main spreadsheet in another folder.
To solve this I created an automated flow "when a file is created or modified (properties only). I inserted a new step to: "Get files (properties only)" and then I entered: "Apply to every". I couldn't move forward.
I need to insert rows from each worksheet into the main worksheet.
After that, I need to create an automated flow to reuse these same steps to consolidate spreadsheets into other Sharepoint folders.
Please can anyone help me?
Dear @JONASNOGUEIRA , maybe your flow needs to look something like that:
You first have to load the excel rows you want to publish in your "master spreadsheet" and then for each of these rows create a new row in the "master spreadsheet" via "add a row into a table".
Does this help you? 🙂
Share
Report
All responses (
Answers (
63
