Showing results for 
Search instead for 
Did you mean: 
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.  


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.



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.


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.

Frequent Visitor

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



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


thank you


This is fine, 

You can ignore the no step on right side.

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

Power Automate News & Announcements

Power Automate News & Announcements

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

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,478)