Copy item with dynamic people picker field to a new list using HTTP action

[EMY9317]

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?

[ekarim2020]

Hi @EMY9317 ,

Please see if the following post helps:

🚹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

[EMY9317]

So I would need to add an additional HTTP action at the end of my flow (after all of the items are created to the new list) to then update those items with the person information?  In your post you showed how to do this, but only for a specific item.  How do I do this for all of the items (I have 126 items in my list)?

[ekarim2020]

Hi @EMY9317 ,

Can you please show your flow, particularly the copy item action. I think you are using the Select action to copy the values, then using that to create an item in to your new list? But it wasn't clear from the screenshots.

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

What is the expression you are using for the People picker?

[EMY9317]

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.

[ekarim2020]

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

 

[EMY9317]

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.

[EMY9317]

I tried using an if(empty) expression for that field but I got the same error.

if(empty(item()?['AVPID/Claims']),'',item()?['AVPID/Claims'])

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.

[EMY9317]

To clarify - The flow fails on the last HTTP action of creating the items.

[ekarim2020]

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

[EMY9317]

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.

[lwerner]

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.

[ekarim2020]

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

[lwerner]

I was trying to copy a people person column from one list to another list using Send an HTTP request to SharePoint