cancel
Showing results for 
Search instead for 
Did you mean: 
davidjohnson500
Nintex Newbie

Re: How do you send one email for multiple list items

Jump to solution

Hi Jesse, I got it to work ! Thanks for your assist.  2 outstanding issues though.

1-How do I get a field to appear as a link in the document.  As an example I have an Issue field which in the SharePoint list is the "linked to item" field.  In short how do I get a link/URL to display in the email for the list item.

2-I have a field called Details which unfortunately in some cases is VERY detailed.  Is it it possible within Nintex to do a LEFT(Field,50) so I only display the first 50 characters or so ?

Thanks..I have learned a ton in a short time period.

Reply
Nintex Employee
Nintex Employee

Re: How do you send one email for multiple list items

Jump to solution

Hello -

Glad to hear you got it working!

As for your outstanding issues:

1. In the Notification action, you can insert a link by clicking Editing Tools > Insert > Link

It will prompt you for the address and the text to display like so:

2. Yes you can trim out the text if you want. You can use fn-SubString(text to modify, position of the first character to retrieve, number of characters to retrieve) to accomplish this. That is located in the Inline functions when you insert a reference.

I have not used PadLeft or PadRight, but I believe you would get similar results.

Hope this helps!

Make sure you mark your question as answered so others can quickly see how you did it when searching

0 Kudos
Reply
davidjohnson500
Nintex Newbie

Re: How do you send one email for multiple list items

Jump to solution

Hi Jesse for the notification though I need each item that I retrieved from the Query Filter.  In my current Workflow I am displaying all Active items for a list.  Thus, if I have 5 items will the above method you explained display 5 Linked Items.  Below is what I have in the email, however, these fields are a result of building a string.  thx !

Issue ID

Assigned To

Status

URL/Linked Item

..................

....................

Reply
Nintex Employee
Nintex Employee

Re: How do you send one email for multiple list items

Jump to solution

Hello -

Ok this is easy enough, just need a few more variables setup:

In you Query list action, add another field to capture (ID):

Next, add another branch in the the For Each loop (if you are running them in parallel) to get the itemID based on the index:

Next you will need to build the url (using Build string action). You will need to add in your specific list name:

{Common:WebUrl}/Lists/YOURLISTNAMEGOESHERE/editform.aspx?ID={WorkflowVariable:itemID}

Last thing to do is add it to your email string:

This will get you the URL directly to the edit form of the item. You could replace editform.aspx with dispform.aspx to have the user click into the display form for the item.

Hope this helps!

Reply
billiemcgrane
Nintex Newbie

Re: How do you send one email for multiple list items

Jump to solution

Hi All,

I am trying to do the same- send one email at the end of the week that contains all users registered for induction on a particular date.

I have managed to get the for Each loop working where I get X emails for X people registered- but I need to merge all these emails into one.

I'm guessing it's got to do with the build string action... would you mind sharing your settings for that action?

Thanks in advance.

Billie

Amendment to post: I found the answer here

https://community.nintex.com/thread/10038

Just needed to add my email string variable to the start of the build string.

Hope this helps someone.

Reply
Highlighted
bhashwar_bhatta
Nintex Newbie

Re: How do you send one email for multiple list items

Jump to solution

We have a field called time keeper, how do we email distinct time keepers and also provide link to all items related to that time keeper?

0 Kudos
Reply
kaillyy
Nintex Newbie

Re: How do you send one email for multiple list items

Jump to solution

Hello! Thank you for this answer, everything is explained clearly and works perfectly in my case. The only problem I have is with quering the list. On Sharepoint I have data in the format M/d/yyyy, e.g. 8/15/2017, without time. I wanted to compare it to Current Date, as in this example, however it didn't work, the query didn't give any results. In the notifications I receive I see that the data variable gives the results with time e.g. 8/15/2016 12:00 AM. It's always 12:00 AM, even though on Sharepoint it's without time (date only format). I was trying to change format of dates, both on Sharepoint and in Nintex, but it doesn't work. It seems that they cannot be compared. Any suggestions what to do? Is it a matter of some settings?

Thank you in advance.

Reply