flow for sending email notification for absent student

[rahul123]

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 

[Shujaath_Khan]

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]

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

Rahul

[Shujaath_Khan]

This is fine, 

You can ignore the no step on right side.

[rahul123]

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