Time Off Flow error message, unsure of how to correct and get item to update on SP Calendar

[mab17]

I've created the following flow for employees requesting time off:

When an item is created in SharePoint, start an approval, then, once approved, send email to employee and add item to our SharePoint calendar. 

Most times, this flow is working without any problems, however occasionally, the flow portion of adding item to the calendar is not working.  In these cases, the flow shows that it was successful.  What would be causing this final step to not work and how can I adjust the start date/time format to read in 12 hour standard time format, not 24 hour military time format? 

[v-xida-msft · Accepted solution]

Hi @mab17,

Could you please share a screenshot of your flow's configuration?

Do you want to change the start date/time of the your SharePoint calendar event into 12 hour standard time format?

Further, could you please show a bit more about your SharePoint list?

I have made a test on my side and don't have the issue that you mentioned. My flow's configuration as below:

The flow works successfully as below:

In addition, if you want to display the start date/time of your SharePoint Calendar event in 12 hour standard time format, I think it is not necessary to add extra action to adjust the format of the start date/time, the start date/time (or end date/time) of SharePoint Calendar event displays in 12 hour standard time format by default:

If you just want to change a date/time into 12 hour standard time format, please take a try with the following formula:

formatDateTime(yourtimestamp,'G')

I have made a test on my side, please take a try with the following workaround:

The flow works successfully as below:

More details about Date function, please check the following article:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language#functions

More details about standard date and time format strings, please check the following article:

https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings#th...

Best regards,

Kris 

[mab17]

Thank you for your reply.  I did look over my flow and realized instead of the action "Create item" in the calendar once vacation/time-off was approved, I had set up "Update Item".  After correcting this issue, I was able to get flow to work properly. 

I Still curious about the time format:

Once time-off request has been approved, the employee receives this email:

"Your Time Off request has been approved for Other starting on 2018-05-13T12:00:00Z and ending on 2018-05-13T22:00:00Z."

Based on the test time off request I inserted, I asked off from 7am - 5pm CST but the format of date and time above seems to pull from some other time zone.

I've verified that our settings on SharePoint 2016 are set to CST.   How do I get the format of date/time to appear correctly in the response email?

Thanks,

Margaret