cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
morall
Microsoft
Microsoft

filter query by date using UTC now

this is my sharepoint list:

 

Screen Shot 2020-07-01 at 10.13.25 AM.png

 

I'm trying to make a filter that checks to see if fu_date2 is today

 

When the date stamp gets saved in Sharepoint, it gets saved as m/d/yyyy 

 

In my Flow, I am using 

 
formatDateTime(utcNow(), 'dd/MM/yyyy')
Screen Shot 2020-07-01 at 10.18.11 AM.png
 
and no results are showing up
 
If I hard code the Filter Query as fu_date2 eq '7/1/2020' it works as expected
 
Any thoughts? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
morall
Microsoft
Microsoft

just realized my date formatting was off and that was causing the problem 

View solution in original post

2 REPLIES 2
morall
Microsoft
Microsoft

just realized my date formatting was off and that was causing the problem 

View solution in original post

rohsh354
Microsoft
Microsoft

Hello,

 

Thanks for sharing the scenario and the solution. I am sure, it can help other community users.

 

 

 

 

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (36,630)