Hi,
Is it possible to combine two 2x2 similar tables in power automate.
Table 1:
Name | Value |
A | 20 |
Table 2:
Name | Value |
B | 50 |
Result:( Table 1 + Table 2)
Name | Value |
A | 20 |
B | 50 |
Solved! Go to Solution.
Hi @Sathya2 ,
Are both tables HTML tables? What is their data source?
I have made a test of combining two tables based on the collections, not sure if it can be of reference for you?
Try to use the following formula:
ClearCollect(Table3,Table1,Table2)
or
ForAll(Table1,Collect(Table4,{Name:Name,Value:Value}));ForAll(Table2,Collect(Table4,{Name:Name,Value:Value}))
Best Regards,
Charlie Choi
Hi @Sathya2 ,
Are both tables HTML tables? What is their data source?
I have made a test of combining two tables based on the collections, not sure if it can be of reference for you?
Try to use the following formula:
ClearCollect(Table3,Table1,Table2)
or
ForAll(Table1,Collect(Table4,{Name:Name,Value:Value}));ForAll(Table2,Collect(Table4,{Name:Name,Value:Value}))
Best Regards,
Charlie Choi
User | Count |
---|---|
258 | |
108 | |
93 | |
57 | |
40 |