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?