Answered

Keeping Leading Zeros from Forms

Like (0) Share

Report

Posted on 9 Dec 2022 14:11:04 by dedgerton1

I have a form that asks for an ID number that should contain two leading zeros. How do I ensure that the leading zeros remain when building my flow? I would like to verify that the user submitted exactly a nine-digit number and that they keep the leading zeros if they input them that way. I do not wish to exclude numbers that don't have leading zeros.

All responses (3)

Answers (1)

Verified answer

Ellis Karim 10,940 Super User 2025 Season 1 on 09 Dec 2022 at 15:56:58

Like (0)

Report

Re: Keeping Leading Zeros from Forms

The following example should help:

Your condition would be similar to the following:

I'm using the string function for 00 and 900 so that flow doesn't flag error that I'm trying to compare a string to an integer value.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
dedgerton1 83 on 09 Dec 2022 at 15:01:42

Like (0)

Report

Re: Keeping Leading Zeros from Forms

Would it be 3 separate "equals" rows under one condition? And do I replace your instance of 001234567 with Compose Output? These IDs could also start with "900," so how do I ensure that I'm not excluding those?
Ellis Karim 10,940 Super User 2025 Season 1 on 09 Dec 2022 at 14:32:27

Like (0)

Report

Re: Keeping Leading Zeros from Forms

Hi @dedgerton1

One option could be to treat the ID as a string.

You could then check if the ID starts with '00', that the length of the ID is 9 and that it is an integer using expressions and the Condition action:

isInt('001234567')

length('001234567')

startsWith('001234567', '00')

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.