Patch multiselect field- pls Help

(0) Share

Report

Posted on by Mana

171

Hello all,

I have am edit form to create some tasks as shown bellow:

My task field is a multi select choice column in sharepoint. I create a collection (colTasks) out of the form and then display the collection in a gallery:

Then I try to patch the items in the gallery into SharePoint but the problem is that I only patch the first item in the gallery (Task 2) and not Task 3.

ForAll(
colTasks,
Patch(
Meeting,
Defaults(Meeting),
{
Title: Now(),

Task: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Value: Gallery_Tasks_NextWeek.Selected.Label5
}
}
)
)

here is the image of sharePoint:

Can someone pls help me.

Regards

Angela

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Poma1 ,

I am not entirely sure I have read your structure properly here, particularly where you are using the Concat without a delimiter, however the below may be what you are trying to do.

Patch( Meeting, ForAll( colTasks, { Title: Now(), Task: ForAll( Gallery_Tasks_NextWeek.Selected.Task As aTask, {Value:aTask.Value} ) } ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Mana 171 on at

Like (0)

Report
Copy link

Link copied!

Hello @WarrenBelz

Thank you so much for your fast responce but I still get an error as showen below:

Invalid argument type(table). Expecting a record value instead.
The function "ForAll" has some invalid arguments.
The function "Patch" has some invalid arguments.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Poma1 ,

Firstly you do not need the "odata" reference any more, however that is not what I posted (you have colTaskName in there rather than Task). I am assuming here that the Task field is in the Selected record in the gallery.

Was this reply helpful? Yes No
WarrenBelz 154,447 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Poma1 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Mana 171 on at

Like (0)

Report
Copy link

Link copied!

Hello @WarrenBelz

Below is the solution that worked for me:

Was this reply helpful? Yes No