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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / how to combine excel r...
Power Automate
Unanswered

how to combine excel rows into one table?

(0) ShareShare
ReportReport
Posted on by 167

Dear all,

 

I have three Excel workbooks.

Table 1 is for information about project 1001. Table 2 is for project 2001. The content in these two tables is dynamic.

Now I want to add rows about project 1001 in Table 1 to the summary table, which should be added to project 1001 rows, and add rows about project 2001 in table 2 to the summary table, which should be after 2001 rows.

 

Could you please help with it? Thanks.

 

Table 1

GGG666_0-1670134770448.png

Table 2

GGG666_1-1670134883052.png

 

summary table

GGG666_2-1670134973936.png

 

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @GGG666 ï¼Œ

     

    You could use the 'Union' function to combine two tables.

    I think this link will help you a lot:
    https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#union

     

    Best Regards,

    Bof

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard