AnsweredAssumed Answered

Nintex Form 2010 lookup runtime function missing leading zeros in text

Question asked by harfmt on Sep 12, 2018
Latest reply on Sep 17, 2018 by emha

I am using the lookup runtime function to do a lookup to a list with a text column containing numbers with leading zeroes. e.g. 00234

 

The runtime lookup function returns "234", missing the leading zeros.

 

The returned data type is set to return a string.

 

Why is it coming back as a number rather than text? It seems to be assuming that because it only has numbers in the text, that it is a number.

 

Is there some way to force it to bring it back as text rather than numbers?

Outcomes