How to Save Power Apps Combobox Multiple Values to SharePoint List?

While working on a project, I was required to save multiple selected combo box items into a SharePoint list in Power Apps.

In this Power Apps tutorial, I will explain how to save Power Apps Combobox multiple values to SharePoint list choice field.

Additionally, we will discuss how to store combo box multiple values in a SharePoint text column with examples.

Save Power Apps Combobox Multiple Values to SharePoint Choice Field

Let’s see how to store Power Apps combo box multiple values in a Sharepoint choice column step by step:

I have a SharePoint list [Loan Approval] with the columns below:

In the choice field [Loan Type], enable the “Allow multiple selections” as below:

In the Power Apps form, there is a Combo box control where users can select multiple items.

When the user submits the items, those user-selected values will be saved in the SharePoint list choice column as shown below:

Follow the below steps to achieve this:

• Sign in to your Power Apps with your valid Microsoft 365 credentials.
• Create a Power Apps Blank canvas app ->Insert an Edit form -> Set its Data source property to:

'Loan Approval'

Where,

1. Loan Approval = Datasource name

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

Patch(
    'Loan Approval',
    Defaults('Loan Approval'),
    {
        Title: DataCardValue3.Text,
        'Loan Applied Date': DataCardValue8.SelectedDate,
        'Loan Type': DataCardValue4.Selected
    }
);

Where,

1. DataCardValue3 = Power Apps text-input control name
2. Loan Applied Date = SharePoint list column name
3. DataCardValue8 = Power Apps date picker control name
4. Loan Type = SharePoint list column name
5. DataCardValue4 = Power Apps combo box control name

• Save, Publish, and Preview the app. Enter the item details, including combo box values, and Submit it.

• Go back to the specific SharePoint list and refresh it once. You can see the new record has been created with multiple values, as shown below.

This is how we can store combo box multiple selected values in the SharePoint list.

Save Power Apps Combo box multiple values in SharePoint Text Field

Here, we will see how to store Power Apps combo box multiple values in a SharePoint text column.

I have a SharePoint list [Product List] that has two columns:

On my Power Apps screen, an Edit form is connected to the above SharePoint list. The form has two controls:

• Text-Input control [Product]
• Combo box control [Vendors]

However, I need to replace the text input control with a Combo box control that enables saving multiple items to a SharePoint list single line of text column.

The user will select multiple items from the Product Combo box control and click on the Submit button.

The Combo box selected values will be saved in a SharePoint list text column as shown below:

Follow the below steps to achieve this:

• On the Power Apps screen, insert an Edit form -> Set its Data source property to:

'Product List'

Where,

1. Product List = SharePoint list name

• Now, remove the Text-input control [Product] -> Select the Title DataCard and Replace a Combo box control as shown below:

• Select the Combo box control -> Set its Items property to:

'Product List'.Title

Where,

1. Product List = SharePoint list name
2. Title = SharePoint list title column

• Select the Title Data card -> Set its Update property to:

Concat(
    cmb_Product.SelectedItems,
    Title & " ,"
)

1. cmb_Product = Combo box control name
2. Title = SharePoint list Title column

• Now, we want to save the multi-selected values from a Combo box to SharePoint list single line of text column. Insert a Button Control -> Set its OnSelect property to:

SubmitForm(Form1);NewForm(Form1);

• Once your app is ready, save, Publish, and Preview it when the user selects multiple values from the combo box control and clicks on a button control.

• The multiple Combo box selected values will be saved in a SharePoint list single line of text column as shown below:

This is how we can save the Power Apps combo box multi-selected value to a SharePoint list text field.

Some more Power Apps articles you may also like:

• How to Set Combo Box Default Value in Power Apps
• Power Apps Combo Box Set or Get Selected Value
• Check if Power Apps Combobox has a selected value
• Power Apps Combo Box Search Office365Users

Conclusion

I hope this Power Apps article helped you learn how to save multiple values from a Power Apps Combobox to a SharePoint list choice field as well as a text field with various scenarios.

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.