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

Update People Column via Send an HTTP request to SharePoint

Hi guys,

 

I am kind of stuck, trying to update a Sharepoint List People Column, via the activity 'Send an HTTP request to SharePoint' from my Cloud Flow. 

 

This is a snippet from my POST body:

TokeJacobsen_0-1654759232312.png

 

MakerTeamsAuto is the column name of my People column.

 

The odd thing here is that the POST request works - it does put data in the list, but the people column is empty:

TokeJacobsen_1-1654759415717.png

 

What am I doing wrong? 

Hope anyone can help me :.

 

Thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @TokeJacobsen,

 

You could use the validateUpdateListItem method for this. 

 

Below is an example of that approach.

 

{
    "formValues":[
	{
	    "FieldName": "MakerTeamsAuto",
	    "FieldValue": "[{'Key':'i:0#.f|membership|jane@contoso.onmicrosoft.com'}]"
	}
    ]
}

 

updatevalidatelistitem.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @TokeJacobsen,

 

You could use the validateUpdateListItem method for this. 

 

Below is an example of that approach.

 

{
    "formValues":[
	{
	    "FieldName": "MakerTeamsAuto",
	    "FieldValue": "[{'Key':'i:0#.f|membership|jane@contoso.onmicrosoft.com'}]"
	}
    ]
}

 

updatevalidatelistitem.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


TokeJacobsen
Helper I
Helper I

It works! You are the man! Much appreciated!! 

Thanks!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,217)