Power Platform Community Forum Thread Details

Hello everyone 🙂

I have a flow that sends an email when a certain field (mail adress) in my SharePoint list is updated or created.

Is it possible to check if this mail adress is somewhere else in my SharePoint list?

I have three fields for mail adresses (person to contact) and the notification should only be sent if the added mailadress is nowhere in my SharePoint list.

The fields names are 1st, 2nd and 3rd Counterpart.

And the flow is triggered if there is a change (edit or completely new) in the 3rd Counterpart field.

Right now my flow looks like this

Sorry the next part is a little chaotic 😕

I wanted to check if the correct column was changed, it has a certain ending (=it is a mail adress) and the last two where my attempts to check if the entry is already somewhere but it doesnt work.