cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rahul123
Frequent Visitor

flow for sending email notification for absent student

Hello All, 

I am trying to create a simple flow that sends an email notification to all relevant personnel.  

scenario:

1. when student absent status ( choice column) " returned to school" no email notification

2. when a student's absent status ( choice column) is " Absent", then check the column " due days", due days more than 3, and less than 6 send an email notification to email from the "teacher" column. if  "due days" are more than 6 days send an email notification to email from the " principal" column. 

Not sure if I can give functionality where Teachers and Principal can add their comments as well?

 

any help will be appreciated.

 

Rahul 

4 REPLIES 4
Shujaath_Khan
Super User
Super User

Hi @rahul123 

You can run scheduled flow to make it automated

  1. condition if student is absent and 3 < due date <6
    1. send approval mail to teacher so she can put some comment and save comment back in list
  2. condition if student is absent and due date > 6
    1. send approval mail to principal and capture principal comments and save it in list.

Thanks

Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

rahul123
Frequent Visitor

Thank you @Shujaath_Khan for your reply, can you please check my flow and advice accordingly 

 

rahul123_0-1659051952701.png

i have set my trigger condition as  @equals(triggerBody()?['Attendance/Value'],'Absent')

 

thank you

Rahul

This is fine, 

You can ignore the no step on right side.

rahul123
Frequent Visitor

@Shujaath_Khan , sorry I didn't mention, that the flow picture I pasted is not working. do you have any suggestions?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,196)