Is it possible to create a that will copy a row item from SharePoint Lis1 to SharePoint List2

[kharina]

Dear Power Automate Community and Admins, 

I have 2 SharePoint Lists: SP1 and SP2. 

and

How can I automatically update the columns in SP2 whenever the status from SP1 is changed?
The Column that I want to update in SP2 depends on the choice of size in my SP1 and also the Quantity in my SP1 ( this quantity comes from my powerapps app).

Can this be done via flow? 

Thank You and Kind Regards,

Kharina

[leyburn19]

The easiest way is to use on modify or new record SP trigger.  If the status is is equal to some thing then do the create new record action.  

Big Warning. 

1. if you modify the main record more times and the status is the same it will also create a new record

2. If you do something in this flow that changes the main record as well but does not change the status you will end up with perpetual running loop

[kharina]

Thank you for your reply @leyburn19 ,

This is the reason why I opened a topic here. I hope to get a solution that will not give me another problem because I can't get my flow to work.

I really hope to get someone who can be patient with me on this because I'm trying for weeks already but kept on failing 😞

Thank you,

Kharina