AutoNumber Column fixed length

(0) Share

Report

Posted on by AnthonyD

559

Hi guys,

I have a autonumber column configured as below. Will this column never exceed 6 characters? Because I need this column value always to have 6 characters.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hello @Anthony_Dob

Hope you are doing Good,

Open the Field, and Click Advance Settings and Set the Maximum Length to 6.

That's it 🙂

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
AnthonyD 559 on at

Like (0)

Report

Hello @rampprakash !

Hope you are doing great as well!
The format used to be {RANDSTRING:2}{SEQNUM:4}. When setting Max length to 6 it would give below warning.
This is why I changed format to {RANDSTRING:6}. Now I don't get this warning on changing Max length to 6. I am just asking this to be 100% sure that Autonumber will never go over 6 digits.

Best Regards,
Anthony

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @Anthony_Dob

As the Warning is not here it will Auto Use ALPHANUMERIC too so no issues in that, it will work as expected

Was this reply helpful? Yes No