@CU29111912-0 The logic of your flow needs to be adjusted. The output of your compose action that contains today's month and day is outputting utcNow() (aka the current date and time) in your selected timezone (since you've converted it.
There are a couple of problems with this:
1) Date/Time Format:
In my original response I indicated that your date time needs to be formatted in ISO 8601 format yyyy-MM-ddTHH:mm:ssZ.
2) Filter Array Argument
If you review the input of the data from the Get Items action (highlighted below) you can see the output of the StartDateAndTime. Your argument is incorrect and the way you've formatted will never return any results. Unless the item was created at exactly the same time that you ran your flow.
Additionally, SharePoint stores all timestamps in UTC.
First, you need to compose the datetime range you want to filter out. Once you have that you can add in the rest of your actions in your flow. In your case, you need to compose the following:
- 3 Days from Today at 12 AM
- 3 Days from Today at 11: 59 PM.
The filter array action needs to be formatted with the argument to look for any items from your SharePoint list that are greater than 3 Days from Today at 12 AM and less than 3 Days from Today at 11: 59 PM.
Follow
this section of my YT Tutorial on how to get a date 3 days from a date stored in SharePoint.
In this tutorial, I only need the date (not time). However, you will just need to adjust the expression (example below):
For 12AM: formatDateTime([datetime],'yyyy-MM-ddT00:00:00)
For 11:59PM: formatDateTime([datetime],'yyyy-MM-ddT11:59:00)
