Custom Lookup Field

[afernando]

Hi,

The dropdown control doesn't allow typing any text like in a SharePoint lookup field. 

Does anyone know if it's possible to create a custom lookup field not necessarily bound to a SharePoint list? 

Thanks,

Anton

[nickduxfield]

1.Add a dropdown control

Set the items to ["Choice1","Choice2","Choice3","Choice4"]

2. You can also convert an exisiting single line of text field from a SharePoint List where you wanted a lookup column, and change the control type to AllowedValues. Then you can do the above like a dropdown control.

3. Create a collection from another SharePoint List with the lookup values you want. Then apply that to a dropdown. This way you can have a choice field from another SharePoint List as a collection, or the collection from scratch.

You can also convert an exisiting single line of text field from a SharePoint List where you wanted a lookup column, and change the control type to AllowedValues. Then you can do the above like a dropdown control.

[afernando]

Hi @nickduxfield

Thanks for your comment. Can you please explain how can I change the control type to AllowedValues?

Cheers

[nickduxfield]

Look at my answer on this post: https://powerusers.microsoft.com/t5/PowerApps-Forum/Drop-down-local-values/m-p/53621#M22264 

[v-micsh-msft · Accepted solution]

Hi @afernando,

If here you mean to enable typing within a custom Dropdown control, then this is not available under PowerApps, currently.

There are ideas submitted on this:

Allow text input in the dropdown control offered under PowerApps Insert tab

Suggestions from @nickduxfield should mean to restrict field value within allowed values, you may also take the following thread as a reference.

Regards,

Michael

[nickduxfield · Accepted solution]

You can use a textinput together with an allowed values field or dropdown on the same datacard, to have a lookup like field.