Power Platform Community Forum Thread Details

How to copy items between two SharePoint lists via Flow

Hello Team,

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

automatically copy chosen data from Source List to Copy List
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):

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.