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!
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
254 | |
106 | |
92 | |
47 | |
37 |