Setting time stamp

(0) Share

Report

Posted on by ComicSansrival

166

Hi,

I am building a form wherein there are three sections that I am tracking the date/time stamp.

The first part is whenever a new user raises a query a time stamp should be saved based on the time, he typed his query.

Second part is when the receiver of the query started to type his resolution

And the last one is when the query was set to "Resolved"

I would like to ask if you can send steps on how to record time stamps of the above scenarios.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@ComicSansrival - there are many ways to achieve this for Forms:

My method:

1. Create a Date field in SharePoint for the Query Detail field

2. Add this field into your Form

3. [Optional] Set the DisplayMode property for the DataCard to: DisplayMode.View

4. Set the Update property to:

If( 'Your Query Detail DataCard'.Default <> 'Your Query Detail DataCard'.Update, Now(), ThisItem.'Your Query Detail Date Stamp Column' )

5. [Optional] Set the Visible property of the DataCard to:

!IsBlank(ThisItem.'Your Query Detail Date Stamp Column')

Repeat the above steps for the other 2 fields.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ComicSansrival - I see you have given kudos to this post, but has it solved your question?

Was this reply helpful? Yes No
ComicSansrival 166 on at

Like (0)

Report
Copy link

Link copied!

Hi, I haven't test it yet but will get back to my query later.

Was this reply helpful? Yes No
ComicSansrival 166 on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik,

Where can I find the "update" in step 4?

Also, how can I do the same for the time?

Seems like time has different setting for hh and mm:

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ComicSansrival - the Update property is in the DataCard for that field (not the DataCardValue)

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ComicSansrival - is this now resolved?

Was this reply helpful? Yes No
ComicSansrival 166 on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik,

I was able to update now the date but I have one more question.

How can I set the timestamp to now if the dropdown value is equal to "Closed"?

Dropdown details:

And lastly how can I apply this auto time stamp to hours and minutes?

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ComicSansrival - please remember to accept the solution to the original question.

I do not understand your logic to the new question. What is the point of checking if the dropdown field = "Closed?" since the Query Resolution date field will already be populated with the current date time whenever that dropdown changes (irrespective of the selected dropdown value).

Was this reply helpful? Yes No