i have created a collection which stores the Groupmembers from Azure, i wanted to use top function to get the all the records
my formula is
Filter(Storemembers,Getresult.Text in displayName)
with this formula my gallery loads 100 records. this is the limitation i see in some controls. any one can suggest how to improve the forumal to get all the records in the gallery even i have change the 2000 in settings in the studio
To solve the delegation issue, try:
Filter(Storemembers, displayName = Getresult.Text)
for more, check:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
Anyways, I'm not sure what ,,TOP function" is.
TOP is used to get the number of records that fetch more than 500 as defualt the gallery control load only 100 records that my issues . based on my formula i ma getting only 100 records
so my question is "can we use {top:999} records to load in gallery with the help of collection
I'm pretty much sure the Gallery control allows us to show max. +100 rows per 'scroll to the bottom'.
This means that all data are presented in the gallery, but you need to scroll down until you see them. (easily said)
Yes, I do enable scroll bars and navigation even though i could not load more that 100 records very strange
try to change your code to this:
Filter(Storemembers, displayName = Getresult.Text)
nothing is showing in the gallery,
Maybe try to display it directly through your datasource. I don't know how does your collection look like.
i had ttried that i can fetch the record but still the same 100 records can be searchable
I don't know how to help, sorry.
The easiest way is to set the gallery's Items property to your datasource and filter inside that
User | Count |
---|---|
256 | |
114 | |
95 | |
48 | |
38 |