Capturing Date and time after selecting Completed on a drop down

(0) Share

Report

Posted on by karlamaddox1

Annotation 2022-03-03 111351.png Annotation 2022-03-03 111531.png snip for power automate .png

Here is what I have on the drop down -

If(
DataCardValue96.Selected.Value= "Completed", DateValue3, Now()
);

In the time card I have this

Text(Now())

Basically I have a drop down.. when someone clicks complete, I want the time and date to be stamp in that box. I am not getting an error on the drop down code, but when I click it, it does not capture the time.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@karlamaddox1

It's not quite clear what you have and where from your description.

Now() is a function that evaluates at one point in time. So the trick is to get a snapshot (in a variable) of the time.

So, on your Dropdown OnChange action, the following formula:

UpdateContext({lclChangeTime: If(Self.Selected.Value = "Completed", Now(), Blank) })

Then, for your DefaultDate property (you do not want to use the Text function as you have as the DefaultDate property wants an actual date - not text) set the property to lclChangeTime

I hope this is helpful for you.
karlamaddox1 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the code.. I am getting an error stating that the function 'if' has some invalid arguments.
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
UpdateContext({lclChangeTime: If(Self.Selected.Value = "Completed", Now(), Blank()) })

I dont want to steal the sollution but I think there is some () missing.

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@karlamaddox1

Oops sorry, I omitted some parens!

The Formula should be the following:

UpdateContext({lclChangeTime: If(Self.Selected.Value = "Completed", Now(), Blank()) })
karlamaddox1 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you... I updated the on change for the drop down.. now when I change to completed, it does give me the date but not the time. What am I doing wrong?
karlamaddox1 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for responding first and quickly. I followed your steps however the hours and minutes have do populated for me.. what should I put in? Thank you
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@karlamaddox1

You will need to change the formula on the hour and minute dropdown as well.

You would do that on the Default properties of those controls.

However, I see this is a form, so you should really be changing the Default property of the DataCard to reflect the logic and not the individual controls in the datacard.