Announcements
Hello,How to add 0 in front of a text string connected with Excel? For example I would like to have 00123456 instead of 123456 or 00012345 instead of 12345
thank you in advance
Hi @Thomaw,
can you provide more information? is this in a label, table or gallery? generally if using gallery, where you'd have thisitem.XXX, i'd use "000"&ThisItem.XXX as using the & sign allows you to append text strings and other values to other fields.
hope this helps, if it does feel free to mark it as a solution!
Hi @Thomaw ,
May be the below link could help you.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Add-leading-zeros-to-digits-using-Text/td-p/269238
Thanks.
@Thomaw
If this is a numeric value and a fixed length you want, then simply use the Text function to provide your results.
Ex. Text(12345, "00000000") will produce - 00012345
I hope this is helpful for you.
Thank you all for your answers ... Great responsiveness of the community
@Alex_Security
I have thisetem.SLID so I guess it's gallery! The problem with your solution is that I need 8 characters total so in the case where 3x0 is missing it is good but if I am missing 2 or 1 zero I exceed my number of characters.
As in Excel, there would not be the possibility of custom formatting the 8-character value to be completed with 0s.
@RandyHayes
Valeur text 🙄
Salvation
It's good, thank you
Text(Value(ThisItem.ARTNO);"[$-fr-FR]00000000")
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.
11manish 354 Super User 2026 Season 2
M Bilal Khan 330
Mohsin Ali 232
