Sharepoint list Query - Crated date vs Today and get list

[RomeroCastroK]

Hello, need some help with this flow, I need to get a list of items created in the last 24hrs, this is what i have but is not giving me anything, appreciate the help

[RouxJMM]

Does that work?

replace(formatDateTime(addDays(convertFromUtc(utcNow(),'Eastern Standard Time'),-1),'yyyy-MM-dd THH:mm:ssZ'),' ','')

[RouxJMM]

@RomeroCastroK 

Or to stay closer to what you had ...

replace(formatDateTime(addDays(utcNow(),-1),'yyyy-MM-dd THH:mm:ssZ'),' ','')

[sandeepstw · Accepted solution]

Hi There,

In SharePoint to get a list of items created in the last 24 hours using Power Automate, you can use the "Get items" action with a filter query-

CreatedDate > 'addDays(utcNow(), -1)'

Here, either you can use the SharePoint item created date or your custom column for the created date. 

Please give kudos and mark as solution if it helps.  

Thanks, 

Sandeep Mishra 

[RomeroCastroK]

I tried both, neither works, no errors but get empty list

not sure what is wrong

[RouxJMM]

Run the ‘Get Items’ action without a filter separately in a new flow and post the first created date so we can look at the format.

[RomeroCastroK]

this is the format I get

2023-01-30T20:14:25Z

[RomeroCastroK]

Found the error, I needed to change the threshold to max, it is working now, both options work

thanks for the help

[RouxJMM]

Btw, I have not tested the accepted solution but in case you were wondering about the purpose of the replace() in my solution. It is to eliminate the ‘Gotcha’ on a flow running in the morning before 10 am.  When the hour is a single digit, utcNow() will introduce a space.  Things might have changed overtime but that was my observation. I couldn’t remember the ‘why’ at the time of my post but here is.