cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

How to Update multi user field/column using Patch()?

Hello,

 

I have came across scenario where I need to update SharePoint list mutiuser field called "InterestedIn".

Here multiple users can register their interests in particular list item using a button which says "I am interested"

on this button I need to add/append current user to the list column "InterestedIn"

 

Below is my code on button click, some how i need to add current user to existing users in columns and then Patch()

 

Patch(
GrabOpp,
galOpenOpportunities.Selected,
{
InterestedIn:Table(
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & User().Email,
Department:"",
DisplayName:User().FullName,
Email:User().Email,
JobTitle:"",
Picture:""
})
}
)
Thanks. 🙂

10 REPLIES 10

Exactly what i needed Thank you 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (103,110)