web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Merge two tables into ...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on 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

Categories:
I have the same question (0)
  • SanmeshG Profile Picture
    1,947 Moderator on at

    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,

  • Glueck Profile Picture
    112 on at

    @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,947 Moderator on at

    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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard