I have a powerapps app connected to a sharepoint list and I'm trying to compare 4 inputted values to 4 different columns in the list. I have it in the Onvisible property so if it matches any, a text box should become visible - like a popup.
The conditions are 1) the drop down is the same as the sharepoint list title column,
2) The selected start time (Starttime) is inbetween the Start time 3) and End time in the SharePoint.
4) The selected date is the same as the date in the sharepoint list.
The code I have is:
If(CountRows(Filter('Sharepoint site', Text(Dropdown.Selected.Value) = Title)) >= 1
&& CountRows(Filter('Sharepoint site', TimeValue(StartTime_Sharepoint) <= TimeValue(Starttime) && TimeValue(EndTime_Sharepoint) >= TimeValue(Starttime))) >= 1
&& CountRows(Filter('Sharepoint site', Date_Sharepoint = DatePicker.SelectedDate)) >= 1,
The problem I have is it's not applying them all, as you can see in the below the pop up is showing when it doesn't pass all the conditions.