ComboBox search capability

(0) Share

Report

Posted on by EuniceG11

I have a drop down menu on a form which I have replaced with a ComboBox to make it searchable.

However, the search function only works if I get the name I'm searching for completely correct.

For example, if I'm trying to search for "Access Navigator Update", but forget the full name of the project and start typing just "Navigate", the ComboBox will not find it.

Is there any way to change it so the ComboBox can find any word the user is searching, not just the exact title?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

cmitchener on at

Like (0)

Report

Just a couple of questions: what data are you searching (SharePoint list, collection, etc.), what are you filtering (table, gallery, etc.), and are the combo box options preprogrammed or dynamic?

Was this reply helpful? Yes No
EuniceG11 50 on at

Like (0)

Report

Hiya. The ComboBox is pulling choices from a SharePoint list. I'm using:

Choices([@'PMO Portfolio Monthly Updates'].'Work Title')

When a user tries to search for their specific project title, rather than scroll through all the options (there are many options!), I want them to be able to type in part of their project name and it will pop up. At the minute, this works if they get the name of their project exactly right. However, if they only remember part of the project name, I would like the ComboBox to be able to search that as well. For example, if the whole project name is "Access Navigator Update" but the user only remembers "Navigator", I would like the ComboBox to find it.

The ComboBox options are dynamic and will change as more projects are added to the list on the SharePoint list.

Was this reply helpful? Yes No
Verified answer

v-hanytian-msft Microsoft Employee on at

Like (0)

Report

Hi @EuniceG11 ,

According to your Description, we have created the data source blow.

The Items of Combo Box:
Filter(Choices([@'0707_2'].'Work Title'),ComboBox2.SearchText in Value)

Hope this will help you,

Best Regards,
Tina

Was this reply helpful? Yes No
EuniceG11 50 on at

Like (0)

Report

Yesssss!!!! That works perfectly. THANK YOU!

Was this reply helpful? Yes No