Skip to main content
Nintex Community Menu Bar

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

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.


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


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:

 

 


Thanks ​@brent_read Much appreicated!


Reply