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");
Go to Solution.
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.
Workaround for loading more than 500 records from delegable data source
View solution in original post
is there limit for collections ?
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand