Check overlapping time

[alt88]

Hello everyone, I am developing an application for time recording. The user can enter the start times via one input field and the end times via another. The problem I currently want to fix are overlaps. For example, the first recorded time pair from 8:00 - 15:00 and the second recorded time pair from 10:00 - 12:00. Means by the recorded time from 8.00 -15.00 o'clock is 10.00 - 12.00 o'clock now redundant. I store the whole thing in the dataverse. Do you have ideas how I can catch this error?

[v-jefferni]

Hi @alt88 ,

Could you please share more details about your scenario? When and where would you like to catch the error? How would you like to display the error in your App?

Best regards,

[alt88]

Of course, I want this error to be thrown when entering the time in the second input field with the end time. That is, when the user enters the second time pair and onchange detects, for example, that this time overlaps with the previous entry. The error should then simply be thrown as notification and the patch is not executed.

[v-jefferni]

Hi @alt88 ,

OK, then how would users input time pairs? In two text input boxes?

BR,

[alt88]

Exactly, there are two text input fields in the PowerApps and the format in the dataverse is also text in the format hh:mm. Means in dataverse you will find one column start time in text format and another column also in text format.

[v-jefferni]

Hi @alt88 ,

Are there any date columns in your data source? Just comparing time values seems strange. Could you please share a screenshot of your Dataverse table (with some sample data)? In addition, a screenshot of your App interface would be appreciated.

Best regards,

[alt88]

Apologies for the incomplete information. There is also a date associated with it. This means the current date selected in the date picker will be included. The table consists of Current User, Date, Start Time, and End Time.

[v-jefferni · Accepted solution]

Hi @alt88 ,

This makes sense. Please try below formula OnChange of start and end time text input (if only checking for the logged in user)

If(!IsBlank(LookUp(Filter(YourTableName, Datum = DatePicker.SelectedDate && CurrentUser.DisplayName = User().DisplayName), IfError(TimeValue(Self.Text),Blank(),TimeValue(Self.Text))<TimeValue(Endzeit) && IfError(TimeValue(Self.Text),Blank(),TimeValue(Self.Text))>=TimeValue(Startzeit))), Notify("Input Time is within existing period. please try other time",NotificationType.Warning))

Best regards,