Power Platform Community Forum Thread Details

Hi all,

I have 2 date field in PowerApps. Planned start and Planned end date. If Planned start date is 8th August, then Planned end date cannot be selected before 8th August. If past dates are selected it will reset the Planned end date field. To satisfy this scenario I have added a condition in "on change " property of Planned end date.

If(
    !IsBlank(psdate_2.SelectedDate) && !IsBlank(peddate_2.SelectedDate) && peddate_2.SelectedDate < psdate_2.SelectedDate,
    Notify(
        "Planned End Date cannot be less than Planned Start date",
        NotificationType. Information,
        1000
    ) && Reset(peddate_2)
)
On save button also I have added the same code but with a variable.
If(
                                !IsBlank(psdate_2.SelectedDate) && !IsBlank(peddate_2.SelectedDate) && peddate_2.SelectedDate < psdate_2.SelectedDate,
                                UpdateContext({Plannedendate: true}) && Notify(
                                    "Planned End Date cannot be less than Planned Start date",
                                    NotificationType.Information,
                                    1000
                                ))
On reset property of Planned end date I have added If (Plannedendate = true, true, false).
So in both cases it will reset the Planned end date field when past dates are selected.
 
For me both the scenarios are working but the notification displays twice. I have attached screenshot for the same.
Any help/suggestion on this.
Thanks in advance.

Categories:

Building Power Apps

Hi Sri,

The fundamental issue is that the OnChange of a Combo Box triggers with the form is refreshed (such as when it it submitted) - if you also check that the data has actually been changed (the content does not match the data field), you should get rid of it

If(
   !IsBlank(psdate_2.SelectedDate) && 
   !IsBlank(peddate_2.SelectedDate) && 
   peddate_2.SelectedDate < psdate_2.SelectedDate &&
   Self.SelectedDate <> ThisItem.YourDateField,
   Notify(
      "Planned End Date cannot be less than Planned Start date",
      NotificationType. Information,
      1000
   );
   Reset(peddate_2)
)

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee