Unanswered

Drop down menu search option

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I've created a dental app with drop down menus of dental procedures such as fillings extractions, crowns and so on. There are over 100 proceudres. as the list gets longer, it is getting time consuming to scroll through all the options. Is there a way to add a search box or maybe modify the drop down menu where you can type the first 3 letters, like ext and extrations would come up?I've been trying to find a solution and have been unsuccessful so far.

The drop down is part of a gallery.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

murali Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, you should be able to do that.

Create a text input control e.g. TextInput1
Set Dropdown control's Items property to Search(DS, If(IsBlank(TextInput1.Text), "",TextInput1.Text), "The column you wish to search in")

Where DS is the datasource that stores dental procedure info

Hope this helps.

Thanks
Murali

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Murali,
Thanks for your help.My drop down item is set at Criteria.Procedure.
I changed it to the following:
Search(Criteria,If(IsBlank(TextInput3.Text),'Procedure',TextInput3.Text) and keep getting an error message. How do I fix that?
Thank you

Was this reply helpful? Yes No
murali Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The formula is incorrect.

here is the right one assuming the datasource is "Criteria" and the column name is "Procedure"
Search(Criteria, If(IsBlank(TextInput3.Text), "", TextInput3.Text), "Procedure")

Murali

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I tried the formula you provided and even though it works, it's not doing what i wanted it to. I think i wasn't clear as to what i'm trying to do. Attached is an image of my app. The drop down in top left contains a list of 100 procedures. once the procedure is picked, it populates into the gallery as shown in column 2 and 3. when Amalgam is picked, text boxes populate as shown. What I was tryig to do was replace the drop down menu with a textinput box where instead of scrolling through 100 procedures, I can type the first few letters of the procedure that would pop up and populate the gallery as shown above. The formula that was provided allows me to input the proceudre into the textinput box and populates the dropdown menu with criteria1 which is textbox 1 right underneath textinput box labeled site.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Any solutions for any of this?

Was this reply helpful? Yes No
hpkeong 2,944 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Allowed me to share to use:
- ListBox
- Visible

Please see the attached.

Hope this helps.Have a nice day

Was this reply helpful? Yes No