Answered

Compare two object arrays by specific key and save non-duplicates

(0) Share

Report

Posted on by dgonzalesjr

I've created two object arrays. I would like to compare the two array items by 'SpaceId' key, then add whatever items don't match to a third array. Here is a sample of my two arrays:

Screen Shot 2021-04-26 at 3.25.00 PM.png

I would like my condition to be if variable(array1)['SpaceId'] is not equal to variable(array2)['SpaceId'] then append to a 3rd array.

If they are equal then do nothing.

I'm pretty sure my syntax is probably totally off but I hope I'm getting my goal across. I'm new to the game so I would appreciate any help that I can get with this.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

Here is how you can do it...

Compose2 Expression --> item()?['spaceid']

Filerarray expression --> item()?['spaceid']

Check Length expression -->length( body('Filter_array'))

Finally append to array expression --> body('Filter_array')[0]

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

@dgonzalesjr - Did you get chance to check my solution?

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

@dgonzalesjr - Did you get chance to check my solution?

Was this reply helpful? Yes No
dgonzalesjr 8 on at

Like (0)

Report
Copy link

Link copied!

Hello @PrasadAthalye so sorry for the wait. This solution has worked for me. Thank you so much for your help!

Was this reply helpful? Yes No