Compare to outputs and retrieve the items that don't match?

[Carl__D]

Hello,

I am doing an HTTP call to get all Team-enabled Groups:

https://graph.microsoft.com/beta/groups?filter=resourceProvisioningOptions/Any(x:x%20eq%20'team')

And I have a SharePoint list with all Teams and their IDs (previously populated with the above HTTP call)

I want to keep the list up to date so want to schedule the HTTP call to grab any new Teams that are not currently on the SharePoint list to update the list with. The list needs to be updated, as opposed to re-build in its entirety, as manual metadata is being added that can't be lost.

I have a variable with both HTTP ID's and SharePoint ID's but can't seem to retrieve the HTTP ID's that aren't on the SharePoint list!?

I have tried Conditions and Filter Arrays to get HTTP ID 'Not Equal' to SharePoint ID - but must be doing something wrong as it keeps returning ID's that are on the list. 

I hope that makes some sense!

Thanks 

[VictorIvanidze · Accepted solution]

Have a look at this: https://www.damobird365.com/efficien-union-except-and-intersect-great-method/

[Carl__D]

Amazing, thank you!

[Mitchelvdh]

Hi, is there a possibility to show your solution? 🙂