Filtering Based on the Starttime, EndTime

(0) Share

Report

Posted on by Kiruthika_02

I am Filtering SharePoint List to display records only for that Day alone. I am Storing StartTime as datetime column in SharePoint in the format dd/mm/yy 00:00 format . In the PowerApps when I use Today() , it is showing todays date and 12:00:00 am as Time . and Filtering Values Start Time(Today()) is not fetching all the values . So I am using like this

With( { StartDate: DateTimeValue(Today()-1), EndDate: DateTimeValue(Today()+1)}, Filter( CallDetailsList,StartTime > StartDate, StartTime <= EndDate ) )

Though it seems to be weird ,But this is only fetching values . But Still I could see some of the Values at the Start of the day (8:00 to 5:00 working hours), it is not fetching values .

Can Someone Help me with the better formula , SO that I can use this to fetch only Today business Hours Record

TIA

Categories:

General Comment