Question

Using Forms & Workflow to feed into a shared calendar

Workflow How To Ideas Forms

Updated October 20, 2021

asked on February 21, 2020

I am wondering if anyone has any ideas for having Workflow feed into a shared calendar. I want to create a shared Time Off Schedule for my office. The way I want it to work is that each employee will submit a time off request using Forms. After it's approved Workflow would update the shared calendar. I cannot use the SharePoint integration to my knowledge because we use SharePoint Online. Another solution would be to have Workflow feed into an Access Database and then have Access keep a calendar updated, but what calendar will do this? I'm running Access 2003. Any feedback would be much appreciated.

0 0

Answer

SELECTED ANSWER

replied on February 21, 2020

You'll probably have to use a Script activity in Workflow to access the Office 365 API and insert the calendar item. SharePoint calendars are actually just lists with calendar metadata under the covers. So, you can use the SharePoint API's to enumerate and add items.

If you're using a group calendar, there are REST API's for those. Or, the Create Exchange Item activity in Workflow might work in your environment.

Since deeper integration with Office 365 was just announced, I imagine that it'll get easier as these new features roll out.

1 0

replied on February 24, 2020

Thank you Devin. This is very helpful!

0 0

Replies

replied on October 20, 2021

I am interested if you were successful creating an API connection to a shared/teams calendar in SharePoint or Exchange Online, and if yes - do you mind sharing some details? Trying to accomplish a similar task to add approved time off requests to departmental calendars. How easy is that? Sharing your experience (code) would be much appreciated!

0 0

You are not allowed to follow up in this post.

Question

Question

Using Forms & Workflow to feed into a shared calendar

Answer

Replies

Sign in to reply to this post.