Hello All,
I need to merge 5 SharePoint files into one Mother file with the help of Power Automate.
Sharepoint file 1:-

Sharepoint file 2:-

As you can see both the above 2 files have one common entry i.e employee ID.
Condition:- Whenever new entries are added or updated in any of these 5 Sharepoint files, a new entry with common employee id should be formed in Mother SharePoint file and updated as shown below:-

Let us know in case of any further information required.
Thanks for the help.
S