Unanswered

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

Categories:

Business Process Flows

filter-array.jpg

All responses (2)

Answers (0)

CU18091204-0 2 on at

Like (0)

Report

Compare 2 excel files

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.
Nived_Nambiar 15,886 on at

Like (0)

Report

Compare 2 excel files

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