I have created a workflow in Power Automate to send an automated email out every morning with a list off all entries added the day before in a sharepoint list.
The get items Filter Query I am using is:
concat(concat('DateTimeofAppointment',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat(' DateTimeofAppointment ',' lt ','''', outputs('x_Days_+_1'),''''))
it is working, though I am getting someentries from 2 days prior and yesterday.
I strated with a remind me workflow from the sharepoint list and and modified it to get items form yesterday.
I believe it has something to do with the timeline. I live in Adelaide South Australia.
I have tried many times to create a Filter Query Expression and it keeps failing.
When you are saying two days prior data - are you saying with respect to data which you have observed in get items outputs ?
Because dates in sharepoint list when viewing via power automate would appear in UTC format only.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
17
Share
Report
All responses (
Answers (
