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 / Creating a reference n...
Power Apps
Unanswered

Creating a reference number on submission. But each device to automatically 'download' 5 references in case of no signal.

(0) ShareShare
ReportReport
Posted on by 1

Hello,

I am designing an app where staff create a record on their devices. They can choose to save the record after a certain amount of data has been entered or submit the record completely. 

Upon save or submit, I need a unique reference number to be created in the format of 22/****/24 (the 24 will need to change depending on the year etc). 

As staff can work in areas on no cellular signal, I need each device to 'bank' a number of reference numbers, say 5, to prevent duplication. The banked references need to be automatically updated each time they have cellular or wifi signal. 

Categories:
I have the same question (0)
  • Adrian_Celis Profile Picture
    1,652 Moderator on at

    Hi @Keiron1850 

    Because your staff may have no internet connection, we can create the unique reference number once the staff's device is online again and gets save in the data source. Are you using SharePoint or Dataverse or another data source?

    To create a reference number you can save an easy format to sort in your data source: a good format is YYYYMMDD-0000 because it easily sorts alphabetically. All you have to do now is get the serial number (get last 4 numbers) and increment it if the previous reference number if it is the same year, or reset it if it is a different year. You can change the format into 22/****/24 when you display it in the app.

    You can follow this tutorial for your requirements or ask me if you have any more questions.
    Power Apps – How to do reference numbers with dates and serial number 

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
Haque Profile Picture

Haque 84

#2
WarrenBelz Profile Picture

WarrenBelz 79 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 40 Super User 2026 Season 1

Last 30 days Overall leaderboard