Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

How to create a new item and add a user to a Person type column using SharePoint HTTP Request

Like (1) ShareShare
ReportReport
Posted on 4 Oct 2024 21:00:46 by 9
How can I create a new item in a SharePoint list and add an office365 user to a Person type column? The user won't always be a member of the site, so I'm not able to use the id of the site user. 
 
I've tried with the following code and didn't have any luck:
{
 "__metadata": {
    "type": "SP.Data.<List name>ListItem"
  },
"formValues":[
	{
	    "FieldName": "Actiontakenby",
	    "FieldValue": "[{'Key':'i:0#.f|membership|<email>]}'}]"
	}
    ],
}
I've also tried changing the Uri and use all of the following without any luck: /items , /AddValidateUpdateItemUsingPath , and /validateUpdateListItem
I've been able to submit and create the new item by removing the people type column, so I know this column is the one causing the issue.
 
 
I can't use 'Create Item' because I'm saving my site address as a variable to later share this flow as a template, this is why I'm using HTTP Request with POST method. 
  • Suggested answer
    FLMike Profile Picture
    FLMike 29,371 on 05 Oct 2024 at 01:00:28
    How to create a new item and add a user to a Person type column using SharePoint HTTP Request
    Hi
     
    Sorry I dont follow. If you are making it a configurable Site and Configurable List, why can't you use Create Item?
     
    I mean the whole point of using Environment Variables is to do exactly what you want to do and use it as a template.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,411

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,328

Leaderboard
Loading complete