Time Zone Formatting between Forms and Flow

[sreedwilson]

I have built a Form which captures a time for an event to start.  It is being input as a choice.

Flow then creates an event on the submitter's calendar and another person's calendar.

The time is always being recognized by Flow as AM.  I have tried 24 hour time, PM with spaces between the last digit and the P, and no spaces.  What am I missing?  I have the time zone correct.

Here is my expression: 

formatDateTime(body('Get_response_details')?['ref9d7b91bb8b21a5a729da14523a77bb'],'yyyy-MM-ddThh:mm:ss')

Here is my Flow: 

Here is my Form:

Thanks for your input in advance!  

[v-yuazh-msft · Accepted solution]

Hi @sreedwilson，

Please learn that the 12-hour time, you should keep all the time in the (0：00：00～11：59：59）,you shouldn't have a time formated as (11/23/2018 18:30 PM), and the time should be (11/23/2018 6:30 PM),

And please refer to the standard, I have created a Form with question as below:

You could refer to screenshot below to create the flow:

The expression in the Condition as below:

@equals(substring(outputs('Compose'), sub(length(outputs('Compose')), 2), 2), 'PM')

The expression in the Compose 2 as below:

first(split(addHours(formatDateTime(body('Get_response_details')?['rf89fb88ae1e04c87ace743cc695ef694'],'yyyy-MM-ddThh:mm:ss'),12),'.'))

The expression in the Compose 3 as below:

formatDateTime(body('Get_response_details')?['rf89fb88ae1e04c87ace743cc695ef694'],'yyyy-MM-ddThh:mm:ss')

And when a response is submited, if the time is with PM, the flow would run successfully as below:

 

Best regards,

Alice

[sreedwilson]

Thanks for pointing me in the right direction!