cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dudditz
Continued Contributor
Continued Contributor

Update SharePoint Person Field using Send HTTP Request

I am updating the metadata on a SharePoint document set which works fine until I add the person picker field into the mix.  Sadly, it seems as though you can't use the email like you can in the update item action which supports claims.  If anyone has any method of using the email I would prefer this as using the ID is very strange, it seems like it requires you to log into the SharePoint site at some point so it can create your ID on the hidden list.  I have no idea how long this ID lasts in this list and if the users does not use this site for a few months if it will drop from the list?  That said, using this method when adding the person picker field into the send http request I get the following error listed below.  I had this working previously and am using the same flow so not sure why this has stopped working.  Any guidance is appreciated.  1.jpg2.jpg3.jpg4.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Dudditz
Continued Contributor
Continued Contributor

How strange, so apparently5.jpg to update the people field using rest you need to have Id after the Column name even though this was not part of the column name and no double quotes on the value as seen.  This now works.

View solution in original post

3 REPLIES 3
eric-cheng
Solution Sage
Solution Sage

Hi @Dudditz ,

 

Your JSON should look like the below.  Wrap ProjectManager up double quotes and add a semi-colon.  Then wrap every underneath in another set of curly braces.

 

{
"ProjectManager":{
"_metadata":{
"type":"aaaa"
},
"customer":"bbbb",
"Accountnumber":"cccc"
}
}

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Dudditz
Continued Contributor
Continued Contributor

Thanks

 

Thanks for the reply, yes I had some clutter in the json that I have cleaned up however still getting an error.

 

for the reply, 1.jpg2.jpg3.jpgyep, that was a mistake, cleaned it up however still getting an error.  

Dudditz
Continued Contributor
Continued Contributor

How strange, so apparently5.jpg to update the people field using rest you need to have Id after the Column name even though this was not part of the column name and no double quotes on the value as seen.  This now works.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,259)