cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cpaz
Regular Visitor

How do I create a flow that synchronizes records between two different excel tables?

I have two different excel files, excel file source.xlsx with table named A, and excel file target.xlsx with table named B. The contents of both tables are shown below.

 

source.xlsx - Table A

Screenshot 2022-09-27 112908.png

 

target.xlsx - Table B

Screenshot 2022-09-27 113346.png

 

I'm trying to figure out how to write a Power Automate flow that will sync records between each of these files. When a user enters a new record on Table A, that record should also show up in Record B (and vice versa). Additionally, duplicate records between files should be ignored (the basis of these duplicate records are in the ID column, where no two records should share the same ID). 

 

How do I do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Sundeep_Malik
Community Champion
Community Champion

Hey @cpaz 

Yesterday also there was a similar post posted. 

So, you can use a scheduled flow, that would be running every two hours or somethings. This will list rows from both the excels. If the length is not equal, just create rows to add new items. And if length matches, do nothing. 

Just the duplicated part, I am not sure about. Maybe if you don't add any duplicates in 1st excel, the second excel won't have any duplicates. 

 

For duplicates, you check the below link:

https://powerusers.microsoft.com/t5/Building-Flows/Help-needed-to-remove-dublicates-from-excel/td-p/...

 

View solution in original post

1 REPLY 1
Sundeep_Malik
Community Champion
Community Champion

Hey @cpaz 

Yesterday also there was a similar post posted. 

So, you can use a scheduled flow, that would be running every two hours or somethings. This will list rows from both the excels. If the length is not equal, just create rows to add new items. And if length matches, do nothing. 

Just the duplicated part, I am not sure about. Maybe if you don't add any duplicates in 1st excel, the second excel won't have any duplicates. 

 

For duplicates, you check the below link:

https://powerusers.microsoft.com/t5/Building-Flows/Help-needed-to-remove-dublicates-from-excel/td-p/...

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,953)