Answered

patch multiselection column

(0) Share

Report

Posted on by arobles

I'm new in powerapps and I would appreciate some help.
I want to patch a list with 2 fields: Title (text) a DepartsAfectats(Multiselect text)
I'm coding patch but it does not work and gives error "Argument type not valid"
Patch(ListaPetic;Defaults(ListaPetic);{Título:NumPeticNou.Text;DepartAfectats:ComboDeparts.SelectedItems});;
where NumPeticNou is a input text and ComboDeparts is a combobox with multiple value selection.

Please how must code it to work?
Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@arobles -

I am not seeing anything wrong with your code. Assuming your data source is SharePoint, what do you have in the Items property of your ComboBox control? I would expect:

Choices([@ListaPetic].DepartAfectats)

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @arobles,

WHat do you mean by DepartsAfectats(Multiselect text)? Is it a multi select Choice column or a multi-line-of-text column?

How you set the Items property of the ComboDeparts?

If DepartsAfectats is just a text column, I think you need to modify yoru formula as below:

Patch(ListaPetic;Defaults(ListaPetic);{Título:NumPeticNou.Text;DepartAfectats:Concat(ComboDeparts.SelectedItems,ColumnName,",")});;

Note that the ColumnName in Concat() represents the column value returned by your ComboBox selected items.

Was this reply helpful? Yes No
Verified answer

arobles 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your answer.
I changed Item definition of ComboDeparts to
Choices([@ListaPetic].DepartAfectats)
But I have the same result

Was this reply helpful? Yes No
arobles 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your answer.
DepartsAfectats is a multi choice column.

Was this reply helpful? Yes No
arobles 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Finally I deleted and defined again the multi select column and ..... now it works.
Thanks for yours suggestions.

Was this reply helpful? Yes No