Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

How to set a pre-populated default value of a Dropdown in EditScreen for a SharePoint Choice field?

Hi Everybody,


I'm currently trying to simply set the Default value of a Dropdown in an Edit Form (Form is opened and the Dropdown should have a pre-selection). Even though I did extensive research I couldn't find a solution for a Sharepoint choice field (as I don't know how to find the ID's of those choices and how to reference it?

I have the DropDown with the Selections from Sharepoint ("Inland", "Ausland") and would like to be the Default for a blank form to be "Inland".



Thank you so much for your help.





Responded there. Feel free to tag me in the thread in question in the future. 👍

Hi @vwyankee After watching Laura's video and getting most of it to work, I turned to @RezaDorrani 's video here ( ) because the Customer column in my SP List is a choice column, so I wanted to add a combo box drop down for the user to choose the Customer. 

I've tried to intuitively follow Reza's logic but have got stuck on the syntax since there is everything else going on with the many nested formulas. 

My screen looks like this:


The formula I tried to add to allow the user to search on a combination of the Ingredient Name and/or the Customer drop-down is below. The insertion I made is highlighted in yellow. The red line indicates the error underline that PowerApps is giving me.

(The green highlight is the context variable from @WonderLaura which I can use for sorting different columns, but that wasn't working for Customer, I think because Customer is a choice field.)


I would also like to include that if the combo box is empty, show all values.


Can anyone help me achieve this? Regards, GraemeNZ



Responded in the new thread you created - Filter a gallery based on combo box and text input

I had tried this to required cell, but it only lock the cell to the specific choice. When submitting, the error popped up and asking to fill up the cell, which I couldn't do that due to default setting. The text I locked was not considered as data entry but for text view only. Please assist me.

Frequent Visitor

can anyone help I have a form for a sharepoint list which has a choice field called "currency" this looks up the choices from another sharepoint list called "Currency List". I am wanting to default the value to EUR from my currency list which i have connected as a data source to the form and I have used the below formula in the default field but I get the attached error (expected operator) any ideas what I am doing wrong?


Lookup(Choices('Currrency List'.Currency Code),Value="EUR")

Frequent Visitor

Looks like this has already been solved, but posting a short video in case it helps anyone else:


New Member

Add a Collection to "OnStart" of the app. 

For Example:

ID: 1,
Value: "RED"
ID: 2,
Value: "GREEN"






Set the 'Items' value to your Drop Down List Menu to the Collection

For Example;

ITEMS (of drop down list) = RGB.Value


In the Drop Down List Menu Advanced Options, set the "AllowEmptySelection" value to 'false' (no quote).


This should prevent an empty value from appearing when the app is initialized.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,416)