web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : SF7bE/5/eR/h56KPfV2woK
Power Apps - Building Power Apps
Unanswered

MULTI COLUMN GALLERY SORT & FILTER FUNCTION

Like (0) ShareShare
ReportReport
Posted on 4 Nov 2022 07:46:45 by 517

Hello,

Can you help. I have a muliti column gallery. I wanted to have a dynamic sort icon for my columns. 

 

 

 

jaina_0-1667547575294.png

Here's the Item property of my gallery.

jaina_1-1667547641824.png

 

Now, i created a global variable below for varSortColumn and varSortDirection in OnStart property of the App.

 

jaina_2-1667547692030.png

 

Then, I have an Icon for Reference_No column. I set the OnSelect Property to:

jaina_3-1667547775281.png

 

Then, i update the Item property of my gallery to:

jaina_4-1667547851540.png

 

 

Now, the items in my gallery is not displaying. 

 

jaina_5-1667547894805.png

 

What could be the reason why items are not displaying? Appreciate your time to check and resolve this concern. 🙂 

 

  • WarrenBelz Profile Picture
    149,147 Most Valuable Professional on 04 Nov 2022 at 08:01:16
    Re: MULTI COLUMN GALLERY SORT & FILTER FUNCTION

    Hi @jaina ,

    That is because variables in the Sort are not Delegable (you will see a warning on your code). Firstly, set the Default of SearchInput_1 to "" (empty string) and try this

    With(
     {
     wList:
     Filter(
     'CAPEX - PH',
     StartsWith(
     Reference_No,
     SearchInput_1.Text
     ) && 
     (
     Len(drp_ApprovalStatus.Selected.Value) = 0 ||
     drp_ApprovalStatus.Selected.Value = "All" ||
     Approval_Status = drp_ApprovalStatus.Selected.Value 
     )
     )
     },
     SortByColumns(
     wList,
     varSortColumn,
     varSortDirection
     )
    )

    Also be aware that the output of the top filter needs to return record numbers under your Delegation limit.

     

    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.

    Visit my blog Practical Power Apps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete