Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Graph Explorer filter query for time off creation date



I am trying to build a flow that checks for any "manual" time off created yesterday using graph explorer. Unfortunately, unless all of my team use the requests app, I can't use the "when a time off is created" trigger. 


I was hoping to use graph explorer to filter queries based on "created date time is greater than 24 hours ago" (because the flow is triggered at midnight" and is less than "utcnow()" - creating a 24hour period. 


However, I can't seem to get the createdDateTime function to filter. I'm getting the response "invalid" clause, but can't seem to figure out the correct syntax. 


My invoke requests looks like:



Memorable Member
Memorable Member

Try to play with GRAPH explorer at first. 

Helpful resources

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (64,953)