cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gofunk1
Helper I
Helper I

Flow help, how to only get items modified in the last 24 hours

Hi All 

 

I have the blow flow configured to send an email each morning, it works, but it is currently sending every item on the SharePoint list. I only want to it send items modified in the last 24 hours. 

 

Can some please help me achieve this please? 

 

Gofunk1_3-1638185868489.png

 

Gofunk1_1-1638185777024.png

Gofunk1_2-1638185796634.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks, I'm still new to this, it is not working for me somehow, still pulling all the data as opposed to the last 24 hours...

 

Modified gt DateTime'@{addDays(utcNow(),-1)}'

 

Gofunk1_0-1638190399842.png

 

View solution in original post

3 REPLIES 3
mahoneypat
Super User
Super User

You can use an OData filter in your Get Items action.  See this previous solution for an expression.

Solved: Filter SharePoint list for last 24 Hours using ODa... - Power Platform Community (microsoft....

 

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thanks, I'm still new to this, it is not working for me somehow, still pulling all the data as opposed to the last 24 hours...

 

Modified gt DateTime'@{addDays(utcNow(),-1)}'

 

Gofunk1_0-1638190399842.png

 

View solution in original post

Got it! Thanks you, it works 🙂

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

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

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,473)