Forum Discussion
send an email to separate individuals based upon a qualifying criteria.
Greetings microsoft community
I've currently set up a flow on Power Automate (abet basic), when a new item is created on SharePoint, it sends an email. However, I need it to send it to a specific sales coordinator that they have an open item that needs to be actioned upon. Seeing there are several coordinators, how do I set up a condition so that it only emails a specific person?
Kind Regards
1 Reply
slacker234 first you should create another list where each item holds the email address and the subject they are responsible for:
The flow will run when an item is added to the request for info list:
The flow looks like this and instead of a normal condition it uses a switch which is a type of condition that looks at just one thing, in this case the subject that the sales coordinators have responsibility for:
In the Switch I've select RequestForInfo Value as it is a choice column. One advantage of a switch over a normal condition is that you can have up to 27 "cases" whereas the maximun number of nested conditions is 8.
In each case add a get items to get the items from the coordinators list but make sure you add a filter query; in the image below it is Subject eq 'CUPRA'
Then add the send an email (v2) action which will wrap itself in an apply to each which is expected. In the To field of the send an email select the column which contains the coordinator's email address, in this casre the Title column.
As the actions in each case are the same just changed to reflect the filter query, make use of the copy to colipboard in the 3 dots at the top right of the actions.As a new item is created in the request for info list the flow will run and will go down the relevant channel. In this example a request had come in for info on the CUPRA car brand and so the flow went down the CUPRA channel in the switch and the appropriate email was sent to the correct coordinator.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
