cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kieranrb
Level: Powered On

Filtering gallery by multiple choice

Hi,

 

I'm having some difficulty sorting a gallery based on a multiple choice list item. 

 

I believe this is due to it being a multiple choice rather than a text entry, I have a Dropdown control but I can't get it to display options from the multi-choice column. Is there something specific I'm supposed to do?

 

Kind Regards,

Kieran

4 REPLIES 4
mdevaney
Level 8

Re: Filtering gallery by multiple choice

@Kieranrb 

Can you please give us some examples of what options are in the drop-down and details about the DataSource the gallery is based on?  Also, are you trying to Sort the gallery or are you wanting to Filter instead?

Kieranrb
Level: Powered On

Re: Filtering gallery by multiple choice

Hi, the data source is a sharepoint list, with 4 options under "status" they are : "Submitted", "Approved", "Rejected" and "Completed". I would like to filter the gallery, so whoever is searching will be able to only see the list items with the status they select.

mdevaney
Level 8

Re: Filtering gallery by multiple choice

@Kieranrb 

Here's how you can do the filter.  First, you should create a drop-down control and place the following code into the Items property:

 

["Submitted","Approved","Rejected","Completed"]

 

Then go-to the gallery and put this code into the Items property.  Replace the SharepointListName with your list's name, and 'Status' with the name of your Choice column in Sharepoint.

 

Filter(SharepointListName,Dropdown.SelectedText.Value in 'Status'.Value)

 

Let me know if this helped!

Super User
Super User

Re: Filtering gallery by multiple choice

Hi @Kieranrb 

 

Check my Vlogs on filtering galleries with multi choice 

 

Filter on single value - https://www.youtube.com/watch?v=pn50AKn3Q1Y

 

Filter on multiple values - https://www.youtube.com/watch?v=44j2VRbdWjk

 

Regards,

Reza Dorrani

 

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 162 members 4,714 guests
Please welcome our newest community members: