Filter Gallery with Combo box, Sharepoint column multi select

[AshishJaiswal]

Hello Experts,

My SharePoint list has a column name 'Tags_x002d_Choices'

I am trying use combo box to filter my gallery, combobox items are coming from above column (multi -select)

However, none of the below formula works it doesn't complete, intellsense just give option to complete/or column name

[v-qiaqi-msft · Accepted solution]

Hi @AshishJaiswal,

Could you please tell me that how you set the Items property of the ComboBox?

You should make sure the returned column name from the ComboBox Items property.

If It returns Value column if you set the Items property as Choices('Graph MC Dump'.'Tags_Choices'), you should modify the formula as below:

Filter('Graph MC Dump', Concat(ComboBox8.SelectedItems,Value,",") in Concat('Tags_Choices',Value ,","))

This formula will filter items that includes all the value selected in the combo box.

(the combo box select a,b; you will only get records with value like this: a,b,c ; ab,d)

ForAll(ComboBox7.SelectedItems,Filter('Graph MC Dump',Value in 'Tags_Choices'.Value))

If you want to filter items that only includes parts of value selected in the combo box, you could try this:

(the combo box select a,b; you will  get records with value like this: a,c ;b,c ;a,b,c)

[aaaa3]

Hi  @v-qiaqi-msft I have similar question but I dont know how to construct the if condition for the label

My combo box for my powerapp

is 

I am adding another option here previous was not loan and loan

Previous label

My inventory label to display data is

I need to modify to include the three options in combobox. May I know how to do? Thank you.