
So i have a large list on SPO. this list has over 5,000 records
I want to create a power flow that looks up a person by email listed in the owner field for example it looks up "JohnDoe@site.com"
for every field that has "johnDoe@site.com" as an owner then i want to remove "person 2" and "person 3" off of the owner delegate as they have moved on to a different department. I also want to keep any existing delegates that may have already been there.
I also want to run a flow that will add "person 3" and "person 4" to the owner delegate and Keep any existing delegates that may have already been there.
How can i do this, i watched quite a few videos and just can't come up with it