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!
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!
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):
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
If i use a string variable in the second query i got a result like this:
ID-1, ID-2 , ID-3 , ... , ID-x
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?