Next review email notificationto supervisor

It sounds like your supervisor query doesn't have the correct select criteria associated to it.
Are you getting the Employee's Supervisor from HR11 and linking to HR07 to get the userid of that supervisor?

Yes I am getting the supervisor from HR11.The query is as follows:
PROD=TEST9&FILE=EMPLOYEE&INDEX=EMPSET1&COND=IS-SUPERVISOR&FIELD=COMPANY;EMPLOYEE;LAST-NAME;FIRST-NAME;EMAIL-ADDRESS&SELECT=EMP-STATUS%21%3DTF|EMP-STATUS%21%3DRT&OUT=CSV&DELIM=~

I'm guessing this is your query to find the supervisor email address?
This query is retrieving employee records where the employee is also a supervisor and their status meets the additional criteria. You aren't limiting by employee number (which should be a value in your index key).

You should query EMPLOYEE to find the employee's supervisor. You should then query HRSUPER to find which employee is assigned to that supervisor code, linking to EMPLOYEE to get the supervisor's name, email, etc.

Thanks for that tip. I have my flow now picking up the supervisor email address but it seems to send every single email to the last supervisor in the supervisor listing.I don't know what I am doing wrong. I have attached my flow for your reference

Well, your 90DayReview Query should be the first one in the sequence and then HRSuper with the Supervisor code from 90DayReview as part of the select criteria. The "Query" query should look up the email for the supervisor from their HR11 record. If the Supervisor email is on their HR11 record then you don't need the ResourceQuery.

You don't really need a Branch within your 90DayReview or 30DayReview since the query should only pick up valid records. You could have your first 90DayReview query pick up both 30 & 90 day values and then use a Branch to seperate them into the different MsgBuilders.

If you want to set up a quick phone call next week, I'd be happy to walk you through this.

David,
Thank you so much for that prompt reply to my query. I will try and see if I can modify my flow based on the recommendations you have made.If not I will set up the phone call for next week. Either way I will send you an update.
Thanks.