You will find in this "How-To", all step to create an ICS element for Outlook.
Some actions see in this document: Build string, Regular expression, Web request, Calculate date, Query list, Collection operation and Send notification.
Of course, you can add all action you want in your workflow and next workflow.
Solved! Go to Solution.
We have run into an issue where the calendar event is submitted without a time zone from a custom list instead of a calendar list. This causes the appointment to be saved to the users Outlook Calendar with the UTC time zone, instead of the local time zone for the user, or the regional time zone for the site collection. Is this due to being a Custom List instead of a Calendar List?
The workflow is based on the date/time you set when you add a new element. None compute action are made to transform the date/time to the value you want (UTC, local or otherwise).
I don't think so the custom list generates an issue.
François THOMAS This is great! Thank you so much for the detailed write up.
Jacob Bradley - My times weren't saving to Outlook correctly either. I did some log to workflow history actions and it showed this:
Everything was being captured correctly and sent to outlook with the correct times, but the appointment in Outlook was off by 5 hours. (I am in Central Time, so that should have been -6 hours, but I think it may have been ignoring daylight savings, too.)
I was able to resolve this by removing the "z" from the format date functions in the build string actions, so it looks like this:
Hope that helps!
Excellent job documenting this...a couple enhancements to accommodate for the time zone issues...
This is really useful. However, this creates an appointment where a user can't "accept" or "Reject" a meeting invite. Is there a way to create an .ics file that has meeting invite format?
Seems like; it will be the same workflow but at very end of the Build String, to use the following:
Although, this does not cancle it but asks you to remove it yourself.
There is no cancellation option...
I thought the above did work but must have mistaken myself ...
Unfortunately, the above does not delete the event from the calendar UNLESS you remove it directly from the calendar manually!
if somebody wants to format the body section as HTML, maybe it is worth looking at this