format outlook calendar end time in Standard Time vs. Military and only grab the time not the date

[mackw009]

I am trying to build a Flow that creates a SharePoint list item when an event with a specific keyword is added to an Office 365 calendar.  I am able to successfully get this to run, however I'm trying to capture the start and end times in my SharePoint list (which is connected to a PowerApp) and need the end time to be formatted in Standard time vs Military time.  I also need to strip away the date and only grab the time.

[v-yuazh-msft · Accepted solution]

Hi @ mackw009,

I have made a test on my side, and have created a sharepoint list with two "Single line of text" type columns to save the Start time and End time of the event as screenshot below:

You could refer to screenhsot below to create the flow:

The expression in the Start time column of Create item action as below:

substring(formatDateTime(triggerBody()?['Start'],'o'),11,5)

The expression in the End time column of Create item action as below:

substring(formatDateTime(triggerBody()?['End'],'o'),11,5)

The flow would run successfully to get the start time and end time with your requirement:

The item would be created in the list as below:

Regards,
Alice Zhang