web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Set main column as aut...
Power Apps
Answered

Set main column as autonumeric with date and sequence

(0) ShareShare
ReportReport
Posted on by 35

Hello there!

 

I'm creating a new table in Dataverse and I want to set the main column as autonumeric.

I want to get this model of sequence:

yyyyMMdd-sequence     Example: 20230411-001, 20230411-002, 20230411-003, 20230412-001, 20230413-001

 

I already try this format: {DATETIMEUTC:yyyyMMdd}-{SEQNUM:3} but I get this...: 20230411-001, 20230411-002, 20230412-003, 20230413-004     the sequence number never reset when it's the next day

 

Any help is appreciated! 😄

I have the same question (0)
  • Verified answer
    Guido Preite Profile Picture
    1,488 Super User 2024 Season 1 on at

    for the sequence you need (reset the number every day) you will need a plugin, the built-in autonumber can't build that kind of sequence.

    EDIT: please don't open multiple threads with the same question, you asked this question on 3 different sections of this forum

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 393

#2
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 271 Super User 2025 Season 2

Last 30 days Overall leaderboard