cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Nintex Form 2010 lookup runtime function missing leading zeros in text

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?

Labels: (3)
0 Kudos
Reply
6 Replies
Workflow Hero

Re: Nintex Form 2010 lookup runtime function missing leading zeros in text

Hi Joanne,

I have 2013 instance so cant confirm if it might work for you, I am assuming you are using calculated control to get the value out?

Can you change the "save as Date Type" to String and see? I quickly checked on my 2013 instance and it does work, not sure if it works on 2010 instance.

Regards,

Shrini

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Nintex Form 2010 lookup runtime function missing leading zeros in text

Hi Shrini

I have that set. 

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Nintex Form 2010 lookup runtime function missing leading zeros in text

Hi Joanne,

It works for me though, if the save as datatype is set to "generic" then the value returned is numeric (i.e. without the 0's) but if the Datatype is "String" it does return the value with 0's included. I guess this must be a bug with the 2010 instance.

Just for simplicity and to rule out any other data type issue do you want to test this on a dummy list and retrieve "title" column .. just to be sure that its a bug rather than any specific datatype for "TravelType or ParsedTraveltype" etc?

Regards,

Shrini

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Nintex Form 2010 lookup runtime function missing leading zeros in text

I would have thought it's a no brainer. If the field is text and i'm bringing it back as text, there should be absolutely no reason why it would suddenly become a number. I guess there is no easy solution to this problem. 

0 Kudos
Accept as Solution Reply
Highlighted
Workflow Hero

Re: Nintex Form 2010 lookup runtime function missing leading zeros in text

I would have thought it's a no brainer. If the field is text and i'm bringing it back as text, there should be absolutely no reason why it would suddenly become a number.

everyone would expect such a behaviour.

everyone, but nintex...  

 I guess there is no easy solution to this problem. 

there is a workaround. as shown in linked threads either append a non-numeric character to the lookup() function result so that it's not convertable to a number, or pass the lookup() function result through a runtime function which's result is string.

0 Kudos
Accept as Solution Reply