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.
Solved! Go to 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
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
User | Count |
---|---|
68 | |
50 | |
47 | |
27 | |
18 |
User | Count |
---|---|
26 | |
26 | |
22 | |
20 | |
19 |