Filter formula is not working

[brendalpzm]

I am developing a power apps site, for this I am creating a booking site

I created a list in share where I located the available slots for the day

I type the formula for filtering the slots only to show the slots available for the selected date and also to be greater than the current time but it doesn't appear anything

These are the variables:

• DateSchedule: Column in the SharePoint list
• SelectDate: name of the date picker
• Slots_ZDP_Psychologist: Name of the SharePoint list

Filter(Slots_ZDP_Psychologist,DateSchedule=DateValue(SelectDate.SelectedDate))

 

[JEC]

What if you put a datevalue around DateSchedule?

Using datevalue is not best practice though

 

[brendalpzm]

What if you put a datevalue around DateSchedule?

Using datevalue is not best practice though

I did and it shows like this

 

[JEC]

Keep the datevalue around the selected value too

 

[brendalpzm]

Keep the datevalue around the selected value too

Same

 

[JEC]

Can you post a screenshot of your list? How many records do you have?

 

[brendalpzm]

Can you post a screenshot of your list? How many records do you have?

It is fixed to 2746 rows

 

[JEC]

You have a delegation issue while filtering datevalues.... take a look at this