Would you like to set a default value when using a combo box control in Power Apps? If so, this Power Apps tutorial will show you how to set a default value within a Power Apps combo box control based on various scenarios, such as:
- Power Apps combo box default value
- Power Apps combo box default multiple values
- Power Apps combo box default value text
- Power Apps combo box default value from SharePoint list
- Power Apps combo box default value empty
- Power Apps combo box default value variable
- Power Apps combo box default value from gallery
- Power Apps combo box default value lookup
- Power Apps combo box default value based on another combo box
Power Apps combo box default value
A combo box control in Power Apps typically holds the options and the items for the user to select. It can be strange to scroll through a list of combo box items to find a specific item. In this case, we must specify a default value in the Power Apps combo box control.
The properties DefaultSelectedItems and Default in the Power Apps combo box control allow the user to select the initial item(s) before interacting with the control. However, because the Default property is deactivated, use the DefaultSelectedItems property instead.
To find this property, we are going to add a combo box control to the Power Apps screen. Then select the control and go to the Advance Property or the top properties panel > DefaultSelectedItems.
Now we will add a default value to the combo box control. As a result, when the user launches the app, it will display the previously selected item by default. For this, the following steps are:
- Let’s add some custom values on the Items property of the Power Apps combo box control.
Items = ["USA","UK","Canada","India","Russia","Brazil"]
To set a default selected value, on the DefaultSelectedItems property insert a default value from the above choices like below:
DefaultSelectedItems = ["Canada"]
Every time it will display “Canada” as the default selected value while opening the Power Apps. This is how to set a default value within the Power Apps combo box control.
Read How to Reset Power Apps Combo Box
Power Apps combo box default multiple values
Because the Power Apps combo box control accepts multiple-selected values, we can also set multiple values as the combo box control’s default selected items. In this section, we’ll look at how to set multiple default values within the Power Apps combo box control.
We are going to use the above example of the custom combo box control where we will set multiple items as the default selected items. Suppose, we want to set both ‘Canada and USA‘ as the default items. For this, we will set the DefaultSelectedItems property as below:
DefaultSelectedItems = ["Canada", "USA"]
Note: The text value is enclosed with the pair of square braces and denoted within the ” “. Similarly, multiple text values are separated within the square braces by commas (‘,’) and ” “.
Whenever we will open the specific app, we can see these items as the default selected items. This is how to set default multiple values within the Power Apps combo box control.
Read Power Apps combo box with Office 365 users
Power Apps combo box default value text
There are different ways to set the text value as the default value within the Power Apps combo box control.
Case-1: Set default value manually
In the preceding example, we set the text value for the combo box’s default selected item as an array. For example:
DefaultSelectedItems = ["<Text Value from the combo box choices>"]
Follow the above example to set the text value as the Power Apps combo box default value.
Case-2: Set default value using table()
There is another way to set the text value as the default selected item within the Power Apps combo box control. Here, we will use a Table() to store the default value and use it in the control.
To implement this, we are going to use the above example of the Power Apps combo box control. Insert the below expression into the DefaultSelectedItems property of the combo box control.
DefaultSelectedItems = Table({Value: "Canada"},{Value:"Russia"})
Whenever the user opens the app, the above default selected items will be displayed within the Power Apps combo box control. This is how to set the Power Apps combo box default text value.
Read How to Sort Combo Box Items in Power Apps
Power Apps combo box default value from SharePoint list
Here, we will see how to set a default value within the Power Apps combo box control using the SharePoint list. That means we will build a Power Apps combo box control using a choice column from a specific SharePoint list.
Suppose, we have a SharePoint list named BikeSales having a Title (Default) and Payment Mode (Choice column).
Connect the above SharePoint list to the app to work with in Power Apps. Then, on the Power Apps screen, we’ll add a combo box control based on the SharePoint list choice column mentioned above. For this, insert the below expression in the Items property of the combo box control.
Items = Choices(BikeSales.'Payment Mode')
From the above combo box control, let’s set the Advance Payment as the default selected item. For this, insert the specific item within the DefaultSelectedItems property like the below:
DefaultSelectedItems = ["Advance Payment"]
Each time when we open the app, it will display the ‘Advance Payment’ as the default selected item.
This is how to set the Power Apps combo box default value using the SharePoint list column.
Read How to Patch Power Apps Combo Box
Power Apps combo box default value empty
While working with the Power Apps combo box control, it will appear blank and let the user select their desired items from the combo box control. However, we can set an empty value in the Power Apps combo box control’s DefaultSelectedItems property programmatically or with a Blank().
DefaultSelectedItems = Blank()
This is how to set the Power Apps combo box default value to empty.
Power Apps combo box default value variable
Here we will see how to set a default value using a variable within the Power Apps combo box control.
That means we will create a variable within the Power Apps and using that variable we will set a default value in the Power Apps combo box control. To work with this scenario, the following steps are:
- On the Power Apps screen, we will add Button control and insert the below expression on the OnSelect property. So that when the user clicks on the button, it will create a variable and values.
OnSelect = Set(VarApp, ClearCollect(ColApp,{AppName:"Power Apps"},{AppName:"Power BI"},{AppName:"Power Automate"}))
In the above expression, we have created a global variable named VarApp and inside the global variable, we have created a collection named ColApp to hold the multiple values. Where AppName is the name of the collection header.
- Let’s click on the button in the app’s preview mode. We can find all the collection’s values under the global variable below:
- Now, add a combo box control to the screen. Set the collection name i.e., ColApp in the Items property.
Items = ColApp
- To set the default value, insert the below expression on the Combo box’s DefaultSelectedItems property.
DefaultSelectedItems = Filter(VarApp,AppName = "Power Apps")
Where,
- VarApp: The name of the global variable that we have created
- AppName: The name of the collection header name that has been created under the global variable
- “Power Apps”: Specify the default text value from the variable
Once the formula is applied, we can see the combo box will display the default value as Power Apps from the variable itself like below:
This is how to set the Power Apps combo box default value from the variable.
Read Power Apps combo box filter
Power Apps combo box default value from gallery
In this section, we’ll look at how to set a default value in the combo box control from the gallery. That is, we will create a gallery and then add a combo box control outside of it.
When a user selects an item from the gallery, the combo box control displays the default choice value. In addition, the user can select any alternate item from the control and modify it into the appropriate gallery item.
To implement these scenarios, we are going to use the above SharePoint list (i.e., BikeSales), and the following steps are:
- In the Power Apps screen, build a vertical gallery using the above SharePoint list as a data source that is shown below:
- Add a combo box control to the screen and place it beside the above Power Apps gallery. Insert the below expression on the ‘Items’ property to display the ‘payment mode’ options on the Power Apps combo box control.
Items = Choices(BikeSales.'Payment Mode')
- Now we will insert the below expression on the gallery’s TemplateFill property to get the item that is selected.
TemplateFill = If(ThisItem.IsSelected, LightGoldenRodYellow, White)
- Also, to display the default choice from the gallery’s selected item on the combo box control insert the below expression on the combo box’s DefaultSelectedItems property.
DefaultSelectedItems = {Value: Gal_BikeSales.Selected.'Payment Mode'}
Where Gal_BikeSales is the name of the Power Apps gallery control name.
Let’s run the app. We can see while selecting any item from the Power Apps gallery, the respective choice value of the Payment mode will display on the combo box control like below.
If you want to modify the default selected item from the combo box control, insert the below expression on the combo box’s OnChange property.
OnChange = Patch(BikeSales, LookUp(BikeSales, ID = Gal_BikeSales.Selected.ID),{'Payment Mode':Cmb_PaymentMode.Selected})
where Cmb_PaymentMode is the name of the combo box control.
Let’s select another choice (ex: Advance Payment) from the combo box control to modify the selected gallery item. We can see it will display the modification on the gallery as well as the SharePoint list too.
This is how to set the default value within the PowerApps combo box control from the gallery.
Read Power Apps Combo box with SharePoint list
Power Apps combo box default value lookup
We’ll look at how to use the lookup field to set a default value within the Power Apps combo box control. That is, we will use a combo box control to display the default value from the SharePoint lookup field.
Suppose, we have prepared a SharePoint list named Departments having some departments in the Title column like below:
Next, we have prepared another SharePoint list named Workers, including a lookup column named Department, that looks up the data from the above Departments’ Title column like below:
Now, move to the Power Apps environment and add an edit form in the Power Apps screen using the above Workers’ SharePoint list.
- To set a default value from the lookup field, select the ‘Department data card’ under the edit form. Then insert the below expression on the Default property of the Department data card.
Default = {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: LookUp(
Departments,
Title = "IT",ID),
Value: "IT"
}
Where,
- ‘@odata.type’: “#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference”: While working with the SharePoint lookup field we need to insert this connector query.
- Departments: The SharePoint list name
- Title, ID: The name of the SharePoint list column
- “IT”: We set the lookup value i.e., IT as the default value
We can see, it is displaying the lookup item, i.e., ‘IT‘, as the default item within the above combo box control of the Power Apps edit form. Now we can fill out the form, submit it, and save the submitted data to the SharePoint list (i.e., Workers).
For this, set the edit form’s Default mode as New. Then add a Save icon to the edit form and insert the below formula on the save icon’s OnSelect property.
OnSelect = SubmitForm(Form1); ResetForm(Form1); NewForm(Form1)
Where Form1 is the name of the Power Apps edit form.
Our Power Apps form is now complete, with a default lookup value in the combo box control. When a user enters data into the form and clicks the save icon, the data is saved to the SharePoint list.
This is how to set the default value from the SharePoint lookup field in the Power Apps combo box.
Read Power Apps Cascading Dropdown Control
PowerApps combo box default value based on another combo box
Here, we will see how to set a combo box default value based on another combo box selection within the Power Apps. That means when an item is selected in the first combo box, the selected value will be displayed as default in another combo box control.
To work with this scenario, we are going to use the above SharePoint lists i.e., Workers and Department. Along with these, we will use another SharePoint list named Projects that has a lookup column named Department and this lookup column use the look-up data from the Department’s Title column.
Using the above SharePoint lists (Workers and Projects), we will build 2 edit forms within the Power Apps like the below:
Now, select the Department Datacard value (i.e., the combo box control) on the second Power Apps edit form(i.e., Projects) and insert the below expression on the DefaultSelectedItems property.
DefaultSelectedItems = DataCardValue9.Selected
Where DataCardValue9 is the name of the department data card value from the Workers edit form.
Now preview the app. We can see whenever we select any department from the first combo box control(i.e., Workers data source), it will display the default value on the second combo box control automatically (i.e., Projects).
This is how to set a Power Apps Combo Box default values from another Power Apps combo box control.
Conclusion
From this Power Apps Tutorial, we learned all about how to work with the default value(s) within the Power Apps combo box control based on different scenarios. Such as:
- Power Apps combo box default value
- Power Apps combo box default multiple values
- Power Apps combo box default value from SharePoint list
- Power Apps combo box default value text
- Power Apps combo box default value empty
- Power Apps combo box default value from gallery
- Power Apps combo box default value lookup
- Power Apps combo box default value based on another combo
- Power Apps combo box default value variable
You may like the following Power Apps tutorials:
- Power Apps Checkbox control within Gallery
- How to Filter Power Apps Dropdown Control
- How to Work With Power Apps Dropdown Blank Values
- How to Remove Duplicates in Power Apps Dropdown
- How to Set Default Value in Power Apps Dropdown
- How to use Power Apps Gallery Dropdown
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Out audiences are from the United States, Canada, United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a SharePoint MVP(8 times), check out My MVP Profile. I have also worked in companies like HP, TCS, KPIT, etc.