web

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

Power Platform CommunityForums Power Apps - Building Power Apps MULTI COLUMN GALLERY S...

Power Apps - Building Power Apps

Unanswered

MULTI COLUMN GALLERY SORT & FILTER FUNCTION

(0) Share

Report

Report

Posted on by jaina

517

Hello,

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

Here's the Item property of my gallery.

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

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

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

Now, the items in my gallery is not displaying.

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

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

WarrenBelz 151,635 Most Valuable Professional on at

Like (1)

Report
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

Was this reply helpful? Yes No

Join the conversation