Announcements
I have three icons that I'm trying to use to filter these columns, but it isn't filtering. Here's my formula:
@Dknight7
The sort would occur in your Items property of the gallery...not the button. So what is the Items property of the Gallery and how are you using the variables in it?
You are only showing the Icon property, not the OnSelect of the Icon - which is where you would be setting the variable, and in the Gallery Items property is where you would be using the variables in your formula.
I hope this is helpful for you.
This is the items property of my table. How can I add this formula to it?
Your formula in the Items is only dealing with sorting the SubmissionDate column. None of the rest of your formulas will have any impact.
I would suggest setting your Items property formula to the following to utilize your variables for the columns and sort direction.
SortByColumns( Filter('Employee Activity List', Employee.DisplayName = User().FullName, Status.Value = "Needs Approval" ), Coalesce(varSortColumn, "SubmissionDate"), Coalesce(varSortDirection, Descending) )
My data disappears:
How big is your list? (number of records) and what is your Record Limit set to in your app?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 392 Most Valuable Professional
11manish 136 Super User 2026 Season 2
MS.Ragavendar 109 Super User 2026 Season 2
