News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Power automate DS date...

Power Automate - Using Flows

Answered

Power automate DS datetime filter issue

(0) Share

Report

Report

Posted on by SamuelZhang

3

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:

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-liwei-msft on at

Like (0)

Report

Re: Power automate DS datetime filter issue

Hi @SamuelZhang

Flow automatically converts times in the dataverse to UTC time.
So you need to use the Filter array action, and use convertFromUtc to convert the time to your time zone.

Best Regards,
Levi

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,645 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans