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?
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.
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?
it's know calculated value control anoyance, see these my past posts
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.
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.