Hello, i have recently started using power automate, to try to create a list i can use to send emails to a population, that arrives from a survey forms entry into the list.
What i have struggeling with, is creating a flow, that has the following logic.
When a new item is created, check the list for all other items with the same email and then delete the all the other items that had the same email as the new item, which would then hopefully result in the only list item being left with a given email, would be the newly created item.
As i am rather new to the use of power automate, I am not sure any of the toying around i have been doing, may be of much help, but so far i have created the following flow, which does not work.
If it would be smarter to make an entirely different flow, form the one i have below, i would love to hear the reasonings and practises behind it as well, so i can become mroe acquiesced with the good practises for using power automate when constructing flows.

Thank you in advance