OData filter query - return all IDs NOT IN other ID List

[Anthony_Dob]

As the title says. I am trying to do a Dataverse Get Rows filter. I have a step 'Get All Budgets' which contains a field 'cref8_cursist_value'. I want to have a filter on 'Get All Cursists' to retrieve all cursists which ID is not in 'Get All Budgets'.

Get All Cursists Output:

Get All Budgets Output

My Flow and what I am trying to achieve

[Anthony_Dob · Accepted solution]

So I found a solution on a similar post here: https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-you-compare-two-sets-of-lists-usin...

However if this can be done with a Odata Filter I would be glad to hear it!

This is what my flow looks like: