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
Solved! Go to 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:
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:
User | Count |
---|---|
92 | |
45 | |
21 | |
18 | |
16 |
User | Count |
---|---|
136 | |
49 | |
42 | |
36 | |
28 |