- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-24-2023 12:55 PM
We have an integration with Exchange Online that provides a catalog item allowing customers to set the OOO message on behalf of other users. This is working as expected except for the time the OOO message is supposed to start/end. Our instance time zone is US-Eastern and I believe I need to transform the date/time field to GMT -6.
I am using a date and time transform function to subtract 6 hours from the provided start date/time and end date/time but integration hub in still sending the wrong times to exchange.
Specifically, when I attempted to set OOO today to start at 11:30 am it set the start date in outlook at 5:30 pm. In spite of the transform, I added.
Any thoughts on how to accomplish this? Should I transform the start and end date times in PowerShell instead of flow designer?
Apologies but I am not able to add a screen shot of the flow.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-15-2023 07:24 AM
For this I ended up creating flow variables in for startDate and endDate then I added the below script when setting the variable:
var gdt = new GlideDateTime(fd_data._1__get_catalog_variables.start_date);
return("" + gdt.getLocalDate() + " " + gdt.getUserFormattedLocalTime());
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-15-2023 07:24 AM
For this I ended up creating flow variables in for startDate and endDate then I added the below script when setting the variable:
var gdt = new GlideDateTime(fd_data._1__get_catalog_variables.start_date);
return("" + gdt.getLocalDate() + " " + gdt.getUserFormattedLocalTime());