I've got a pretty standard formula on the item of a Gallery:
SortByColumns(Filter(LLL, StartsWith(Title, TextSearchBox1.Text)), "Modified", If(SortDescending1, Ascending, Descending))
How would I modify this formula to further restrict the filtered results to only return a set amount of items from my SharePoint list? Say 100 items?
Cheers in advance.
Solved! Go to Solution.
You can use the FirstN function for that:
FirstN( SortByColumns( Filter( LLL, StartsWith(Title, TextSearchBox1.Text)), "Modified", If(SortDescending1, Ascending, Descending)), 100)
You can use the FirstN function for that:
FirstN( SortByColumns( Filter( LLL, StartsWith(Title, TextSearchBox1.Text)), "Modified", If(SortDescending1, Ascending, Descending)), 100)
Can this technique be used to retrieve data from a Large Sharepoint lists?
See https://powerusers.microsoft.com/t5/PowerApps-Forum/Help-with-Large-Sharepoint-List/m-p/66007#M27107
Thank you!
It should work; if all the functions that you use for filtering and sorting are delegatable (if they're not, there will be a blue icon indicating it), then it should work.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
252 | |
122 | |
84 | |
84 | |
67 |