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.
Can this technique be used to retrieve data from a Large Sharepoint lists?
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