Filter gallery by choices combobox

(0) Share

Report

Posted on by Hazza

I'm trying to filter my gallery using a combobox which fetches choices from a Sharepoint list.

My combobox "Items" field is - Choices('*sharepointlistname*'.*choicescolumn)

This displays all of the available choices just fine in the combox itself.

Can anybody help me filter my gallery to the selected value of the above combobox, please?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@Hazza

Please consider your Items Formula to be the following:

Filter(yourSharePointList, ChoicesColumn.Value = yourCombobox.Selected.Value)

I hope this is helpful for you.

Was this reply helpful? Yes No
Hazza 40 on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes

Thanks for your quick response,

I've tried this before, but when trying this formula I always get a red squiggly under the equals sign

Any ideas?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Hazza

How is the Vehicle column defined in your list?

Was this reply helpful? Yes No
Hazza 40 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
The column was simply created by clicking > Add Column > Choice > *Naming the column and adding the choices*.

Nothing else bespoke was applied to this column

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Hazza

If you go into the List Settings for the list and then click on the Vehicle column. Check to see if the "Display choices using:" is set to "Drop-Down Menu" and not to "Checkboxes"

Was this reply helpful? Yes No
Hazza 40 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes
OK, so i've caught up with you now. Sorry, I'm still learning....
So this column needs to be a checkbox/multiple choice. Sometimes we need to use more than one vehicle.

If I change the Display Choice to "Drop Down", it breaks one of my other gallery body fields -

Concat(ThisItem.Vehicle.Value, Concatenate(Text(Value),", "))

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!
Hi @Hazza,

Have you solved your problem?

Do you have a Choice column allowing multi select and you want to filter gallery based on multi select Combo Box?

If so, please the set the Items property of the Gallery as below:

Filter( Actions,// Here is my list name "yes" in ForAll( ComboBox9.SelectedItems, If( Value in TestCHoice.Value,// Here is my Choice column "yes", "no" ) ) )

Was this reply helpful? Yes No
Hazza 40 on at

Like (0)

Report
Copy link

Link copied!

This worked great, thank you!

Was this reply helpful? Yes No