AnsweredAssumed Answered

Multiple List Items Sent to One Person

Question asked by jhong88 on Apr 25, 2017
Latest reply on Apr 27, 2017 by jackgelo

Hi Everyone,

 

I've just started with Nintex so a bit of help would be great.  Here is what I'm trying to achieve:

 

I have a list of which has the following (as well as others, but those are not important)

  •    Due Date (Date)
  •    Reference Number (Unique) (Text)
  •    Date Received (Date)
  •    Assigned to (person or Group)

What would like to do is one day before the due date, I would like to send an email to the person listed in the "Assigned to" field with ALL the "Reference Number"  and its "Due Date" and "Date Received" that is associated to this person.

 

So for example

Michael Smith has the following:

Reference #: 1

Due Date: 01/10/2017

Date Received: 01/ 01/2017

 

Reference #: 2

Due Date: 01/10/2017

Date Received: 01/ 01/2017

 

I would like to send Michael Smith the following email :

Hi Michael Smith

You have the following due on 01/01/2017

Reference #: 1

Due Date: 01/10/2017

Date Received: 01/ 01/2017

List Item URL: [[List Item URL]]

 

Reference #: 2

Due Date: 01/10/2017

Date Received: 01/ 01/2017

List Item URL: [[List Item URL]]

 

I've read through some examples on this forum and on the web and here is what I've got:

I have a date calculation with current date + 1.  This gives me the due date (one day prior to the due date)

I have a query and in it I filter out the due date to equal whatever the date calculation gives me

In the "Field" section of the Query List, I pull out the Due Date, Assigned to, Date Received, Reference Number, URL into its own collection variable.

So now the Assigned to would have duplicates, so I've created a collection Operation to remove duplicates from the date stored in the Assigned to collection variable  and store it into another NoDuplicate collection variable

Then I have a "For Each".  In it, I use the "NoDuplicate" in the target and then store it in a single text variable called "AssignedtoSingle" variable

 

After this part, I'm lost.  I tried creating a collection operation for each of the variable, but they are not collecting the correct information, I'm guessing because I'm using the "NoDuplicate" variable.  but I don't know how to go around it so that I'm not getting duplicates.

 

I'm not sure if this make sense.  any help would be greatly appreciate it. 

 

thank you.

Outcomes