Skip to main content

Notifications

Community site session details

Community site session details

Session Id : UAv7ZD3kDeieSnLa78k6AR
Power Automate - Building Flows
Unanswered

Merge two tables into one table by Automate doesn't work

Like (0) ShareShare
ReportReport
Posted on 5 Sep 2023 09:05:22 by 112

Hi dear all,

There are two table in one Excel and I would like to merge two tables into one as below.

SampleSample

I built a flow as below and seems run history worked. But the table is not merged.Does anyone know how to solve?

flow1.JPGflow2.JPG

  • SanmeshG Profile Picture
    1,938 Super User 2025 Season 1 on 06 Sep 2023 at 13:28:22
    Re: Merge two tables into one table by Automate doesn't work

    Hi @Glueck  ,

     

    If your table headers are fixed you can create a template file with the headers create a new file with the headers and avoid the create table action in your flow.

    After that you have to iterate over the array that you are getting from the Select operation.

     

    So , after Select operation use an apply to each loop , add the select array into it add a compose action inside it and write item(). The compose action is optional , this compose will show you the data that you are trying to add. Now after the compose you can use the action add a row and pass the same object(row) or use output of compose action in that array.

     

    Refer the below screenshot.

     

    1.png

    The Add a row action takes time to execute based on how many objects are there in your array. If you have a large dataset then you can consider using office script and adding the data to a blank excel file , refer the below link for more details.

     

    https://www.youtube.com/watch?v=4g8Lh0gzEnc

     

    Hope this helps!

    Thanks,

    Sanmesh

  • Glueck Profile Picture
    112 on 06 Sep 2023 at 07:10:20
    Re: Merge two tables into one table by Automate doesn't work

    @SanmeshG ,

    Thank you for your advice!

    Based on your advice, I tried, but it didn't work.

    1.Added new table

    2.Added one flow to pick the file content dynmically. 

     

    Do you know how to build a flow to pick the content and reflect into a new table?

     

    tbl3.jpgadvice.JPG

     

  • SanmeshG Profile Picture
    1,938 Super User 2025 Season 1 on 05 Sep 2023 at 09:59:06
    Re: Merging two tables into one table by Automate doesn't work

    Hi @Glueck ,

     

    How are you creating the table in the excel file?

     

    One way could be to keep a template file with the header pick the file content dynamically before adding the data (the template file will have only headers)and then add the data.

     

    Thanks,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 66 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 61

#3
rzaneti Profile Picture

rzaneti 31 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading complete