News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Consolidade excel Spre...

Power Automate - Building Flows

Unanswered

Consolidade excel Spreadsheet

(0) Share

Report

Report

Posted on by JONASNOGUEIRA

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.

fluxo consolidar.JPG

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?

All responses Img

All responses (1)

Answers Img

Answers (0)

_Stella_ 63 on at

Like (0)

Report

Re: Consolidade excel Spreadsheet

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? 🙂

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans