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, let me explain how to save Power Apps multiple selected combo box items into a SharePoint list.

Additionally, you will learn to store selected multiple values from a Combo box to a SharePoint list [single line of text column].

Power Apps combobox save multiple values to a SharePoint list

This section will explain how to save multiple selected combo box values into the SharePoint list in Power Apps.

For Example, I have created a SharePoint list [Loan Approval] with the columns below:

Column NameData Type
NameTitle
Loan Applied DateDate and time
Loan TypeChoice [“Home loan,” “Car Loan,” “Gold loan”]
powerapps combobox save multiple values

The SharePoint list choice column, the “Allow multiple selections” option, as shown below:

Power Apps save mutliple Combo box items into SharePoint list

On my Power Apps screen, an Edit form is connected to the above SharePoint list. The form contains a Combo box control where users can select multiple items. Once they select it, they can click on button control.

How to submit multiple selected Power Apps combo box values into the SharePoint list

Later, the multiple combobox selected values will be saved to a SharePoint list choice column as shown below:

Power Apps store mutiple selected values of combo box records into SharePoint list

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
Save mutiple selected values of combo box records into SharePoint list in Power Apps
  • Insert a Button control -> Set its OnSelect property to:
Patch(
    'Loan Approval',
    Defaults('Loan Approval'),
    {
        Title: DataCardValue1.Text,
        'Loan Applied Date': DataCardValue5.SelectedDate,
        'Loan Type': DataCardValue2.SelectedItems
    }
);

Where,

  1. Loan Approval = SharePoint list name
  2. Title = SharePoint list title column
  3. DataCardValue1 = Power Apps text-input control name
  4. Loan Applied Date = SharePoint list column name
  5. DataCardValue5 = Power Apps date picker control name
  6. Loan Type = SharePoint list column name
  7. DataCardValue2 = Power Apps combo box control name
How to Save Power Apps combobox multiple values to SharePoint list
  • SavePublish, and Preview the app when the user provides information in the edit form and selects multiple values in a combo box control. Then click on a Button control.
Save Power Apps combobox multiple values to SharePoint list
  • The multiple Combo box selected values will be saved to a SharePoint list choice column as shown below:
Power Apps save mutiple selected values of combo box records into SharePoint list

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

Submit multiple values from Power Apps Combo box to SharePoint List [Single line of text]

Here, you will learn how to store Power Apps combobox multiple values into a SharePoint list single line of text column.

For example, I have a SharePoint Online list [Product List] that has two columns:

Column NameData type
ProductTitle
VendorsLookup
Power Apps save the multiple selection Combo box

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.

How to save Power Apps multiple selection Combo box

Now, whenever the user selects multiple items from the Product Combo box control and clicks on a Submit button.

Power Apps submit multiple selection Combo box to SharePoint list single line of text column

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

Power Apps submit multiple selection Combo box to a SharePoint list

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
How to save Power Apps multiple selection Combo box to SharePoint list
  • Now, remove the Text-input control [Product] -> Select the Title DataCard and Replace a Combo box control as shown below:
Submit multiple selection Combo box to SharePoint list in Power Apps
  • 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
Power Apps Combo box with multiple select saving into a text field
  • 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
How to store Power Apps multiple selection Combo box
  • 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);
Store Power Apps multiple selection Combo box to SharePoint list
  • Once your app is ready, just SavePublish, and Preview the app when the user selects multiple values from the combo box control and clicks on a button control.
Submit multiple selection Power Apps Combo box to SharePoint list single line of text
  • The multiple Combo box selected values will be saved in a SharePoint list single line of text column as shown below:
Store multiple selection Combo box in Power Apps

This is how we can submit the multiple selected values of a Power Apps combo box to a SharePoint list single line of text column.

Conclusion

We can save the Power Apps multiple selected combo box items into a SharePoint list choice column or a Single line of text column.

In this Power Apps tutorial, I have covered how to save the multiple selected combo box values into the SharePoint list in Power Apps.

Lastly, you have learned to submit multiple values from a Combo box to SharePoint list single line of text column in Power Apps.

You may also like: