Get Same-name tables from multiple excel files

(0) Share

Report

Posted on by Sgav1

I have a SharePoint folder where there are a bunch of excel files, with some getting archived out of the folder and new ones being added in. All of these excel files are formatted the same and have identically formatted tables named the same way (i.e. all excel files have Table1, Table2, Table3, etc.).

I want to be able to loop through all excel files in the folder, and depending on a value provided by a user in a form response, add a row to the appropriate table in the appropriate file. The part I'm struggling with is looping through all the excel files and getting the correct table. Namely, the "Add a row into a table" and "List rows present in a table" actions require providing the specific file url/information for a single file, which doesn't work for me because I need to loop through all files and there are new files being added in and old files being removed.

Does anyone know of a solution for this?