Dynamic file read from Document library and Process to Sharepoint list using Power Automate

[suriyamv07]

Hi All,

Below is my case scenario,

Input file: File format : Excel which is available in different document library folder. Excel is in .XLSX format, but i doesn't have Table format in it.

Consider, i have 3 document library.

Document library folder 1 - Having excel file with different name and set of people will place file over here.

Document library folder 2 - Having excel file with different name and different set of people will place file.

Document library folder 3 - Excel will be placed by 3rd set of people. 

Expected solution: I need to create Scheduled flow to read all the placed files from different folder and create table and process data to Master excel sheet which is available in "Document library folder Master". Is it possible to read the excel with dynamic name and create table and place data in master excel sheet? 

Thanks.

[C-Papa]

Hi, you can't dynamically change the data source. Sounds like you would need to run a PowerAutomate to collect the data from each spreadsheet and override a master spreadsheet with the combined data. Then link to the master spreadsheet only. The other solution would be to not create addition spreadsheets with different names, instead add a new column to the spreadsheet and input the name of what you would have called the spreadsheet into each corresponding row. then when it collects into PowerApps you can read all the data in from 1 spreadsheet and also filter based on the original spreadsheet name.