Power Platform Community Forum Thread Details

Hi Fam!

Basically, I have 2 SharePoint lists, List1 has all the CompanyNames and List2 has select CompanyNames.

I just want to get all items in List1 that does not exist in List2.

I used a string variable and appended all CompanyNames to it.

Would've been easy if there was a IN operator then I can maybe do a NOT IN filter in the query box of the Get Item step..

substringof works the other way around, and I cant think of a reverse way of doing this...

Any workaround? Any suggestions is greatly appreciated!

Thanks!

Categories:

"In" operator in filter query to get items from 2 SharePoint lists