Unanswered

Find differences between two arrays

(0) Share

Report

Posted on by User1980

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:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

faustocapellanj 1,662 on at

Like (2)

Report

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

Was this reply helpful? Yes No
User1980 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

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

Was this reply helpful? Yes No
User1980 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No