Compare 2 excel files

(1) Share

Report

Posted on by CU18091204-0

Hi, I am new with PA and trying different solutions.
I would like to compare the contents of two excel files and as a result get only the data that is in file-2 and not in file-1

I found this solution: https://sharepains.com/2020/11/11/compare-2-excel-files-power-automate

Unfortunately there is an error that I can't deal with. It concerns the part of comparing two arrays. Filter array doesn't filter the elements of the array correctly. items('Apply_to_each')?['Row'] shows the elements of the array from file #2 but doesn't compare with item()?['Row'] - the array from the data of file #1. As a result, I have an empty array

How to compare these two tables so that as a result you get only the data that are in file-2 and bypass those that are in file-1

filter-array.jpg

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

in the blog, i think from field of filter array should have mapped to select action's output from first excel data. Then things would have work

Was this reply helpful? Yes No
CU18091204-0 12 on at

Like (0)

Report
Copy link

Link copied!

I also think that there is an error and should be compared two arrays: from the first file and the second file but I have it set like this:

https://pasteboard.co/koUyj3vc3GoS.jpg

and it still doesn't work properly. Perhaps item()?['Row'] is not referencing the first data file but I don't know how to change it.

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I don't think it is due to issue in referencing the value from first excel where item()?['Row'] is not working.

May be try to compare the values in select action for both excel types and see whether they are same or not ?

Was this reply helpful? Yes No