auto populate today date if dropdown selection is selected

(0) Share

Report

Posted on by aoghelian

Hi all! i have a dropdown called status and a date field called completion_date date

i would like to auto populate today's date if the option Completed is selected in the completion_date date field

Thank you

Categories:

Building Power Apps

All responses (12)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @aoghelian ,

Set a Variable OnChange of the Status dropdown (I have assumed .Value is the output here)

If( Self.Selected.Value = "Completed", UpdateContext({varSetToday: true}) )

then the Reset of the Date Picker

varSetToday

and the Default of the Date Picker (I am assuming it is Parent.Default now)

If( varSetToday, Today(), Parent.Default )

and lastly at Screen OnVisible

UpdateContext({varSetToday: false})

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
aoghelian 71 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz worked like a charm!! Thank you!!
lotrix 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,
I have the exact same scenario and your solution worked perfectly. However, could you help me creating a minor modification:
If the "Completion Date" picker is empty and the dropdown is set to "completed", then the today's date should be inserted....but if a completion date has already been entered BEFORE the dropdown is set to "completed" then the entered completion date should remain. THank you for your help.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lotrix ,

DefaultDate would be something like this

If( varSetToday, Coalesce( ThisItem.CompletionDate, Today() ), ThisItem.CompletionDate )
lotrix 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
There is still an issue: When I first select the 7/1/2023 as completion date and then set the dropdown to "complete", it changes the completion date to todays date 7/15/2023. Any suggestions?
lotrix 10 on at

Like
a
(0)

Report
Copy link

Link copied!

It seems as if the ThisItem.'Close Date' is not not correctly evaluated and the if function always returns the TODAY date.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@lotrix ,

Dates are not always blank - try

If( varSetToday, If( Value(ThisItem.CompletionDate) < 1, Today(), ThisItem.CompletionDate ), ThisItem.CompletionDate )

I am assuming you are using SharePoint here.
lotrix 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Further issue, when I save the form, the close date seems to get cleaned. It is not saved in the sharepoint list. When I click on Edit Item again, then there is no close date available...
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@lotrix ,

Sorry, I do not know what you mean - the only possibilities here are

If you have a date in your list it will show the date

If varToday is true, it will show the current date
lotrix 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
What I am trying to say is: Even when I entered a date in the Completion Date field and hit SAVE on the form, the Completion Data is not being saved in the sharepoint list. When I re-visit the form, the Completion Date is empty.