Answered

Combo boxes multiple selection on Gallery won't work

(0) Share

Report

Posted on by Tbabe

i Have a combobox that is suppose to filter a gallery, but i discovered, when i select multiple data, it only pulls the last data selected and not all that was selected. e.g in my combobox, i have A,B,C,D. if i select A, it shows A in my Gallery, if i select A,B, it shows B only in my Gallery instead of A and B. the below is my combobox expression and Gallery expression

cmb_InformationType(Item Properties)=Filter(Choices('Class Information'.'Information Type'),Trim(Value) in "Mathematics|Geography|Physics|Anatomy")

Informationgallery(Items Properties)= Filter(colInformation,cmb_InformationType.Selected.Value in 'Information Type'.Value || IsBlank( cmb_InformationType.Selected.Value)

my Collection formula = ClearCollect(colInformation,'Information Management');

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Tbabe

So to be clear...

You have a choice column in your datasource that allows multiple selections and you want to be able to filter by a multiple selection combobox. Is that correct??

Also, what is your datasource?

Was this reply helpful? Yes No
Tbabe 81 on at

Like (0)

Report

yes and my Datasource is Sharepoint (Library)

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@Tbabe

Your formula then will need to be this:

Filter(colInformation, Sum( ForAll(cmb_InformationType.SelectedItems, If(Value in 'Information Type'.Value, 1, 0)), Value ) > 0 || IsBlank( cmb_InformationType.Selected.Value) )

This is just one of a couple ways to approach this. The concept is to look at each selected item and then see if it is in the table of choices in the column. If so, then it all gets summed up and if the sum is greater than 0, then there was a match and thus the row should be returned.

Was this reply helpful? Yes No
Tbabe 81 on at

Like (0)

Report

it didn't give errors, but when i select from the combobox it doesn't return anything. The formula you shared was used in the itemgallery

Was this reply helpful? Yes No
Tbabe 81 on at

Like (1)

Report

thank you, this worked, guess it was a bug initially.. you just saved me as usual..😀

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

Like (0)

Report

@Tbabe

Good deal! Happy to help!

Was this reply helpful? Yes No