web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to compare two Exc...
Power Automate
Unanswered

How to compare two Excel files with Power Automate with Sharepoint

(0) ShareShare
ReportReport
Posted on by

Hello,

I want to compare the value of an Excel tile (A1) with another file. The one excel file is in sharepoint. How do I implement this?

Do I start with Sharepoint "Get file content"?

 

I am glad to get some help.

Categories:
I have the same question (0)
  • David_MA Profile Picture
    12,966 Super User 2025 Season 2 on at

    Are you asking how to compare the data in cell A1 of two different spreadsheets? If so, to use the Excel actions in Power Automate, your data must be in a table. Cell A1 would be in the header row of your table. If this is what you need, you will first need to format the data in your spreadsheets as a table. Then I assume you are wanting to compare the data from the second row of each of your spreadsheets.

     

    If so, this gets much easier. Once you have the data formatted as a table, add an additional column to your spreadsheets named Row with the function =ROW() so that each row in your spreadsheets has a unique ID, as this is needed to get the row. The following is made-up data from Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel, but your spreadsheet would look like this this:

    David_MA_0-1678994006975.png

    In my data above, I already have a column that contains unique values in the id column. If you have something similar in your data, you can use that instead of creating the "Row" column in the Key Column/Key Value pair. However, the Row method ensures you are always comparing the second row. If you need to compare a specific item no matter how the data is sorted, then you will need to have something unique in each spreadsheet to identify the row.

     

    Next you will use two Get a row actions to get the data for the rows you want to compare. You would configure these like:

    David_MA_1-1678994111464.png

    Finally, add a condition and compare the field in the row from your first spreadsheet to the one in your second spreadsheet:

    David_MA_2-1678994179332.png

     

  • tushar123 Profile Picture
    17 on at

    After comparing i need to update one other excel sheet with match and unmatched value for each field. By using this solution,its giving only one value of matched in A1 cell of 3rd excel file. I need each value of coloum of 1st excel file to compare with each value of coloum A of 2nd excel file and give results 3rd excel file with matched and unmatched value for every field of both input excel.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard