Answered

Generate Unique string using SharePoint ID

(0) Share

Report

Posted on by YatinMumbai

123

I have a SharePoint Document Library column called PermitNo. I need to update this on create new item with a unique string that uses SharePoint list ID . If the ID is 23, then the PermitNo should be FHD000023. Concat function will give me FHD23, no problem. I am accomplishing this with the expression -

Concat('FHD',String(variables('m_ID'))) where m_ID is avariable initiatized and set to list ID.

But I need to pad m_ID with leading zeros. Essentially, the string should be 6 digits with leading zero.

I have seen couple of posts which use loop and they seem complicated. Is ther a function or expression that will solve this?

There should be a TEXT(ID,"000000") function in Flow to format numbers as string?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @YatinMumbai ,

There is no expression function for format numbers for leading zeros. Here are the steps you need to follow.
I will explain each step below.
First step is your input number (eg 23).
Next we need to construct a Do Until Loop where the length of input number match the total digit we want which is 6 in your case.
So in your case the initial length is 2 (length of 23) so that means the loop will execute 4 times to add the leading zeros.
To add the leading zeros we will use the flow Compose step.
Finally reassign the input number to compose output.
So it's starts with 023, 0023, 00023 and finally 000023 which is the result we want.

Here are my test results:

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
YatinMumbai 123 on at

Like (1)

Report

Sounds good. Will try this out and revert with Accept as Solution.

Was this reply helpful? Yes No