cancel
Showing results for 
Search instead for 
Did you mean: 

Autocomplete control

I am really missing the autocomplete control. A cohntrol where the user can start entering data and it will then make suggestions based on a datasource, the user should not be forced to use any of the suggestions.

We have the drop down control and we have the textbox control. But the Autocomplete control can make it really easy for mobile users to enter data.

 

I really hope you will add this Smiley Very Happy

 

Status: Completed

We are recommending the combo control for this scenario. Please review documentation on the combo control here:

 

https://docs.microsoft.com/powerapps/maker/canvas-apps/controls/control-combo-box

 

Thank you for your patience, and continued feedback,

Audrie

 

Comments
Chimosh
Regular Visitor
I have a workaround for this. If you guys are interested I can post here.
BeemerBum
Regular Visitor

@ChimoshAt this point a work around would be great!

Chimosh
Regular Visitor

Create a Text box to act as search field.

For Example I am using a customer company name lookup.

The search field will be labelled searchcustname
I then use a drop down menu below it that will trigger and populate the company names based on what is typed into searchcustname.

Capture.PNG

 

The drop down menu contains the following code:

Distinct(Filter('[dbo].[CUSTTABLE]', StartsWith(NAME, SearchCustName.Text )), NAME)

Where [dbo].[CUSTTABLE] is the table that i am required to look at to pull the customer information.


Where StartsWith(NAME, SearchCustName.Text )), NAME) creates the filter for the column in [dbo].[CUSTTABLE] called NAME, with what is entered into Searchcustname.

Result is when I type a letter or the start of the company the drop down menu will filter the results and show me either the exact company name of for example if I type X, it will show all companies starting with X.

Capture.PNG

BeemerBum
Regular Visitor

Thanks @Chimosh  for the workaround. This should prove very helpful.

 

Cheers!

Dcurran12
Advocate IV

@Chimosh Is there away to extend this so that:

1) I can pick an item from the resulting filtered list and have it update the text box

2) Or the text box can be a new thing

 

For example, in my app, I'm gathering Sales Forecast info...if the customer exists, I want the customer from the list.  If its a new customer, I want whatever the sales person enters in the box.

 

Is it possible to extend your example to accomodate this?

Skyinou
New Member

Hi,

 

@Dcurran12 I found a workaround for this.

 

You set up a Dropdown and a Textinput as explained by Chimosh.

 

In the field "Default" for the Textinput, you type a new variable. (for the example: MyDefaultText)

In the field "On Select" for the Dropdown, you put:

UpdateContext({MyDefaultText: Dropdown.Selected.Name}); Reset(Textinput)

(Where the dropdown is named Dropdown, the text input is named Textinput and Name is what you want from the Dropdown values.)

All that's left to do is set up MyDefaultText to "" somewhere; most likely in the "Onvisible" from your screen, or a "new form" button.

UpdateContext({MyDefaultText: ""})

 

That way, if you select something on the dropdown, the variable is updated, and so is the default value of your input field. And then the reset function makes it take the new default value.

 

Hope that helped,

 

Skyinou

Audrie-MSFT
Power Automate
Status changed to: Need Info

This is the case for the Combo Control. See details here:

https://docs.microsoft.com/powerapps/maker/canvas-apps/controls/control-combo-box

 

Please let me know if this helps with this feature request.

 

Thank you,

Audrie

Dcurran12
Advocate IV

Combo control works nicely...thanks!

Audrie-MSFT
Power Automate
Status changed to: Completed

We are recommending the combo control for this scenario. Please review documentation on the combo control here:

 

https://docs.microsoft.com/powerapps/maker/canvas-apps/controls/control-combo-box

 

Thank you for your patience, and continued feedback,

Audrie

 

gatsbe
New Member

Combo box seems nice, but it does not seem to allow to add a new value, only select from existing.