Extract data from multiple excel files

(0) Share

Report

Posted on by Dsa2

101

Hi ,

I want to extract data from all the Excel files in a folder on SharePoint. A new file is added to the folder every month. I have a master file and I'm planning to extracting data from all the files and putting it in a master file table. . Can you help me to create a flow for this one ?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Dsa2 ,

Do you want to extract data from all the excel files in a folder?
If all files have the same table structure, i have made a test for your reference.
1. Here is my master excel table.
2. Here are other excel tables.
3. Here is my Flow.
items('Apply_to_each_2')?['Item']
items('Apply_to_each_2')?['ItemID']
items('Apply_to_each_2')?['columnname']
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
ScottFellows 4 on at

Like (1)

Report
Copy link

Link copied!

Hi

I am trying to do this but the second Apply to Each isn’t showing dynamic content for Values or the column data to add. Any ideas how to fix this?

Was this reply helpful? Yes No
Vaibhav_k on at

Like (1)

Report
Copy link

Link copied!

@ScottFellows I am facing same problem. Was this fixed for you?

Was this reply helpful? Yes No
Jaozau 4 on at

Like (0)

Report
Copy link

Link copied!

@ScottFellows @Vaibhav_k @Dsa2 i'm facing the same problem with the 2nd apply to each...
did you guys solved it ? pls can you help me ?

Was this reply helpful? Yes No
RajeshG1231 4 on at

Like (0)

Report
Copy link

Link copied!
I'll help you if you can help me lol. I think this a function he is creating when he says. it turns into an excel connector after you run it.
items('Apply_to_each_2')?['Item']
my issue is "Table1" in List Rows. i cant get it to pull up. I can use a custom value but is this right?

Was this reply helpful? Yes No