Answered

Creating a time stamp in a gallery

(0) Share

Report

Posted on by ben22

Hi, how would I create a time stamp in an editable table using galleries in Dataverse? I am trying to record when the changes have been made (not using audit logging) in the gallery. I have tried using a Patch Function but am unsure of how exactly to create the formula and where I would put this formula. Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
Have a hidden timer in your app set to auto start auto restart etc. at 1000 milli, every time ontimerend occurs have it set something like
Set(whattimeisitVar,Now())
then anytime you need a timestamp just reference whattimeisitVar and you have an updated time stamp

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ben22 ,

Since you mentioned you want to create a time stamp when "changes have been made in the gallery", I guess you have a button to save your changes into the Dataverse, like a submit/update button.

If so, I would suggest you use Patch function in this button to log the timestamp. Before doing this, remember to add a Text/DateAndTime type column to keep the time stamp. The Patch formula should be like this:

XXX(Other actions here);Patch(DataverseName,ThisItem,{TimeStamp1:Now()})

See my example:

Best regards,

Allen

Was this reply helpful? Yes No