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

Cannot open SharePoint 2010 Approval task form from Outlook

When trying to click on Open this task from Outlook 2010, it brings an error - " Outlook cannot open a new form. The form contains schema validation errors" Element '{ http://www.w3.org/1999/xhtml}div ' is unexpected according to the content model of parent element '{ http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields}Body '. As given in the error message, the issue is with the Body column of the workflow tasks list. For the approval workflow, there would be a tasks list. In the workflow task list, the Body column is Enhance Rich multi-line column. Change the setting to Plain text, instead of enhanced rich text. After that do an iisreset.
7 comments
Read more

Display a Thank You message at the end of survey form in Sharepoint 2010

A quick and easy way to display a Thank you message at the end of survey for submitting the form. At the end of last question, insert a page breaker. After the page breaker, add the Thank you message as a question, and select the type Single line of text. Enter the default value as "Internal". Go to the survey form and click on Respond to Survey. Click Next and in the Editform url in the browser, append &ToolPaneView=2 to the end of URL. Add a CEWP to the below of the page and insert the below code, in HTML source or else paste the code in a text file uploaded to sharepoint library and refer to the text file. (referring the text file is preferred) <script> // hide the input textbox for the "thank you " message  var x = document.getElementsByTagName("INPUT");  var i=0;  for (i=0; i<x.length; i++)  {   if (x[i].value=="Internal")   {     x[i].style.display="none";   }  }  </script> Save the page. Respo...
1 comment
Read more

Audit Log Reports issue in sharepoint 2010

When enabling audit log reports, there were a couple of issues faced, given below 1.        I could not find the Audit Log Reports link in Site Collection Administration. Enabled it using stsadm as given in the below link How to enable the audit log reports link - http://www.danielbrown.id.au/Lists/Posts/Post.aspx?List=276dae61%2D6562%2D4ad1%2D8ca5%2Dba66c07b0cff&ID=47&Web=8a2513e7%2D4048%2D450e%2Dbd08%2Dea5ab59830ef 2.        When trying to generate audit reports or when trying to click Browse to select the location, I was getting an error "An unexpected error has occurred” with a correlation id. a.        As mentioned in sites, I checked in ULS logs for the description – The ULS logs can be found in C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS b.       There was an exception related to Search c.   ...
6 comments
Read more