Power Platform Community Forum Thread Details

Re-posting in the correct forum -

I am trying to create a flow to send out an automated email (v2) only during specific time of the day in Eastern Time Zone. I have used following steps:

1. Convert received email time to Eastern time zone using "Convert time zone"

2. Use "Condition" action to compare converted time against

However it gives inaccurate results. The condition always results "false" regardless of converted time

value. I think once or twice I got an accurate result, not sure of that was a " even a broken cloak is correct twice a day" situation. I have looked through forums for this issue. I have found following.

1. Use yyyy/mm/dd format for date but no info for time. https://powerusers.microsoft.com/t5/Building-Flows/Date-Comparison-Issues/td-p/679511

2. Use "timeValue" function but I can't find TimeValue function in expression - https://powerusers.microsoft.com/t5/Building-Power-Apps/Compare-two-time/td-p/824035

3. Use ticks function, I have not tried this yet as I am trying to compare converted time against static range of time. If I understand the concept correctly, ticks converts all the times from a reference of "x" (specific time in past). So it may not work for static range of time as is. https://stackoverflow.com/questions/53033536/comparing-ticks-time-in-powershell

I would appreciate any insight for this issue.

Thank you for reading my post.

Nina.

Categories:

General topics