You’re offline. This is a read only version of the page.
Announcements
2
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!
You can use "intersection" Function , this function returns the common items in two different arrays. in your case List 1 get items and List 2 Get items response.
Link for reading:
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Share
Report
All responses (
Answers (
