0

I've been playing with Flow: Send HTTP Request to SharePoint to create items in a list. Everything works great until I include the Person field: Assigned To.

error 400: A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property

Tried claims, display name, email...

enter image description here

Looking at the list item XML I see Assigned_x0020_ToId, so I guess I need to pass the numeric ID of the person. Do I need a step prior to resolve the user or look up their id?

Once I figure out this issue I would like to move on to something more advanced, like creating a list item for each person in a multiple person column...

enter image description here

FYI, I would have just used the available Create Item but Flow seems to ignore site column lookups.

1

Per my test in my SharePoint online environment, I create a person or group column named “p1” in the list. And then I create the flow in the list and add the “send HTTP Request to SharePoint“ action in the flow.

To get the internal name of the person column, you could use the URL below and find the person column. And the value of the person column is not the user name, it is the code.

https://yoursite /_api/web/lists/getbytitle('listname')/items

enter image description here

Then in the flow, I add the body like the picture below. enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.