News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Automating the auto-nu...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Automating the auto-numbering format of a field

(0) Share

Report

Report

Posted on by F.Mogheth

95

A question from a newbie here

I wonder if this below automation is possible by a WF or Flow

I am adding a new Auto number field that should have the YEAR+Serial Number
So the field should be auto named in the forma 2023-CZ123456
The serial numbers will be a normal auto number but I would like the year "Prefix" to update automatically with a 2024 prefix that would only affect the new created records
So all fields created this year will be 2023-1, 2023-2, 2023-3 and now we have a new year, the auto numbering will continue as a serial number (not from 0) and proceed as 2024-4, 2024-5

Thank you for any suggestions

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

XM-22040801-0 11 on at

Like (0)

Report

RE: Automating the auto-numbering format of a field

You can set a custom autonumber type.

Example for you : {DATETIMEUTC:yyyy}-{SEQNUM:6}

Example:

To learn more about format : https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/create-auto-number-attributes?view=op-9-1#autonumberformat-options
Suggested answer

F.Mogheth 95 on at

Like (0)

Report

RE: Automating the auto-numbering format of a field

Cheers and thanks a lot... Adding a date prefix is something I have missed... That´s a great start

Will check the format of that Date and if it can be changed but it definitely offers a possible solution/compromise to the client
Suggested answer

XM-22040801-0 11 on at

Like (1)

Report

RE: Automating the auto-numbering format of a field

Hi,

Can this article help you? carldesouza.com/.../

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,885 Super User 2024 Season 2

#2

Martin Dráb 230,569 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans