Hi there
I have a due date column the user fills in when an approval workflow is initiated, say 10 Dec.
I'd like to send a reminder email on the due date (10 Dec) but it's to send at 9 am.
But I'm also on Aust Eastern Standard Time. From my calculation if I put work on UTC at 10 pm it should be AEST 8 am or 9 am (depending on daylight savings). I'm not fussed if it is 8 or 9 am.
See pics to see what I've come up with from my searching to make the time 9 am.
So, just to check I put the End Time in a SharePoint column it comes up as 11 Dec at 10 am. In the running flow it is 10 Dec at 22 pm. I have no idea which time it is going to send it and neither are the correct times.
Any help would be appreciated.
Solved! Go to Solution.
Hello @xxxxmints ,
I'd try different approach to build the dates. Instead of concat() and building the the date I'd use 2 expressions: startOfDay() to get the Due date at 00:00:00 UTC and addHours() to adjust the hours to your time zone + the wish time.
addHours(startOfDay([DueDate]),-1)
That should take Dec 10, 00:00 UTC -1 hour = Dec 9, 11PM UTC +10 hours (UTC to AEST) = Dec 10, 9 AM
Hello @xxxxmints ,
I'd try different approach to build the dates. Instead of concat() and building the the date I'd use 2 expressions: startOfDay() to get the Due date at 00:00:00 UTC and addHours() to adjust the hours to your time zone + the wish time.
addHours(startOfDay([DueDate]),-1)
That should take Dec 10, 00:00 UTC -1 hour = Dec 9, 11PM UTC +10 hours (UTC to AEST) = Dec 10, 9 AM
Ok, thanks. Sounds great! I'll give that a test and will get back to you.
OMG it worked! Thank you.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
User | Count |
---|---|
23 | |
23 | |
23 | |
23 | |
17 |
User | Count |
---|---|
56 | |
39 | |
38 | |
29 | |
26 |