Skip to main content

I was asked to create a workflow to send a reminder email to all the manager's that have time cards yet to be reviewed by them. I want to send only one email, even if they had more than one time card to review. 

This is a SITE workflow. This way I can schedule it to run when I want. You can schedule it to run at what ever interval you desire. List or Library workflows work best when set up to run when something is created or modified.

 

First set up your variables. 

193506_pastedImage_9.png

 

This is what my workflow looks like. 

193497_pastedImage_4.png

 

Configure your first query: I filtered by the status of Submitted as they are ready for review but not yet reviewed.

193509_pastedImage_12.png

Select your "Collection" variable.

193498_pastedImage_1.png

 

Next, use a Collection operation to remove the duplicates

193508_pastedImage_11.png

193499_pastedImage_2.png

 

Configure the For each

193510_pastedImage_13.png

193500_pastedImage_3.png

 

Next we want set a variable to find the Manager's User ID so we can filter it later. 

193511_pastedImage_14.png

193503_pastedImage_6.png

 

193501_pastedImage_4.png

We will query this list again. This time filtering so the list Column (manager) and the Variable match up.

193509_pastedImage_12.png

193504_pastedImage_7.png

193505_pastedImage_8.png

 

Now I want to send a notice to each manager based on this query.

193512_pastedImage_15.png

193507_pastedImage_10.png

 

You can use this on a task list, workflow task list, or just about any list or library that has a people picker and choice column.

 

I hope you find this useful!

Vickie Reschke‌ - 

Nice post, detailed

I have to ask, why are you querying the list again within the loop? If you already have your list of managers from your first query list action (which is filtered by Status) and then remove duplicates in your collection action, that should be enough to send your one email per manager with outstanding tasks correct?

It does leave open the possibility to get information from each item for the specific manager and put them in the email if needed, but if you only need to send one email per manager if they have at least one outstanding task, I think that that query action it is redundant and could be removed. I say this because on larger task lists or if there are a large number of managers, going back to query the list again each loop through could be costly.

Let me know - I am always intrigued on how other users approach and solve the same problems/issues! In fact, Cassy Freeman and I have had similar conversations about querying lists to see if her way or my was more efficient.

Thanks Jesse,

I am new to queries in this way, so I'll try and see if I get the same result with just one query. Worth a try!

It always helps with performance to save on round trips to the server. 

Could reminders be included in this summary? 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings