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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Find differences betwe...
Power Automate
Unanswered

Find differences between two arrays

(0) ShareShare
ReportReport
Posted on by 4

Hi Community,

 

I need some help with a flow of mine. The goal is to compare a files data in 2 separate branches to find the differences.

The flow works in parallel and runs the same operation from 2 separate branches in git in the same flow. in 'branch#1'

Note - there are definitely differences  between the branches

OUTPUT of both arrays (after using append to array & Initialise Variable to break the data out of a loop)

Branch#1

{

  "Flag": "Text#1",

  "Status": "Text#2",

  "Branch": "SOURCE"

}

 

Branch#2

{

  "Flag": "Text#1",

  "Status": "Text#2",

  "Branch": "TARGET"

}

Both branches 'Flag' value should be the same, but the 'Status' can change from either 'Y' or 'N'.

The scenario is I need to return the Flag, Status & Branch value for each item that has the same Flag name, but the Status in Branch#1'(SOURCE) is different from 'Branch#2'(TARGET)

 

I've tried allsorts of exceptions combinations to return the just the differences but I'm getting no where.

Any help in bridging this gap would be amazing

 

Categories:
I have the same question (0)
  • faustocapellanj Profile Picture
    1,662 on at

    Hello @User1980 

    @PieterVeenstra has an excellent blog post on comparing two arrays. Please check out the link below;

    Compare two arrays, tables or lists a lot faster in Power Automate 

  • User1980 Profile Picture
    4 on at

    Hi Thanks, but this is more to do with speeding the return of the output rather than using the nested loop.

    I need help to sort through and return the diffs based on the Flag being the same but the Status being different between the branches.
    But thank you

  • VictorIvanidze Profile Picture
    13,081 on at

    Hi @User1980,

    if you _can_ manage it to run as fast as possible, just do it - follow  the Pieter's article recommendations.

  • User1980 Profile Picture
    4 on at

    Yes I completely agree, I have been using 'Filter', 'Selects' to manipulate the data this far, so the speed isn't the concern, its the separation of data to return the specific format.

     

    But thank you

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 976

#2
Valantis Profile Picture

Valantis 863

#3
Haque Profile Picture

Haque 547

Last 30 days Overall leaderboard