Patch Combobox selected items to a Column in Collection

(1) Share

Report

Posted on by rameshmukka

1,123

Hello Power Users,

I have a column called AreaofImprovement in my collection. I would like to patch selected items from a combo box to this column. But how do we patch a table (selected items from combo box) to a column in collection? When I used below snippet and trying to patch, it patches only the last selected item from my combo box(may be overwriting previous selected values) but not all. Please help!

ForAll(
ComboBoxImprov.SelectedItems,
Patch(
ColOTJSession,
First(ColOTJSession),
{AreaofImprovement: ThisRecord.Value}
)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RameshMukka
Patch(
ColOTJSession,
First(ColOTJSession),
{AreaofImprovement:ComboBoxImprov.SelectedItems}
)

should solve your issue.
Hope it helps !

Was this reply helpful? Yes No
rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!

@gabibalaban I have already tried this and I got below error.

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Well... it seems that you have in other place of your app AreaofImprovement column defined as text.
In this case, use:
Patch(
ColOTJSession,
First(ColOTJSession),
{AreaofImprovement:Concat(ComboBoxImprov.SelectedItems,Value&";")}
)

Was this reply helpful? Yes No
Verified answer

rameshmukka 1,123 on at

Like
a
(1)

Report
Copy link

Link copied!

@gabibalaban I was able to resolve this using the same snippet above but this time I initialized my collection column as AreaofImprovement : [""]

Was this reply helpful? Yes No
KaufnNailer on at

Like
a
(0)

Report
Copy link

Link copied!

Concat worked for me! Thanks!

Was this reply helpful? Yes No