cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kdillon
Regular Visitor

Sharepoint Get Items for Today's Date (Filter Query)

I have a powerapp that saves data into a Sharepoint list with a Date column. I'm trying to build a flow that sends out data from that list at the end of each night for the day. So it's essentially a scheduled flow that runs every night at 10PM, pulls the records for that day and sends an email with various items recorded on those days. 

 

I assume I have to put something in the Filter Query but I'm not clear on how to filter for a specific date, or 'todays' date? 

 

kdillon_0-1618584598700.png

 

Any help would be appreciated. 

 

Thanks

1 REPLY 1
fchopo
Super User
Super User

Hi @kdillon 

In the Filter Query field you could add something like:

created le 'formatDateTime(utcNow(),'yyyy-MM-dd')' and created gt 'formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd')

Which means that created date (in SP list) should be less or equals to today at 0h and greater than yesterday 

Hope it helps!

Ferran

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,991)