Copying entries from one Sharepoint list to another depending on the input name in a particular column

[AB21]

Hi all,

I have a a list that contains staff data which is inputted through a power app. What I want to do is get a particular row of data copied  to another Sharepoint list depending on what is entered in the column field 'floor' 

Main list where all data is put into: 

So in this case Alex has selected Com/Hum for floor so I want to create a flow that reads this and copies any row from this sharepoint list to another if staff put Com/Hum in the floor column 

This would be the Com/Hum sharepoint list 

Is this possible as an automated flow? 

Thanks in advance 

[Jcook · Accepted solution]

Hello @AB21

Please check out this awesome blog post:
https://flow.microsoft.com/en-us/blog/copying-using-filtering/

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others