Users Matching Filter Criteria not Returned by List Records Query

[LeeHarris]

Hi all,

I am having issues fetching Users from an instance of Dynamics 365. I am using the List Records action with a filter of 

isdisabled eq false and accessmode ne 3 and accessmode ne 4 and accessmode ne 5

However, I am not seeing all of the expected results returned. If I run the same query with the exact same filter against the Dynamics 365 Web API I receive all the matching records. Flow is only returning 512 Users though I have also tried explicitly setting the Top value higher than this with no luck.

I have tried this with both the old Dynamics 365 connector and the Common Data Service and they both have the same issue.

Anyone else encountered this and know how I can get the filter to function correctly within Flow?

[Brad_Groux]

Have you tried building a delay into your Flow? You may be hitting the 1000 API calls per 1 minute limit. Outside of that, if you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[LeeHarris]

Hi @Brad_Groux 

Thanks, I was unaware of the 1000 call limit so added a delay to get around this. Unfortunately this did not resolve the issue though. As a test I have created a new Flow which only runs the List Records action (shown below).

When run via Flow this returns 512 results. If I run the exact same query using the Web API (url below) then I get the expected 787 results.

https://[Dynamics Client URL]/api/data/v9.0/systemusers?$filter=isdisabled eq false and accessmode ne 3 and accessmode ne 4 and accessmode ne 5

I am logged in to Flow and Dynamics with the same User so security roles should not be affecting what I can see in the response. Any other ideas on why the query could be returning different results via Flow?

[LeeHarris · Accepted solution]

For anyone that might end up on this thread after running into the same issue. This was resolved by enabling Pagination on the List Records step. This can be found in the Settings section (click the elipses on the action).

Now I am getting all the results back from the query.