cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Send multiple notifications in one email

Jump to solution

Hi,

I have a list in which there is a project name, a task description, who (multiple people picker) and a due date

PROJECTTASKWHODUEDATE
A1person1;person2;person302/25/17
A2person2;person4;person602/25/17
A3person1;person202/25/17
B1person402/25/17
B2person1;person602/25/17
B3person602/25/17
B4person1; person202/25/17
C1person3;person4;person5;02/25/17
C2person4;person502/25/17

There can be multiple lines for a project, as many times there are tasks.

I need to send an email 3 days before the due date to the persons in the "Who" column BUT only for the tasks where they appear. I would like to send only one mail which will display all the tasks the person has to complete.

Example: 3 days before "02/25/17", the site workflow is supposed to send a mail to each person in the "who" column.

I assume the mail is sent to person1:

Dear person1,

Please complete the following tasks before 02/25/17 :

Project A

Task 1

Task 3

Project B

Task 2

Task 4

Hope it is clear!

Thansk for your help

Labels: (1)
0 Kudos
Reply
5 Replies
Workflow Hero
Workflow Hero

Re: Send multiple notifications in one email

Jump to solution

Hi Cassy,

I'll try these!

Thanks for your help. 

Reply
Workflow Hero

Re: Send multiple notifications in one email

Jump to solution

how did you get on?

0 Kudos
Reply
Workflow Hero

Re: Send multiple notifications in one email

Jump to solution

I made a site workflow as you suggested with loops in loops!!

Query "whos"

   For each "who"

      Query "project"

            For each "projects"

                  Get "who" collection on the project

                     Query "tasks"

                         For each "task"

                            Get "who" collection on the task

                            Get "project" collection on the task

Send Notification

A bit hot but it works

Thanks a lot!

0 Kudos
Reply
Workflow Hero

Re: Send multiple notifications in one email

Jump to solution

Hi Patricia, i am try to do the same thing but it not working.can you show how you do it ??

thankk!!!

0 Kudos
Reply