Restrict number of items in Gallery

[Doors1980]

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.

[CarlosFigueira · Accepted solution]

You can use the FirstN function for that:

FirstN(
    SortByColumns(
        Filter(
            LLL,
            StartsWith(Title, TextSearchBox1.Text)),
        "Modified",
        If(SortDescending1, Ascending, Descending)),
    100)

[Doors1980]

You are the man @CarlosFigueira Nice one.

[SqueezeOJ]

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!

[CarlosFigueira]

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.