Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Comparing Two Excel Files

(0) ShareShare
ReportReport
Posted on by
Hi there,
 
I'm somewhat new to Power Automate and am trying to create some basic logic that I'll eventually use in a larger flow. I'm trying to pull two separate Excel files into a PA flow (from my OneDrive using a OneDrive for business connection), have PA compare the two files (cell by cell) and see if there are any differences between the two. For example, say I have two identical excel files with identical data. I'd like for PA to check both files and send a response back saying "no errors found'. On the flip side, say I have two files that are identical aside from one cell being blank in one of the files where data exists in the other. I'd want a response back saying "error found in cell x". Is this possible to do?
 
I've attached two example files that are the exact same aside from the name in the first row being 'Jones' on one file and 'Jone' on the other.
 
Thanks!
  • NickWarner Profile Picture
    NickWarner 113 on at
    Comparing Two Excel Files
    This would be very complex to do the comparison in PA. The cleanest way to do it would be to write an Azure Function to do the comparison and return the output. a flow to provide the two files to the function would be relatively straightforward then. 
  • abm abm Profile Picture
    abm abm 32,275 on at
    Comparing Two Excel Files
    Quick question? Are you looking for files are exact match only? If there differences what you expect?

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,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard