Datepicker onChange/onSelect not working

(3) Share

Report

Posted on by k_romych

Hi All

I am trying to limit the range of dates that can be selected from the datepicker so I added some formulas to datepicker onSelect and onChange:

If(DateDiff(DatePicker1.SelectedDate,Today(),Days) > 5, 
 UpdateContext({DateWorning:"NO", TheDate:Today()}) , 
 UpdateContext({DateWorning:"Yes", TheDate:Today()}) )

also tried

UpdateContext({DateWorning: If(DateDiff(DatePicker1.SelectedDate,Now(),Days) > 5,"NO", "Yes"), 
 TheDate:If(DateDiff(DatePicker1.SelectedDate,Now(),Days) > 5, Today(), DatePicker1.SelectedDate) })

but it doesnt change neither DateWorning or TheDate

Any Ideas?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi!

I'm not sure about the OnSelect event, but I think the OnChange event only triggers when a date is selected, not when you type into the control (at least that was the case the last time I used it).

I'd recommend replacing your default datepicker with this one by @PowerAddict:

https://powerusers.microsoft.com/t5/Canvas-Apps-Components-Samples/Reusable-Revamped-Date-Picker-Control-v3/m-p/590606#M200

Then you could modify the component to limit date ranges,

Cheers,

Sancho

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Thank you @iAm_ManCat!

@k_romych I have a significantly better version of the date picker component which I will be releasing this week. You can either take that and customize it or if you want, I can try to add the feature that you are requesting here.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
k_romych 22 on at

Like (0)

Report
Copy link

Link copied!

@PowerAddict - I am getting "There was an error opening the file" when trying to import your .msapp

Was this reply helpful? Yes No
CodeMorgan 28 on at

Like (0)

Report
Copy link

Link copied!

The PowerApps modern date picker doesn't seem to be any better at OnChange trigger events. I have one in a gallery and it simply does not perform the OnChange event even though I can put the exact same script in an icon with an Classic date picker and the script works. Microsoft is really leaving us developers hung out to dry with their untested horrible controls.

Was this reply helpful? Yes No
Suggested answer

brightfame 5 on at

Like (0)

Report
Copy link

Link copied!

Four years later, I'm finding out that OnSelect fires for both OnSelect and OnChange events. Not that it helps now, but the OP's code should be applied to OnSelect and read:

If(DateDiff(Today(),Self.SelectedDate) > 5,

UpdateContext({DateWorning:"NO", TheDate:Today()}) ,

UpdateContext({DateWorning:"Yes", TheDate:Today()}) )

Was this reply helpful? Yes No