Share
Report
2I 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?
All responses (
Answers (
