Autonumbering with Alphabetic order generator

(0) Share

Report

Posted on by EBMRay

899

Hello Experts,

In the opportunity entity, I have added an auto number field with a static prefix using the auto number datatype in Dataverse.
The autonumbering will only increase the number based on the seed value.

I would like also to customize and automate the prefix in alphabetical order for example:

Whenever the first record is created the code will be RAA0000.
2nd record RAB0001
3rd record RAC0003..

When the R series is finished it should start with the S series (1st rec SAA000#, 2nd rec SAB000#).

I am planning on building a Power Automate flow that can handle the process of the above but I was wondering if there are other solutions available.

If yes, can someone please explain it in detail and provide me examples to help me achieve this scenario?

Any help will be greatly appreciated.
Thank you!

All responses (1)

Answers (0)

Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report
RE: Autonumbering with Alphabetic order generator

Hi,

Thank you for your query.

As far as I know, there are only 2 place holders available in an Autonumber Configuration:

{RANDSTRING:MIN_LENGTH} (this returns a random string)

{SEQNUM:MIN_LENGTH} (this returns incremented number)

There is no placeholder available for INCREMENTAL STRING.

To implement your logic, you need to write your custom code (a plugin).