Power Automate Flow to Sync and Update SharePoint Lists Without Duplicates

Question

Description

I need assistance with creating a Power Automate flow to sync two SharePoint lists (EmployeeDetails and ContractorDetails) with a third list (CombinedList). The requirement is as follows:

• Lists Involved:
  • EmployeeDetails**:** Contains columns Employee ID (unique identifier), Name, Department, and Status.
  • ContractorDetails**:** Contains the same columns as EmployeeDetails.
  • CombinedList**:** A target list with the same columns (Employee ID, Name, Department, Status).
• Requirement:
  1. When a new item is created in either EmployeeDetails or ContractorDetails, the item should be added to CombinedList with all column values (Employee ID, Name, Department, Status).
  2. When an existing item is edited in EmployeeDetails or ContractorDetails, the corresponding item in CombinedList (matched by Employee ID) should be updated with the new values, instead of creating a duplicate entry.
  3. The flow should be efficient for large lists to avoid server overload.
  

Answer 1

Microsoft Q&A(en-us) does not support Power Platform.
For questions about Power Platform (PowerApps, PowerAutomate, etc.), please ask in the official dedicated community below.
Power Platform Community
　├ Copilot Studio
　├ Power Apps
　├ Power Automate
　│　└ Power Automate Desktop
　└ Power Pages