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 / How to show the last u...
Power Apps
Unanswered

How to show the last updated time in the data?

(0) ShareShare
ReportReport
Posted on by 35

I would like to set last updated time sutomatically. Please tell me how?

 

Thank you

Categories:
I have the same question (0)
  • Verified answer
    PK_Hong Profile Picture
    337 on at
    Hi

    If you are using CDS, it is be defaults and you can display it.

    Otherwise you got to insert a today() with timer to activate it to show the current date or time and save it.

    Tq
  • chanokns Profile Picture
    35 on at

    Thanks a lot for your help.

     

    I have insert Now() but I don't know when I edit the data, the time doesn't shown up different from my first draft.

  • Verified answer
    PK_Hong Profile Picture
    337 on at

    Hi

     

    When you insert Today()  or Now() and format with TEXT to desired format, it will show the CURRENT date and time when it is inserted.

    So, to make it works like a normal Clock, you have to use:

    - A timer, with OnTimerEnd = UpdateContext({Now(): MyClock})

    - Duration = 100 (100 ms)

    - Autostart = True

    - Repeat = True

     

    And have a lable to show MyClock

     

    Note: MyClock is the context variable  which is updated

    - every 100 ms and autostart when the apps is opened and repeat everey 100ms.

     

    PowerApps doesn;t teach how to make a real clock, we got to use Timer + UpdateContext.

     

    Hope this helps and you learn how to make a real time clock.

     

    TQ

  • chanokns Profile Picture
    35 on at

    Thanks a lot for your help again.

     

    I use a SharePoint list, I can set ONLY time format in Excel Online but there is no Update time. Moreover, What is the formula? UpdateContext({Now(): MyClock}), right?

  • Verified answer
    hpkeong Profile Picture
    2,944 on at

    Hi

     

    Please see screenshot.

    My apology:

    UpdateContext({Variable: Now()})...the correct definition

     

    THanks

     

    You can remove yyyy, leave only hh:mm am/pm to show timeYou can remove yyyy, leave only hh:mm am/pm to show time

     

  • chanokns Profile Picture
    35 on at

    I am using the data from Excel Online in OneDrive.

    If I set this formula as you have mentioned, after filling the data, the data will be shown up in Cell in the same Column in Excel Online, right? 

     

    Thank you for your kindly support.

  • chanokns Profile Picture
    35 on at

    I am using the data from Excel Online in OneDrive.

    If I set this formula as you have mentioned, after filling the data, the data will be shown up in Cell in the same Column in Excel Online, right? 

     

    Thank you for your kindly support.

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 793 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 333 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard