cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dlprentice
Helper V
Helper V

Opposite of intersection exist in PA?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
fchopo
Super User
Super User

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

 

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

2 REPLIES 2
fchopo
Super User
Super User

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

 

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,824)