Hi,
Below is my flow. In my sql database table i have 2981 rows.
So, I expect the same number of rows to be exported to excel too.
However, only 2048 rows are exported to excel through flow. Please help.
@cyberco01
Have you enable pagination in list row present in table action setting? Also set threshold 5000.
if yes please let me know.
Thanks
Hardesh
Hi @cyberco01,
I think you should turn on the pagination of Get rows action and turn up the threshold of items to return to 5000:
Best Regards,Community Support Team _ Lin TuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-litu-msft I did not get the option to turn on the pagination of Get rows action nor to set the threshold of items to return to 5000.
Please help.
I tried with Sharepoint list too. Write is happening for only 2048 items. Any workaround please suggest.
Kindly suggest dears as I am very much in need of a solution for this.
Please share list row present in a table settings page? have you enabled what i suggested?
@Hardesh15
I did the setting as suggested and run the flow and got the below flow status.
Please find below the flow status:
Please check limitation-
https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations
Kindly elaborate as I know we have D365 Enterprise License and we can connect to premium connectors.
Please correct me if my understanding is not correct.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tomac 497 Moderator
Michael E. Gernaey 477 Super User 2025 Season 2
chiaraalina 242
