web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get records created to...

Power Automate

Answered

Get records created today from SharePoint in PowerAutomate Get Items action

(0) Share

Report

Report

Posted on by uiit3155

124

I am trying to fetch all those items from SharePoint where 'Created' date is today's date with below formula in "Get Items" action in PowerAutomate

Created gt '@{addToTime(utcNow(), -1, 'Day', 'yyyy-MM-dd')}' and Created lt '@{addToTime(utcNow(), 1, 'Day', 'yyyy-MM-dd')}'

But this formula is not working properly and returning records of yesterday as well.

Can you please help how can i only fetch records created today only?

Categories:

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @uiit3155

Try like this -

Created gt '@{formatDateTime(utcNow(),'yyyy-MM-dd')}' and Created lt '@{addToTime(utcNow(), -1, 'Minute')}'

See whether this works ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Join the conversation