Answered

i cant see all elements in a gallery

(0) Share

Report

Posted on by Community Power Pla...

I have a sharepoint list with 7000 elements, I uploaded it to powerapps to be able to view it from there, the problem is that you do not see all the elements, is there any limit of elements in powerapps?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

RezaDorrani 12,143 on at

Like (1)

Report

Hi @Anonymous

By elements do you mean columns or rows
for columns no limits
for rows - if you do not see a delegation warning you should see all data
Note a gallery only shows the first 100 rows and as you scroll will subsequently show/load more data

Regards,
Reza Dorrani

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
Community Power Pla... on at

Like (0)

Report

they are rows, do you know any way to fix it?

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (1)

Report
Hi @Anonymous ,

The picture that you showed is non-delegable limit.

The max of non-delegable limit is 2000.

If you want to avoid the effect of delegation, you need to use delegable data source and delegable functions.

For now, we only support three delegable data soucre:

Common Data Service

SharePoint

SQL Server

You could click it to see its delegable functions. Different data soucre have different delegable functions.

To sum up, if your record is smaller than 2000, just edit the non-delegable limit to 2000. Then delegation warning will not effect your app performance.

If your record is larger than 2000, you need to use delegable data source and delegable functions or else your app will not perform well.

Best regards,

Was this reply helpful? Yes No