Patch sharepoint list with multiple choice combobox

(0) Share

Report

Posted on by ervinw

I have combobox (cbbEducationInstructor) where Users can be selected.

My Patch function waits for a text variable:
Patch(Oktatasok;Defaults(Oktatasok); {Oktató: whatShallIWriteHere}));;

Shall I concatenate the DisplayName of Users?
What is the ideal solution for this?

The data stored as Text in my SharePoint list, not Choice column.

If I try another field (which is choice type), then it writes my field is Table but has a different scheme than cbbEducationInstructor.SelectedItems.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ervinw ,

Assuming that is a Person field the Combo Box is based on, this should write to a Text field with commas between the names

Patch( Oktatasok; Defaults(Oktatasok); { Oktató: Concat( cbbEducationInstructor; DisplayName; "," ) } )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
ervinw 83 on at

Like
a
(0)

Report
Copy link

Link copied!
I just have to correct it with .SelectedItems:

Concat(cbbEducationInstructor.SelectedItems; DisplayName; "," )

What if my SharePoint instructor field is choice type;
how can I save then?
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@ervinw ,

Probably something like this (it would need to be multi-choice)

ForAll( cbbEducationInstructor.SelectedItems; {Value: DisplayName} )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
ervinw 83 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for both answers.