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)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

@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