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.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,886)