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

Default Dropdown


I have 2 drop downs


  • Request (Yes/No) Dropdown from SP list 
  • COP Request (Lookup) Dropdown SP List

These need to have set defaulted values. I have looked at the other forums on this topic and my expression doesnt appear to picking up the value. See screen shot.



So for request I have used:

If(EditForm1.Mode=FormMode.New,{'@odata.type': #Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id: 0, Value:"Yes"},ThisItem.Same_x0020_User_x0020_Request)


As for the 2nd COP list could you please help how the expression should be written as this is a lookup?






Microsoft Employee

Re: Default Dropdown

As replied on a different threas, the formula is almost correct. Please see if the updated version below works for you. Please also note that it needs to be assigned to the YourComboBox.DefaultSelectedItems property:

If(EditForm1.Mode=FormMode.New, Table({'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id: 0, Value:"Yes"}),[ThisItem.Same_x0020_User_x0020_Request])

Level: Powered On

Re: Default Dropdown

Hi @dinusc


How does this work with a lookup coloumn to make a default? Using the combo box. Do you have an example If Statement?

Level 10

Re: Default Dropdown

Hi @daniellemaree


The default value of a drop-down/combobox depends on the Items property .

If your Items property is a default "Choices(...)", then you can use the same formula .

If you have customized the Items property to plug it directly to another DataSource, then instead of the {odata.type,id,value} object, you have to use a LookUp into your DataSource (but in this case you have to update the Update property of the DataCard).


Choices and LookUp have the same structure in SharePoint :

Value: "Value",
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}

The only difference is that the choice column doesn't required the Id property. 


Tell me if you need more explanations .




Microsoft Employee

Re: Default Dropdown

@daniellemaree, the problem is in the way the metadata is delivered for "Choices" type fields. THat metadata works fine for "Lookup" type.

Can you please confirm that the suggested workatround works?