Export to Excel exports only 2048 values

(0) Share

Report

Posted on by cyberco01

480

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.

Categories:

Business Process Flows

I have the same question (0)

All responses (9)

Answers (0)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Export to Excel exports only 2048 values

@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

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Re: Export to Excel exports only 2048 values

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 Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report

Re: Export to Excel exports only 2048 values

@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.

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report

Re: Export to Excel exports only 2048 values. Workaround needed.

I tried with Sharepoint list too. Write is happening for only 2048 items. Any workaround please suggest.

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report

Re: Export to Excel exports only 2048 values. Workaround needed.

Kindly suggest dears as I am very much in need of a solution for this.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Export to Excel exports only 2048 values. Workaround needed.

@cyberco01

Please share list row present in a table settings page? have you enabled what i suggested?

Thanks
Hardesh

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report

Re: Export to Excel exports only 2048 values. Workaround needed.

@Hardesh15

I did the setting as suggested and run the flow and got the below flow status.

Please find below the flow status:

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

Re: Export to Excel exports only 2048 values. Workaround needed.

@cyberco01

Please check limitation-
https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations

Thanks
Hardesh

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report

Re: Export to Excel exports only 2048 values. Workaround needed.

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.

Was this reply helpful? Yes No