Patch multi select combobox as choice column

Like (0) Share

Report

Posted on 21 Jun 2022 10:20:36 by evalindag

117

Hi everybody

I have a combobox which has choices from a choices field in SharePoint (the formula for the combobox is: Choices([@'DataSource'].Disabilities) and it is set as SelectMultiple: true

I'm trying to patch multiple values and I've tried many different formulas but nothing seems to work.

I've tried creating a collection and patching that and tried patching as

Any help much appreciated 🙂

Best regards

Eva

Categories:

General Questions

All responses (6)

Answers (1)

ShefiBasheer 9 on 21 Jun 2022 at 11:48:10

Like (0)

Report

Re: Patch multi select combobox as choice column

On the "update" property of the datacard use the concat function
Concat(ComboBox1.SelectedItems, Disabilities,",")
evalindag 117 on 21 Jun 2022 at 11:39:15

Like (1)

Report

Re: Patch multi select combobox as choice column

Hi @Mink21 & @Silvester

It was the SharePoint setting for allowing more than one value that was causing the error 🙂 🙂 🙂
I changed it and the formula now works as a charm

Thank you so much for your help!

Best regards
Eva
Verified answer

Mink21 158 on 21 Jun 2022 at 11:26:31

Like (1)

Report
Re: Patch multi select combobox as choice column

Hi @evalindag ,

I understood it wrong then.
Try this:

Patch(YourTable, Defaults(YourTable), {Disabilities: ComboBox1.SelectedItems})
Make sure your column in SharePoint allows more than one value.
evalindag 117 on 21 Jun 2022 at 11:19:31

Like (0)

Report

Re: Patch multi select combobox as choice column

Hi @Mink21

I tried this and it works but it saves each selected value in the combobox as a different item in sharepoint. I want them to save as one item 🙂
Can I change this formula so it saves them all in one line?

best regards
Eva
Silvester. Akakpo 783 on 21 Jun 2022 at 10:42:21

Like (0)

Report

Re: Patch multi select combobox as choice column

Hi @evalindag ,
Check this post from @mdevaney ,
PATCH A SharePoint Choices Column With Multiple Values In Power Apps - Matthew Devaney, you should be sorted.
Kindly let me know how it goes.
Mind giving this post a thumbs up? Please accept it as a solution if it works for you.
Mink21 158 on 21 Jun 2022 at 10:39:33

Like (0)

Report
Re: Patch multi select combobox as choice column

Hi @evalindag

Try this:
ForAll(ComboBox1.SelectedItems, Patch(YourTable, Defaults(YourTable), {Disabilities: ThisRecord}) )