Leading zeros on ID number which get replaced by increasing ID number

[jamesfisher]

Is there a way to add leading zeros to an ID number but the leading zero gets replaced with every digit increase from 1, 10, 100 and 1000, it replaces a zero?

For example, if I had four leading zeros '0000', when ID is '1', the leading zeros and ID will look like '0001'? And then when the ID is 10, it looks like '0010'. Then when it reaches ID '100', it is '0100' and so on...

My ID is currently leading with XXXX + YY (current year) + Leading zeros + ID 

Currently the ID will just keep getting longer with the current version:

001 -> 009

0010 -> 0099

00100 -> 001000

Hopefully I've explained myself well enough here!

James

[DamoBird365 · Accepted solution]

Hi @jamesfisher 

Check out Unique IDs and pad a string - DamoBird365

Padding with 0’s

In my example we want the unique ID to be 5 characters in length. Using the Length() expression we are able to ascertain the length of the new ID. Note that we must convert the integer value into a string(). Then by subtracting sub() the length from 5, we know how many 0’s we must pad the string with. The length of 257 is 3 and 5-3 = 2. Using substring() of five 0’s i.e. 00000 and specifying the string to start at position 1, and using the example to 257, we will return two 0’s 00. Finally, with the concat() expression, we bring 00 together with the InvoiceID 257.

concat(substring(‘00000’, 1, sub(5, length(string(outputs(‘InvoiceID’))))),outputs(‘InvoiceID’))

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks