Unanswered

ComboBox Selection not fully patching to SP List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Spoiler (Highlight to read)

Hi,

I have a powerapps form that has text input boxes and comboboxes for users to fill and submit. This updates a list on sharepoint. The comboboxes also populate the choices from the sharepoint list.

The combobox name is DataCardValue40. The patch formula does not let me write 'Business Line':Table(DataCardValue40.SelectedItems) and throws an error. If I write 'Business Line':Table(DataCardValue40.Selected), it accepts but then it only updates the first selection my SP list. Business Line is the Column which I want updated with the selection of choices.

Need help to fix this.

Hi,I have a powerapps form that has text input boxes and comboboxes for users to fill and submit. This updates a list on sharepoint. The comboboxes also populate the choices from the sharepoint list.The combobox name is DataCardValue40. The patch formula does not let me write 'Business Line':Table(DataCardValue40.SelectedItems) and throws an error. If I write 'Business Line':Table(DataCardValue40.Selected), it accepts but then it only updates the first selection my SP list. Business Line is the Column which I want updated with the selection of choices.Need help to fix this.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

notj 782 on at

Like
a
(0)

Report
Copy link

Link copied!

Is your column in SharePoint set to allow multiple selections?

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

Like
a
(0)

Report
Copy link

Link copied!

Yes it is.

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,'

You are Patching a number of values to a multiple value Choice field, which is a table, so the syntax for this field should be as below

'Business Line': ForAll( DataCardValue40.SelectedItems As aBL, {Value: aBL.Value} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you tell me:
Do you have a button control in the edit form?
Do you use the pathc() function to submit records?

If my assumptions are correct, the point is that the formula requires data of table data type.
When you use the selected property of the combo box control, it selects the first option among all the options. The data type of this option is a record. So use the table() function to convert the record type to the table type.
However, when you use the selectedItems property of the combo box control , It selects the options you selected. Its data type is table already. Therefore, there is no need to use the table() function to convert it.

You could try the following code:
Patch(LIST33,Defaults(LIST33),{Title:"1",'Business Line':DataCardValue40.SelectedItems}) // LIST33 Is my list name.

Best Regards,
Wearsky

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you tell me:
Has the problem been solved?
Is there anything else I can help?

If my post helps, then please consider Accept it as the solution to help others.Thanks
Best Regards,
Wearsky

Was this reply helpful? Yes No