Forum Discussion

Copper Contributor

Feb 22, 2024

Auto number with prefix (sharepoint list)

I would like to add a column to a list in sharepoint (populated from a form), that automatically assigns a number to each new entry, with the prefix "DEV-", so eg. "DEV-0001", then "DEV-0002" etc. I...

SharePoint Online

Koong

Copper Contributor

Feb 23, 2024

Tbelly50 ,

You can use https://make.powerautomate.com/ to adding prefix like follows:

Thanks!

Tbelly50

Copper Contributor

Feb 23, 2024

Hi Koong

It worked - thanks! Now I have a follow up question - is it possible to update the ID field to show leading zero's or start at a specific number? We wont be starting with DEV-0001, as this system's been in place for some time, but something like DEV-3893.

Thanks again!