How to build an alternative to Meeting Workspaces in SharePoint 2013

By  |   |  10.64K views
Categories: SharePoint, Workflows

Microsoft decided to deprecate Meeting Workspaces in Sharepoint 2013. These handy site templates are still widely used in SharePoint 2010 (SP2010). In this post I’m going to describe an alternative.

According to Microsoft, there are enough alternatives for Meeting Workspaces, they mention Lync meetings, OneNote, SP team sites or the My Site. I have looked at these alternatives, but these require a huge change in the way the end users work.

That’s why I created another alternative by using a standard SharePoint team site, connected web parts and workflows.

Create lists and views

A Meeting Workspace in SP2010 has the following lists: agenda items, decisions, calendar, documents and tasks. We will create these lists.

Let’s start with the calendar list:

  • Create the default calendar;
  • Create a new view called FutureItems;
  • Uncheck recurrence and workspace at Columns;
  • Create the filter Start Time is greater than or equal to [Today];
  • Create another view called PastItems
  • Uncheck recurrence and workspace and Sort by Start Time and choose for descending order;
  • Create the filter ‘Start Time is less than [Today]’.

Then we make the list Agenda items:

  • Add a custom list and call it Agenda items;
  • Go to List settings;
  • Change the name of the Title column in Subject;
  • Create the columns Time (single line of text), Comments (multiple lines of text) and Owner (person or group);
  • Now click on Add from existing site columns and Start Date;
  • Change the name of this column in Meeting Date, set it at required and set defaults to None.

Now make the list Decisions:

  • Add a custom list and call it Decisions;
  • Go to List settings;
  • Create the columns Description (multiple lines of text) and Owner (person or group);
  • Now click on Add from existing site columns and Start Date;
  • Change the name of this column in Meeting Date, set it at required and defaults to None.

The list Documents probably already exists:

  • Go to Library settings and click on Add from existing site columns and Start Date;
  • Change the name of this column in Meeting Date, set it at required and default values to None.

Finally the Tasks list:

  • Add a custom list and call it Tasks;
  • Go to List Settings;
  • Change the name of the Title column in Task name;
  • Create the columns Start date (date and time), Due date (date and time), Assigned to (person or group), Description (multiple lines of text), Status (choice) and Priority (choice);
  • Now click on Add from existing site columns and Start Date;
  • Change the name of this column in Meeting Date, set it at required and set defaults to None.

Creating the dashboards

The first dashboard we create is on the home page. For the dashboard, I choose a page layout with three columns. Add in the first column the Calendar web part. In the second column Agenda items and Decisions web parts. In the last column we place the web part for Documents and Tasks.

Edit the Calendar web part:

  • Change the view in FutureItems;
  • Click on Row with data send to and then Agenda items. As shown in the example below:

  • Select for retrieving Filter values, and then click Configure. As seen in the example below:

  • Choose at Provider name field for start time and consumer field name at for meeting date. As seen in the example below:

  • Click on Finish.

Do the same for decisions, documents and tasks.

Then we make a dashboard with the items from the past. Add the web parts again, set on the connection between the web parts in the same way. The only difference is the view of the calendar web part. Set up the view on PastItems. Link from the first dashboard to the second and vice versa.

Make the workflow

The Calendar list in Sharepoint offers the possibility for recurring items. Then one item will be created and is shown several times in the list or web part. This is a problem in this solution, because connecting the web parts doesn’t work with recurring events. There is only one item and therefore only one start time of the event. Filter out the other dates of the event won’t work.

To solve this problem, we create a workflow which create recurring events for us. In this example I create a workflow in SharePoint Designer that creates the same weekly event at the same time.

Create the variable Counter with as type Number. Then create the following Form parameters:

  • Quantity: Type Number
  • Title: Type Single line of text
  • Start date and time: Type Date and Time. Uncheck Allow blank values and set Display format as Date and time
  • End date and time: type Date and Time. Uncheck Allow blank values and set Display format as Date and time

Copy the workflow as illustrated in the following figure:

This workflow, created using SharePoint Designer, has one disadvantage. When you create multiple items, some of them in the summer time and some of them in winter time, the time of the event after the daylight-saving change is incorrect. For example an event at 1 p.m. in summer time is set in winter time at 12:00. When its summertime and you create multiple items that starts in wintertime there will be no problem.

When you use an on-premises environment with Nintex workflows you can solve this problem. You can use the ‘Calculate date’ action and specify that the time must be stored in ‘local time’ instead of UTC. This option isn’t available in Nintex for SharePoint Online.

(10637)

4.28/5 (12)

Please rate this

How to build an alternative to Meeting Workspaces in SharePoint 2013

| SharePoint, Workflows |
About The Author
- x

34 Comments

  • Adrienne Andrews

    @Amir – You might check to see if the page you are using is a content type “Wiki page”.  To get the functionality you are looking for, make sure it is a “Web Part Page”.

    @Matthew McDermott – Filtering a Task list in SP 2013 has a bug so the filtering given in the instructions here won’t work unless you create a custom list.  Yay Microsoft!  🙂

  • Tami

    Hi, I made a dashboard on my page by adding two columns. In the first column I put Future Items Calendar, Agenda Items, Decisions, Documents and Tasks. For the second dashboard I put in the second column Past Items Calendar, Agenda Items, Decisions, Documents and Tasks. I connected the calendar in both to their respective web parts per the instructions. I hope that it was ok to make the dashboard this way. The directions said to link the two dashboards. I have no idea how to do this. I am fairly new to SharePoint using Office 365. Would someone be able to tell me how to link the two dashboards? Or if I even did the dashboard right? Thank you for your help. I have attached a screenshot of what I have done.

    • David Crighton

      I like your idea of having the future and past dashboards on the same page. Since the author created two different pages, I believe they were just suggesting that we create a link on one page to the other page. you obviously can skip that step since you have both on the same page.

  • Carl Frank

    Frank,  Great piece, but question for you…  The workflow you have in here is designed in SPD as a 2013 workflow.  Could you (or anyone else who has been working with this solution on this thread) give me some direction in creating the loop using SharePoint 2010 workflow?  The client I am trying to implement this with is not running 2013 Workflow manager. They may be going to Nintex at some point in the future and don’t want to go through the exercise of standing up WFM.  Thanks!

       

  • Evans Conforti

    @Frank or anyone
    Can you explain the Workflow in more detail?
    Specifically the variables, parameters and the “Create item in calendar” section. Trying to understand this section; I got you need to create:
    Variable:
    Counter = Type: Number
    Then you need to create:
    Parameters:
    Quantity = Type: Number, Default Value: 0 (?)
    Title = Type: Single line of Text, Default Value: BLANK (?)
    Start date and time = Type: Date and Time, Default Value: Today’s Date (?), Allow blank values: Unchecked, Display format: Date and Time
    End date and time = Type: Date and Time, Default Value: Today’s Date (?), Allow blank values: Unchecked, Display format: Date and Time
    The following variables get created automatically:
    create = Type: Guid
    calc = Type: Number
    Now with the “Create item in calendar” section:
    List = Calendar (?)
    Title = Field: Title (?), To this value: Calendar:Title (?)
    Start Time = Field: Start Time (?), To this value: Calendar:Start Time (?)
    End Time = Field: End Time (?), To this value: Calendar:End Time (?)
    Do we need to add other fields?

    • Null Data

      Now with the “Create item in calendar” section:
      List = Calendar – use the Form Parameter Values you created in the previous step….
      Title = Field: Title | Parameter: Title
      Start Time = Field: Start Time | Parameter: Start date and time
      End Time = Field: End Time | Parameter: End date and time
      Do we need to add other fields? | I don’t think so.

  • Ahmad

    Hi Frank, is it possible to sync meetings and tasks with outlook to appear in outlook calendar and task list?
    and sync outlook meetings and tasks to the system?

  • Vijay SIngh

    We are looking to migrate all our SP 2010 Meeting sites to O365. This OOTB seems like a good option.Anyone has tried Meegaan Meeting workspace app for Office 365 .Appreciate any feedback from anyone who is using this app.