Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

GET Items from one list POST to another, diffrent sites, diffrent user id's

In my flow I use Send an HTTP request to SharePoint (GET) _api/web/lists/getbytitle('ListA')/items

And part of the body looks like this:

"assigned": {
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
"Claims": {
"type": "string"
"DisplayName": {
"type": "string"

In the next step I use Parse JSON and use the same as the body above.

And in the output i get a result that looks like this:

"assignedStringId": {
          "__metadata": {
          "results": [
And this is a Person/Group field allowing multiple persons.
Then I use a HTTP request POST to another list, and in the body I use
'assignedId': {'results': items('Apply_to_each')?['assignedId']?['results']
This gives me the correct output with the assigned user id from ListA, but the list Im updating (ListB) is located on another site, so the users dont have the same ID, so for example the ID nr 13 on site where ListA is located the ID belongs to John Doe, but on the site where ListB is located its Jane Doe.
I tried adding a HTTP request using _api/web/siteusers to get the user email from the site where ListA is located and use that insted in the POST to ListB but cant figure out how to achive this when its multiple id's involved in the output.
In the list the field is "Field=assigned" and from the JSON parse I get a dynamic content "DisplayName" or "Claims" or "Email"
for ex body('Parse_JSON')?['items']?['properties']?['assigned']?['items']?['properties']?['DisplayName'] and if I try using that the Flow runs and then break with Error Details: 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.
Any help appreciated!
Community Support
Community Support

Hi @henkerunesson 

Do you want to copy items from ListA to ListB? You can try to use Get items and Create item action to achieve it.

I set up a simple flow , you can refer to the screenshots below to see if it helps.

This is my test ListA


Another list 


Flow in details:


Assigned Claims Field, first choose 'Enter custom value',then choose 'Assigned Claims' from the dynamic content. 



After flow runs, the items will be created in 'ListB'.


Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Frequent Visitor

Hi @v-LilyW-msft 

Thanks for reply!


Im using this solution today (copy items), and its working but I would like to improve it.

Today I have 7 lists where users update information and with Flow I update all information to one masterlist for managers to monitor.

In current solution when an item is updated, we remove all items in the masterlist that is coming from that "sublist" and then resend them, but the flow is not quick enough so if the user updates two items within a couple of seconds the flow repost all items twice.

Maybe I could look into adjust the current flow to not remove all items insted just send the update, but when I started to look in to this I found I way to use the API and do batch updates which is a much faster procedure.

In the new Flow Im creating everything works, except for the "assigned" field and I wanted to give it a try and find a solution before I go back and adjust the current flow.


Best regards


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,849)