cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RalfsZ
Helper I
Helper I

Combobox search within values

Hello!

We have a powerapp (Canvas), where users put it hours.  It goes to a list in Sharepoint.


When putting hours in, they also choose a Project.
Project comes from a Sharepoint list, and it is a combobox in the app.

The combobox can be made searchable, but I would like to ask, if there is any way to make it a bit more "smarter"?

 

Problem:

Project names consist of "YY-### Project Name", e.g. 22-111 Summer
Currently, the combobox search function is only able to search by the 22-111 portion of the values, but it is unable to search within the value, e.g., I can't type in project name and find the desired project, I have to know the project number.

Is there a way to make the combobox search within the value, or do I have to re-create the project list?

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
RalfsZ
Helper I
Helper I

Couple of lucky google searches later, I've found that this is very easy to do.

You have to add Filter to "Items" property of the Combobox.

More information can be found here:

PowerApps - enhance Combo Box search functionality - Office 365 Basics


To give this a more meaningful answer:

This is the default behavior for the ComboBox:

Choices([@'Your Source Library/List'].ValueSourceColumn)

What you have to do:


Filter(
Choices('Your Source List/Library'.ValueSourceColumn),
DataCardValue14.SearchText in Value
)

I've bolded the stuff you need to change for this to work.
All credit goes to the author in the posted link.


View solution in original post

1 REPLY 1
RalfsZ
Helper I
Helper I

Couple of lucky google searches later, I've found that this is very easy to do.

You have to add Filter to "Items" property of the Combobox.

More information can be found here:

PowerApps - enhance Combo Box search functionality - Office 365 Basics


To give this a more meaningful answer:

This is the default behavior for the ComboBox:

Choices([@'Your Source Library/List'].ValueSourceColumn)

What you have to do:


Filter(
Choices('Your Source List/Library'.ValueSourceColumn),
DataCardValue14.SearchText in Value
)

I've bolded the stuff you need to change for this to work.
All credit goes to the author in the posted link.


Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,660)