Answered

Format number variable length?

(0) Share

Report

Posted on by Karolsweat

I have a desktop flow that pulls a number from an excel sheet and stores it in a variable, is there a way to format the number and add leading zeros to it? I need it to format the number to 5 digits after it is pulled

Ex:

pulls excel - 39

variable - 39

format to - 00039

Thanks!

Categories:

Power Automate Desktop

All responses (3)

Answers (1)

Sort by

Verified answer

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Check out Pad text if it suits your requirement
Karolsweat 10 on at

Like
a
(1)

Report
Copy link

Link copied!

Worked perfectly! This is my first time using desktop and haven't found much documentation for some things yet. Thank you
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

The PAD text and some other string functions are explained here. It is in the Text manipulation section.

The above link is a part of this bigger course.