Nintex for SharePoint Forum
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forĀ
Dear community,
I'm looking for a way to set reminders based on dates in a list. Until now i build a workflow, where i get one email, if one of the EndDate is passed, but i want to give out every line of the list, that passed the Date. Is there a way to realise that?
Thank you very much!
Hi,
try setting up a site workflow, which gets items from your list with passed end-dates.
The workflow can then run as needed, I guess in your case daily
I would create a view which meets this criteria. I would then have a site workflow that queries the list and returns all the "Created By" for items which meet this criteria into a collection variable. I would do a collection operation to remove duplicates. I would then email all users in the collection by using the collection in an email and point them to the view (i.e. you have expired items)
Hi! First of all: Thank you for your reply!
I'm not a native english speaker and i have problems to understand :
Is it possible, that you visualize that for me? That would be great!
Hi @EdVonSchleck,
because in the step before you just received the information for ID, you may want to have other fields of an item (for example Title, Created By, ...)
You do this by querying the list again but filter by ID (see screenshot) then you can "pull the necessary fields".
Using Build String, you can concatenate the information on necessary fields to send only 1 notification.
The Workflow would look something like this (I haven“t configured any of the actions):
Variables:
col_IDs - Contains the IDs from first query List
str_ID - for use as variable in ForEach Loop
str_Title - to get Info from the second query list (you“d need one for each column to retrieve)
multi_MailContent - contains all the information you got from the forEach Loop
How did you configurate each loop? I'll try it today and I'll hope I finally work it out.
Hi @EdVonSchleck,
Target Collection is "col_IDs"
Store result in is "str_ID"
Hi @EdVonSchleck,
you can access all the columns you need in a single query list.
Just add the columns below and create variables for them.
Hey Tarf,
If i use a string variable in the second query i got a result like this:
ID-1, ID-2 , ID-3 , ... , ID-x
title 1
but i want the title of every id. so i used a collection and somehow it works.
Now i want to create a data set. Instead of the arrangement above i want something like.
ID-1 , title 1
ID-2, title 2
is this possible?