SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

As my previous post(s) indicate, I'm fairly new at developing for Sharepoint. I'm working on a Sharepoint 2010 cloud website and would like to try to find out how to test the following:

In the SharePoint website, I want to run a workflow on a custom list which I have made. I got the workflow running, but there is one point of concern. Whenever a file is uploaded to this list, it has the following title convention: "Customer-$moneyamount-date"

What I wish to do is test whether or not the money amount is more than a value. If not, then run task A. Otherwise, run task B.

Since I am unable to use Visual Studio or Visio, I do not think that I would be able to write my own custom solution to this. If there are ways to go about solving this, I'd be more than happy to learn.

share|improve this question
up vote 2 down vote accepted

Within the workflow actions you can use substring functions, look at the utility actions here. Using those, you might be able to extract the dollar amount from the title and continue on with your logic.

If that isn't feasible, then the alternative would be to have customer, money and date as columns set when an item is added/uploaded. This will then allow you to evaluate the column values in your workflow as needed.

share|improve this answer
Most definitely. When I was trying to work a solution for this, I noticed that the best way to TRY to tackle this was using the utility actions. Noting that it probably is more trouble than it's worth, I think that I will edit the list to include those custom columns that you mentioned. I will be reporting back to you when I have implemented the change. – Hectron Dec 1 '11 at 21:23
I ended up going with the following solution: Since we are likely to be tweaking the workflows and assign groups to certain customers, I went ahead and created these custom columns. – Hectron Dec 1 '11 at 22:27

I think you can do this with SharePoint Designer Workflow Variables:

share|improve this answer
Not the comparison part I think – Christophe Dec 1 '11 at 23:50

I's say that the clean approach would be to have the amount in a separate column.

If you want to save your users some time, you could do this in a Calculated Column. This will work if by "Title" you actually mean the document title, not the file name.

Out of the box workflows have variables, but have very limited operators. The (complicated) workaround is to combine a workflow and a SharePoint list to do calculations.

share|improve this answer
Thanks for the valuable insight. This is somewhat the current process which I've implemented. – Hectron Dec 2 '11 at 15:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.