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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,645
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
