Unanswered

Load 80K record in Column Chart in power apps

(0) Share

Report

Posted on by Ape Awakening

301

I have a SP list with more than 80K records and I want to populate a distinct column value of each item from that column.
When I want to populate using formula :

AddColumns(GroupBy(TimeSheetChild,Process,ProcessName),NumberOfUser,CountRows(ProcessName))
Its only populate 2K record.
How can I popuate my all record in column chart

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (0)

Report

Hey @apeawakening ,

Since Power apps has delegation limits it's normal, that you only get the first 2,000 records populated. It would be possible to do it with a complicated formula, but I wouldn't advise to do it.
A far better solution would be to use Power automate. You ca, make it start with a button click from the app if your application should be the trigger.

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

Like (1)

Report

Hi , @apeawakening

The Column Chart do not support the delegation in Power Apps. So it can just load maximum 2000 rows to power app.

Understand delegation in a canvas app - Power Apps | Microsoft Learn

If you have a large data need to show in a column chart in Power Apps. I recommend you to connect your data in Power BI and embed the tile in Power App.

Power BI tile control in Power Apps - Power Apps | Microsoft Learn

Embed Power BI tiles in PowerApps | Microsoft Power Apps

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
VishalJhaveri 1,167 Moderator on at

Like (0)

Report

Create Power Apps Collections Over 2000 Rows With These 4 Tricks
Check this link, if it works for you. You will get a rough idea of DISTINCTING out records.

Was this reply helpful? Yes No