how to patch a multible choice dropdawn to a list

(0) Share

Report

Posted on by vaso

132

how to patch a multible choice dropdown to a lcolumn in a list?

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

LaurensM 12,516 Moderator on at

Like (1)

Report
Hi @vaso,

Patching a multi-select combobox to a multi-select choice field will look as follows (see .SelectedItems) :

Patch( ListName, Defaults(ListName), //Change to LookUp / a record reference if you want to update { requiredField1: "test", MultChoiceColumn: ComboBoxName.SelectedItems } )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
HI @vaso

Plz try this function

Patch( 'data source', LookUp('data source', columnname), { dropdown: dropdown.SelectedItems } )

Refer this link :- PATCH A SharePoint Choices Column With Multiple Values In Power Apps - Matthew Devaney

Thanks!

Was this reply helpful? Yes No
vaso 132 on at

Like (0)

Report

I m missing something
I type the patch
Patch('VISIT PLAN & FEEDBACK R1';Defaults('VISIT PLAN & FEEDBACK R1');{Target:stoxos.SelectedItems) and is not working

Was this reply helpful? Yes No
vaso 132 on at

Like (0)

Report

Sorry
Patch('VISIT PLAN & FEEDBACK R1';Defaults('VISIT PLAN & FEEDBACK R1');{Target:stoxos.SelectedItems})

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
@vaso at first glance that looks correct. Is there a specific error you are receiving?

A few things you could do to troubleshoot the issue:

Make sure the ComboBox called stoxos has Choices('VISIT PLAN & FEEDBACK R1'.Target) as its Items property

Make sure you are not forgetting any required fields in your Patch (e.g. Title)

Make sure the column Target allows multiple choices (not just 1 choice)

Was this reply helpful? Yes No
vaso 132 on at

Like (0)

Report

@LaurensM
Hi, sorry I m a beginner...
What if my column is a text?

Was this reply helpful? Yes No
vaso 132 on at

Like (0)

Report

I made the column Target a "choices" one with the same choices the combobox stoxos has
Yes i have the title the formula is working without patching that column that way and when i add the target is having the red underline saying that the target is not in line with the anticipated "record" and that a tale is found. (this is a translate from Greek language)

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
No worries, we are here to help 😊

If it is a text column then we will need to concatenate the values within the ComboBox with a separator such as a comma, space...

Patch( 'VISIT PLAN & FEEDBACK R1'; Defaults('VISIT PLAN & FEEDBACK R1'); { //You might have to replace Value (with e.g. a columns name) if it gives an error Target: Concat(stoxos.SelectedItems; Value; ", ") } ) //This will save your options as text e.g. Choice1, Choice2, Choice3

I hope this helps!

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report

Ok we are getting close 😊. Now I expect that it will still be a single-select choice column since it expects a record.

Try to edit the column, go to 'more options' and set the toggle 'Allow multiple selections' to true - afterwards refresh your datasource in the Power Apps editor.

Was this reply helpful? Yes No
vaso 132 on at

Like (0)

Report

when i right the formula when i reach the point of writing value then it opens a bracket ( like a formula

Was this reply helpful? Yes No