Hi,
I have a workflow in NAC that runs through a document library in SP 365, grabs the last modified date and adds 36 months to it before it sends out an email. My question is, within the loop for each, how do you pause for each iteration it goes through?
Each modified date is different so the notification would go out at different times but it seems to pause at the first iteration…
Thanks in advance!
Best answer by Chris_Ben
Hi, I’m guessing you want to do a 36 month reminder to check the document is still relevant or something like that?
You’re right that building the workflow as is, takes the first document, adds 36 months to the modified date and then would actually try and pause for 36 months before looping through to the next document. That’s not ideal! Also keep in mind that workflows have a maximum runtime of 12 months.
Instead maybe you make a scheduled workflow to run once a day/once a week etc that checks all documents that were modified 36 months ago and then sends the reminder. That means it doesn’t have to pause for 36 months. You’d also need to update a status or something like that so it doesn’t send the same email a day/week later.
+14Hi, I’m guessing you want to do a 36 month reminder to check the document is still relevant or something like that?
You’re right that building the workflow as is, takes the first document, adds 36 months to the modified date and then would actually try and pause for 36 months before looping through to the next document. That’s not ideal! Also keep in mind that workflows have a maximum runtime of 12 months.
Instead maybe you make a scheduled workflow to run once a day/once a week etc that checks all documents that were modified 36 months ago and then sends the reminder. That means it doesn’t have to pause for 36 months. You’d also need to update a status or something like that so it doesn’t send the same email a day/week later.
Thanks again for this useful info! That makes sense and I didn’t know that workflows had a runtime of a year. I appreciate your time responding to this, happy holidays!
Thanks!
+14Hah! Lucky you’re not using PowerAutomate then because their flows only run for 30 days which is really inconvenient!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
