I have followed the tips on this website: https://sharepains.com/2020/11/11/compare-2-excel-files-power-automate/. And I have fetched the list of rows from both the spread sheets and I have collected each data set in a 'Row'.
When I get to the comparing stage, I am uncertain of what I am doing. I choose Apply to each and choose 'output' (does this choose output from both the files?). Then a filter array for the 'Row's I created. For the condition, Can I choose 'Row' is equal to 'Row' or should I do an item() and list what items should be in each to find which ones are the same? or a concatenate?
If they aren't the same, I'd like to fetch that one and write it in a third spreadsheet. Is that possible?


Report
All responses (
Answers (