Skip to main content

Auto Chase site workflow using SharePoint designer

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





Labels:

Comments

Post a Comment

Popular posts from this blog

Powerapps overcome 2000 item limit from any datasource

First go through delegation concept https://tejasadventure.blogspot.com/2020/05/power-apps-understanding.html In powerapps, we observe by default 500 item limit has set with in the app level for any data source. In order to overcome, we have option to set the limit of 2000 item limit maximum in the app. Now using code, MaximoFacility is my data source name contains 3000 items. ColFacilityDropdown is the collection storing the count of items from data source. We expect to see more than 2000 items. Based on StartWith function filtering the data with respective to the charectors and numbers as mentioned below. Code: Place the below code in a button on select property. Add label with code CountRows(ColFacilityDropdown) ClearCollect(ColFacilityDropdown,Filter(Filter(MaximoFacility, Status = "ACTIVE"), StartsWith( Title, "A" ))); Collect(ColFacilityDropdown,Filter(Filter(MaximoFacility, Status = "ACTIVE"), StartsWith( Title, "B" ))); Collect(ColFacilit...
Post a Comment
Read more

Power Apps Understanding

https://tejasadventure.blogspot.com/2019/10/power-apps-we-have-1.html https://tejasadventure.blogspot.com/2019/11/power-apps-how-to-configure-using-blank.html   https://tejasadventure.blogspot.com/2019/11/power-apps-field-controls.html Report We can use people picker fields, look up fields  file attachment back next save cancel download the report and this report can be used in other system of powerapp. Add new report button - asks add from existing report Report all item view can design in the way like sharepoint list views for example. we can group it Group AND or Group OR by apply filters Canvas apps: Arrange user experience and interface design allow creativity and business use case guide how the way app wants to look like. Sources can be around 200+ ways. Majorly SharePOint, Power BI From data, From Sample From CDS From blank canvas via appSource Model driven apps: Model driven apps uses power of CDS rapidly to configure your for...
Post a Comment
Read more

PowerApps multiselect cascading dropdown and save an item to SharePoint List

 I have one scenario as below List 1: Division List has title field List 2: District List has Title and Division Field(LookUp from Division List) List 3: Facility List has Title, District Field(LookUp field from District List) List 4: County List has Title, Facility Field(LookUp field from Facility List) Main List: Spill Report is the main list  Division Field( Look up from Division List) District Field(Look up field from District List) Facility Field(Look up field from Facility List) County Field(Look up field from County List) List Screenshots provided below can be refered for clarification. ----------------------------------------------------------------------------------------------------- PowerApps Canvas Apps In Power Apps Canvas App, We need to first design the app with the 4 respective fields Since those fields are multiselect, then it is to combo box. Generally power apps are not supported for multiselect cascasding dropdown. Refere microsoft documentation, Know Limit...
Post a Comment
Read more