web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Aggregating data from ...

Power Automate

Unanswered

Aggregating data from Excel

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

This is my first time using Power Automate, and I'm trying to create (what I hope to be) a pretty simple flow. Was wondering if someone could help me out?

What I'm trying to do:

- Open all excel files in a specific folder

- Grab specific data from each excel file

- copy data into new excel file

- Save Excel file

Any chance someone here could take me through how to get this done? Thank you so much!

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please tell me the data structure is the same for all excel files? If not, I think this requirement is difficult to achieve.

I have made a test for your reference, but based on the premise that all excel files have exactly the same data structure and table names.
1. Here are my excel files.
2. Create a flow.
item()?['YourColumnName']
Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No

Join the conversation