You’re offline. This is a read only version of the page.
2
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
target.xlsx - Table B
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?
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:
Share
Report
All responses (
Answers (
