Unanswered

Pad value with fixed number of leading zeros

(0) Share

Report

Posted on by CMSGuy

170

I have an employee ID that is being pulled in and it can be any length of numbers. 99% of the time, the number is five digits, but I am needing to accommodate for the possibility of four or six characters also. The data connector (API) that I am writing data to is expecting the value to be 8-characters long with leading zeroes. I am sure I need to use the Text() function, and I am sure I can check the length of the value and use if statements. Just wondering if there is an easier or better way to to do this.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

PowerStudent 150 on at

Like (0)

Report
Hi,
In Power Apps, you can pad a number with leading zeros using the Text function to format it as a string with a specific number of digits. Here's how you can ensure your employee ID is always 8 characters long with leading zeros:
Text(employeeID, "00000000")
This will automatically add leading zeros to your employee ID to make it 8 digits long. For example, if employeeID is 12345, it will become 00012345. This is a simple and efficient way to achieve the padding without using if statements to check the length.

For more detailed support, book a consultation call with me here:
Consultation: https://softwarezone365.com/contact-us
PowerApps Blogs: https://softwarezone365.com/power-apps

Should you appreciate my assistance and wish to support my work, you might consider:
Giving this post a Thumbs Up.
If applicable, marking it as the Solution.

Support my work:
PayPal: https://www.paypal.com/donate/?hosted_button_id=DASYHQAEETD2J

Contact directly:
Email: Contact@SoftwareZone365.com
WhatsApp: https://wa.me/+923087478066

Best regards,
Ahmad Raza

Was this reply helpful? Yes No
CMSGuy 170 on at

Like (1)

Report

Really? That simple? Thanks for the reply! Have a great day

Was this reply helpful? Yes No
PowerStudent 150 on at

Like (0)

Report

Hi,
Sure..! you're welcome 🙂
you can save my mail for future help

For more detailed support, book a consultation call with me here:
Consultation: https://softwarezone365.com/contact-us
PowerApps Blogs: https://softwarezone365.com/power-apps

Should you appreciate my assistance and wish to support my work, you might consider:
Giving this post a Thumbs Up.
If applicable, marking it as the Solution.

Support my work:
PayPal: https://www.paypal.com/donate/?hosted_button_id=DASYHQAEETD2J

Contact directly:
Email: Contact@SoftwareZone365.com
WhatsApp: https://wa.me/+923087478066

Best regards,
Ahmad Raza

Was this reply helpful? Yes No