Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Compare 2 excel files

(1) ShareShare
ReportReport
Posted on by 12
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
 
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.

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,059 on at
    Compare 2 excel files
    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 ?
     
     
  • CU18091204-0 Profile Picture
    CU18091204-0 12 on at
    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:
     
     
    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.
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 17,059 on at
    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
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard