I am having trouble pulling collection ID's in a for each loop. Scenario:
Applying this to a site workflow.
I have overdue tasks that need to be emailed to users in individual emails. Now, I have managed to pull the entire table to highlight overdue tasks but I can only manage to collect that into one email and HTML table for a notification.
I am looking to send multiple individual email notification to the assignee with their respective tasks that are overdue.
I have made a query to pull individual assignees that have 1 or more overdue tasks. When I put this collection into a for each loop and try to query the collection of ids for these tasks it simply comes up blank?
Is this possible, please!?
@sumalh ....You will have to query your task list twice. Try below approach:
Thanks for the reply - I have got to this stage already. My problem occurs with the next step.
I have multiple Id's assigned to the assignees. Instead of one bulk email going out to all I was looking at a for each loop to capture the multiple id's for each assignee and email out the details. It's not ideal every one knowing each analyst overdue tasks via bulk email. So the idea is to only email the assignees direct with there task that is overdue and then for each loop onto the next.
Hopefully, the below helps layout my dilemma:
|Query below complete to capture overdue Id's|
Next Steps causing roadblocks
|1 email needs to go to <Analyst Bob> containing details from Id's 1 &2|
|1 email needs to go to <Analyst Harry> containing details from Id's 3 &5|
1 email needs to go to <Analyst Collin> containing details from Id 7