Sunday, December 27, 2015

Issues on Sharepoint Designer Approval Workflow

In this post we introduce how to use Sharepoint Designer for Approval Workflow. But there are some issues on this way.




Issues on Sharepoint Designer Approval Workflow



1. Need to be familiar on Sharepoint Designer



As Sharepoint Designer is not included in standard office suite, it needs to be separately downloaded and installed on PC. It requires to conntect to Sharepoint Server, choose list and choose or create new workflow, which is not much difficult though, requires some days for new people to get familliar with it.

2. Workflow configuration is not very visible



As we introduced, workflow variable needs to be used when the approver or departments needs to be set from the content of request. That will be already excess the standard IT knowledge level of business worker and requires the way of thinking of IT engineer or programmers. If those kind of workflow mainteined by business people, and those people left or move within organization, it is almost very hard for new people to understand existing workflow, especially the variables within workflow specifies what kind of value. It is always headache for IT support department to handle those kind of help.

3.  Permission issue



The biggest and may be critical for certain case is that permission is not controlled by Sharepoint designer workflow. This means 1. approver can edit the request body before or even after the approval. 2. Anybody who know the link can approve the request and also can change the comment or other content after approval. These behavior are usually not preferable, but it may very hard to overcome this issue with Sharpeoint designer standard function (requires impersonal step with 2010 workflow)


Sharepoint Add-in(s) to overcome those issues



Many company chose to introduce Sharepoint workflow add-in as Sharepoint Designer itself still has issues above, which still remains for Sharepoint 2013 and Sharpeoint online. MoriApps Simple Workflow is the one which provide easy and quick creation of Sharepoint approval workflow. It is free for standard function and designed for simple requirements and even for business users.

Monday, December 21, 2015

Create Approval Workflow with SharePoint Designer

1.  Create Two Lists on your sharepoint site.
  • Puchase Request
  • Departments

2.  Departments List has field "Manager" (People type field)


3.  Purchase Requests List has "Department" field, which is Lookup field to Department. Also you can add contents field, price field or anything elese you need.


4.  From Sharepoint Designer, choose List Workflow - Purchase Reuqest.




5.  From Ribbon, click "Workflow variables" and create two new variable.


  • Deparment (type String)
  • Approver (type String)



 
 
6.   Insert "Set Variable" action and Choose Departments as Field from Source.




7.  Insert "Set Variable" action and set Approver field. Choose Departments as Data source, then "Find the List Item" Section appears and choose Title as Field, and click Fx button on the right, then choose Workflow Variable "Departmens" as value.

Then the Manager of chosen departments will be set in workflow variable "Approver".




8.  Insert Start Approval Process and set "Task Process Participants" with Workflow Variables:Approver






9.  Set Email Body. You can insert field value from the Item.







10.  Then set the workflow step to as "End of Workflow", and set the Workflow as "Start automatically when new item created". Then save and publish the workflow.


11.  Once new item created, request for Approval email will be sent the the Manager of the Department which requester selected.





 12.  Then Manager can go Approval Page from the link in the email.