Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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



Responsive Resident
Responsive Resident

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

Frequent Visitor

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.

Responsive Resident
Responsive Resident

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

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (9,864)