Pass large SharePoint list to Gallery in the Component

(0) Share

Report

Posted on by jarze

Hello,

How to pass large data to the gallery in the component?

Case:

I created component with two elements:

1. input filed

2. gallery which display elements based on what we enter in the input field

a) gallery --> items I set the filter Filter(Parent.table1, StartsWith(FiledName, component.InputField))

3. in the component I created custom properties --> Input --> DataType --> Table

I am implementing component in my application connecting SharePoint list with component input property keeping the same data structure using ShowColumns.

Until this point all works fine, but I noticed that gallery in my component is not showing all data. Looks like it reads only first 500 rows of my SharePoint list.

Is it related to the fact that input property is defined as table?

Is this a known limitation of using Galley in the component or maybe I am doing something wrong?

Thank you very much for all your thoughts on this topic Guys.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @jarze,

Could you please tell me that how many records in yur data soruce?

Actually, you are right that it is a known limit for a Gallery to display limitted records, however you could display 2000 records at max instead of only 500.

You could go to settings and change the limit from 500 to 2000.

Was this reply helpful? Yes No
jarze 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Qi,

Thank you for your prompt response and suggested workaround.
Answering your question about data source size I am using SharePoint List with 40k records.

To sum-up
we can say that Gallery in the component does not behave like galley in the canvappp but more like a table with possibility to display some filed in the gallery.

Thank you

Was this reply helpful? Yes No
ScottRMeredith 141 on at

Like (0)

Report
Copy link

Link copied!

Did you find anything on this? I have the same scenario and headache with it.

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

@jarze @ScottRMeredith
There is now a delegation workaround solution for brining large SharePoint lists into Power Apps: https://powerusers.microsoft.com/t5/Community-App-Samples/Delegable-Large-SharePoint-List-App/td-p/2330721

Was this reply helpful? Yes No
ScottRMeredith 141 on at

Like (1)

Report
Copy link

Link copied!

Thank you...unfortunately for me, I don't even remember which of my projects I was referring to in my comment. I will keep this in mind though if it comes up again for me.

Was this reply helpful? Yes No