Answered

Saving multiple combobox to choices column in sharepoint

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Interesting ! 😂

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

What's your update property of the data card?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you trying to store multi select combobox?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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 )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
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:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft Thank you so much, I followed your method step by step and it works. I think the problem is because I change the SP type from single line text to choices without removing and creating a new datacard, I just add a new combobox.

Was this reply helpful? Yes No