cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Anonymous
Not applicable

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

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
Highlighted
Anonymous
Not applicable

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

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

Highlighted
Helper IV
Helper IV

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

is there limit for collections ?

thx

Jens Rogge

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,088)