cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate IV
Advocate IV

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

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.2018-04-20_15-50-37.png2018-04-20_15-51-38.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

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:

Capture.PNG

 

 

You could refer to screenhsot below to create the flow:

Capture.PNG

 

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:

Capture.PNG

 

The item would be created in the list as below:

Capture.PNG

 

 

 

Regards,
Alice Zhang

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

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

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:

Capture.PNG

 

 

You could refer to screenhsot below to create the flow:

Capture.PNG

 

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:

Capture.PNG

 

The item would be created in the list as below:

Capture.PNG

 

 

 

Regards,
Alice Zhang

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,197)