Solved

Sharepoint 2010 workflow: Substitute field variable in string manipulation function?

Posted on 2013-01-03
4
1,820 Views
Last Modified: 2013-01-04
In a workflow, is there a syntax that can be used to substitute the variable

[%CurrentItem:FieldName%]

for "FieldName" in the function

=RIGHT(FieldName,LEN(FieldName)-FIND("#",FieldName))

?
0
Comment
Question by:dgmoore1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 38742428
Hello,

I don't think you can do string manipulations like that in the dialog. You may need to create a new calculated column in the SharePoint list that stores the value you need in the workflow. Use a calculated column with the formula you posted above.

Note that not all data types can be used in calculated columns.

cheers, teylyn
0
 

Author Comment

by:dgmoore1
ID: 38742433
Thanks - I have already done that, and it works fine, but I was wondering if I could tighten up the process a bit by doing the string manipulation in the workflow instead of using a calculated column.
0
 
LVL 50
ID: 38742463
Don't think you can. String manipulation in SPD workflows is on my wishlist, too! :-))

cheers, teylyn
0
 

Author Comment

by:dgmoore1
ID: 38743443
Not the answer I wanted to hear, but useful information nonetheless.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question