Copy one item from a list to another list when something is changed

[lennart0909]

Hi all,

I have created two lists in SharePoint: List A and List B (which will be the "master database"). 

This is what I want to create via PowerAutomate (FLOW):

When an action (item in List A) is completed, one can set the status of this action to "Fully Completed" in a specific column. Once this is done, the whole item should be copied, transferred to List B (master database) and can then be deleted in List A. The two list contain different columns. I provided two screenshots below. Screenshot 1 (List A, with Action Status on the right) and Screenshot 2 (List B, master database).

 List A

 

List B

If anyone could help me out, I would be very thankful!

[abm]

Hi @lennart0909 

Follow the below steps:

1. Create a trigger called "When an Item is created or modified"

2. Check the status with an IF condition whether it is completed

3. Under the Yes condition add a "Create Item" action step

4. Map the relevant values from your trigger

5. Finally use the Delete Item to delete the record. Here pass the id from your trigger.

Thanks