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.
As I’m only interested in unique Business Process, I put a below Condition
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
In the end, flow ran successfully but data is not copied.
Do you have any idea what I’m doing wrong?
Thank you!
