Saving multiple combobox to choices column in sharepoint

[Anonymous]

Good day everyone. I'm trying to save a multiple combobox into a choice type column named testingtesting in sharepoint. The combobox data source is from an excel file. When I try, I've been getting "the property on this control expects text values, but this rule produces table" error in the default properties of the datacard. 

the source for the combobox named DropList from an excel business

the excel file

[Anonymous]

Interesting ! 😂

[zmansuri]

What's your update property of the data card?

[Anonymous]

 Here is the update property of the data card. The combobox2 is the name for combobox for the data

[zmansuri]

Are you trying to store multi select combobox?

[v-qiaqi-msft]

Hi @Anonymous,

Do you want to save the Combo Box selected workers to the Choice column in SP list?

Could you please tell me if you have created a Choice column that allows multi select in your SP list?

Firstly, please make sure that you have created a Choice column that allows multi select in your SP list, just modify your Update property as below:

ForAll(
            Combobox2.SelectedItems,
            Worker
        )

[Anonymous]

@v-qiaqi-msft 

Yes I've already created a choice column that allows multi select in SP. 

I've copied your code but it says Expected Text Value.

@zmansuri 

Yes I'm trying to store multi select combobox in SP list but with datasource from an excel

[v-qiaqi-msft]

Hi @Anonymous,

Could you please check if you have paste the formula on the Update property of the data card?

It is impossible for a Choice column to have that error message.

A Choice column allowing multi select could not expect a text value. Check the screenshot as below, you should put my formula into the Update property.

[Anonymous]

@v-qiaqi-msft both of your codes giving the same error 

I change it to Combobox2.Selected.Worker and the error goes away but another error pops up in default.

[v-qiaqi-msft · Accepted solution]

Hi @Anonymous,

Here is how I set in my scenario:

This is the Combo Box where I populate with the Excel Worker column:

This is the data card where how I set the Default property in the Edit form, note that the Module is the Choice column in my SP list.

This is the data card where I set the Update property as below to save the multi select:

DataCardValue9.SelectedItems

Here is the test result: