Answered

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)

Sort by

Verified answer

PowerStudent 150 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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

Was this reply helpful? Yes No
PowerStudent 150 on at

Like (0)

Report
Copy link

Link copied!

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