Posted on

How to get a Microsoft Teams meeting attendance report

white graphing paper

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, and your admin must have enabled this ability. See here for more info.

You can get these attendance reports in the meeting chat once the meeting ends (a report icon will appear) or simply follow these steps later to retroactively get the report from meeting details:

  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

Posted on

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!
Posted on

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.

Posted on

New MS-700 exam guide (Managing Microsoft Teams) now available with 165 practice questions

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.

You can order our MS-700 exam guide here.

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.

Posted on

Custom registration pages coming to Microsoft Teams meetings in March 2021

crop ethnic psychologist writing on clipboard during session

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.

Posted on

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.
Posted on

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.

Posted on

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.

Posted on

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

Posted on

SharePoint 2019 Solution: “Sorry, apps are turned off. If you know who runs the server, tell them to enable apps.”

Photo by Artem Beliaikin from Pexels

Without an App Catalog and a setting enabled, your users may run into the following error when attempting to access the SharePoint Store from the “Add an app” dialog:

“Sorry, apps are turned off. If you know who runs the server, tell them to enable apps.”

If you’ve run into this issue and are a farm admin, you can enable the app store and ability in SharePoint 2019 by following these steps. If you’ve already created the App Catalog site collection, skip to step 4.

1. Log onto your central admin server and open central admin

Click to enlarge

2. Choose Apps > Manage App Catalog. Make sure the Web Application shown is the correct web application then click OK to create a new App Catalog (or enter a URL for one if you’ve already created one)

Click to enlarge

3. Set the App Catalog site name and description, URL, admin, and then end users who should see apps in the catalog.

Click to enlarge

4. Once you have an App Catalog, go back to Apps > Configure store settings.

Click to enlarge

5. Confirm the Web Application shown is the correct web app, then change App Purchases to Yes. Save your changes.

Now when users who were granted access to view apps in the store choose SharePoint Store from the “Add an app” dialog, they’ll be able to get marketplace apps as well.

Click to enlarge