How to use Combobox or Dropdown to select items to search in gallery

(0) Share

Report

Posted on by JerryTsai

My SharePoint list name is 'IUR'

The 'Platform' column is a Choice type.

Platform

The 'Platform' data type shows [record] in Power Apps.

I want to add a search(or filter) function for my gallery, use the multi-select to choose items in 'Platform', and show results in the gallery.

I use Combobox to make the dropdown list. It can show P1, P2, P3, P4 correctly.

>> Combobox1 Items = Distinct(IUR, Platform).

Bit I got the error when I used the Search function in the gallery.

>> Gallery Items = Search(IUR, ComboBox1.SelectedItems)

How do I fix this?

Should I use Combobox or Dropdown?

Thank You.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-mengmli-msft on at

Like (0)

Report
Hi @JerryTsai ,

I am assuming that platform column is single selection and combo box is multiple selection.
Please try this:
Items of combo box:
Choices([@IUR].Platform)
Items of Gallery:
If(IsEmpty(ComboBox1.SelectedItems),IUR,Filter(IUR,Platform.Value in ComboBox1.SelectedItems.Value))

Best regards,
Rimmon

Was this reply helpful? Yes No
JerryTsai 12 on at

Like (0)

Report

Hi Rimmon,

It works! you are the best!

I have one more question, and hoping you could help.
Can I add another combobox2 to select a different Column 'State' in the same SharePoint 'IUR', and filter with combobox1 at the same time?
How do I edit the Items of Gallery?

Thank You.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

Report
Hi @JerryTsai ,

What is type of state column?
I am assuming that it is a choice column and combo box2 is also multiple selection.
Please try this:
If(IsEmpty(ComboBox2.SelectedItems),If(IsEmpty(ComboBox1.SelectedItems),IUR,Filter(IUR,Platform.Value in ComboBox1.SelectedItems.Value)),Filter(If(IsEmpty(ComboBox1.SelectedItems),IUR,Filter(IUR,Platform.Value in ComboBox1.SelectedItems.Value)),State.Value in ComboBox2.SelectedItems.Value))

Best regards,
Rimmon

Was this reply helpful? Yes No
JerryTsai 12 on at

Like (1)

Report

@v-mengmli-msft I'm new to Power Apps. Your answer is Excellent!
Even if it's not easy for me, I can study it.

Love this community!
Thank You!

Was this reply helpful? Yes No