Not sure how to compare date and time correctly

[Pacadile]

What I have so far:
'Recurrence' Trigger
'Get Items' = 'Equipment Inventory Reservations'
'Apply to Each' = outputs('Get_items')?['body/value']
//Inside 'Apply to Each'
       'Get user profile (V2)'= items('Apply_to_each')?['Email']
        'Condition'= items('Apply_to_each')?['ReminderSent'] "is equal to"  OR items('Apply_to_each')?['ReminderSent']} "is equal to" null
               //Inside 'Condition'
               'Condition 1'= items('Apply_to_each')?['Reservation_x0020_End_x0020_Date']} "is less than" utcNow()

Heres some inputs for 'Apply to Each':

"ReservationEnd": "2024-04-12",

"ReservationEndTime": "12:30 PM",

"Reservation_x0020_End_x0020_Date": "2024-04-12T16:30:00Z", (The column in my SharePoint list is actually 'Reservation End DateTime', which is calculated from ReservationEnd and ReservationEndTime and currently looks like this in my list: 04/12/2024 12:30 PM, note: its 12:30 PM and not 16:30:00Z like Power Automate thinks)

My problem is this:
The current date/time is 04/11/2024 04:13 PM.
04/11/2024 at 08:00 AM the Condition passes true successfully.
04/11/2024 at 05:00 PM the Condition passes true when it should be false.
04/11/2024 at 02:30 PM the Condition passes true successfully.

[SudeepGhatakNZ]

@Pacadile 

I think you are struggling with Timezone issues.

See the solution I proposed here

Solved: compare dates - Power Platform Community (microsoft.com)

[Pacadile]

Unfortunately I dont know how to apply that to my specific situation 😞

[SudeepGhatakNZ · Accepted solution]

Use this action to convert the dates to the same time zone before comparison

 

[Pacadile]

Im sorry, its still not working... Now its skipping 04/11/2024 08:00 AM and 04/11/2024 02:30 PM even though the current Date/Time is 04/11/2024 06:15 PM. Heres how I set it up:

In the “Convert Time Zone” action, I set the following:

• Base Time: This should be set to the ‘Reservation End DateTime’ from my SharePoint list.

• Source Time Zone:  ‘Pacific Standard Time’.

• Destination Time Zone:  ‘UTC’.

Then the Condition:

outputs('Convert_Time_Zone') is less than utcNow()

Im not sure what Im doing wrong, though for context, I AM an idiot

[Pacadile]

Update on what I have, but its still not working:

I implemented this into Condition: convertFromUtc(utcNow(), 'Pacific Standard Time') is less than convertTimeZone(body('Convert_time_zone'), 'UTC', 'Pacific Standard Time')

But this is what happened:
Current Date/Time= 04/11/2024 08:11 PM
04/11/2024 02:30 PM, Condition returned 'false' when it should have returned 'true'
04/11/2024 08:50 PM,
Condition returned 'false' successfully.
04/11/2024 08:00 AM, Condition returned 'false' when it should have returned 'true'

This is what I got from my debug Compose actions:
Compose 1= convertFromUtc(utcNow(), 'Pacific Standard Time') Output: 2024-04-11T20:10:46.9877816 Compose 2= convertTimeZone(body('Convert_time_zone'), 'UTC', 'Pacific Standard Time') Output: 2024-04-11T13:50:00.0000000

[SudeepGhatakNZ]

Very useful. What is the time zone set in your SharePoint site's regional settings?

[Pacadile]

I believe it is Eastern Standard Time, but I can't check since I'm not admin