Power Platform Community Forum Thread Details

Hi Support,

I am trying to filter the date range from the Dataverse table, which screenshots are attached.

My timezone is 'AUS Eastern Standard Time' and the datetime data are the 'AUS Eastern Standard Time' shown from the DS table.

I just need to filter all data for the date of 15/Sep which is yesterday.

Here are two functions in filter rows:

startofday(adddays(convertfromutc(utcNow(),'AUS Eastern Standard Time'),-1))

startofday(convertfromutc(utcNow(),'AUS Eastern Standard Time'))

Result only showing one last record when I ran it on 16/Sep/2022 8am AEST.

Could you please help to explain what did I do wrong?

Data:

Categories:

Power automate DS datetime filter issue