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

Do you want to save combo box multiple values to the SharePoint list in Power Apps? In this Power Apps tutorial, I have explained how to save Power Apps combobox multiple values into a SharePoint list.

Further, I will teach you how to save Power Apps combo box multiple values into a single-line text column in a SharePoint list.

Power Apps combobox save multiple values to a SharePoint list

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

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

Column Name	Data Type
Name	Title [It is a default single line of text, I just renamed it as “Name”]
Loan Applied Date	Date and time
Loan Type	Choice [“Home loan”, “Car Loan”, “Gold loan”]

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 by clicking on a button control.

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

To save multiple values from a Power Apps Combo box into a SharePoint list, you must first enable the “Allow multiple selections” option for the SharePoint list column.

To do this, open the SharePoint list, select the choice column > Column Settings > Edit > Toggle “On” on the Allow Multiple Selections > Save like the screenshot 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. Then, add a new data source for the above SharePoint list and set the Edit form’s Data source property.

Where,

• Loan Approval = Datasource name

• 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

• Save, Publish, 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.

• The multiple Combo box selected values will be saved to a SharePoint list choice column as shown below:

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

Submit multiple values from a Power Apps Combo box to SharePoint list single line of text

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

Example,

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

Column Name	Data type
Name	It is a default single line of text, I just renamed it as “Name”
Vendors	Lookup

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

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

• Text-Input control [Name]
• 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.

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

The multiple Combo box selected values will be saved in a SharePoint list single line of text column 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,

• Product List = SharePoint list name

• Now, remove the Text-input control [Product] -> Select the Title DataCard and insert 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, just Save, Publish, and Preview the app. 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 submit the multiple selected values of a Power Apps combo box to a SharePoint list single line of text column.

Conclusion

We can store the Power Apps multiple selected values of Combo box into a SharePoint list columns like:

• Single line of text
• Choice

In this Power Apps tutorial, I have explained how to save multiple selected Combo box values into a SharePoint list in Power Apps. Lastly, I have shown you how to submit multiple values from the Power Apps Combo box to SharePoint List single line of text column.

You may also like:

• Reset Combobox in Power Apps
• Power Apps Combo Box Search Office365Users
• How to Set Power Apps Combo Box Value On Button Click?
• Power Apps Combo Box Filter Gallery
• Check if Power Apps Combobox has a selected value