Power Platform Community Forum Thread Details

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.