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 1...
Sharepoint tips and learnings from my day to day work