Skip to main content
Nintex Community Menu Bar
Solved

Need to convert an Expression I created in the Legacy Workflow Designer to modern workflow designer

  • May 9, 2019
  • 1 reply
  • 4 views
  • Translate

Forum|alt.badge.img+3

In the legacy workflow designer, I created an Expression to build a SharePoint document link that--when clicked--opened a Word document in the browser (versus downloading it and opening it in Word). I'm rebuilding the workflow now using the modern designer and can't figure out how to create a similar expression. Here's what my expression looks like in the legacy designer:

 

Document Link: Left(Document ID (Link to Document), LengthToComma)

LengthToComma: Find(Document ID (Link to Document), ,) -1

 

I tried setting variables and can get parts of it, but I can't get the LengthToComma formula to work with the "-1" bit at the end. Kept getting character mismatch-type errors. I couldn't find a way to do expressions in the same way in the new workflow designer. 

 

Anyone have any thoughts?

Best answer by RayBoone

Solved it myself. There's a Function available in the new Workflow Designer called...wait for it...Formula. You can do all the maths in there.

 

I did something like this and then used Document Link as the URL for the Hyperlink function:

Document Link: Left(Document ID (Link to Document), LengthToCommaMinusOne)

LengthToCommaMinusOne: Formula(LengthToComma-1)

LengthToComma: Find(Document ID (Link to Document), ,)

 

What this gives you is a link to a SharePoint document that, when clicked, opens in a browser window instead of downloading the document and opening it in Word. One note about this--you have to turn on the Document ID feature in a Site Collection to make the Document ID (Link to Document) field available for documents in your SharePoint site.

View original
Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img+3
  • Author
  • 9 replies
  • Answer
  • May 9, 2019

Solved it myself. There's a Function available in the new Workflow Designer called...wait for it...Formula. You can do all the maths in there.

 

I did something like this and then used Document Link as the URL for the Hyperlink function:

Document Link: Left(Document ID (Link to Document), LengthToCommaMinusOne)

LengthToCommaMinusOne: Formula(LengthToComma-1)

LengthToComma: Find(Document ID (Link to Document), ,)

 

What this gives you is a link to a SharePoint document that, when clicked, opens in a browser window instead of downloading the document and opening it in Word. One note about this--you have to turn on the Document ID feature in a Site Collection to make the Document ID (Link to Document) field available for documents in your SharePoint site.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings