How to add a Version column to modern SharePoint list and library views

Versioning is enabled by default on all modern lists and libraries in Microsoft 365 and saves the last 500 major versions of an item/document . However, you won’t see a column displaying an item’s/document’s version number automatically in list/library views unless you explicitly add it.

Normally in modern lists and libraries you could show/hide columns that already exist by selecting the column header titled “+ Add column” then “Show/hide columns” as seen in the screenshot below.

However, when we do this, Version isn’t an option.

Solution #1: Edit the current view

We visit some classic SharePoint settings to find this column. Simply follow the steps below to add the “Version” column to your list or library view.

1. Go to the list or library and make sure it’s on the view to which you’re adding a column for Version

2. Select the view name (All Items or All Documents is default) then Edit current view

3. Scroll down to the bottom of the list of column names and select the checkbox next to Version.

4. Click OK at the top or bottom of the screen to save.

Note: If you want to rearrange the order of columns as well (perhaps placing Version between other columns) then be sure to change its corresponding number next to its row in the view settings as well.

Solution #2: Edit the view through List/Library settings

Rather than using Edit current view from the view itself, you can also get to the same view settings by going to Settings > List Settings or Settings > Library Settings.

Scroll down to the Views section and select the name of the view for which you’re adding the Version column then proceed with steps 3 and 4 from Solution #1.

And through either method, now we have a column for Version added to our view.

How to get a Microsoft Teams meeting attendance report

Microsoft Teams has three types of virtual meetings:

  • Meetings
  • Webinars
  • Live Events

Live events already had a nice attendance report (which I assume will be available for webinars as well), but traditional/regular meetings had yet to see a similar feature until now. You could always export attendance during the meeting, but it was a snapshot at that moment and you didn’t capture those who had left early or joined late depending on when you exported it. It also didn’t capture join/leave times.

Now meetings have attendance reports that you can get AFTER the meeting as well. Note that you must be the organizer or co-organizer, and your admin must have enabled this ability. See here for more info.

You can get these attendance reports in a downloadable CSV/Excel format in the meeting chat once the meeting ends (a post with a downloadable report will appear) or from meeting details by simply following these steps after the meeting ends:

  1. Open the meeting/event in Teams to view Meeting Details
  2. Click the Attendance report icon to download the Excel file to your machine’s Downloads folder
Click to enlarge

The resulting report will feature these details:

  • Total participants
  • Meeting start/end
  • Attendee name
  • Attendee join/leave times
  • Duration attended
  • Email
  • Role
Click to enlarge

You do have a third option if it’s a meeting that you’re the sole organizer of (meaning it’s not a channel/team meeting). For one of your meetings, you can also find attendance by opening the meeting/event details and choosing the Attendance tab at the top. This tab is not available for channel meetings, but does give you a nice view of attendance stats without having to download anything. Check out the video below to see all three methods in action:

Aw, PIVOT! G-rated profanities and swear-alternatives inspired by Microsoft 365 apps

A while back, I shared some reactions one might see if NBC’s The Good Place deployed Microsoft 365. In the show, profanities are auto-filtered and replaced with something a little more G-rated. For example, “holy sh**” becomes “holy shirt!” So even though PG-13 profanities can’t be used, the characters can still get their emphatic points across.

In that spirit, I present some M365-inspired (but G-rated) profanities and swear alternatives to incorporate into your daily vernacular.

M365 appOffice-appropriate swear alternative
DelveMotherBOARD.
ExcelAw, PIVOT!
FormsSon of a BRANCH!
ListsFishTEMPLATES!
OneDriveUPLOAD yours!!
OneNote I don’t give an INK-TO-SHAPE.
OutlookWhat the FLAG?
PlannerSon of a BUCKET!
Power AppsDon’t be an APPhole.
Power AutomateFor FLOW’s sake!
Power BIBalderDASHBOARD!
PowerPointMORPH it.
SharePointHeavens to WEB PARTS!
StreamWhat in TRANSCRIPTION??
SwayGosh CARD it!
TeamsCheese and CHANNELS!
WhiteboardOh, SNAP.
WordHoly WORD WRAP.
YammerJumpin’ COMMUNITY!

What is Teams Pro? A look at the latest M365 service plan

Microsoft announced a Teams Pro service plan on Feb 9, 2021. This service plan will be rolled out for all customers with applicable SKUs (Office 365 E5/E3/A5/A3, and Microsoft 365 Business Standard/Business Premium licenses) at no additional cost. You can read the message center announcement in your admin center.

What features are included in Teams Pro?

Teams Pro will include a set of features that will enable “meeting intelligence” and webinar capabilities. While nothing has currently been officially announced, I speculate the new custom registration pages will be included in the Teams Pro feature set.

Admins will be able to turn Teams Pro functionality/capabilities on or off for users similar to how they currently can toggle any app/service product license assignment on/off for users.

How does Teams Pro change my current Teams licensing and M365 cost?

This new addition will not change existing licenses, and will not come at an additional cost to those with Office 365 E5/E3/A5/A3, and Microsoft 365 Business Standard/Business Premium licenses.

When is Teams Pro available?

Teams Pro will be showing up mid-March 2021.

Managing Microsoft Teams: MS-700 exam guide with 165 practice questions (first edition)

NOW AVAILABLE
We’ve just released a second edition (June 2022). 🥳

I had the honor of co-writing Packt’s new MS-700 exam guide with fellow MVP and MCT Peter Rising. We cover the latest exam objectives released in over 400 pages that include plenty of screenshots and a total of 165 exam practice questions.

Successfully passing the MS-700 exam earns you the Microsoft 365 Certified: Teams Administrator Associate certification. This is an excellent way to prove skills and proficiency to employers (current and prospective) and also challenge yourself with keeping up-to-date on administering one of Microsoft 365’s core collaboration and communication apps.

We had an amazing team of technical reviewers and I want to thank Linus Cansby, Adam Deltinger, Amanda Sterner, and Mike Swantek for their invaluable time and input to help make this the best exam guide possible.

I also want to thank the many editors and staff at Packt who invited us to work on this project and helped us make it exceptional from beginning to end. It’s our success to celebrate together and I’m quite proud of what we’ve accomplished.

Custom registration pages coming to Microsoft Teams meetings in March 2021

crop ethnic psychologist writing on clipboard during session

Update 5/19/2021: This is now available for Microsoft Teams webinars.

You may have noticed a message in your M365 admin message center recently that announced registration pages will soon be available for Microsoft Teams meetings, beginning in early March 2021.

This announcement shared that “Microsoft Teams meeting organizers will be soon be able to create a custom registration page for any meeting, although the feature is designed for webinars.”

When can I create custom registration pages for Teams meetings and webinars?

The feature will apply to both desktop and web versions of Teams and may be seen rolling out to your tenants as early as March and as late as April.

What Teams meeting types can have custom registration pages?

Webinars are the ideal candidate for this feature but any normal Teams meeting will work. Recurring meetings and channel meetings, however, will not have this ability.

Who can create custom registration pages in Teams?

Anyone in your tenant will be able to create custom registration pages for their meetings by default.

Who can submit/complete custom registrations for my Teams meeting?

Your organization’s users are able to submit by default, but you can change this everyone (public) to host public webinars. Your admin will need to grant you the ability to create public registration forms, and once granted you can use it repeatedly until access is revoked.

Admins, see the required PowerShell commands for modifying registration permissions in the announcement.

How do custom registration forms work in Teams?

You create a custom registration form during the normal meeting scheduling process. Anyone you invite to the webinar/meeting will automatically receive the link to your form for registration. Others can use your link from social media posts, emails, blogs, etc.

Meeting organizers will have access to a downloadable registration report to track registration activity. This can be found on the “details” tab for the meeting at any time.

Microsoft Word Online Follow-ups feature to be replaced with Comments

The Follow-ups feature in Word Online will be replaced with Comments effective Mar 1, 2021. Comments can be used to notify others and assign tasks by using @mentions.

This was announced via the Message center earlier this month.

What will happen to my existing Follow-ups?

These will be converted to Comments automatically.

How do I use Comments in Word Online?

You can right-click text and select New Comment to create a comment.

Click to enlarge

You can use an @mention to notify someone in your organization. Once @mentioned, you can check a box to also assign that user a task.

Click to enlarge
Click to enlarge

The assigned user then receives an email with a snippet of the task’s context and link to full document. The user can choose to respond to the comment without leaving the email by expanding Add a comment, or they can click Go to comment to go to the full document.

Click to enlarge

To resolve the task, the user needs to Go to comment and can then check the task off in the original comment’s header as shown below.

Click to enlarge.

Solution: SharePoint Asset Library app type missing when adding new app to site

If you’re wanting to add an Asset Library to your SharePoint site but not finding it available as an option, chances are the Video and Rich Media feature for that site collection isn’t activated. This feature enables the asset library which is basically a modified document library but with metadata specific to rich media that can be auto-extracted such as width and height of images, duration of video clips, etc. Asset libraries are good for storing your audio, video, and image content types.

To enable it (as a site collection admin) go to Settings > Site Settings and choose Site collection features from under the Site Collection Administration heading.

Then scroll down and look for the Video and Rich Media feature. Click Activate.

As the description says, this will “[provide] libraries, content types, and web parts for storing, managing, and viewing rich media assets, like images, sound clips, and videos.” Once activated, you’ll now be able to add the asset library to your site(s) in that collection.

Registration now open for #GlobalCon5: 6 days of Microsoft 365 and Dynamics 365 tips and training

Collab365’s virtual GlobalCon summits bring you the best speakers and content on Microsoft 365 (M365) all year long. The next iteration of the series is GlobalCon5, taking place Jan 26th, Feb 9-10th, and Mar 16th-17th (+ 1 more TBA).

  • Jan 26th: Turbo Tuesday (15-minute M365 sessions)
  • Feb 9th-10th: Dynamics 365 Days (45-60 min D365 sessions)
  • Mar 16th-17th: Main Event (45-60 min M365 sessions)
  • 1 more date TBA

I’ll be sharing some OneNote love during Turbo Tuesday! As an attendee (free or paid) you can chat with me and other attendees LIVE during my sessions.

This summit is unlike any previous summits as it will include a dedicated 2-day event specifically on Dynamics 365. If you’re using Dynamics 365, you won’t want to miss this opportunity to learn more about it and ways to optimize your usage of it.

As with other summits, you can register for free and join us live during session air times or you can purchase the All-Access Pass to get ALL session recordings and e-books for all GlobalCon5 dates.

If you’re not sure if the free or paid ticket is best, you can start with the free and upgrade later OR use this new tool that helps you decide which might be best.

I can’t wait to see you at GlobalCon5.

Use MyAnalytics to discover your digital work habits and set goals for the new year

This year, I landed an amazing role at Centriq Training in Kansas City, Missouri. I’m thrilled to be able to contribute to our company blog and recently posted “Year-end reflection: Use MyAnalytics to discover your digital work habits and set goals for the new year” on it. My post covers:

  • What can MyAnalytics do?
    • Focus
    • Wellbeing
    • Network
    • Collaboration
  • What goals can MyAnalytics help me set?
  • Where is MyAnalytics?
  • Who has MyAnalytics?

Read the post here: Year-end reflection: Use MyAnalytics to discover your digital work habits and set goals for the new year – Centriq Training