1 )
------------------------
A) Upper record-limit when loading a data source into a collection (I currently only work with Dataverse):
Clearcollect (ColName, Data source);
Only up to 500 or 2000 records can be loaded, based on the “Data row limit”-setting in Power Apps
How to deal with this upper-limit-challenge ???
Of course, you can try to use filters to lower the number of records returned… But if this is not possible, and if the number of records still exceeds the “Data row limit”-setting…
Is the only (and best) way to deal with this challenge to, directly after data load, check the “record count” ("CountRows(CollectionName)") of the “data-loaded”-collection, and if the count is equal to the data row limit, create an alert informing the user that the limit has been reached and the results might not be trustworthy?
B) How to do “inner join” in Power Apps between two tables based on common key-column-values
Which Power Apps constructs (formulas) can be used to do this inner join ?
C) Possible way of doing “inner join” in Power Apps
To do “Inner join” ManyTable01:
// Gallery.Items =
Filter(
ManyTable01,
Key in ManyTable02[@cr406_key]
)
To do “Inner join” ManyTable01 and add the ManyTable02 ValueB column at the same time:
// Gallery.Items =
AddColumns(
Filter(
ManyTable01,
Key in ManyTable02[@cr406_key]
) As ToBeExtended,
ValueB,
LookUp(
ManyTable02,
Key = ToBeExtended[@cr406_key],
ValueB
)
)
Are there other Power Apps constructs that can be used to perform the above-shown inner joins ?
D) Delegated complex linking of big data sources to a Gallery
In C) above, relatively complex formulas were used to connect a gallery to data through the gallery’s “Item” property. The formulas did not reference collections, however, a data source reference is specified as part of the filter criteria in the formulas.
Are these formulas fully delegated from Power Apps to the Data Source (here, Dataverse), and will the outcome be fully trustworthy if ManyTable01 and ManuTable02 both contain many thousands of records?
E) Dynamic linking of big data sources to a Gallery
As above in C), sometimes you can directly link a gallery to a data source through the gallery’s Items property. This way the gallery will be able to show a limitless number of records, as data is loaded dynamically from the data source when the user scrolls through the gallery.
But if you want the gallery to dynamically show data from different sources, one way is to “hard code” a link from the gallery’s items property to a collection, and then dynamically change the content of the linked collection.
In the Item’s property of the gallery, you link the gallery to the collection:
// Gallery.Items =
CollectionName
And then you can through code decide the content of the collection:
// First load of data
ClearCollect (
ColManyTable01,
ManyTable01
);
// Second load of data
ClearCollect (
ColManyTable01,
SomeOtherManyTable
);
Of course, you must make sure that the collection maintains the same column names, for the gallery to keep showing the collection data correctly between data loads.
This can work fine, but you then run into the collection upper-limit problem discussed in A) above, where you are unable to get more than 500 or 2000 records from a data source to the collection.
So, you are back to square one…: Even though a gallery can show thousands or perhaps even millions of records, when the gallery gets its data from a collection, in practice the limit is 500 or 2000 records depending on the “Data row limit”-setting in Power Apps.
Am I missing something here ? Is there another way of dynamically linking a gallery to different data sources than through a collection ?
