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 / Updating dates automat...
Power Apps
Answered

Updating dates automatically

(0) ShareShare
ReportReport
Posted on by 40

Hello

 

Trying to build some example in Sharepoint, which should in the end work with our not yet available SQL database. 

I have a simple sharepoint list: code, description, date-added, date-changed.

Build a standard app on that. With a Browsescreen, Detailscreen and Editscreen.
When I edit a record on the Editscreen and change something I would like date-changed get the value of today.
Date-added must not change.

When I add a record, by using + on the Browsecreen, I would like date-added and date-changed get the value of today.

Is there a possibility?

 

Regards

Ron

Categories:
I have the same question (0)
  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @PowerRon :

    Yes. I will update the detailed solution later.
    In addition,I recommend you directly use the standard field "Modified" that comes with the SP list. This field is not editable. As long as the record is changed, the value of this field will be changed to the time when the change occurred.

    Best Regards,

    Bof

  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @PowerRon :

    Please try this solution:

    1\The Date Picker control for "Date-Add"

    DefaultDate

     

    If(EditForm1.Mode=FormMode.Edit,Parent.Default,Today())

     

    2\The Date Picker control for "Date-Change"

    DefaultDate

     

    Today()

     

    1.JPG

    73.gif

    Best Regards,

    Bof

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard