Answered

Update a Date & Time picker column on button click and submit record to SharePoint List

(0) Share

Report

Posted on by Juliet

I have a SharePoint List called "Demand Request List" that has a date & time picker field called "PLM Created Date".

On my PowerApp I want to update this column with the current date & time when a user clicks a button. Ideally, I don't even want the fields to be in the PowerApp, and the button could just send the timestamp to the SharePoint List, but I would settle for just making them not visible.

I tried a few solutions but nothing has worked so far. Any thoughts?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Akash17 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Juliet
make use of Now()
UpdateIf( dbname, ID = Gallery.Selected.ID, {DateColumn:Now()}
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Juliet ,

OnSelect of the button

UpdateContext({varToday: true})

Date field DefaultDate

If( varToday, Today(), Parent.Default )

Hour drop-down Default

If( varToday, Text(Hour(Now()),"00"), Text(Hour(Parent.Default),"00") )

Minute drop-down Default

If( varToday, Text(Minute(Now()),"00"), Text(Minute(Parent.Default),"00") )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Juliet 17 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked perfectly, thank you so much!
federico1995 3 on at

Like
a
(0)

Report
Copy link

Link copied!
Works perfect,
Dont forget to set the variabel to false on the save or cancel button in the edit form:
UpdateContext({varToday: false})