web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps set default sorting wh...

Power Apps

Unanswered

set default sorting when app open in gallery

(0) Share

Report

Report

Posted on by KatieLiu

2

how do i sort a gallery by name with Filtered function and Search box and large data

At the moment the following is working, just can't add the sort and make it working, please help

If(
varDataCount < VarDelegationLimit,
Filter(
Filter(
Documents,
hiddenFolderPath = "xxxxx/xxx/xxx/xx"
),
TextInput2.Text in Name
),
Filter(
Documents,
(hiddenFolderPath = "xxxxx/xxx/xxx/xx")
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @KatieLiu ,

The whole formula can be wrapped in a Sort function.

Sort( If( varDataCount < VarDelegationLimit, Filter( Filter( Documents, hiddenFolderPath = "xxxxx/xxx/xxx/xx" ), TextInput2.Text in Name ), Filter( Documents, (hiddenFolderPath = "xxxxx/xxx/xxx/xx") ) ), Name )

However, there may be room for improving your existing formula by working around the delegation limit. The below will work as long as the number of items in the pre-filtered data does not exceed the Data Row Limit:

Sort( With({ _PreFilteredData: Filter( Documents, hiddenFolderPath = "xxxxx/xxx/xxx/xx" ) }, Search(_PreFilteredData, TextInput2.Text, "Name") ), Name )

Was this reply helpful? Yes No
WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @KatieLiu ,
Assuming there will be no more than your (500-2000) Delegation limit files in that folder, you can do this

With( { wDocs: Filter( Documents, hiddenFolderPath = "xxxxx/xxx/xxx/xx" ) }, Sort( Filter( wDocs, TextInput2.Text in Name ), YourSortField, YourSortOrder ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation