Skip to main content
Community site session details

Community site session details

Session Id : J+DWNJnbt61oQOkg8kTi0P
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 10 Nov 2023 16:05:01 by 48

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?

 

  • lwerner Profile Picture
    7 on 09 Dec 2023 at 13:33:47
    Re: Copy item with dynamic people picker field to a new list using HTTP action

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

     

     

  • Ellis Karim Profile Picture
    11,155 Super User 2025 Season 2 on 09 Dec 2023 at 13:26:26
    Re: Copy item with dynamic people picker field to a new list using HTTP action

    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 Profile Picture
    7 on 05 Dec 2023 at 17:56:14
    Re: Copy item with dynamic people picker field to a new list using HTTP action

    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.

  • EMY9317 Profile Picture
    48 on 13 Nov 2023 at 15:26:46
    Re: Copy item with dynamic people picker field to a new list using HTTP action

    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.

  • Ellis Karim Profile Picture
    11,155 Super User 2025 Season 2 on 10 Nov 2023 at 23:02:15
    Re: Copy item with dynamic people picker field to a new list using HTTP action

    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:

    Snag_211a79d.png

     

    Snag_217e67d.png

    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 

     

    Snag_230843f.png

    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 Profile Picture
    48 on 10 Nov 2023 at 21:58:08
    Re: Copy item with dynamic people picker field to a new list using HTTP action

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

    2023-11-10_15-56-04.jpg

  • EMY9317 Profile Picture
    48 on 10 Nov 2023 at 21:50:39
    Re: Copy item with dynamic people picker field to a new list using HTTP action

    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 Profile Picture
    48 on 10 Nov 2023 at 21:29:02
    Re: Copy item with dynamic people picker field to a new list using HTTP action

    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.

  • Ellis Karim Profile Picture
    11,155 Super User 2025 Season 2 on 10 Nov 2023 at 21:10:03
    Re: Copy item with dynamic people picker field to a new list using HTTP action

    Hi @EMY9317 ,

     

    For the AVPID value, can you try using the AVPID Email or AVPID Claims:

    2023-11-10_10-02-07 (2).jpg


    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 Profile Picture
    48 on 10 Nov 2023 at 20:49:24
    Re: Copy item with dynamic people picker field to a new list using HTTP action

    Sure - here is the copy items action.

    2023-11-10_14-40-49.jpg

    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:

    2023-11-10_10-02-07.jpg

    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.

    2023-11-10_14-45-49.jpg

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2