Power Platform Community Forum Thread Details

I have a scenario where I need to use the HTTP to Sharepoint action in Power Automate to save my data from Power Apps.

The power automate flow seems to create a new item in the SharePoint for all columns except a Person column which I continue to get an error.

I'm passing the data from Power Apps using the following code:

Set(varPerson, 
 {
 Claims:"i:0#.f|membership|" & Lower(myemail@abc.com),
 DisplayName:Office365Users.UserProfileV2(myemail@abc.com).displayName,
 Email:myemail@abc.com,
 Picture:"",
 Department:"",
 JobTitle:""
 });

'API-POST'.Run(
 "Comments",
 "POST",
 0,
 JSON(
 {
 Audience:"External",
 Comment:"Testing",
 Item:"Comment",
 Person:varPerson 
 }))

When I run the Power Automate, this is the error I'm getting:

Spoiler (Highlight to read)

{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected."}}}

As you can see on the screenshot below, I'm sending the body from Power Apps to Power Automate through JSON.

Can anyone tell me how to send the person array correctly? I feel like I'm missing something.

Thanks ahead

Categories:

Building Power Apps