How to Display Combo Box Items from SharePoint list in Power Apps?

Do you want to bind a Power Apps combo box items from a SharePoint list? In this tutorial, I will show you how to bind Power Apps combo box items from a SharePoint list.

I will also show you how to submit the Power Apps combo box selected items into a SharePoint list.

Display Combo Box Items from SharePoint list in Power Apps

This section will show how to bind or display the Power Apps combo items from a SharePoint list.

Example,

I have a SharePoint list [Customer Details], which has various columns like:

Column Name	Data Type
User Name	Title
Country	Single line of text

Here, I want to bind the list of countries to a Power Apps dropdown list.

On my Power Apps screen, there is a Power Apps Combo box control that is connected to the above SharePoint list column [Country]. Whenever the user expands the combo box control, it shows the values from the respective SharePoint list column.

To achieve this, follow the below steps:

• Sign in to your Power Apps with your valid Microsoft 365 credentials.
• Create a Blank canvas app -> On the Power Apps screen, insert a Combo box control [Click on +Insert -> Expand Input -> Select Combo box]

• Set the combo box Items property to:

'Customer Details'.Country

Where,

1. Customer Details = SharePoint list name
2. Country = SharePoint list column name

• Save, Publish, and Preview the app. Now, the combo box control contains the items from a SharePoint list column, as shown below:

This is how to bind the Power Apps combo items from a SharePoint list.

Power Apps submit Combo box records into the SharePoint list

In this section, I will show you how to store Power Apps combo box selected items in the SharePoint list.

For example, [Here, I have taken the same above SharePoint list as a reference]

My Power Apps screen has an Edit form containing a text-input control and a Combo control, whenever the user selects a value from the combo box control [country] and clicks on a button control.

• Then, the selected value will be saved in the SharePoint list as shown below:

Now, create a blank canvas app by using the SharePoint list and follow the below steps:

• On the Power Apps screen, insert an Edit form -> add a new data source for the above SharePoint list and then Set the Edit form’s Data source property.

Where,

• Customer Details = Datasource name

• Insert a Button control -> Set its OnSelect property to:

Patch(
    'Customer Details',
    Defaults('Customer Details'),
    {
        Title: DataCardValue2.Text,
        Country: cmb_Country.Selected.Value
    }
)

Where,

1. Customer Details = SharePoint list name
2. Title = SharePoint list title column
3. DataCardValue2 = Text input control name
4. Country = SharePoint list column name
5. cmb_Country = Combo box control name

• Save, Publish, and Preview the app. When the user provides the user name in the text-input control, select a country from the combo control and click on a button control.

• Now that data will be saved in the SharePoint list as shown below:

This is how to submit Power Apps Combo box records into the SharePoint list.

Conclusion

In this Power Apps tutorial, I have explained how to display Power Apps combo box items from a SharePoint list. In one real example, I have shown you how to bind a Power Apps combo box from a SharePoint list.

Lastly, I have covered how to store Power Apps combo box items in a SharePoint list.

You may also like:

• How to Populate Distinct Values in Power Apps Combo Box?
• Power Apps Combo Box Sort
• Power Apps Combo Box Search Office365Users
• How to Set Combo Box Default Value in Power Apps?
• How To Save Power Apps Combobox Multiple Values To SharePoint List?
• Power Apps Combo Box Concatenate Display Fields