Hi,
I have a autonumber field. Its current format is "TK-0000001". I want to append date at the end of it. For e.g "TK-0000001-ddmmyy".
Please let me know how is this possible.
Thanks
Hello,
I'm afraid you can't do that using OOB autonumber but you can do it using custom code - for example plugins.
You can do it with the OOTB Autonumber, however the 1 issue is that the only value available is UTC. In the make.powerapps.com interface go to a Text column and change it to Autonumber (or create a new autonumber field), in the Autonumber type dropdown select Custom, in the dropdown below the Format you can select to add Date after adding it you can then rearrange the yyyy-dd-MM elements e,g, ddMMyy is valid.
This is an old page but has some examples of different formatting options docs.microsoft.com/.../create-auto-number-attributes
Also, after the number is generated it is just a text value so you can also append after it has generated via plugin or workflow etc.
LA thanks! Did not know that! That's why I like this community website!
pls refer this article,
https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/146170/auto-number-based-on-year/326230
I hope it helps,Thanks.Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
MVP-Daniyal Khaleel 127
Tom_Gioielli 125 Super User 2025 Season 2
