
Announcements
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?
Created gt '@{formatDateTime(utcNow(),'yyyy-MM-ddT00:00:00Z')}Feed it today's date with zero hours and minutes.