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

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 42 members 3,968 guests
Please welcome our newest community members: