Unanswered

Date Auto Populates into field once status is selected as Closed

(0) Share

Report

Posted on by Evan_S1

341

I have a Status drop down that has Open or Closed. If the status is selected closed, I need the date to auto populate date, hour, minutes. My setup is Shown below. What functions do I need to use for each?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Devvj 1,132 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Evan_S1
You could use the Now() to get the current date/time, and then format it accordingly using Minute(Now()) and Hour(Now()) to get the current minute and hour accordingly.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report

@Devvj It needs to change based off of the status "closed" being selected. If I use what you mentioned it changes the time and date to the current time but the time and date should only change if "closed" is selected. The time and date should remain empty if any other status is showing.

Was this reply helpful? Yes No
Devvj 1,132 Super User 2024 Season 1 on at

Like (0)

Report

@Evan_S1
YYou could use a if() in the onchange property on the status field, something like

If('your status field'.selected.text = "Closed", 'set all your fields to current date/time')

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report

@Devvj

How would the "seta all your fields to current date/time" look in the function?

If(DataCardValue61_3.Selected.Text = "Closed", (what function goes here?)

Was this reply helpful? Yes No
Devvj 1,132 Super User 2024 Season 1 on at

Like (0)

Report
You can use a variable in the Default property on you date field, call it "varDate" or whatever you feel fit.

Then your solution would look something like this
If(DataCardValue61_3.Selected.Text = "Closed", Set(varDate, Now()), Set(varDate, Blank()))

What it does is to check if the status field is set to closed and if it is, it sets the date field to current time, else it blanks out the date field instead.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report

@Devvj

Then what function do I put in the date, hour, minutes ?

Was this reply helpful? Yes No
Devvj 1,132 Super User 2024 Season 1 on at

Like (0)

Report

You can maybe reuse the same variable, just put the default property in the Hour field to "Hour(varDate)" and "Minute(varDate)" on the Minute field

Was this reply helpful? Yes No