Merge Multiple Excel Files - Workflow Screenshots

Screenshots / Diagrams

Flow Overview

Merge Multiple Excel Files - Workflow Overview

1. List Folder Get Files From Source Folder

List Folder Get Files From Source Folder

2. Filter Array Source Files

and(

  endsWith(item()?['Name'], '.xlsx'),

  not(startsWith(item()?['Name'], '~$'))

)

Filter Array Source Files

3. Apply To Each Filtered Excel

Apply To Each Filtered Excel

3.1. Apply To Each Filtered Excel - Degree of parallelism

Apply To Each Filtered Excel - Degree of parallelism

4. Compose Excel File Path

Compose Excel File Path

5. Get Tables From Excel Item

Get Tables From Excel Item

6. Condition Length Check

Condition Length Check

7. Apply To Each Table In Filtered Excel

Apply To Each Table In Filtered Excel

7.1. Apply To Each Table In Filtered Excel - Degree of parallelism

Apply To Each Table In Filtered Excel - Degree of parallelism

8. List Rows Present In A Table

List Rows Present In A Table

9. Apply To Each List Row

Apply To Each List Row

9.1. Apply To Each List Row - Degree of parallelism

Apply To Each List Row - Degree of parallelism

10. Compose List Rows

Compose List Rows

11. Add A Row Into A Master Excel Table

Add A Row Into A Master Excel Table

11.1. Add A Row Into A Master Excel Table

Add A Row Into A Master Excel Table

12. Environment Variables

Environment Variables

Display name	Schema Name	What it is / Example	Notes
EV_DestinationDocLib	sp_EV_DestinationDocLib	b!qInsudMRb0SsEejTlwqoXN03YlQxo7FNvUwhwy7oH0Il-KHA-N0EQY9WrgeqxUzS	Destination Document Library Drive ID
EV_DestinationSiteUrl	sp_EV_DestinationSiteUrl	https://<tenant>.sharepoint.com/sites/site	No trailing slash. Site hosting the master workbook.
EV_MasterFilePath	sp_EV_MasterFilePath	/Shared Documents/MasterFiles/Master.xlsx	Server‑relative path to the master file.
EV_MasterTableName	sp_EV_MasterTableName	Table1	Single target table in the master workbook.
EV_SourceFolder	sp_EV_SourceFolder	%252fShared%2bDocuments%252fSourceFiles	Use internal folder identifier from Peek code (not plain path /Shared…).
EV_SrcDocLib	sp_EV_SrcDocLib	b!qInsudMRb0SsEejTlwqoXN03YlQxo7FNvUwhwy7oH0Il-KHA-N0EQY9WrgeqxUzS	Source Document Library Drive ID
EV_SrcSiteUrl	sp_EV_SrcSiteUrl	https://<tenant>.sharepoint.com/sites/site	No trailing slash. Site hosting the source files.

Peek Code/Code View for EV_SourceFolder

To get the actual values, provide actual Location/Site Address, File Identifier/Document Library in Parameters and get the actual details in Code view.

Peek Code/View Code for EV_SourceFolder

Peek Code/Code View for EV_SrcDocLib (Document Library Drive ID for both Source/Destination)- follow same method.

Peek Code For EV Source Document Library