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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Opposite of intersecti...
Power Automate
Unanswered

Opposite of intersection exist in PA?

(1) ShareShare
ReportReport
Posted on by 628

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?

Categories:
I have the same question (0)
  • Verified answer
    fchopo Profile Picture
    8,003 Moderator on at

    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):

     

    image-23You 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

     

     

  • dlprentice Profile Picture
    628 on at

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

  • steve_hendy Profile Picture
    385 on at

    Wish I saw this earlier, well done

  • risham Profile Picture
    2 on at

    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

  • ericwhitley Profile Picture
    137 on at

    Works great! Just make sure your arrays have the same structure.

  • testasdfasfsafa Profile Picture
    309 on at

    I don't understand, you will still need an apply for each for each item in 1 array...

  • Community Power Platform Member Profile Picture
    on at
    Hi, could you please explain what output-item is?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard