You’re offline. This is a read only version of the page.
22
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.
Hi Nina,
Now there is a new function dateDifference() that you can try. It returns a timespan between two dates/times.
Share
Report
All responses (
Answers (
