Power Apps – Set Default Drop Down and Combo Box

Overview

In this tutorial we’ll walk through how to set default options for drop downs and combo boxes in Canvas Apps with Dataverse. This will help make your apps more user friendly by automatically filling in the most common selection.

YouTube

Set Drop Down Default Value to Dataverse Column

To set a default value in a drop down component, you will need to perform the following steps:

1. Select the drop down component
2. Select Default in the property list
3. Update the formula bar to reference the record’s drop down column in Dataverse
4. The field should now be updated with the field in the database. If you are switching between rows in a galley, the field will automatically update.

gallery_Accounts_DV.Selected.'Account Status'

Set Default Value if Dataverse Column is Blank for Drop Down

To set a fallback value for a drop down component, you will need to perform the following steps:

1. Select the drop down component
2. Select Default in the property list
3. Update the formula bar to check if the Dataverse value is blank
   • If blank, set the value to the preferred default in the option set
   • If not blank, reference the record’s drop down column in Dataverse
4. The field should now default to specified option when Dataverse value is blank. If you are switching between rows in a galley, the field will automatically update.

LookUp(Choices('Account Status Optionset'), ThisRecord.Value = gallery_Accounts_DV.Selected.'Account Status')

Set Combo Box Default Value to Dataverse Column

To set a default value in a combo box component, you will need to perform the following steps:

1. Select the combo box component
2. Select DefaultSelectedItems in the property list
3. Update the formula bar to Look Up the record’s drop down column in Dataverse. Note – This is different from drop down’s, since combo boxes references records
4. The field should now be updated with the field in the database. If you are switching between rows in a galley, the field will automatically update.

If(IsBlank(gallery_Accounts_DV.Selected.'Account Status'),
    'Account Status Optionset'.New,
    gallery_Accounts_DV.Selected.'Account Status'
)

Set Default Value if Dataverse Column is Blank for Combo Box

To set a fallback value for a combo box component, you will need to perform the following steps:

1. Select the combo box component
2. Select DefaultSelectedItems in the property list
3. Update the formula bar to check if the Dataverse value is blank
   • If blank, set the value to the preferred default in the option set using LookUp function with the option set
   • If not blank, reference the record’s drop down column in Dataverse using LookUp function
4. The field should now default to specified option when Dataverse value is blank. If you are switching between rows in a galley, the field will automatically update.

If(IsBlank(gallery_Accounts_DV.Selected.'Account Status'),
    LookUp(Choices('Account Status Optionset'), ThisRecord.Value = 'Account Status Optionset'.New),
    LookUp(Choices('Account Status Optionset'), ThisRecord.Value = gallery_Accounts_DV.Selected.'Account Status')
)