A "Type Ahead" or "Searching" Dropdown control.

[Drrickryp]

I placed a textbox control over the window of the dropdown and set the color and fill to transparent, and set the clear button to “on”.  When the cursor is placed over the Textinput box both the text and fill of the control become opaque and will show the text that the Dropdown will use to search or filter.  When the cursor is moved off the Textinput box both the text and fill become transparent.  Depending on the datasource, use the Search function on the items property of the dropdown: Search(datasource, TextSearchBox.Text,"ColumnName")  or for SharePoint, use Filter(datasource,StartsWith(ColumnName, TextSearchBox.Text)). If the cursor is off the Textinput box, the control appears and functions as it normally does. Cursor over Textinput control

typing into Textinput control

Cursor off Textinput, control shows all items

[Anonymous]

I am using sharepoint and this isn't working for me. Invalid argument type (record). Expecting a text value. I am assuming you're inputting the formula under On Select? 

Thanks! 

@Drrickryp 

[Drrickryp]

For SharePoint use Filter() and StartsWith() in the Items property of the Dropdown control.

[Anonymous]

ah right...that's what it said in the initial post too. reading at 4am et isn't very productive. However, the issue is still the same...dropdown is expecting a choice and the textbox is outputting text...any thoughts? @Drrickryp 

[Drrickryp]

Hi @Anonymous 

I tested using a Choice field as the Items in your Dropdown but I had to modify it as follows and then it worked fine for me.

Filter(Distinct(Products_2,Category.Value),StartsWith(Result,TextInput2.Text))

[Anonymous]

Items accepted is as a solution without any errors but it's not working as intended for some reason. the dropdown is not working. if i search in the box, the text disappears. @Drrickryp