Relevant item fields
- Budget Difference
- Engagement Leader
- Assurance Partner
- Assurance Leader
- Assurance PM
- Individuals in the four roles above must receive weekly alerts of items/engagements were Budget Difference is above X amount or below Y amount on an items/engagements in which they're serving one of the roles above
- Not one e-mail per item, but rather a list of all items that meet the criteria in previous bullet point
- Each individual must receive an alert with aggregated items per their role in that item/engagement (e.g. Tom is the Engagement Leader for 10 engagements, 5 of which are X Budget Difference amount; so Tom must receive an e-mail with a list of those 5 items)
- Individuals may serve different roles depending on the engagement (e.g. Tom is the Assurance Partner for 5 other items/engagements, 3 of which are below Y Budget Difference amount; so he must receive a second e-mail for these 3 items/engagements for which he's serving a different role than in previous bullet point)
I'm not concerned about e-mail format at this point - I can do html table after the fact, but I just want to know the best way to get put this data together.
I'm thinking Query List, Collection operation to Get whatever fields I want to display on the e-mail and store in coll variable, then Build string...? I struggle with what to do after that. How to display item after item in a way that makes sense.
Thanks much for any guidance you can provide!