sort gallery based on dropdown in SP List

[ahohman]

I'm not a developer and I'm new to PowerApps, so be gentle with me.  🙂  I'm sure this will be simple for you guys.

I have a SharePoint list.  It tracks requests that users make to the Facilities Department.  The list includes two dropdowns:

• PRIORITY -  Choices are Urgent, Normal, Low
• STATUS -  Choices are New Request, In Progress, Complete 

I'm creating a Mobile app, and I'd like the records to be displayed by Status -- New Requests at the top. If I can figure that out, then I'd also like them to be ordered by Priority so that I get something like:

New Request - Urgent

New Request - Normal, etc.

I've figured out the filtering but it seems like it only works on text fields and not on dropdowns.  Any help you can provide is appreciated. Thanks. 

[RezaDorrani]

@ahohman 

For filtering on dropdowns use

dropdown.Selected.Value (this will give you the text control)

https://www.youtube.com/watch?v=pn50AKn3Q1Y

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-monli-msft · Accepted solution]

Hi @ahohman ,

If you are using 2 dropdown controls to filter with the 2 choice columns for the gallery, then set below formula in the Items property of the gallery control:

Filter(ListName, PRIORITY.Value=Dropdown1.Selected.Value,STATUS.Value=Dropdown2.Selected.Value)

Regards,

Mona

[ahohman]

Thank you!  I didn't realize that dropdowns can't be used with SortByColumns.  Your videos are very helpful.

Ang