Suppose I have value like 1234 I need to add prefix 5 zeros to get 9 digit number

I have requirement like in one of the excel column I need to format the numbers to 9 digit, suppose I have value like 1234 I need to add prefix 5 zeros to get 9 digit number.

Thanks
Shaik Muktharvalli

Hi @shaik.muktharvalli1 ,

Could you check with the below Expression :

"1234".PadRight(9,"0"c)

image

can you send workflow

@shaik.muktharvalli1 ,

As it is a Simple Expression to implement, we would ask you to test it our first and let us know what issues you are facing, we can then if really required convert to a Workflow.

Let us know if this works or not for your case, if not, let us know the details.

Let me check and will confirm ASAP

Hi @shaik.muktharvalli1

xaml :-
Adding zerso.zip (1.9 KB)

Hi,

you can use this,