Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Drop down local values

Hi all,


I was wondering if it was possible to set the dropdown values in a choice column in Powerapps instead of Sharepoint.


The current method of the list looking up the SP values occasionally returns zero results and confuses the users.


Please let me know if this can be done and where/how the change can be made



Level 8

Re: Drop down local values

Option A:

You can add a column in SharePoint as a Single line of Text instead of a lookup or Choice column.

Then in Powerapps, change the control to 'Allowed Values'.

Filter lookup values from a list in SharePoint to display non empty values etc.



  1. Avoid lookup column threshold
  2. Easy to manage
  3. Can create a collection of the list which contains the Choice values.

Option B:

in your dropdown control Items, or AllowedValues filed write this syntax



Can ellaborate,

Search for Ennumeration in Powerapps

Level: Powered On

Re: Drop down local values

Any hint on where the AllowedValues field is? I'm looking though the datacards on my form and haven't been able to find it yet.

Level 8

Re: Drop down local values














See i have a single line of text control as an allowed values type.


Gotcha: You need to convert it before you unlock the card. Otherwise, you won't get the option.allowedvalues2.PNG



Helpful resources


Power Apps Community User Group Member Badge

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


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (3,747)