Hi @michuk ,
Can you provide more context or details of the scenario you’re solving for? i.e. What is your overall need, what is the business process, etc? With this information we may be able to find a different solution to solve for your scenario. As much detail as possible would helpful.
Regards,
Kate
I have a list with a date column. It's a calculated column base on another column.
When that date = the current date I need the WF to start.
Hi @michuk,
Your option 1 of starting the workflow on item creation and letting it wait is okay, as long as it does not wait for more than a year. You can have as many workflows waiting as you like.
Your option 2 is probably not working because the date format between the calculated date and what the workflow uses as the current date is probably different.
Hi @michuk ,
Thanks for the extra details. Rather than the specific step you’re trying to build, I was looking for your broader business process, e.g.: The SP list is an invoice list. A new item is created when a new sales motion starts. Every day, I want all invoices that have a due date of ‘today’, to be escalated to the team.
Depending on the overall scenario you’re trying to achieve, there may be different solutions on offer.
In the mean time, does this scenario resonate with you - https://community.nintex.com/nintex-workflow-2/send-one-e-mail-based-on-multiple-items-updated-73310? This community user was looking for a scheduled capability, to collect multiple Sharepoint items for processing.
If your scenario is similar, perhaps Scheduled workflow might work for you too?
MichUK, the scenario provided in the link by kate is similar to what I would suggest and we use repeatedly. Set up a site workflow on a daily schedule and simply query the list of items for those whose Created or Modified dates match today. Then you can perform whatever action is needed on each of those items in the query’s result collection.
Hope this helps
Hi @michuk has your question been answered?