Power Automate Flow only returning 250 records from Dataverse

(0) Share

Report

Posted on by bfausti

195

I've got a stranage one.

I am trying to popuate table B with table A using a Flow, a very simple task. Table A contains 3200~ records, however when I try to do a List Rows it only ever returns 250 records. I've tried everyting, just a list rows with no filter, using fetch, deleting re-creating the flow several times, creating the flow from a different environment, creating the flow with another admin user, the list goes on...

I know the table contains 3200~ records from within MSSMS:

as well as from the model driven app which lists the rows:

I have tried everything and I don't understand what is happening.

This is the flow:

This is the result:

Has anyone else had this experience before? Something is limiting the list rows returned I have no idea what is going.

Please help!

Categories:

Microsoft Dataverse

All responses (2)

Answers (1)

mstrblueskys 14 on at

Like (0)

Report

Re: Power Automate Flow only returning 250 records from Dataverse

Thanks for the fix! Listing the columns I needed for the flow resolved this issue for me as well.

You did include your org details in the connection details of your solution, btw.
Verified answer

bfausti 195 on at

Like (0)

Report

Re: Power Automate Flow only returning 250 records from Dataverse

So it seems specifing columns in the flow fixed the issue:

Has anyone experienced this behaviour before?