Forum Discussion

Tbelly50's avatar
Tbelly50
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's avatar
Koong
Copper Contributor
Feb 23, 2024

Tbelly50 ,

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

 

Thanks!

  • Tbelly50's avatar
    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!

Resources