More than 5000 records in PowerApps form on export button click

[Syndicate_Admin]

Hi,

I have one data source like (SharePoint or SQL), That table having 6000 records. All the records I'm getting from collection (Using 3 collection, each collection having 2000 records).

Screen On Visible:

Concurrent(

ClearCollect(
colUpto2000,
Filter(
Test,
Count <= 2000
)
),
ClearCollect(
col2001To4000,
Filter(
Test,
Count > 2000 And Count <= 4000
)
),
ClearCollect(
col4001To6000,
Filter(
Test,
Count > 4000 And Count <= 6000
)
)
);
ClearCollect(
MyRecord,
ShowColumns(
colUpto2000,
"ID",
"Title",
"Count",
"Test"
),
ShowColumns(
col2001To4000,
"ID",
"Title",
"Count",
"Test"
)
,ShowColumns(
col4001To6000,
"ID",
"Title",
"Count",
"Test"
)
);

In my scenario on PowerApps form, On button click exporting those records to excel.

On Button Click:

ExportExcelFlow.Run(
JSON(
Sort(MyRecord,Count,Ascending),
JSONFormat.IncludeBinaryData
))

Actually I exported 4463 records to excel through Power Automate flow (On button click calling power Automate flow). My issue was, If I'm using more than 4463 records then button click is not working which means workflow not trigger.

Is any limitation to execute Power Automate flow from PowerApps?

Any help will be greatly appreciated.

Thank You.

[Syndicate_Admin]

Hi @TSundar ,

What are you using in you Flow to collect the data in Excel?

Have you turned on the Pagination on the connector? If your Threshold is set to 4463, you have to change it to suite your needs.

You can find more information here: https://www.c-sharpcorner.com/article/retrieve-more-than-default-number-of-rows-of-data-from-excel-u...

[Syndicate_Admin]

Hi @PTBBSolutions ,

Thanks for your reply and sry for my late response. In my flow I didn't use excel component, refer below screenshot.

I have export in csv format.

Now I got one solution, I changed one parameter to multiple parameter like passing one collection to multiple collection (Each collection having 2000 records). Based on record count dynamically create collection and passed to Power Automate flow.

Refer my code,

Screen On visible:

"_count" is my int variable  (Value is Source record count/2000)

Switch(
_count,
1,
ClearCollect(
colUpto2000,
ShowColumns(
Filter(
Test,
Count <= 2000
),
"ID",
"Count",
"Test"
)
),
2,
Concurrent(
ClearCollect(
colUpto2000,
ShowColumns(
Filter(
Test,
Count <= 2000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col2001To4000,
ShowColumns(
Filter(
Test,
Count > 2000 And Count <= 4000
),
"ID",
"Count",
"Test"
)
)
),
3,
Concurrent(
ClearCollect(
colUpto2000,
ShowColumns(
Filter(
Test,
Count <= 2000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col2001To4000,
ShowColumns(
Filter(
Test,
Count > 2000 And Count <= 4000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col4001To6000,
ShowColumns(
Filter(
Test,
Count > 4000 And Count <= 6000
),
"ID",
"Count",
"Test"
)
)
),
4,
Concurrent(
ClearCollect(
colUpto2000,
ShowColumns(
Filter(
Test,
Count <= 2000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col2001To4000,
ShowColumns(
Filter(
Test,
Count > 2000 And Count <= 4000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col4001To6000,
ShowColumns(
Filter(
Test,
Count > 4000 And Count <= 6000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col6001to8000,
ShowColumns(
Filter(
Test,
Count > 6000 And Count <= 8000
),
"ID",
"Count",
"Test"
)
)
),
5,
Concurrent(
ClearCollect(
colUpto2000,
ShowColumns(
Filter(
Test,
Count <= 2000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col2001To4000,
ShowColumns(
Filter(
Test,
Count > 2000 And Count <= 4000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col4001To6000,
ShowColumns(
Filter(
Test,
Count > 4000 And Count <= 6000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col6001to8000,
ShowColumns(
Filter(
Test,
Count > 6000 And Count <= 8000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col8001to10000,
ShowColumns(
Filter(
Test,
Count > 8000 And Count <= 10000
),
"ID",
"Count",
"Test"
)
)
),
6,
Concurrent(
ClearCollect(
colUpto2000,
ShowColumns(
Filter(
Test,
Count <= 2000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col2001To4000,
ShowColumns(
Filter(
Test,
Count > 2000 And Count <= 4000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col4001To6000,
ShowColumns(
Filter(
Test,
Count > 4000 And Count <= 6000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col6001to8000,
ShowColumns(
Filter(
Test,
Count > 6000 And Count <= 8000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col8001to10000,
ShowColumns(
Filter(
Test,
Count > 8000 And Count <= 10000
),
"ID",
"Count",
"Test"
)
),
ClearCollect(
col10001to12000,
ShowColumns(
Filter(
Test,
Count > 10000 And Count <= 12000
),
"ID",
"Count",
"Test"
)
)

On Button Click:

ExportExcelFlow.Run(
JSON(
Sort(
col4001To6000,
Count,
Ascending
),
JSONFormat.IncludeBinaryData
),
JSON(
Sort(
col2001To4000,
Count,
Ascending
),
JSONFormat.IncludeBinaryData
),
JSON(
Sort(
col6001to8000,
Count,
Ascending
),
JSONFormat.IncludeBinaryData
),
JSON(
Sort(
col8001to10000,
Count,
Ascending
),
JSONFormat.IncludeBinaryData
),
JSON(
Sort(
colUpto2000,
Count,
Ascending
),
JSONFormat.IncludeBinaryData
),
JSON(
Sort(
col10001to12000,
Count,
Ascending
),
JSONFormat.IncludeBinaryData
)
)

Finally I got this solution, If you have any other solution please share to me.