Best way to compare values in different Date Picker columns

(0) Share

Report

Posted on by CU01081947-0

716

Hello Power Apps Community,

I hope you can help please.

I'm using Dataverse for Teams to build a timesheet app.

I have a Form with a number of Date and Time columns, "Monday Start", "Monday End", "Tuesday Start". "Tuesday End" etc.

I want to add some validation, so when the date and time in say the column "Friday Start" is greater than "Friday End" I want to notify the user and stop them saving the form with incorrect data.

Currently, as a test, on one of the columns, "Friday Start", on the "HourValue" part of the datacard I've added this formula:

If(
         crdFridayStart.Update > crdFridayEnd.Update,
         Notify(
                     "Day Start hour is greater than day End hour. Adjust your Start hour to be earlier than your End hour",
                     NotificationType.Error,
                     10000
                   ),
        false
)

This notifies the user but still allows them to save the record. This test, or course, is not what I really want.

I want the entire datacard of the "Friday Start" to be compared with "Friday End" and if "Friday Start" is greater than "Friday End", even by a minute, I want the notification to appear and to stop the user saving the record.

Also, of course, I want this for all the datacard pairs, so "Monday Start" vs "Monday End", "Tuesday Start" vs "Tuesday End" etc.

Any guidance would be greatly appreciated.

Thanks very much,

Garry

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@GarryPope Place this code in the OnSelect of the Save icon (remember to change control names as required),
With({ varMondayStart:DateTimeValue(crdMondayStartDate.SelectedDate & " " & crdMondayStartHour.SelectedText & " " & crdMondayStartMinute.SelectedText), varMondayEnd:DateTimeValue(crdMondayEndDate.SelectedDate & " " & crdMondayEndHour.SelectedText & " " & crdMondayEndMinute.SelectedText), varTuesdayStart:DateTimeValue(crdTuesdayStartDate.SelectedDate & " " & crdTuesdayStartHour.SelectedText & " " & crdTuesdayStartMinute.SelectedText), varTuesdayEnd:DateTimeValue(crdTuesdayEndDate.SelectedDate & " " & crdTuesdayEndHour.SelectedText & " " & crdTuesdayEndMinute.SelectedText) // Add variables for other days here }, If( DateDiff(varMondayStart, varMondayEnd, Minutes)<0 || DateDiff(varTuesdayStart, varTuesdayEnd, Minutes)<0 || // Add comparisions for other days here , Notify("ERROR MESSAGE"), // Save the data ) )

Was this reply helpful? Yes No
CU01081947-0 716 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @CNT,
Thank you so much for your quick response, I really appreciate it. I don't doubt it's not working, but when I try it, I'm getting errors. I'm terrible with variables. Leave it with me, and once again, thanks for your reply.
Garry

Was this reply helpful? Yes No