
Announcements
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!
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