I have a flow that copies a template list into a new list with a new name and also copies all of the items from that template list into the new list. Everything worked fine with the flow until I changed one of the template columns and made it a people picker column instead. Now, the flow fails when completing the item copy step or it completes successfully but just doesn't put anything in the people picker column in the new list.
I have searched around for a solution and I've tried some things that were recommended but they don't work either. What am I missing?
I was trying to copy a people person column from one list to another list using Send an HTTP request to SharePoint
Hi @lwerner ,
Are you trying to update a person column in a newly created list item using the Send an HTTP request to SharePoint?
See 1.2 Using a HTTP request to update a People column in Power Automate in 🚹SharePoint People Column : How to Update and Patch in Power Automate and Power Apps
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
i to am having the same issues. I am trying to pass the people picker data into a newly created sharepoint list using 'send to http sharepoint'. The flow ends with 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.
Thank you! Is there a way for me to incorporate this into my HTTP action to create my items? I'm very new to using the HTTP functions.
If not, I can see if I can figure out how to use what you have provided to go back to the items that have been created and update the AVPID columns.
HI @EMY9317
(1) Can I check that your flow works when you do not reference the new column AVPID column? Can you confirm that the flow still works if you do not use AVPID column in the flow.
(2) By way of an example, in the flow below the list is copied from "Issue Tracker" to "Issue Tracker 2". The list has two person columns AVPID and AVPID2:
In the Create items I've used both AVPID Claims and AVPID Email, but either one can be used.
(3) In this example, which achieves that same outcome as in step 2, may give you a hint on how to format the body of the HTTP request is
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
To clarify - The flow fails on the last HTTP action of creating the items.
I tried using an if(empty) expression for that field but I got the same error.
When I use either the AVPID Email or the AVPID Claims options the flow fails with error:
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.
Hi @EMY9317 ,
For the AVPID value, can you try using the AVPID Email or AVPID Claims:
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
Sure - here is the copy items action.
The replace expression is as follows:
replace(replace(string(setProperty(setProperty(body('Parse_JSON')?['actions'][0],'listName',variables('ListName')),'addNavLink',false)),'\','\\'),'"','\"')
This is my Select action:
But when I try to add the person column (called AVPID in my list) to the Select action, none of the dynamic content options seem to work.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2