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

Announcements

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 308

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard