cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

sort gallery based on dropdown in SP List

 

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: sort gallery based on dropdown in SP List

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User
Dual Super User

Re: sort gallery based on dropdown in SP List

@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

Community Support
Community Support

Re: sort gallery based on dropdown in SP List

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper I
Helper I

Re: sort gallery based on dropdown in SP List

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

Ang

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,316)