HI @v-yuxima-msft ,
Thanks for your reply. Here is my scenario. There are two departments, Dept1 and Dept2, which needs to check for dues and if there are any to be collected, a single email to the manager has to be sent. The manager has to collect them and respond back to each team. I am currently trying is
If (Dept1.HasDues && (Dept2.HasDues || Dept2.Status="Closed") && Manager.Notified=false),
// Email Manager
The same applies to Dept2 as well
If (Dept2.HasDues && (Dept1.HasDues || Dept1.Status="Closed") && Manager.Notified=false),
// Email Manager
Below is my DB design
MasterList
EmpName, Manager, EmpID, HireDate, ExitDate, Status
ApprovalList (A task for each dept)
EmpName, EmpID, Dept, AssignedTo, ApprovalStatus, HasDues, Comments
Should I also include a new filed in the master list for whether the manager is notified or any other way to track this?