Opposite of intersection exist in PA?

Like (1) Share

Report

Posted on 22 Oct 2021 15:00:49 by dlprentice

626

So basically the title, I do an intersection() I get the common items, all is good. Now, is there an expression to get the items that don't match or would I be forced to use some filter array actions for this?

All responses (7)

Answers (1)

Community Power Pla... on 18 Sep 2023 at 08:14:00

Like (0)

Report

Re: Opposite of intersection exist in PA?

Hi, could you please explain what output-item is?
testasdfasfsafa 307 on 27 Mar 2023 at 14:47:12

Like (0)

Report

Re: Opposite of intersection exist in PA?

I don't understand, you will still need an apply for each for each item in 1 array...
ericwhitley 137 on 05 Aug 2022 at 18:03:55

Like (0)

Report

Re: Opposite of intersection exist in PA?

Works great! Just make sure your arrays have the same structure.
risham 2 on 04 Aug 2022 at 18:09:04

Like (0)

Report

Re: Opposite of intersection exist in PA?

It does not work for me, instead of giving me the unique items, the flow returns all the items that are in the List 2
steve_hendy 371 on 08 Jul 2022 at 08:01:05

Like (0)

Report

Re: Opposite of intersection exist in PA?

Wish I saw this earlier, well done
dlprentice 626 on 22 Oct 2021 at 17:52:33

Like (0)

Report

Re: Opposite of intersection exist in PA?

Thank you! This works so much better than a Apply_for_each loop!
Verified answer

fchopo 7,968 Super User 2025 Season 1 on 22 Oct 2021 at 16:05:32

Like (7)

Report

Re: Opposite of intersection exist in PA?

Hi @dlprentice

I guess the only solution you have is to use Filter Array action. In this sample, this filter array action is getting items that are in List2 (array) and not present in List1 (array):

You could do it for List1 and List2 in another action, and finally use a union operation to get a list of all items.

Hope it helps!

Ferran