Unanswered

Leading zeros

(0) Share

Report

Posted on by haqian

One of the functions of my app is that the user needs to put in a "test case number." I was testing out random combinations and I noticed that every time I typed in a combination with leading zeroes, the zeroes disappear (for example, 001 turns into 1). Is there a way to keep the leading zeroes that the user types into the text box?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@haqian

Not if it is a numeric field that you are using. If it is text, then yes, you could keep them.

Although you could use the Text function to format the number, the question would be, how many leading zeros. If you know it will always be, say, 4 leading zeros, then you could use : Text(yourfield, "00000") That would give you 4 leading zeros and a digit.

But, if this is random (one could be 2 leading zeros another 5 and so on) and the length for the number is variable, then you will need to store as a string.

I hope this is helpful for you.

Was this reply helpful? Yes No
haqian 23 on at

Like (0)

Report

@RandyHayes
I believe the text input box I put saves it as a string, but I could be wrong. I set the format as "text" but it still gets rid of the leading zeroes the user types in. Any ideas?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@haqian

Yes, the formatting or text designation would not make a difference here. You need to look at the type of column that Test Case ID is based on. If it is numeric, then you will always lose the zeros. If it is text, then we can dig deeper.

Was this reply helpful? Yes No
haqian 23 on at

Like (0)

Report

@RandyHayes
I just checked the column and it should be saved as a string. It would make sense for the leading zeroes to go away if it were a numerical value but I'm stumped about why it disappears even if it's saved as a string value.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@haqian

So, the first thing I would look at is the actual data source. Is the data being stored in the datasource as a string? Does it have leading zeros in it? You can click on your datasource in your data source list and choose Edit Data to see what is there.

If it is not there with zeros, then you should look at the Update property for that datacard. If it is, then you should look at the Default property of the datacard.

Was this reply helpful? Yes No
haqian 23 on at

Like (1)

Report

@RandyHayes
Thank you so much for directing me to the data source itself! I ended up going into my excel and going into the "format cells" page to change the numbers category to text, so now the leading zeroes are saved in both power apps and excel!

Was this reply helpful? Yes No