Sync An Outlook Calendar With SharePoint List

Подписаться 15 тыс.

Просмотров 6 тыс.

50% 1

This SharePoint List tutorial will demonstrate how to sync outlook calendar with sharepoint list. It provides step-by-step instructions on how to add outlook events to sharepoint calendar and connect sharepoint list to outlook calendar, ensuring that all your important dates and meetings are in sync. For those wondering “can you add sharepoint calendar to outlook?” or “how do i sync my outlook calendar to my sharepoint list?”, this tutorial is the perfect resource. It not only answers these questions but also demonstrates how to sync outlook calendar with sharepoint online. The tutorial delves into microsoft lists outlook integration and shows how to link sharepoint list to outlook calendar. It also explores the capabilities of power automate sharepoint list to outlook calendar and power automate sync sharepoint calendar with outlook office 365, providing users with automation options to maintain their calendars. Users will be able to create an always updated sharepoint list outlook calendar viewable within SharePoint and will also discover the ease with which they can view sharepoint list in outlook calendar. The guide also covers sync outlook events to sharepoint calendar and how to sync sharepoint calendar with outlook 365 for a cohesive scheduling experience. By the end of this tutorial, users will be able to add sharepoint list to outlook calendar and sync sharepoint list with outlook calendar, making the management of events and tasks more efficient and integrated. Lastly, this video will answer the following questions: Can I Connect a SharePoint list to Outlook Calendar?, Can I link a SharePoint list to Calendar?, How to copy Outlook calendar appointments to SharePoint calendar?, and How do I link a SharePoint list to my Outlook calendar?
FREE PDF - TOP FIVE MICROSOFT OUTLOOK PRODUCTIVITY TIPS: academy.luigiiacobellis.com/f...
FREE - DOWNLOAD A COPY OF THE POWER AUTOMATE FLOW CREATED IN THIS TUTORIAL FOR FREE HERE: bit.ly/3ydbM3J
🔔JOIN THE SHAREPOINT LIST FUNDAMENTALS PRE-LAUNCH ENROLLMENT - LIMITED SPOTS AVAILABLE🔔: bit.ly/3yIiE9D
GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE: bit.ly/3Q921sH
Timeline
0:00 - Start
0:35 - Create the SharePoint list calendar
3:29 - Add the calendar view to the SharePoint list
5:11 - Create the Power Automate workflow to sync outlook calendar with SharePoint list
6:21 - How to find Microsoft Outlook calendar ID
7:41 - Initialize Power Automate TerminateLookUp variable
8:21 - Add a switch control to the Power Automate workflow
10:23 - Add case block one when a new Outlook event is scheduled
12:48 - Test case block one when a new Outlook event is scheduled
13:41 - Add case block two when an existing Outlook event is updated
18:42 - Test case block two when an existing Outlook event is updated
20:10 - Add case block three when an existing Outlook event is deleted
21:05 - Test case block three when an existing Outlook event is deleted
#microsoft365 #sharepoint #powerautomate
MORE ABOUT ME
Become a Channel Member & Get Access To Awesome Perks:
bit.ly/3wEuXQq
LETS BE FRIENDSI
🔔Instagram: / luigiiacobellis
🔔LinkedIn: / liacobe
🔔Twitter: / luigiiacobellis
🔔TikTok: / luigiiacobellis
🔔Reddit: / owndirector1326
🔔Website: luigiiacobellis.com/
🔔Linktree: linktr.ee/Liacobellis
GOT A VIDEO IDEA? FILL OUT THIS FORM:
bit.ly/3yjEewm
SOFTWARE THAT I USE TO CREATE MY RU-vid VIDEOS & CONTENT:
⭐ Screen Recording & Editing - Camtasia: bit.ly/3NmF9mf
⭐ Screenshots & Photo Editing - SnagIt: bit.ly/3NmF9mf
⭐ RU-vid Thumbnails - Canva Pro: bit.ly/3nj1Rkx
⭐ Content Tracking - AirTable: bit.ly/3dYsV3H
⭐ Mailing List Forms - ConvertKit: bit.ly/3xVD5ff
Note that I may earn a small commission at no additional cost to you from purchases made using these links.

Наука

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 45

@LuiIacobellis 3 месяца назад

FREE PDF - TOP FIVE MICROSOFT OUTLOOK PRODUCTIVITY TIPS: academy.luigiiacobellis.com/five-microsoft-outlook-productivity-tips-and-tricks-1 FREE - DOWNLOAD A COPY OF THE POWER AUTOMATE FLOW CREATED IN THIS TUTORIAL FOR FREE HERE: bit.ly/3ydbM3J 🔔JOIN THE SHAREPOINT LIST FUNDAMENTALS PRE-LAUNCH ENROLLMENT - LIMITED SPOTS AVAILABLE🔔: bit.ly/3yIiE9D

@KiwiBA712 2 месяца назад

The import fails: You'll need to resolve these conflicts before importing the package Resource Sync SharePoint Online Calendar with Outlook Calendar Import setup Create as new Error Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'Unauthorized'. This may indicate invalid input parameters. Error response: { "error_description": "Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown." }'.

@KiwiBA712 2 месяца назад

So it seems to fail because the sharepoint site and list is from your tenant and one has to redo these connections, but first need to save as new. Therefore one will never get to a success screen as shown in your import document. When doing the mapping the screens seem to be slightly different to what is on your video...also getting the following the errors:

@KiwiBA712 2 месяца назад

Once I had completed all the reconnections I was able to test it. Couple issues on this flow: It doubles up the create event. I get two entries. The update doesn't not remove the event. Under the Update Event it says "ActionBranchingConditionNotSatisfied. The execution of template action 'Update_item' skipped: the branching condition for this action is not satisfied." Delete has the same issue "ActionBranchingConditionNotSatisfied. The execution of template action 'Delete_item' skipped: the branching condition for this action is not satisfied." Setting up the flow myself using the video produces the same issue as the update and delete above. Any ideas why?

@jordanking6315 2 месяца назад

Lui - thanks for this video. It was an amazing tutorial and it helped me set things up. I needed something just like this, but I added a condition to only pull in events with certain key words in subjects for a team SharePoint site.

@LuiIacobellis 2 месяца назад

Glad you found it helpful!

@user-qj2ei4fh8t 18 дней назад

Hi Lui, that was awesome and was really helpful for me. On top of it I tried making the update flow more simpler for me. In the updated case, I had my first action as "get items" and under that, I used a filter query where I compared my event identifier with the event identifier that I am getting from outlook action, and when the condition matches, I got the correct item from the SharePoint list and post that update item was my last action and and that’s how I made it more simpler. let me know if you see any gaps in this.

@bintangshavira4074 2 месяца назад

THIS TUTORIAL HELPSSSS ME SOOO MUCH. thank you sir!!

@LuiIacobellis 2 месяца назад

Glad it helped!

@imran002ali 20 дней назад

Hello Lui, great information, appreciate your knowledge sharing, very helpful! 👍

@DanCarp 2 месяца назад

Great tutorial - thanks for sharing. Do I remember from trying previously that this workflow doesn't work with recurring events?

@LuiIacobellis 25 дней назад

Yes, unfortunately it will not capture all events in a recurring event series.

@TheSquire12345 2 месяца назад

Very nice tutorial. Thank you so much.

@LuiIacobellis 2 месяца назад

Glad it was helpful!

@TheSquire12345 2 месяца назад

I was able to improve it by using OData filtering in the Get Items EventIdentifier eq '@{triggerOutputs()?['body/id']}'

@LuiIacobellis 2 месяца назад

That is an excellent idea! I will consider creating a short update to the video to demonstrate this approach which would result in a more efficient flow. If I do this are you okay for you me to give you a shout-out in the video and share a snippet of your comment ?

@TheSquire12345 2 месяца назад

@@LuiIacobellis Yup, go ahead.

@cbowman92 5 дней назад

Fairly confident I followed this verbatim. When I create a new item on the calendar - it creates two in my SP list. If i edit it, it updates one and leaves the other alone. Thoughts?

@philbarker2072 Месяц назад

Thanks for a great tutorial. I'm trying to delete a recurring event, but I keep getting false in my second expression result when the item is going to be deleted. Is there a step/s that needs to be taken that I'm missing?

@amandawahlig6597 Месяц назад

Thank you so much! This is super helpful. But I'm having a weird situation where the flow is running (successfully) twice every time it's triggered? And so items are appearing twice in the list. Any suggestions? Next up is categories and recurring events.

@LuiIacobellis 25 дней назад

You're very welcome. I've had a few people report the duplicate issue but I've not encountered it myself. I have the flow package that I created available for download, I'd suggest trying that.

@MarkVickers-b9n 12 дней назад

Hi mate! Great video, I got it setup and works quite well. Of someone edits the calendar from Sharepoint, with current logic, it wont write back to the Outlook calendar. Did you find a solution to this? Is there a way to make the calendar read only from the sharepoint side? Thanks again

@NeilFalzon 11 дней назад

Since the SharePoint is receiving events from the outlook calendar it will not update it, that's how it is set in the Power Automate. You will probably need to set the trigger to update items FROM SharePoint TO Outlook Calendar. As for the read only, you should have site permissions for the SharePoint list/Calendar.

@amritsidhu3918 2 месяца назад

Awesome tutorial Luigi Iacobellis. Is it possible to extract only Out of Office events from Calendar into SharePoint lists?

@LuiIacobellis 2 месяца назад

Unfortunately out of office events are not a type. You'd need to build in additional logic to identify when an event is considered out of office

@korvipinguil7941 Месяц назад

Hello! Thanks for this amazing video. Sadly my calendar list has one flaw when using this power automate flow. In fact, whenever an outlook event is added, the event is appers in the assigned SharePoint Site 2 hours earlier. Is there a solution to this? Or how can the flow add 2 hours more to the outlook event, so that this appers on SharePoint at the same time. Thank you in advance :)

@LuiIacobellis 25 дней назад

This is likely due to the time zone settings on your SharePoint site. You can configure the time zone from the site settings. Alternatively, you'd have to incorporate some logic in the flow to transform the date-time to the intended format.

@TimothyDouglas-fz7lw Месяц назад

Thanks Lui, I was SEARRRRRRCHING for this! Is there a way to take the assigned category and apply it as a choice in the SharePoint list? Also, how does it handle recurring events?

@LuiIacobellis 25 дней назад

Based on my testing, this will not work for recurring events. As for the category, that is not coming from the Outlook event itself, that is coming your account in Outlook. I've personally not tried to solution for this myself.

@bintangshavira4074 2 месяца назад

hi sir, i was wondering how to get outlook group calendar ID and add all of the event to sharepoint list?

@LuiIacobellis 25 дней назад

Hi there, I cover how you can get the Outlook calendar ID in the video.

@bintangshavira4074 2 месяца назад

i have a question, how to sycn event that's already exists outlook to sharepoint list sir?

@LuiIacobellis 2 месяца назад

This flow doesn't cover existing Outlook events. You'd have to cancel and reschedule for it to be caught by this flow

@KiwiBA712 2 месяца назад

Tried setting this up. The created works perfectly. THe Update and delete does not. Keeps saying conditions not met.

@LuiIacobellis 2 месяца назад

Sorry to hear you're having trouble with the flow. Unfortunately I can't provide troubleshooting support with individual users flows.

@rayt61 3 месяца назад

@LuiIacobellis 3 месяца назад

You're very welcome Tim!

@kategelletly1921 Месяц назад

This is great but I already have an issue testing the add event. My list is populating with 4 entries. Why would that be?

@GreenbackerTechnology Месяц назад

are they across multiple days? perhaps your power automate is still using the default utc time, while sharepoint is using your local regional time?

@kategelletly1921 27 дней назад

@@GreenbackerTechnology No, it's just capturing an 30 minute session for example. Not across multiple days.

@LuiIacobellis 25 дней назад

I've had a few people report the duplicate issue but I've not encountered it myself. I have the flow package that I created available for download, I'd suggest trying that. You can download it from the pinned comment on the video!

@kategelletly1921 25 дней назад

@@LuiIacobellis What about doing this with a Group calendar? Tried pasting the calendar ID but did not work. And thank you for the response!

@bintangshavira4074 27 дней назад

hi sir, i followed your tutorial from start to finish, but when I tested mine, all cases arent working. the error is "The execution of template action 'Create_item' skipped: the branching condition for this action is not satisfied." and "The execution of template action 'Update_item' skipped: the branching condition for this action is not satisfied.". how do I fix this...

@LuiIacobellis 25 дней назад

Hi there, unfortunately I have not experienced this issue. As a suggestion, you can download the sample flow package I created in my tutorial from the video comments. You can try this