
Hello
Trying to find a way to combine the information from 2 excel files:
First Table is my source file
Second Table is the file I work on
Result is the way my table should look like after combining between table 1 & 2
Hope you can help
TNX
| First Table | |
| Joe | 12% |
| Mary | |
| Chris | 50% |
| Jona | |
| Goldin | 23% |
| Max | |
| Arthur |
| Second Table | |
| Joseph | |
| Ben | |
| Ibra | |
| Alex | |
| Jesus | |
| Lena | |
| Goldin |
| Result | |
| Joseph | |
| Ben | |
| Ibra | |
| Alex | |
| Jesus | |
| Lena | |
| Goldin | 23% |
@GuyBar You can treat the excel files as databases and use SQL queries to get the resultant table.
Database - Power Automate | Microsoft Docs