PowerApps – Updating current Date and Time

Hey folks,

in this post i want to show you how you could create an always up to date timestamp within PowerApps. Just follow the next few steps:

Add Timer

  1. In the menu bar, click on “Insert” – “Controls” and add a “Timer” to your screen
  2. Now change the following Timer settings:
    1. Duration = 0
    2. AutoStart = true
    3. Repeat = true
    4. OnTimerEnd = Set(CurrentDateTime,Now())

Now the timer starts if we start the app, runs and will repeat endless times. Every time the timer ends, it will set the variable “CurrentDateTime” to the current date and time.

To display the current date and time, you need to add a label to your screen and change the text:

  1. Text =Text(CurrentDateTime,”dddd mm/dd/yyyy hh:mm:ss”)

The current date and time should appear in the label field. If not, please start your app (play button in the upper right corner or F5) or check if your variable “CurrentDateTime” is correct.

If it works fine, you could hide the timer, so that only the label will be visible to your users. Just select the timer on your screen and change the setting:

  1. Visible = false

Now you have a Timer with the current date and time in PowerApps.

 

If you want to use different formats, here are some more:

“ddd mm/dd/yyyy hh:mm:ss”

 
“dd.mm.yyyy hh:mm:ss”


“yyyy-mm-dd hh:mm:ss”

if you want to change the shown language, just add a comma within the Text()-function:
Text(CurrentDateTime,”dddd dd.mm.yyyy hh:mm:ss”,”de-DE”)
German:
 

Text(CurrentDateTime,”dddd dd.mm.yyyy hh:mm:ss”,”nl-NL”)
Dutch:

Text(CurrentDateTime,”dddd dd.mm.yyyy hh:mm:ss”,”da-DK”)
Danisch:

2 Gedanken zu „PowerApps – Updating current Date and Time“

  1. How can we change the date to another language? For example German or Spanish.

    I tried Dutch:

    Text(CurrentDateTime, “[$-nl-NL]dd/mm/yyyy hh:mm:ss”)

    But it still gave me Wednesday instead of Woensdag. Do you know what I’m doing wrong?

    Thanks for your answer.

    1. Hey,

      the language is not defined by the “[$-nl-NL]” in front of the date, but within the Text() function. Just add a comma after your date format and you can select the language:
      Text(CurrentDateTime,”[$-en-US]dddd dd.mm.yyyy hh:mm:ss”,”de-DE”)
      Text(CurrentDateTime,”[$-en-US]dddd dd.mm.yyyy hh:mm:ss”,”nl-NL”)

      I will update the article, thanks for the question!

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.