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