cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
motami
Level: Powered On

Filtering dropdown box options as I type

Hi all

 

I have an app to register employees and when choosing the employee from a dropdown box (as seen in the picture below) I'd like to be able to filter (there's around 300 employees) them as I type any single part of their name, for example, if I only remember their surname, I'd like to type it in there and it would return all the names of employees with that surname.

 

So far, on all my attempts, I've only managed for it to behave as default, it only shows the results that start with whatever I type.

 

screen.jpg

 

The main problem I'm getting, on practically any formula I try, is because these are Record entries, not Text, and so it can't filter them as I want.

 

Any help with this would be apprecciated, as it's the last "problem" with this app I'm having, and once fixed it will start being used.

 

Thanks in advance,

 

Miguel

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filtering dropdown box options as I type

Hi @motami,

 

Please take a try to switch the Dropdown control to a Combo Box control:

Combo box control in PowerApps

 

Or consider take use of the Search() function:

Filter, Search, and Lookup functions in PowerApps

 

See if that would help in your scenario.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Filtering dropdown box options as I type

Hi @motami,

 

Please take a try to switch the Dropdown control to a Combo Box control:

Combo box control in PowerApps

 

Or consider take use of the Search() function:

Filter, Search, and Lookup functions in PowerApps

 

See if that would help in your scenario.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
motami
Level: Powered On

Re: Filtering dropdown box options as I type

Hi @v-micsh-msft,

 

Thanks for your reply. 

 

I've tried using all those functions and all of them behaved the same way, except Search which wouldn't even work.

 

Today, I don't know how, I got the search function to work, I was probably configuring it wrong. 

 

I'm using the following formula:

Search(Choices(AIRC.Nomes); DataCardValue24.SearchText; "Value")

and it is FINALLY filtering the dropdown options by searching the user input text anywhere in each dropdown option.

 

Thanks so much for your help.

 

Miguel