Announcements
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
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
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
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 477
WarrenBelz 341 Most Valuable Professional
11manish 317
