Patching a collection to a sharepoint list

(0) Share

Report

Posted on by bigcodes-42

I have a gallery where you select multiple values and it puts the values in a collection:

OnSelect = Collect(Collection_Name,ThisItem)

The current code I am using to send Collection_Name to the SharePoint list is:

OnSelect = Patch(Sharepoint_Name, Defaults(Sharepoint_Name), { Column_Name:Collection_Name } )

Column_Name is a choice column that takes multiple selections.

The error I get is "Expecting a table value, but of a different schema" and "Missing column. Your formula is missing a column 'Value' with a type of 'Text'.

How do I send Collection_Name to a column that takes multiple values?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bigcodes-42 ,
For updating a choice field, try using below syntax -
OnSelect = Patch(Sharepoint_Name, Defaults(Sharepoint_Name), { Column_Name: {Value: Collection_Name }})

Was this reply helpful? Yes No
bigcodes-42 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @NandiniBhagya20, thanks for replying. The code did not work. The error it is giving me is "does not match the expected type 'table'. Found type 'record'".

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try wrapping it inside a table function.
Are you using choice field with multi select option enabled

Was this reply helpful? Yes No