web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sending an email to st...
Power Automate
Answered

Sending an email to staff member for a specific service

(0) ShareShare
ReportReport
Posted on by 51

Hi, 

We are looking at making a flow that will do the following:

  • Email a specific staff member, with customised answers, when a student has booked e.g., Maths goes to Joe Bloggs and Chemistry goes to John Smith.
  • An email to be sent the day before with the list of the 8 students that have booked.

Not sure if this is doable or if it could be a possible future feature.

Any advice would be great.

Many thanks in advance.

Categories:
  • Verified answer
    RobElliott Profile Picture
    10,539 Super User 2026 Season 2 on at

    @GraceGarwood For the first bullet point of your post, to have an email go to a different person based on the subject selected by the user you should use a Switch which is a type of condition that looks at just 1 thing, in this case the subject. There can be up to 25 "cases" for each Switch, i.e in case Subject equals Maths then do something, or in case Subject equals Chemistry the do something. Inside each switch you would have a set variable that saves the email address to send the email to. Then add a new send an email action action below the cases and for the To field select the variable.

     

     A simple example of a Switch like this is shown below:

    1-SwitchEmail.png

     

    Rob
    Los Gallardos
    Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

  • GraceGarwood Profile Picture
    51 on at

    Perfect, thank you for this Rob. I will give it a try this afternoon. 

    Kind Regards, 

    Grace

  • GraceGarwood Profile Picture
    51 on at

    Hi @RobElliott I have noticed this is aimed at Forms, we are using Bookings.

  • RobElliott Profile Picture
    10,539 Super User 2026 Season 2 on at

    @GraceGarwood it should still work with the Bookings "when an appointment is created trigger". The rest of it from the initialize variable would be the same.

  • GraceGarwood Profile Picture
    51 on at

    Hi, I have got it working to a degree, apart from the last part. I'm not sure if I am missing something but when I have filled in the Equals*, Name and Value it is not sending the email to a staff member, it is sending it to the name of the service, please see the screenshot:

     

    GraceGarwood_0-1713530585198.png

     

  • RobElliott Profile Picture
    10,539 Super User 2026 Season 2 on at

    SOrry, I can't tell anything from that screenshot, but I haven't used Bookings in Power Automate so don't know what the dynamic content would be selected for the name of the user.

  • GraceGarwood Profile Picture
    51 on at

    Hi, I have fixed it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 414

#2
11manish Profile Picture

11manish 331 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard