Skip to main content
Community site session details

Community site session details

Session Id : aFqb1lMXGw9GSD5mZC7HHp
Power Automate - Using Flows
Unanswered

How to copy items between two SharePoint lists via Flow

Like (0) ShareShare
ReportReport
Posted on 21 Feb 2024 14:44:13 by 50
 
Hello Team,

I’m working on a flow that should help me to:

  1. automatically copy chosen data from Source List to Copy List
  2. automatically update the chosen data in Copy List in case of any changes in Source List.

I already studied thousands of articles, YouTube videos and even post in this community but still cannot move out from the 1st point.

(Btw, I also followed this post but cannot deal with it: https://powerusers.microsoft.com/t5/Building-Flows/Copy-and-Update-data-between-two-sharepoint-lists... ) 

 

The structure of both Lists looks like that:

 Source List (around 30 columns & 1000 lines) – example of some columns / lines:

PDT

Business Process

(Title)

Feature

Session

Session Code

Business Process Link

Business Process Status

Target Date

PLN

PLN_BP1

ABC

S1

1

PLN_BP1_Link

Completed

dd-mm-yyyy

PLN

PLN_BP1

DEF

S2

2

PLN_BP1_Link

Completed

dd-mm-yyyy

PLN

PLN_BP2

GHI

S2

2

PLN_BP2_Link

Not Started

dd-mm-yyyy

OMS

OMS_BP1

JKL

S3

3

OMS_BP1_Link

Under Review

dd-mm-yyyy

OMS

OMS_BP1

MNO

S3

3

OMS_BP1_Link

Under Review

dd-mm-yyyy

OMS

OMS_BP1

PRS

S4

4

OMS_BP1_Link

Under Review

dd-mm-yyyy

 

Copy List (around 10 columns, only unique ‘Business Process’ values):

PDT

Business Process

(Title)

Business Process Link

Business Process Status

PLN

PLN_BP1

PLN_BP1_Link

Completed

PLN

PLN_BP2

PLN_BP2_Link

Not Started

OMS

OMS_BP1

OMS_BP1_Link

Under Review

 

 

So I started to build automatic flow - focusing at first only on coping chosen data (later I will think how to add an action to update the line in case of any changes in Source List):

 

AgnieszkaPoland_0-1708526609804.png

 

 

 

I added Get Items action and choose the fields that I would like to move from Source List to my Copy List (for test purpose, I choose only one field as once I choose more fields, I'm getting different errors).

All columns in both lists have the same headers. 

AgnieszkaPoland_1-1708526609968.png

 

 

 

As I’m only interested in unique Business Process, I put a below Condition

AgnieszkaPoland_2-1708526609674.jpeg

 

 

 

Nevertheless, in this condition:

Yes: Business process doesn’t exist in my Copy List, Create item

No: Business process already exists in my Copy List, no action required

 

AgnieszkaPoland_3-1708526609845.png

 

 

In the end, flow ran successfully but data is not copied.

Do you have any idea what I’m doing wrong?

Thank you!

  • AgnieszkaPoland Profile Picture
    50 on 23 Feb 2024 at 07:54:13
    Re: How to copy items between two SharePoint lists via Flow

    Hi, for now it works (but this still still magic for me 🙂 ) .

    Nevertheless, Business Process this is in fact TITLE column with changed name. Maybe only because of that it works.. 

  • The21k Profile Picture
    33 on 22 Feb 2024 at 20:28:15
    Re: How to copy items between two SharePoint lists via Flow

    I understand the flow runs correctly, but is the condition met? I feel like the dynamic variable that's on your condition may be incorrect, maybe you could have the field 'Business process' specified on the condition through dynamic variable, instead of body/value, but i'm not sure as i'm not familiar with sharepoint.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

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!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete