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
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,
pls refer this article,
I hope it helps,
Thanks.
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365
LA thanks! Did not know that! That's why I like this community website!
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.
Hello,
I'm afraid you can't do that using OOB autonumber but you can do it using custom code - for example plugins.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,645 Most Valuable Professional
nmaenpaa 101,148