My ask:

Is there any existing solution, or maybe a clever way of using Microsoft Office 365 to announce your intention to attend at a certain date?

Components / requirements:

  • Calendar, covering future dates (at least 2 weeks forward)
  • Announcement:
    • Identifiable - person name
    • Date (or optionally time frame)
    • Comment - Allowing a place to indicate specific location (meeting room?)
    • Visible to everyone (within the group/company)
  • Searchable by:
    • Date - listing people who are planning on attending
    • Name - list the dates a person is planning on attending

The task of doing this is repetitive, similar to shift planning, but non-binding like that.

Intended use case

Like for many others (I assume), COVID-19 pandemic at first shut down our offices, and everyone were forced to work remotely.

Since then, most of our office locations around the world have opened, but attendance is optional, and in some locations open-space spots are mandated to wear masks.

The mixture of knowing it's going to be uncomfortable for most + physical presence isn't mandatory, wanting to come in is usually tied to knowing colleagues of interest are planning on coming in as well.

A way to invite people to publicly announce: "I'm planning on being in the office on Wed" (in a non binding way) could help increase presence in the office for some, and make visiting the office much more fun/palatable.

Already existing software / groupware

We already use Microsoft Office 365, with Teams and SharePoint. We also have Zoom.

Finding a solution utilizing these platforms (while still making it easy to use) will be a huge plus, especially with persuading others to use it.

  • Sorry folks for the bounty message, it was supposed to be for a different bounty.
    – Lockszmith
    Dec 6 '21 at 15:23

Here's what I would do:

  1. Create a Microsoft List called Upcoming Attendance. Fields would be user (linked to AD), date, office location (dropdown), and comments.
  2. Somewhere in Teams and/or Sharepoint add a link to the form to add items to that List. Or you can create a Microsoft Form that posts to that list, it's just more complicated.
  3. Create an Automation flow that posts to a Teams channel when items are added to Upcoming Attendance. Something friendly like "Join [user] in the [location] office on [date]! [comments]". If you have a Teams team/channel per office location you could send the posts to just those channels.

The nice thing about Lists is you can add tabs to Teams and Sharepoint that everyone can see and easily search.

Another option might be able to create a Form and connect it with an Automation flow to post to a shared calendar. I've never had any luck automating anything with calendars, but there might be a way.

This is a really great question. In fact I might borrow this idea for my own office!

  • 1
    Thanks! I'm going to try this - Please post updates or a blog post/gist page with details about the steps and you success. I'll update here with feedback as well. Thanks for thinking about this.
    – Lockszmith
    Dec 3 '21 at 17:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.