I'm having a bit of trouble adding the ability to show my gallery tickets how I want to see them. Currently it shows it by lowest ID number to highest. I would like them to show priority highest to lowest.
HelpDesk =SharePoint List HelpDesk Ticket
Assignedto = Who is assigned the ticket
Dropdown1.Selected.Value = Assignedto DisplayName
(Gallery) Items =Sort(Filter(HelpDesk, "Assignedto" = Dropdown1.Selected.Value || Assignedto.DisplayName = Dropdown1.Selected.Value ),Descending)
*This part of the formula works for me no problem. However I would like to add the ability for the gallery to show the highest priorities first currently it shows it by it's ID lowest to highest.
Priority: SPL Column Name
Priority Choices: Level 1 - High, Level 2 - Medium, Level 3 - Low
Any ideas how this can be done? Thanks!
Go to Solution.
Just figured it out. I added Priority.Value at the end.
Sort(Filter(HelpDesk, "Assignedto" = Dropdown1.Selected.Value || Assignedto.DisplayName = Dropdown1.Selected.Value ),Priority.Value,Ascending)
View solution in original post
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.