Aggregating data from Excel

(0) Share

Report

Posted on by Community Power Pla...

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:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

v-yujincui-msft on at

Like (0)

Report
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