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.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
34 | |
15 | |
15 | |
13 | |
7 |
User | Count |
---|---|
41 | |
31 | |
25 | |
12 | |
11 |