Skip to main content

Examples of utility function in SPD 2010 workflows

In SPD workflows, under Actions, there is a set of Utility functions.
Using the substring function, a string can be trimmed from the beginning/end/or from a position, with or without specifying the length.

An example, to remove the domain part from the user name, e.g. abcdomain/username, follow the below steps
1.       Use “Extract substring from the index of string”
2.       It would insert a step in WF as “Copy from string, starting at 0 (Output to Variable: substring)
3.       Click on ‘string’ and click fx to get the field to be trimmed.
4.       It would bring the look-up window.
5.       Select the field and click OK. In this e.g., Data Source: Current Item and Field from Source: Created By
6.       To set the index, click on 0 and enter the required number, here it would be 11.
7.       If the variable name has to be changed, click on ‘Variable:substring’ and change the name.
8.       The value stored in the workflow variable would be ‘username’

The workflow variable can be used in further steps in the workflow as required.
To get the workflow variable, in the Lookup for string window, for Data Source – select Workflow Variables and Parameters

The other string functions available are
·         Extract Substring from Start of String
·         Extract Substring from End of String
·         Extract Substring of String with Index of Length
·         Find Interval between Dates
 
Labels:

Comments

  1. Anonymous21 November 2016 at 12:31

    What if i want to find index of string for example,

    I have current item field with value "abc#def", '#' character index will be dynamic there can be any number of characters before and after '#' character in string. So in that case i will require '#' index and need to extract string after'#'.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to link to Download a copy option in Office 365/SharePoint 2013

At times it is required to have the option to save a copy of a document uploaded in SharePoint document library, in a page or a webpart. The url to get the save option for a doc is - http:// site /_layouts/download.aspx?SourceUrl= url-of-document-in-library Change the bold text with the actual url, i.e., with the site url and the url to the doc in the doc library. For example, if the site is www.contso.com and the doc "Test" is uploaded in SiteAssets library, the url to save a copy would be - http://contso.com/_layouts/download.aspx?SourceUrl=http://contso.com/SiteAssets/Test.docx
1 comment
Read more

How to create approval workflow in SharePoint 2013

When a new document is added to the doc library, a task email is sent to the approvers to review the doc. The due date for the task can be set in the workflow. If one of the approvers, approves the doc, the workflow is ended. Go to the document library, and from the ribbon, click on Workflow settings – Add a workflow In Add a workflow page, select Approval workflow and enter a name for the workflow Note – The out of box workflows are of SharePoint 2010 template. To use SharePoint 2013 template, the workflow has to be created with SharePoint Designer 2013. Also, if there are no approval workflow templates, go to Site Settings – Site collection features and activate Workflow. Set the workflow to be started manually and when an item is created. As approvers, a person or group can be set. If there is more than one stage of approval, a new stage can be added and the action can be set to follow the parallel or serial sequence. In parallel sequence, the approval stages will happen to
Post a Comment
Read more

How to - Task list for project planning in SharePoint 2010

SharePoint 2010 has Task list template which can be used to track project work. The task list can be used to create task, assign task and track the task completion. When a project starts, it can be divided into various stages/tasks and each task can be assigned to a person with start and end dates. Each task may have sub-tasks also. A project is a collection of all the tasks, sub-tasks required to attain the output. The output can be a completed product, end-service etc. To create a project task list in SharePoint site, click on Site Actions, then click on View All Site Content and click Create. Click on List and select Project Tasks. Enter the Name for the project task list. Once the list is created, the user or manager can enter the task in the list. A task usually contains the Task Name, Start date, End date and Task Status. If the projects is done in various phases and there are inter-dependence between the phases, larger tasks for each phase, can be created. The larger tasks know
Post a Comment
Read more