Integration Hub Sending Wrong Date/Time to Exchange Online

Scott Megargee
Tera Expert

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.

1 ACCEPTED SOLUTION

Scott Megargee
Tera Expert

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());

 

View solution in original post

1 REPLY 1

Scott Megargee
Tera Expert

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());