You cannot use “List rows present in a table” with a file picker because it only allows one file. To merge multiple spreadsheets, you must use the file Identifier dynamically inside a loop.
High‑level flow:
1)List files in folder (get all .xlsx in the source folder)
2)For each file
2.1) Get tables (returns the Excel tables in that file)
2.2) For each table
→ List rows present in a table (dynamic file Identifier + target Table Id)
→ Apply to each row → Add a row into a table (master workbook)
This works because Excel actions accept a File Identifier when placed inside a loop; you don’t use the static file picker. Microsoft notes that the Excel connectors require a file identifier for dynamic scenarios and that you should resolve it from the file you’re looping over.
Detailed Steps:
1)List files in folder (SharePoint)
Site Address: Your site
Library: Documents (or your library)
Folder: /Your/Subfolder
(Optional) Add a Filter array after this to keep only .xlsx and skip ~$ temp files.
2)Apply to each → value (from List files in folder)
Inside this loop:
2.1 Get tables (Excel Online (Business))
Location: OneDrive for Business or SharePoint Sites (where your files live)
Document Library: same as above
File: Identifier → use the Identifier from the current file (Dynamic content: Identifier)
Don’t use the picker; pick Identifier from the “List files in folder” item.
2.2 Apply to each → value (from Get tables)
Inside this inner loop:
2.2.1 List rows present in a table (Excel Online (Business))
Location / Document Library: same as above
File: Identifier (again, from the outer “List files in folder” loop item)
Table: Id (from the Get tables action)
Pagination: On if you expect >256 rows; set threshold high enough (e.g., 100000). Microsoft documents the default 256‑row cap and other limits (500 columns, simple filters only). [help.lexia...arning.com]
2.2.2 Apply to each → value (from List rows present in a table)
Add a row into a table (Excel Online (Business))
Location / Library: where your MasterFile.xlsx lives
File: pick the master workbook (static—this one can be the picker)
Table: MasterTableName
Map each target column to the current item’s columns (from the row dynamic content).
Why “Get tables”? Some files may have more than one table—or different table names. “Get tables” returns the table Id list per file so you don’t hardcode. That Id is the only stable way to feed List rows present in a table dynamically.
✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.
