Power Platform Community Forum Thread Details

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

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