Hello,
I have two separate forms, that connect to the same SharePoint List. I was not having this problem, until the addition of the second form.
Both forms ask for a date and time for the submission of the form. When you click submit, the app is supposed to check the SharePoint list for if a date already exists.
I had renamed the List that the forms were referencing, but I used the search function to make sure I did not miss any references.
One form is for Adobe installations, called "Adobe", and the other is for laptop deployments, called "Laptop Deployment Form". The difference between the two forms is a hidden text block that distinguishes which form was filled out. The screens for reach respective form are linked to a button on the main menu.
This is the code for the submit buttons:
If(!IsBlank(LookUp('Adobe Install and Laptop Deployment','Date and Time'=DateValue4.SelectedDate+Time(Hour(HourValue4.Selected.Value),Minute(MinuteValue4.Selected.Value),0))),Notify("The date and time you selected are unavailable. Please choose a different date or time.",NotificationType.Error,3000);ResetForm(Adobe),Set(MyVar,1);SubmitForm(Adobe); Navigate('Main Menu',ScreenTransition.Fade))
If(!IsBlank(LookUp('Adobe Install and Laptop Deployment','Date and Time'=DateValue5.SelectedDate+Time(Hour(HourValue5.Selected.Value),Minute(MinuteValue5.Selected.Value),0))),Notify("The date and time you selected are unavailable. Please choose a different date or time.",NotificationType.Error,3000);ResetForm('Laptop Deployment Form'),Set(MyVar,1);SubmitForm('Laptop Deployment Form'); Navigate('Main Menu',ScreenTransition.Fade))
The problem that is happening is the submit is not accurately searching the list. It tells me a date and time already exist when one does not, and in some cases, submits a date despite the reservation already existing in the List. I have also noticed that it does not work when attempting to submit times past 12 PM. 13,14,15, etc. (hour times) do not allow me through.
Editing to add that I am now seeing this as well:
There's never been a problem with the time pickers like this before, how is 14 not an hour value?
Switching the order of the syntax did not help this issue, nor has adjusting data row limits (which is set to 500)
I could really use the help, thank you!
