I'm trying to take a time listed in a row in Google Sheets and use it as a source for a Delay until action in Flow. Flow originally gave me a format error (it wants everything in YYYY-MM-DDTHH:MM:SSZ format) which I've tried to provide, but it didn't like until I took the input and made it a variable that pulls in as a string (see below). But then it's in the wrong time zone. So I'm trying to convert to UTC, but it's not liking that either.
Basically, I just need to know how to input a time, from my time zone (EST), into a Delay until, from a Google Sheet cell.
Here is the Flow with the expression for converting to UTC in the Delay until step.
Here is the error I'm receiving, which is complaining that I didn't provide the source time zone, even though I did (700, US Eastern).
Solved! Go to Solution.
I took this approach to get the correct date/time format for the Delay Until action:
concat(body('Convert_time_zone'),'Z')
Below you can see the whole Flow with the outputs. Please let me know if you have any questions.
Regards,
Fausto Capellan, Jr
I took this approach to get the correct date/time format for the Delay Until action:
concat(body('Convert_time_zone'),'Z')
Below you can see the whole Flow with the outputs. Please let me know if you have any questions.
Regards,
Fausto Capellan, Jr
That worked perfectly, thanks @faustocapellanj! One minor detail I'm trying to sort out. Time zones are the bain of my existence in Office 365. I'm unable to get the time zone in GSheets to align with Flow. It will only post at the 'correct' time if I schedule the time for five hours ahead (I'm EST, that would make it UTC). I've tried doing both "convert from EST to UTC" and "convert from UTC to EST", but neither work (the former gives me an immediate result, since the time in UTC has already occurred and the latter throws an error). Any ideas how to make it so the input time in GSheets is actually the time the action is delayed until in my time zone?
User | Count |
---|---|
78 | |
54 | |
52 | |
42 | |
42 |
User | Count |
---|---|
81 | |
79 | |
75 | |
67 | |
43 |