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

List workflow - query list and email

Jump to solution

Hi Cassy Freeman. I was reading your post Site Workflow - Document Review Date Approaching Reminders and it closely resembles the workflow I need to build. I have a Nintex form that collects project related information in a list. I need to loop through this project list each month, locate those projects that have project create dates of greater than 100 days, and send an email reminder to the project owner to update the project status.

Your post is related to a site workflow and so didn't know how to best build with a List workflow. Is it the same or similar?

Thanks.

0 Kudos
Reply
14 Replies
krishnachaluvad
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

Hi Jeremy

List workflows is used when something triggered on a list item, since your requirement is to loop thru all projects in the list every month and send a notification as per business requirement, you should use a "Site Workflow" and schedule it to run for every month.

Thanks,

Krishna.

0 Kudos
Reply
jkweaver
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

So I built the site workflow based on the similar steps from Cassy's post and the workflow runs, but it does not generate the email notification from the parameters I need the workflow to run on. Those are: projects that are older than 365 days and those that have a Project Status <> Completed. Here is what I have so far:

Something or somethings are not connecting and providing the emails that will need generated for review.

Any thoughts?

0 Kudos
Reply
krishnachaluvad
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

I see below issues as per your screen shot:

1. In "Query List" action that is after "Calculate Date", you have not selected ID field, but selected "Created" in itemIDCollection variable.

2. In "Query List" action that is in "For Each", apply filter on "ID"  equal to "currentitemID" (from For Each action)

Hope this works after the above modifications.

Thanks,

Krishna.

0 Kudos
Reply
jkweaver
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

Awesome. Thanks for the feedback. Just one clarification. For the "Query list" action that is after "Calculation Date"...are you suggesting I should replace "Created" with "ID" in itemIDcollection variable? Or keep "Created" and add an additional "Field" that is related to "ID"? 

0 Kudos
Reply
krishnachaluvad
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

Hi Jeremy,

Your requirement is to get all list item IDs from "Parallel List" where items are created < 365 ago and status <> "Completed".

So, you have select the "ID" instead of "Created" in itemIDcollection.

With this, your itemIDcollection will have list of IDs that matches the filter criteria. 

Thanks,

Krishna.

0 Kudos
Reply
jkweaver
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

Makes sense. I have made the suggested changes.

Do the settings for my two requirements look fine? I need items created >365 days ago and status <> "Completed" (that is not equal to Completed).

0 Kudos
Reply
krishnachaluvad
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

Yes, they are correct, and I corrected my reply with <> Completed.

0 Kudos
Reply
jkweaver
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

So I ran the workflow and it Completed, but nothing returned to generate the emails (I have probably 50 that are over 365 days old and have a status <> Completed). Could it be the Site workflow? Here's mine. Could it have an issue with two list workflows under Parallel Test? My project list of data is in the All projects review workflow name. Now just figuring out why it's not generating the emails.

0 Kudos
Reply
krishnachaluvad
Nintex Newbie

Re: List workflow - query list and email

Jump to solution

Did you check if itemIDcollection variable has any values? Use "Collection Operation" action to get the count of items in itemIDcollection variable.

0 Kudos
Reply