Store multiple selected value of combo box to Sharepoint List

(0) Share

Report

Posted on by Quincy_Chan

Dear All,

It would be appreciated if you could help.

I am trying to store multiple selected values of a combo box (ProductLineCombo) in the Sharepoint list.

However, none of the results of this field were transferred to SharePoint.

The setting of 'Product Line' in Sharepoint is Choice, with multiple selections allowed.

I tried to set it as text, but it was not working. Is there any way I can save it as text, for example, "A,B"? thank you.🙏

Patch(

'Data Collection',

Defaults('Data Collection'),

{

'Product Line':Concat(ProductLineCombo.SelectedItems,",")

}

);

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Yogesh Murugan 451 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Try this Code :
ClearCollect( SelectedProducts, ProductLineCombo.SelectedItems.Value ); Patch( 'Data Collection', Defaults('Data Collection'),, { 'Product Line': Concat(SelectedProducts, Value & ",") } );

Was this reply helpful? Yes No
SebS 4,867 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@Quincy_Chan

You said the Product line is a choice column, which means You can't concat results into it.

There is a specific Schema you need to follow and to achieve what You looking you need code like this

Patch( 'Data Collection', Defaults('Data Collection'), { Title: "Test", 'Product Line': ForAll( ProductLineCombo.SelectedItems, { 'Value': Value } ) } );

You notice I added Title when you create new record title is required as well

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

HI @Quincy_Chan ,

How you set the ProductLineCombo Items property?

SInce you have tried to set it as text, I suggest you refresh the data source in the Power Apps, and then I want to know how you set the Items property of the ComboBox after you change it into Text column because original Items formula does not apply after you change column type.

Furthermore, I suggest you changed it into Choice column allowing multi select again and refresh the data source in the Power Apps, modify your formula as:

Patch(
'Data Collection',
Defaults('Data Collection'),
{
'Product Line':ProductLineCombo.SelectedItems
}
)

The above formula only works when you set the ProductLineCombo Items property with:

Choices('Data Collection'.'Product Line')

Was this reply helpful? Yes No