cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jeanshak
Helper IV
Helper IV

How many Records can be loaded from a table? are the limits?

How many Records can be loaded from a table into a collection in one load?
Are the limits?
Maximum Records?
Is there Maximum for a Galery ?

 

Loading into Collection:

If (Connection.Connected;
Clear(LocBVGewerke);;
ClearCollect(LocBVGewerke; Filter( Tabelle1_1; Value(blnr)=Value(BLDropDown.Selected.BLNR) ));;
SaveData(LocBVGewerke; "LocBVGewerke");

 

Jens Rogge
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

There is a limit of 500 records to be loaded into a collection from a data source that cannot be delegated. It is not possible to overcome this limit.

 

Data sources where delegation is possible, there are workarounds to load more than 500 records into collection but you will still be loading only 500 at a time.

 

Delegation Info

Workaround for loading more than 500 records from delegable data source

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

There is a limit of 500 records to be loaded into a collection from a data source that cannot be delegated. It is not possible to overcome this limit.

 

Data sources where delegation is possible, there are workarounds to load more than 500 records into collection but you will still be loading only 500 at a time.

 

Delegation Info

Workaround for loading more than 500 records from delegable data source

is there limit for collections ?

thx

Jens Rogge

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,194)