How to get out of pause until date if target is achieved?

Hi,

We are developing a SharePoint Designer 2013 platform workflow on Office 365 SharePoint Online. Following is what we are trying to achieve:

  • Document Library workflow.
  • There are 3 users involved e.g. UserA, UserB and UserC.
  • There are 2 content types e.g. Notification Letter and Statement Method.
  • As soon as UserA uploads/adds a document the workflow kicks-off.
  • An email is sent to UserB where he verifies it and select a dropdown verification complete.
  • This workflow also kicks-off on item change hence it creates a task process and assign UserC a task.
  • If UserC rejects the task, the email is sent to UserB and he has to resubmit.
  • However if UserC approves it then it goes to the approval folder.

In the above process we need to have reminders/notifications to UserC. There are 3 reminders. As soon as the document is added the document should be sent to the approval folder within 30 days (cut off) from the item creation date. First reminder 7 days before the cut off date. Second reminder 2 days before the cut off date. Finally the last reminder on the cut off date itself.

If I set Pause Until Duration event then the workflow as expected doesn't do anything till the date. How to break the Pause Until Duration if the UserC approves the task within the date range before cut off date.

I was thinking of loop but couldn't figure out how to achieve it in a better way.

Thank you

January 25th, 2015 4:17pm

Free Windows Admin Tool Kit Click here and download it now
January 25th, 2015 4:51pm

Ravin,

How does that resolve my issue?

Regards

Tanzim.

January 26th, 2015 8:41am

Once documented added just add the value 23, 28 ,30  to the current date so you will get the date . Then set the pause the execution until the date . once the date was hit just check weather the document was moved to approval folder or not. if its moved don't send email or else send remainder

Free Windows Admin Tool Kit Click here and download it now
January 26th, 2015 10:47am

That is not the issue. The problem is once the workflow hits Pause then if the document is approved the workflow won't do anything until the date/duration occurs.

I hope I have explained it clear enough or please write back for queries that might help you resolving this issue.

Thank you

January 26th, 2015 11:14am

http://blog.qumsieh.ca/2012/01/27/sharepoint-designer-workflow-pause-until-date-change/

Here the user break the pause duration using code. if you don't want to code means just split the workflow into two

One for managing approval

One for managing Email

So that the pause state in email workflow will not affect the approval workflow.

Also in Email workflow we have check the approval and moved status so it will not send the remainder mail to approved request

Free Windows Admin Tool Kit Click here and download it now
January 26th, 2015 11:24am

We already did the separate workflows as we weren't find any solution.

However we wanted to have it in a single workflow without coding hence I started this thread.

Please let me know if you find a logic to achieve it.

Thank you

January 26th, 2015 12:21pm

Sorry!
Free Windows Admin Tool Kit Click here and download it now
January 27th, 2015 6:27am

FYI

https://social.msdn.microsoft.com/Forums/office/en-US/9c042dec-ee66-4040-9057-3ae9256af558/workflow-error-suspended-the-workflow-instance-exceeded-the-cpu-usage-limit-of-throttle-of?forum=sharepointcustomization

I have posted an error to the other forum. I tried to achieve the result via Loop but fall in to another critical error.

January 27th, 2015 2:10pm

if UserC approves the task store a value " approved "

then when the workflow start after pause check if its approved dont send email

Free Windows Admin Tool Kit Click here and download it now
June 28th, 2015 8:25am

Thank you Fatma for the reply.

We resolved it earlier by If-Else statements and loop together. The problem persists if we go for duration (Pause for Duration) but works for date (Pause until Date).

July 14th, 2015 3:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics