Announcements
Is there a way in PowerApps to remove leading zero's in a gallery and not have to use Power Automate. Pulling in data from SQL DB, there is a text field that has leading zero's in this one column. For example: 000006201 to be 6201. Now, we do sometimes have 000000000 and it just needs to be 0. Is this possible? Thank yoiu
@Anonymous please try the Int() function:
//This will be 11 Int("000011") //This will be 0 Int("0000")
If this answers your question, would you be so kind as to accept it as a solution.Thanks!
Is it always fixed? 000006201 to 6201 always has 5 zeros? 000000000 to 0 always has 9 zeros?
Hi @LaurensM
This fixed it. I was researching but only found Power Automate stuff. I didn't think about the 'Int' function. Thank you so much!! Have a good one.
Try adding Text(Value(<<fieldwith0s>>), "#########0")
That should remove any leading 0's and change all zeros to just 0
Hi @Rusk
Thank you for replying. I appreciate it. No, it's not fixed but using the Int functionality worked. Thank you for responding to this post. Have a good one!
Hi @Pstork1 Thank you for responding to my post. I appreciate it. I fixed it by using the 'Int' functionality. Thank you again. Have a good one.
Good day thanks for your solution.I am also having a similar problem. I am using a hexadecimals RFID keyboard emulator which writes to text of my PowerApps textbox. I wish to know how can I remove a leading zero. I am scanning a 7 digit barcoded RFID but it comes with a leading zero.Is there a way I can make the textbox ignore a leading zero on scan or keyboard number typing?Kindly help.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 396 Most Valuable Professional
11manish 134 Super User 2026 Season 2
MS.Ragavendar 101 Super User 2026 Season 2
