• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Technology
    • Development
    • Hardware
    • Intune
    • Microsoft
    • Office
    • Office 365
    • Security
    • SharePoint
    • Software
    • SQL server
  • Personal development
    • Blog
    • Career
    • Freelancer
    • Knowledge
    • NEWS
    • Private
    • Thoughts
  • Consulting services
  • Contact me

Not only IT

About life, IT and other things...

Home » Technology » Office 365 » SharePoint calendar notification

SharePoint calendar notification

November 30, 2014 By Tomasz Szulczewski Leave a Comment

SharePoint calendar notification

If you work with any SharePoint version (on premise or online) you can be surprised, that there’s no SharePoint calendar notification option. I mean you can’t get message that event in SharePoint calendar is coming. A few days ago I was surprised when client asked me to do something like this, as they don’t synchronization with Outlook client, which one button operation in case of SharePoint. Of course you can achieve it in very simple way, so let me show how it works.

[adblockingdetector id=”5770e6ed85560″]

Let assume that we need two notification. One which should be fired twenty four hours before the event, and another one which will be fired one hour before the event. First we need create two columns where will store data and hour of notification time. So let create one column called “1HourBeforeEvent”. This column should be calculated type, and the value should base on [End Time] value of our event, which keeps tine when the event will end. So formula should looks like this: [End Time]-(1/24/60*60) – one hour before the end. And also we need another column “24HoursBeforeEvent” where we will keep time 24 hours before the event. Formula in this case is =[End Time]-1 .

Now we need just create simple workflow. Below you will find print screen of the my workflow.

WorkFlow For Event Notification
WorkFlow For Event Notification

This workflow is very simple. In the first step it will send message that new event has been created. Then we have to check if the end of event time is less than 24 hours. In such case we don’t use notification for 24 hours before, but only one hour before. In other case we will pause the workflow until time which is stored in our column “24HoursBeforeEvent”. And then we will send a message to the users. And then we will make the same for one hour before the event. We pause the workflow until it reach value which is stored in “1HourBeforeEvent, and then it will send final notification message. Fast and simple to create SharePoint calendar notification.  Isn’t it? This solution works for SharePoint on premise and SharePoint online also.

Related

Filed Under: Office 365, SharePoint Tagged With: Office 365, SharePoint

About Tomasz Szulczewski

I've got more than 20 years of IT experience. IT is my passion and I am still increasing my skills. I work as a SharePoint, Office 365 and Azure architect.

Reader Interactions

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Join the Newsletter

Social media

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Search this site

Sign up for Wise accounts

Signup and earn $25

payoneer
payoneer

My latest achievement

Microsoft 365 Certified: Enterprise Administrator Expert
Microsoft 365 Certified: Enterprise Administrator Expert

Tags

Azure Azure Active Directory BizSpark Blog career Certification cloud conference edge freelance Freelancer Hardware home office InfoPath Intune Knowledge licensing Microsoft Microsoft 365 News Office Office 365 Personal development Power virtual agent Private security SharePoint SharePoint designer SharePoint online Software SQL server upwork Windows Windows 365 yammer

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2022 Tomasz Szulczewski