Skip to main content
Nintex Community Menu Bar
Question

NWC scheduled workflow

  • February 24, 2025
  • 4 replies
  • 30 views

Forum|alt.badge.img+4

Good day

How do you get NWC to check on the status of a Sharepoint Online column from a list every day? Based on the value of this column, it needs to continue to check the status of this column until it reaches a certain state. 

 

Example:

Column = CompletionDate

 

I need to create a workflow that checks the value of Todays Date once a day. If the value of today's date equals the value of “CompletionDate” then the workflow stops. But until the value Today's date is equal to “CompletionDate” the workflow continues to run every day at a specified time.

Additional steps I want to include is if the number of days left until CompletionDate is <5<0 then an e-mail will be sent. This part I know how to do. 

I have tried using a Scheduled Start as Start Event but i want to use the columns in a Sharepoint List. With Scheduled Start I don't know how to use columns from a list.

 

Thanks

Translate
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+9
  • Nintex Employee
  • 65 replies
  • February 24, 2025

Hi ​@kirkie4567 

In this situation you’d want to use a scheduled workflow to query the list for the items that the workflow needs to run against (Completion Date > today) then use a for each loop to start a component workflow for each item.  In the component workflow you’d pass the ID and then use the retrieve an item action at the beginning to return the item you’re working on.

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 18 replies
  • February 25, 2025

Thanks @brent

This helps, but when a use Query a list, it only returns the first item in the list. I want to check all the items in the list. I know I will have to use a loop, but I am not sure exactly how to do it. Can you point me in the right direction. I tried using Start a loop, but I am not sure how to configure it

Translate

Forum|alt.badge.img+9
  • Nintex Employee
  • 65 replies
  • February 25, 2025

Hi ​@kirkie4567 
When you use the Query a List action you should see a ariable structure like this:
 

 

If you expand the Items Collection you should see that the collection of items contains the item properties:

 

In configuring your for each loop you should select that collection.  Then the for each loop will also create a variable for the current item with each of those properties:

 

 

Translate

Forum|alt.badge.img+4
  • Author
  • Rookie
  • 18 replies
  • March 3, 2025

Thanks ​@brent_read Much appreicated!

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings