I have a table of trainers and a table of trainees, there is a REF between them. I want to send each trainer an email that contains a list of their related trainees and their status. What I get is a bunch of identical emails with a list of every trainerโs trainees, which is miles long. The report workflow is set up to act on the trainers table, โFor each row in tableโ, with the condition: isnotblank([Related Trainees By Area Tech Trainer]) so that we hopefully wonโt send an email to a trainer with no trainees (there are a few, donโt ask). The action sends an email (currently just to me for testing purposes) based on a template.
Here is the start of my email template for my report:
<<Start:Select(Trainers[Name],true)>>
Trainee Report for:
<<[Name]>>
___________________________________
<<Start:Select([Related Trainees by Area Tech Trainer][RandomID], [Current Status]="Active Approved")>>
What should I change so that each email only contains one trainerโs list? Iโm stumped. Thanks!
LinkedIn
Twitter
