Answered

Set Date picker to today's date when a specific value is selected from a dropdown list

(1) Share

Report

Posted on by Egasber

I have a Powerapps form where I want to track when an issue starts getting worked on, and again when the issue is resolved. If I can figure out how to get the "Being Worked On" status to set its date field, I should be able to repeat the process for when the issue is "resolved" So I just want to track when the "Being Worked On" status is selected by recording the date in a date picker control tied to a SharePoint date field.

I have a dropdown Control "DD_HBCorrectionStatus". When the value "Being Worked On" is selected, I want to automatically set the HB worked on Date field "HBWorkedOnDateValue" to be set for the date when the "being worked on status was selected.

I have three options for the dropdown that are coming from a sharepoint list data source, The list is "Correction Status" and the column being used is the "Name" column to hold the choice values:

Not Applicable

Being Worked On

Resolved

This is a sharepoint integration, form, not a stand alone canvas App.

For the life of me, I haven't been able to figure this out, and I know this should not be particularly difficult. This feels like it should be such a basic use case, but all the similar threads I've looked at don't quite fit this scenario.

This is the last part of the form before it will be a fully working solution. I'm just stuck on this part.

If anyone has a suggestion, I would really appreciate it.

First time using this community, so if additional info would be helpful, just let me know. Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
Hi @Egasber ,

The issue you have is to change the data field once only - so OnChange of your dropdown (please confirm this is not a Combo Box)

If( Self.Selected.Value = "Being Worked On", UpdateContext({varWorkDate: Today()} )

then the DefaultDate of the Date Picker

Coalesce(Parent.Default,varWorkDate)

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Egasber 7 on at

Like (0)

Report

Thank you for this. I solved my immediate problem by going to Power Automate to get the behavior I wanted for now but I'm going to explore this in detail. I don't fully understand what this is doing yet- well I understand the what, but not the mechanics, and I am reluctant to use any formula I don't understand fully. But that said, it does work (I immediately built a test form). I just started working with powerApps two weeks ago so I'm still learning about the various functions and syntax.

Anyway, yes, this does give me exactly what I was looking for, so I'll be adding that to my tool box, lol

Thank you so much!

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @Egasber

I will briefly explain it

If( Self.Selected.Value = "Being Worked On", UpdateContext({varWorkDate: Today()} )

When you change a value in your drop-down, if it is now "Being Worked on", it sets a Variable calledvarWorkDate to the current date

Coalesce(Parent.Default,varWorkDate)

then the date displayed by default in your date picker first looks to see if you have already written something into your SharePoint field and it something is there, displays it, if not looks to see if varWorkDate has a value and displays it (or if not displays nothing)

Was this reply helpful? Yes No