RLS and value based email alerting

Hi all,

I have a question regarding how alerts work with RLS. Currently I have one report with RLS applied (filtered by grade)

So i have 6 row levels

1. Chief role
2. 4 roles for the "Heads" (per department)
3. and a final category for the members/employees

I have already created a workbook with the missing data regarding their timesheets. So each role is available to see

• employee -> only his data
• head - > his own  and his  team members data 
• chief - all the above

I made some metrics (such as : missing hours last week ,  missing hours last month), i refresh the data set every 2 minutes and now i want to create an weekly alert for each member as a reminder for his missing inputs. Moreover, I use Microsoft Flow to send the email, meaning that i would like to find a fast solution to send e mail for each one based on his missng hours ( eg Missing hours previous week>0). Do i have to create 30 ( we are 30 persons) different cards with specific alert or is there any clever solution?

Is it possible to combine the roles with the alers?

thanks in advance

theo