You’re offline. This is a read only version of the page.
I have a workflow that runs for 6 mins and does not error out, but also does not load all 3303 rows. It stops loading at row 256. Is there a log file that I can review to see why it fails to load all possible rows? The workflow is loading only one table. I noticed that some varchar cols are being loaded with blanks and others are loaded with nulls. Some columns are being loaded with all nulls, but should have values. I would love to see the logs on this load process, if they exist.
Ok @AaronO ,
which Power Automate do you have?
Cause, for “Low” performance profile, the limit is 5000 as below:
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco
Unfortunately, when I try that I receive an error and the flow does not save.
"Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'List_rows_present_in_a_table' of type 'OpenApiConnection' at line '1' and column '1582' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '10000'. Maximum: '5000'.'."
@AaronO ,
you can put a number > 5000 in the Pagination settings.
Inside e flow for a project that I’m managing, I’m grabbing 8000 rows.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco
Hello @KennyTheFarmer ,
by default you can retrieve only 256 rows. If you want to retrieve more than 256, click on the 3 dots and select "Settings", then enable the "Pagination" function and put the max number of rows you want to get.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco
Share
Report
23
All responses (
Answers (