Adding a prefix 0 (zero) to the Employee ID

Question

Hello!
I have a situation where the Employee IDs returned from a Looking Activity have to be 6 characters long. However , some of the Employee IDs must begin with a Zero if they are 5 characters long (please see below) . In the case below the EMPL_ID that is 10042 should be 010042 and I use it in the url to look like

How can I count the EMPL_ID once it has been retrieved to see if it is 6 chars or 5 chars? and then if it is 5, I have to add a zero to precede the 5 character EMPL_ID?

Thanks!
MIke
@Nasreen Akter

Answer 1

Hi @Mike Kiser ,

Please try the following expression. Thanks!

@concat('https://battelle-dev-services.azure-api.us/employees/v1/', if(equals(length(item().EMPL_ID), 5), concat('0', item().EMPL_ID), item().EMPL_ID))  

----------

If the above response is helpful, please accept as answer and up-vote it. Thanks!