I really need someones help please.
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.