Skip to main content
Nintex Community Menu Bar

Look up problem

  • Dec 5, 2017 12:58 PM UTC
  • 5 replies
  • 29 views
  • Translate All

Forum|alt.badge.img+4

If a lookup component in workflow like 'Query List' etc is having a value with apostrophe, the workflow is getting terminated:

For example:

If in the configuration below if {Variable:Brand} is having a value like xyz's (apostrophe inside) then the workflow is terminating throwing the error like  substringof('xyz's',Brand/Title)" is not valid...

211234_pastedImage_1.png

I have sorted it with a trick but not to an extreme satisfaction. I am not sure whether it's a bug or not but it seems a bug to me in NINTEX.

Let me know if you have any information about this.

5 replies

Forum|alt.badge.img+8
  • Dec 5, 2017 3:59 PM UTC

Have you checked the "Encode xml inserted tokens" button? This ensures that the inserted token are encoded and will allow for special characters.

source: Query List 

Translate

Forum|alt.badge.img+8
  • Dec 8, 2017 5:44 PM UTC

‌ Did you ever solve this problem?

Translate

Forum|alt.badge.img+4

Thanks Roger! But one thing I am trying to implement this in Office 365 but not getting any such component in a workflow (Office 365). Please let me know what I need to do for that?

Cheers!

Mani.

Translate

Forum|alt.badge.img+8
  • Dec 11, 2017 1:10 PM UTC

Sorry, I have on prem. I'm guessing you don't have the "Encode xml inserted tokens" button in O365?

Translate

Forum|alt.badge.img+14
  • Scholar
  • Dec 12, 2017 12:27 AM UTC

I do not have access to O365 either, but could you following

{TextStart}{Variable:Brand}{TextEnd}

Translate