how to combine excel rows into one table?

[GGG666]

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

Table 2

summary table

[v-bofeng-msft]

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#...

Best Regards,

Bof