SPD workflow logic or calculated column... Very long condition - possible need for contains and begins with operators? RRS feed

  • Question

  • We have a lookup column on a SharePoint list with some 500 entries.  There is going to be a business rule where we want to include a URL link in a workflow email alert if one of 30 entries is selected from that lookup column. the rule might allow for if begins with XYZ or if Contains XYZ, or maybe not. But only if the the entry qualifies.

    We need to send the email alert regardless, but if one of the 30 is selected, we need to send the user some extra fixed text and a url link that will have the list row id in a the uRL query string.  For example.

    This record requires more information, please click here:

    where here is an html a href pointing to  http://somewebform?ID=<id of my row>

    So we also do need to format some html into the alert as well.  Recipients will be reading alert emails in Outlook 2007 with HTML turned on. The link will be to a form outside sharePoint and the sharepoint row must have been added before user can visit that form.

     Is there a Contains or Begins with type funciton in the Calculated column.

    Is there way to condition blocks of text in a SPD worflow with a condition that might need to test if a selection is one of 30 possible choices? Is there a way to test Begins with or Contains in SPD workflows?

    Is there a limit to how long these conditions or formulas can be. Calc Columns formulas do appear to be limtied to 256 or something.




    Thursday, April 7, 2011 8:38 PM

All replies

  • I think you're out of the realm of SPD with this requirement.

    You could try editing the XOML file directly and copy/past so that you can mass produce the bits and pieces of the conditions you need.  It's maybe worth trying.


    --Paul Galvin, BrightStarr
      Microsoft MVP - SharePoint
      Blogging @ http://www.mstechblogs.com/paul
      Twitter @ http://www.twitter.com/pagalvin
    Friday, April 8, 2011 4:12 AM
  • Because of the size of the condition? Or because it's not possible to condition content in an SPD Workflow email?

    Basically, If columnA is case (some of some 30 entries) include this link (with the Row ID) in the alert.  BTW, do we have the ROW ID availalbe to us in the SPD WorkFlow Email after logic?

    What about the idea of having a caluclated column in the list itself that serves as a flag.. no string constains or begins with operators in calculated column formulas.

    Friday, April 8, 2011 9:45 AM