I am new to Power Automate, and I’m tring to get html tables in a .jsp website with too many pages. And I want to combine all the tables in a loop, then save it to excel.
Example of table_1:
| id | year | rank |
|---|---|---|
| 1 | 2014 | A |
| 2 | 2014 | B |
Example of table_2:
| id | year | rank |
|---|---|---|
| 3 | 2015 | A |
| 4 | 2015 | B |
How can I combine table_1 and table_2 in Power Automate flow by usinng Power Fx syntax?