Auto Chase site workflow using SharePoint designer

on

Scenario:

When ever a list item has not approved after one day, that means when ever modified date exceeds 1 day and compare with today date

eg: Modified date+1 = 28-Aug + 1 day = 29 Aug is the modifiedPlusone date
and todaydate is 29 Aug
Now if modifiedPlusone >= todaydate then send email to the user.

In the above scenario, you can create a site workflow and you can use certain actions and run the workflow daily.

Workflow:

 Stage:Stage 1
Build {...} Dictionary (Output to Variable: JSonRequestHeader )
Call https://team.uat.sp.wp.corpintra.net/... HTTP web service with request (ResponseContent to Variable: JSonResult |ResponseHeaders to responseHeaders |ResponseStatusCode to Variable: responseCode )
Get d/results from Variable: JSonResult (Output to Variable: list )
Count Items in Variable: list (Output to Variable: counting )
Set Variable: index to 0
Loop: Loop the List
The contents of this loop will run Variable: counting times
Get d/results([%Variable: index%]) from Variable: JSonResult (Output to Variable: myitems )
Get ID from Variable: myitems (Output to Variable: itemID )
Get STATUS from Variable: myitems (Output to Variable: STATUS )
Get Ref_x0020__x0023_ from Variable: myitems (Output to Variable: RefVal )
Get SubmitterName/EMail from Variable: myitems (Output to Variable: SubmitterName_EMail )
Get SubmitterName/Name from Variable: myitems (Output to Variable: SubmitterName_Name )
Get Modified from Variable: myitems (Output to Variable: ModifiedDate )
Get CASE from Variable: myitems (Output to Variable: CASEvariable )
Get Region from Variable: myitems (Output to Variable: RegionVar )
Add 0 months, 1 days, 0 hours, 0 minutes to Variable: ModifiedDate (Output to Variable: ModifiedDate_Plus_1 )
Set Variable: TodayDate to Today
Set time as 0 : 0 for Variable: TodayDate (Output to Variable: TodayDateZeroTime )
Set time as 0 : 0 for Variable: ModifiedDate_Plus_1 (Output to Variable: modifiedDatePlusOneZeroTime )
If Variable: TodayDateZeroTime is greater than or equal to Variable: modifiedDatePlusOneZeroTime
Log Date Matched: [%Variable: TodayDateZe... to the workflow history list
If Variable: RegionVar equals APAC
Email Treasury_Complaints_Approver_APAC_L1
If Variable: RegionVar equals EMEA
Email Treasury_Complaints_Approver
Calculate Variable: index plus 1 (Output to Variable: indexPlusone )
Set Variable: index to Variable: indexPlusone
Transition to stage
Go to Trigger workflow next day
-------------------
Stage:Trigger workflow next day
Log Waiting for next day to the workflow history list
Pause for 0 days, 72 hours, 0 minutes
Transition to stage
Go to Stage 1





Comments

Post a Comment