How to create an address book in SharePoint Online

In this post we take a look at a few of the different ways an address books can be created in SharePoint Online.

  1. Intro
  2. Example 1 – dynamic list filtering
    1. Create the alphabet list
    2. Create the contacts list
    3. Create the address book page
    4. Bonus! Populate the contacts list from M365 user data
  3. Example 2 – Custom SharePoint Framework address book web parts
    1. People Directory SPFx sample
    2. Organization Directory SPFx sample

Intro

The idea for this post came from reader George’s comment asking to do a demo of how an address book can be created in SharePoint. From my research there is already quite a bit out there on how to do this already, but here are my two ways to create an address book.

Example 1 – dynamic list filtering

This example is a pure out of the box, SharePoint solution for creating an address book feature. For this example we will use dynamic filtering between two lists to show a certain set of values when an option is selected.

To start we will need to create two lists:

  1. An alphabet list that will act as our index, storing all the letters of the alphabet as list items.
  2. A contacts list that will be the list that contains all the address book data.

Create the alphabet list

  • Start by creating a new custom list > call the list Alphabet.
  • Create new items in the list for each letter of the alphabet. I used ‘edit in grid mode’ to speed this process up
Create an Alphabet list to store the A-Z letters as list items.
  • Change the view to a gallery view
  • From here, format the list view using either the example JSON list view formatting below, or create your own to style the A-Z list to display each letter as a button
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/tile-formatting.schema.json",
  "height": 45,
  "width": 53,
  "hideSelection": false,
  "fillHorizontally": true,
  "formatter": {
    "elmType": "div",
    "attributes": {
      "class": "sp-card-container"
    },
    "children": [
      {
        "elmType": "button",
        "attributes": {
          "class": "sp-card-defaultClickButton",
          "role": "presentation"
        },
        "customRowAction": {
          "action": "defaultClick"
        }
      },
      {
        "elmType": "div",
        "attributes": {
          "class": "ms-bgColor-white sp-css-borderColor-neutralLight sp-card-borderHighlight sp-card-subContainer"
        },
        "children": [
          {
            "elmType": "div",
            "attributes": {
              "class": "sp-card-lastTextColumnContainer"
            },
            "children": [
              {
                "elmType": "p",
                "attributes": {
                  "title": "[$Title]",
                  "class": "ms-fontColor-neutralPrimary sp-card-content sp-card-highlightedContent"
                },
                "txtContent": "=[$Title]",
                "style": {
                  "text-align": "left",
                  "font-size": "0.8em",
                  "font-weight": "bold"
                }
              }
            ]
          }
        ]
      }
    ]
  }
}
  • Save your view under a new name, I called mine “alphabet filter view”. The end result will look like the below:
Example gallery list view formatting to display A-Z as buttons.

NOTE: There was an original example for this I found online many months ago, but I cant for the life of me find it. If anyone knows where this example came from, leave a message in the comments and I’ll credit it in this post.

Create the contacts list

Next, we need to create the contacts list. If you already have your user data held somewhere else, you can always create your new contacts list from Excel.

  • Once the contacts list is created, create a new lookup column with the following configuration:
    • Give your lookup column a name. I called mine “AZLookup”
    • Require that this column contains information = No
    • Enforce unique values = No
    • Get information from: Alphabet
    • In this column: Title
    • Press Save
Create a lookup column to connect to the Alphabet list.
  • Now you need to update each item in the contacts list, to ensure each item has an A-Z value in the lookup column. Again, for this I used “edit in grid view” to speed things up.
Update the contacts list to include values in the lookup column.
  • Switch to the gallery view and format the list using either the example JSON list view formatting below, or create your own to style the contacts list in a way that suits your needs.
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/tile-formatting.schema.json",
  "height": 166,
  "width": 300,
  "hideSelection": false,
  "fillHorizontally": true,
  "formatter": {
    "elmType": "div",
    "attributes": {
      "class": "sp-card-container"
    },
    "children": [
      {
        "elmType": "button",
        "attributes": {
          "class": "sp-card-defaultClickButton",
          "role": "presentation"
        },
        "customRowAction": {
          "action": "defaultClick"
        }
      },
      {
        "elmType": "div",
        "attributes": {
          "class": "ms-bgColor-white sp-css-borderColor-neutralLight sp-card-borderHighlight sp-card-subContainer"
        },
        "children": [
          {
            "elmType": "div",
            "attributes": {
              "class": "sp-card-previewColumnContainer"
            },
            "children": [
              {
                "elmType": "div",
                "style": {
                  "display": "flex"
                },
                "children": [
                  {
                    "elmType": "p",
                    "attributes": {
                      "class": "sp-card-userEmptyText"
                    },
                    "txtContent": "=if(length([$DisplayName]) == 0, '–', '')"
                  },
                  {
                    "forEach": "personIterator in [$DisplayName]",
                    "elmType": "a",
                    "attributes": {
                      "class": "=if(loopIndex('personIterator') >= 5, 'sp-card-userContainer', 'sp-card-userContainer sp-card-keyboard-focusable')"
                    },
                    "style": {
                      "display": "=if(loopIndex('personIterator') >= 5, 'none', '')"
                    },
                    "children": [
                      {
                        "elmType": "img",
                        "defaultHoverField": "[$personIterator]",
                        "attributes": {
                          "src": "=getUserImage([$personIterator.email], 'S')",
                          "title": "[$personIterator.title]",
                          "class": "sp-card-userThumbnail"
                        },
                        "style": {
                          "display": "=if(length([$DisplayName]) > 5 && loopIndex('personIterator') >= 4, 'none', '')"
                        }
                      },
                      {
                        "elmType": "div",
                        "attributes": {
                          "class": "ms-bgColor-neutralLight ms-fontColor-neutralSecondary sp-card-userOthers"
                        },
                        "style": {
                          "display": "=if(length([$DisplayName]) > 5 && loopIndex('personIterator') == 4, '', 'none')"
                        },
                        "customCardProps": {
                          "formatter": {
                            "elmType": "div",
                            "attributes": {
                              "class": "sp-card-personCallout"
                            },
                            "children": [
                              {
                                "forEach": "personIterator in [$DisplayName]",
                                "elmType": "div",
                                "attributes": {
                                  "class": "sp-card-userContainer sp-card-userCustomCard"
                                },
                                "style": {
                                  "display": "=if(loopIndex('personIterator') < 4, 'none', '')"
                                },
                                "children": [
                                  {
                                    "elmType": "img",
                                    "defaultHoverField": "[$personIterator]",
                                    "attributes": {
                                      "src": "=getUserImage([$personIterator.email], 'S')",
                                      "title": "[$personIterator.title]",
                                      "class": "sp-card-userThumbnail"
                                    }
                                  }
                                ]
                              }
                            ]
                          },
                          "openOnEvent": "hover"
                        },
                        "children": [
                          {
                            "elmType": "span",
                            "txtContent": "='+' + toString(length([$DisplayName]) - (4))"
                          }
                        ]
                      }
                    ]
                  },
                  {
                    "elmType": "div",
                    "attributes": {
                      "class": "sp-card-userTitle"
                    },
                    "style": {
                      "display": "=if(length([$DisplayName]) == 1, '', 'none')"
                    },
                    "defaultHoverField": "[$personIterator]",
                    "txtContent": "[$DisplayName.title]"
                  }
                ]
              }
            ]
          },
          {
            "elmType": "div",
            "attributes": {
              "class": "sp-card-displayColumnContainer"
            },
            "children": [
              {
                "elmType": "p",
                "attributes": {
                  "title": "[$FirstName]",
                  "class": "ms-fontColor-neutralPrimary sp-card-content sp-card-highlightedContent",
                  "role": "heading",
                  "aria-level": "3"
                },
                "txtContent": "=if ([$FirstName] == '', '–', [$FirstName])"
              }
            ]
          },
          {
            "elmType": "div",
            "attributes": {
              "class": "sp-card-displayColumnContainer"
            },
            "children": [
              {
                "elmType": "p",
                "attributes": {
                  "title": "[$Surname]",
                  "class": "ms-fontColor-neutralPrimary sp-card-content "
                },
                "txtContent": "=if ([$Surname] == '', '–', [$Surname])"
              }
            ]
          },
          {
            "elmType": "div",
            "attributes": {
              "class": "sp-card-lastTextColumnContainer"
            },
            "children": [
              {
                "elmType": "p",
                "attributes": {
                  "title": "[$Email]",
                  "class": "ms-fontColor-neutralPrimary sp-card-content "
                },
                "txtContent": "=if ([$Email] == '', '–', [$Email])"
              }
            ]
          }
        ]
      }
    ]
  }
}
  • Save the view and give it a new name. I called mine “Contact cards”. The result will look like the below:
Contacts list with list view formatting applied.

Create the address book page

Now are lists are created and formatted, it’s time to create a new page, add our web parts and start dynamic filtering!

  • Create a new page, select any template you like
  • In a new one column section, add a new list web part > select the Alphabet list
  • Edit the web part and make the following changes:
    • Change the view to Alphabet Filter View
    • Set the size to small – about 5 items
    • Hide the command bar
    • Hide the see all button
  • Press Apply
  • Either in the same or new one column section, add a new list web part > select the Contacts list
  • Edit the web part and make the following changes:
    • Change the view to Contact Cards
    • Set the size to autosize – fit to number of items
    • Hide the command bar
    • Hide the see all button
    • Turn dynamic filtering on
    • Column in Contacts to filter = AZLookup
    • List or library containing the filter value: Alphabet
    • Column containing the filter values properties: Title
  • Press Apply

You will now be able to dynamically filter your contacts list using the A-Z buttons on the address book page!

Bonus! Populate the contacts list from M365 user data

When creating this demo I thought to myself “wouldn’t it be great if you could populate the contacts list from data already in Microsoft 365”. I thought it was a good idea so I created a Power Automate flow to get all the user data from M365 and add it to the contacts list.

Power automate flow to populate the contacts list with user data from Microsoft 365.

The flow uses the search for users (V2) action that, if no search terms are added, will bring back all the users within Microsoft 365 within the flow. Once that action has retrieved all the users, the create item action, wrapped within an apply to each creates a new item within the contacts list for each user the search for users action has found, populating the columns in the contacts list with dynamic content from the previous action.

NOTE: There is a pagination setting that will need updating if you have more than the threshold limit of 1000 users.

Pagination setting within the search for users (V2) action.

This flow was really just to prove the concept, so it runs on a manual basis. If you were to want to do something like this I would suggest having a one time “import of all the user profile data into the contacts list, then a separate, flow that runs on a longer schedule that only runs if certain conditions are met (for example: if the email address doesn’t already exist in the contact list).

Example 2 – Custom SharePoint Framework address book web parts

There are several SharePoint framework (SPFx) sample solutions available from GitHub that work as address books, connecting to user data in Microsoft 365 and allowing you to browse and search for users. Not all samples are offered as downloadable solutions packages, sometimes you will need to package & deploy them manually. I’ve got a post here that covers everything you need to do 🙂

People Directory SPFx sample

This sample was made available as part of the PnP starter kit (formerly the SharePoint starter kit), which I installed and have been using in my tenant since 2019 without issue. This web part lets you browse an A-Z, as well as being able to search for users.

People Directory SPFx sample.

This web part can be downloaded from GitHub and installed into your tenant.

Link to the sample: https://github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-people-directory

Organization Directory SPFx sample

This sample allows you to browse an A-Z, as well as being able to search for users and sort the results by job title, first name, last name etc. When a user is found, a profile hover card is displayed is the same as the rest of Microsoft 365.

Organization Directory SPFx sample.

This web part needs to be packaged into a solution before installing into your tenant.

Link to sample: https://github.com/pnp/sp-dev-fx-webparts/tree/main/samples/react-directory


Microsoft 365 roadmap roundup – 26th September 2022

Use the links below to switch between each product’s roadmap updates:

SharePoint
Teams
OneDrive
Microsoft Information Protection

Teams

  • Launched (2)
  • Rolling out (4)
  • In development (6)

🍾 LAUNCHED

  • Microsoft Teams: Home page customization for Teams admin center – IT admins can drag and drop widgets to customize their Home page in Teams admin center.  Roadmap ID:85703
  • Microsoft Teams: Transcription for 1:1 Calls – Transcription captures the text version of your Call and saves it for later use. This can be enabled via the control bar within the Call window. Feature ID:68774

🚂 ROLLING OUT

  • Microsoft Teams: Interactive Large Gallery – View up to 49 video participants at once, interact with them via actions like pin and spotlight, and observe their meeting activity like raise hand and reactions. Roadmap ID: 86435
  • Microsoft Viva: Meeting category insights coming to the Viva Insights app in Teams – Meeting category insights can help you align time spent in meetings with your goals by giving you visibility into the categories of meetings where you spend your time. Roadmap ID:93410
  • Microsoft Teams: View video recordings and attendance reports inside LMS – Teachers and students will be able to access video recordings and attendance reports inside their LMS itself. Microsoft Teams Meeting LTI app has enabled availability of these artifacts inside LMS. The feature will be available to use in all the LMSs incorporating Teams Meeting LTI app. Roadmap ID:96402
  • Microsoft Teams: Live Transcript for Teams Meetings for DoD – Teams Meetings now have a real-time transcript during their meetings as well as a post-meeting transcript. Roadmap ID: 82838

⌛ IN DEVELOPMENT

Release – September 2022

  • 🆕 Microsoft Teams: Zero install link unfurling – Users can now see a preview card when a pasted link unfurls even when they don’t have the app installed. Roadmap ID: 98723
  • Microsoft Teams: Microsoft eCDN – Microsoft eCDN is an enterprise Content Delivery Network that optimizes the streaming experience for Microsoft Teams and other video products. This WebRTC-based solution reduces bandwidth usage helping to mitigate impacts to network and line of business (LOB) applications. Its mesh networks are self-balancing and automatically scale as the number of viewers increases. The technology does not require additional installation on user endpoints or changes to the physical network infrastructure.  Roadmap ID:89824

Release – October 2022

  • 🆕 Microsoft Teams: Teams calendar now includes scheduling form pop-outs – In a Teams calendar, users will now be able to pop-out an existing meeting using the pop-up icon in a Teams calendar scheduling form.  Users will be able to pop out the meeting and have it visible while creating a new meeting. This feature will allow users to view multiple meetings in separate windows while also being able to check their chats or edit their files without the need to switch apps. Roadmap ID: 99197
  • 🆕 Microsoft Teams: People targeting Graph API – This allows organizations to publish content to multiple teams. Today, the hierarchy is used for task publishing to distribute task lists across multiple teams based on team attributes. Today, customers must use a preview version of PowerShell since we do not have Graph APIs to upload their hierarchy. Having Graph APIs for this hierarchy would Give customers capabilities to work with their hierarchies through Graph for both querying the hierarchy and for end-to-end workflows Remove the barrier of downloading the preview cmdlets from PowerShell once we eventually get the APIs out and release new cmdlets. Roadmap ID: 99191
  • Microsoft Teams: Enhancement to app usage report – support for Line of Business apps – An updated version of Teams app usage report with support for Live of business apps in alignment with Teams app usage in M365 admin center. This will help admins track all app usage metrics over time. Roadmap ID:70677

Release – November 2022

  • Whiteboard: Attribution – Participants in Teams and on Web can see who added content to the board. Roadmap ID: 66765

Microsoft 365 roadmap roundup – 19th September 2022

Use the links below to switch between each product’s roadmap updates:

SharePoint
Teams
OneDrive
Microsoft Information Protection

Teams

  • Launched (7)
  • Rolling out (1)
  • In development (7)

🍾 LAUNCHED

  • Microsoft Teams: Parent App – With Parent Connection, educators can see the roster of the parents and guardians for their students (info provided by School Data Sync) and initiate a Teams chat with them by a single click. So now, instead of the twice-yearly parent-teacher conference or sporadic email, educators and guardians can provide more iterative updates back and forth through Teams chat to help manage and track their student’s progress. Roadmap ID:96942
  • Microsoft Teams: LTI apps integration with Schoology LMS – Microsoft Teams and Schoology can help provide seamless experiences to teachers and students, with the integration of Teams Meetings LTI within Schoology’s LMS, educators and students can access, schedule, and manage Teams Meetings within the Schoology LMS.   Roadmap ID:97149
  • Microsoft Teams: Background Blur and Effects for Citrix  – Microsoft Teams users on virtual desktop infrastructure (VDI) for Citrix will be able to blur their background in a video meeting or call, or replace it entirely with the images provided. Roadmap ID:97951
  • Microsoft Teams: Background Blur and Effects for VMware – Microsoft Teams users on virtual desktop infrastructure (VDI) for VMware will be able to blur their background in a video meeting or call, or replace it entirely with the images provided. Roadmap ID:97952
  • Microsoft Teams: Pre-assign Channel members to Breakout Rooms – Ability for organizer to pre-assign participants to a breakout room within Channel meetings for channel members not explicitly invited to the meeting. Currently, pre-assignment can only be completed for participants invited to the meeting. Roadmap ID:96350
  • Microsoft Teams: View attendance report on Microsoft Teams for Android and iOS – You can now check the attendance information for regular meetings or webinars and also the registration information before webinars on Microsoft Teams for Android and iOS. Roadmap ID: 97466
  • Microsoft Teams: Education Insights – Student Support Card – New AI-based Student Support spotlight in Education Insights helps educators better support students before they fall behind.  Roadmap ID:93388

🚂 ROLLING OUT

  • Microsoft Teams: Live Translated Captions in Meetings – Users will now be able to choose the live captions in the language they prefer, with the help of Microsoft Cognitive Service Speech Translation Capabilities. This will help users fully participate in meetings where the spoken language may not be their most comfortable language to use. Roadmap ID: 94843

⌛ IN DEVELOPMENT

Release – September 2022

  • 🆕 Microsoft Teams: Teams Platform Apps in One-on-One VOIP Calls – All the familiar functionalities of meeting apps – tabs, bots, in-meeting dialogue, and meeting stage – will be supported in Teams VOIP Calls. Users of your apps will enjoy the same familiar app experience as seen in Teams Meetings, in their Teams VOIP Calls. Roadmap ID: 96188

Release – October 2022

  • 🆕 Microsoft Teams: Teams calendar – Multi window experience for scheduling form for Government – Currently, it is not possible to work on a file, chat, look into activity while managing time on teams’ calendar. The reason for this is all these are in different apps located in the left app tray. Users have to switch back and forth between these apps to multi-task in calendar and there are times the data/context gets lost while switching between these apps. We have heard this feedback and as a first step towards solving this, scheduling form can now be popped out as a separate window. This scheduling form new window can be seen while creating a new meeting An existing meeting can also be now popped out by clicking on the icon on scheduling form. Our tech wizards have also made some improvements to calendar in this version which makes it faster to load now. In our next versions, we also plan to pop out the complete calendar app as a new window. Roadmap ID: 99198
  • 🆕 Microsoft Teams: Firefox Meeting Support for Outgoing Screen Sharing – Extend outgoing screen sharing capabilities for Teams Meetings from the Firefox browser. Roadmap ID: 99384
  • Microsoft Teams: Adobe PDF experience – Tenant admins can set Adobe Acrobat as the default app in Teams admin center to view and edit PDF files in the Microsoft Teams.   Roadmap ID:95128

Release – November 2022

  • 🆕 Microsoft Teams: Unread Toggle on Activity Feed – Unread Toggle will help the user review only unread items on the activity feed easily and efficiently. Roadmap ID: 88389
  • Microsoft Teams: Live reactions in Teams Meetings for DoD – React during a meeting using emojis that will appear to all participants. Roadmap ID:83251
  • Microsoft Viva: Effective meetings in Viva Insights – A new “Effective meetings” experience is being introduced in the Microsoft Viva Insights app in Microsoft Teams. Meeting organizers will be able to view personalized insights and suggestions to help improve their meeting habits. Users will also be able to create and share meeting plans to set team meeting norms such as shorter meetings by default and always including Teams links.  Roadmap ID:85660

Microsoft 365 roadmap roundup – 12th September 2022

Use the links below to switch between each product’s roadmap updates:

SharePoint
Teams
OneDrive
Microsoft Information Protection

Teams

  • Launched (8)
  • Rolling out (9)
  • In development (11)

🍾 LAUNCHED

  • Microsoft Teams: Native Apple Silicon Support – Universal Binary Teams Version – Teams now comes as a Universal Binary Mac so it runs natively on both Intel and Apple Silicon based Mac devices. Roadmap ID:94836
  • Microsoft Teams: View Together Mode for everyone for GCC-High and DOD – Meeting organizer and presenters will be able to start Together Mode in the meeting for all the participants. Roadmap ID:94390
  • Microsoft Teams: Mute/ unmute status icon for Teams Rooms on Windows – To ensure users in the room are aware of the mute state of the room, a mute icon is added to the room video on the front of room display. Roadmap ID:95257
  • Microsoft Teams: Deploy Teams at scale for frontline workers – Deploying Teams at Scale enables your admins to deploy up to 500 teams and add 25 users per team using one Teams PowerShell command and 2 csv files. This allows admins to meet their organization’s scale needs and significantly reduces deployment time. Admins can also use this solution to add and remove members from existing teams at scale. Roadmap ID:96352
  • Microsoft Teams: Check out for Microsoft Teams panels – From a Microsoft Teams panel, users can “check out” of a room with the touch of a button, ending the room reservation and returning the room back to the room inventory. Roadmap ID:88047
  • Microsoft Teams: Extend Room reservations for Microsoft Teams panels – From a Microsoft Teams panel, users can extend their existing meeting room reservation. The reservation can only be extended if the room is available during that time.  Roadmap ID:88643
  • Microsoft Teams: Bulk removal for individual policy assignments – Admins can cleanup individual policy assignments from users in bulk, so that those users can inherit the correct policy either via a group policy assignment or global org-wide default. Roadmap ID:90705
  • Microsoft Teams: Manage meeting options for DoD – Organizers will now be able to modify the user experience, or customize the safety and security settings for their meetings using the new “Meeting Options” feature. Roadmap ID:72169

🚂 ROLLING OUT

  • Microsoft Teams: Device Test for virtual visits – Ability for users to test their device before a virtual visit. Roadmap ID:87715
  • Microsoft Teams: Microsoft Teams chat embedded within Dynamics 365 – Microsoft Teams chat can be accessed directly from Dynamics 365 allowing users to continue existing chats or create new individual or group chats.  Roadmap ID:89100
  • Microsoft Teams: Choose preferred download location for files – Teams will now enable users to select the default download location where they would like to have their files downloaded. This is applicable only on the desktop client. Teams on the web will continue to honor the setting in the browser.  Roadmap ID:94719
  • Microsoft Teams and Forms: Ranking Poll – The Ranking question type is being added to the Polls app within Microsoft Teams. Meeting owners can easily create and launch Ranking polls to increase engagement and collect input from their meeting attendees, as well as share the results live.  Roadmap ID:94764
  • Microsoft Teams: Suggested Replies in Group Chat – Suggested Replies will be enabled in group chats, allowing you to select a quick response when you are mentioned in a group chat or when you are having a 1:1 conversation within a group chat.  Roadmap ID:95618
  • Microsoft Teams: Usability improvements to in-meeting notifications – Simplifying the in-meeting notification displays where users are informed about what they need to know or do without causing unnecessary distraction.  Roadmap ID:96283
  • Microsoft Teams: Assign seats in Together Mode – Allow meeting organizers to assign seats to participants in Together Mode. Roadmap ID:83648
  • Microsoft Teams: Teams Platform Apps in Group VOIP Calls – All the familiar functionalities of meeting apps – tabs, bots, in-meeting dialogue, and meeting stage – will be supported in Teams VOIP Calls. Users of your apps will enjoy the same familiar app experience as seen in Teams Meetings, in their Teams VOIP Calls. Roadmap ID:96189
  • Microsoft Teams: Activate team from inside the Microsoft Teams Classes LTI app within your Learning Management System (LMS) – Now educators can activate a class from the Microsoft Teams Classes LTI app within a LMS and no longer need to leave the LMS to activate a class. The new activation option is intuitive and easy to discover, with a notification banner for classes that need to be activated. Roadmap ID:97406

⌛ IN DEVELOPMENT

Release – September 2022

  • 🆕 Microsoft Teams: Detailed call history – Get a more comprehensive view into whether calls were transferred or forwarded, how group calls arrived and were controlled once received.  Roadmap ID:98455
  • 🆕 Teams admin center: View users and groups assigned to a policy – Admins can view the list of assigned users and groups for a policy. Roadmap ID:97253
  • Microsoft Teams: Music on hold for call transfer – Music can be played to callers on hold when a call transfer is initiated.  Roadmap ID:98431
  • Microsoft Viva: Meeting category insights coming to the Viva Insights app in Teams – Meeting category insights can help you align time spent in meetings with your goals by giving you visibility into the categories of meetings where you spend your time. Roadmap ID:93410

Release – October 2022

  • 🆕 Microsoft Teams: Transcription for calls on Microsoft Teams for Android – Transcription for 1:1 calls and group calls will be available on the Microsoft Teams app for Android. Roadmap ID:98510
  • 🆕 Microsoft Teams: Choose your spoken language for captions and transcriptions for Microsoft Teams on Android – Specify your spoken language for meetings and calls for more accurate captions and transcriptions. Choose translated captions for a more inclusive calling and meeting experience.   Roadmap ID:98513
  • 🆕 Microsoft Teams: Music on Hold for Voice over IP Calls and PSTN Consult and Transfer for GCCH and DOD – This feature ensures that music can be played for VOIP calls placed on hold, as well as VOIP and PSTN consult then transfer scenarios.    Roadmap ID:83503
  • Microsoft Teams: Group chat invitations from unmanaged users – When using external access for Teams, users receiving a group chat invitation from an unmanaged Teams user will be prompted with the option to acknowledge or leave the group chat. Roadmap ID:95051
  • Microsoft Teams: Viewing the Full Chat conversation thread after clicking on search message results – When users search for a chat message in Teams and click on a message result, they are taken to a view that contains only the selected message, rather than the entire chat thread. This fix will now land the users on the full chat thread once the message search result is clicked, thereby providing full context of the conversation around the message result. Roadmap ID:97510
  • Microsoft Teams: Collaborate in Teams with Excel Live – Collaborate easily in Teams with our new Excel Live feature. You can easily collaborate with all meeting participants on your Excel worksheet during the meeting. Select the file you want to share, grant permissions to meeting participants, and enable all meeting participants to edit the document right from the meeting window. Roadmap ID:96099

Release – November 2022

  • Microsoft Teams: RTMP-In for Teams Live Events – Produce your Teams Live Events using an external encoder  and leverage RTMP-in to broadcast to your Teams Live Event Attendees. Roadmap ID:84960

Microsoft 365 roadmap roundup – 5th September 2022

Use the links below to switch between each product’s roadmap updates:

SharePoint
Teams
OneDrive
Microsoft Information Protection

Teams

  • Launched (9)
  • Rolling out (12)
  • In development (13)

🍾 LAUNCHED

  • Microsoft Teams: Live Transcript for Teams Meetings for GCC-High – Teams Meetings now have a real-time transcript during their meetings as well as a post-meeting transcript. This will help users in real-time recall what has been spoken during the meeting as well as review the meeting after the fact. Roadmap ID:82230
  • Microsoft Teams: Pop out shared content into a separate window – Users can pop out shared meeting content in a separate window. Roadmap ID:86948
  • Microsoft Teams: Data Export within Approvals App – Through the approvals app you can now export your approval data within a selected time period. Roadmap ID:92925
  • Microsoft Teams: Activate team from inside the LTI app within LMS itself – Now teachers will be able to activate a class from the Class LTI app within LMS itself. They need not go outside LMS anymore to activate a class. The new activation option is quite intuitive and easy to discover. A notification banner is shown for all the classes that need to be activated. Roadmap ID:97953
  • Microsoft Teams: E-signature approvals creation on mobile – Users will now be able to create e-signature approvals on any mobile device. Roadmap ID:92940
  • Microsoft Teams and Forms: Rating Poll – The Rating question type is being added to the Polls app within Microsoft Teams.  Meeting owners can easily create and launch Rating polls to increase engagement and collect input from their meeting attendees, as well as share the results live.  Roadmap ID:93991
  • Microsoft Forms: Re-use previously created polls in Teams meetings – Meeting organizers and presenters can now access the polls previously created to re-use or modify, so that they can apply them to new meetings instead of creating repeated polls every time from scratch.  Roadmap ID:94765
  • Microsoft Teams: Camera On/Off feature – Beginning July 2022, any certified Teams Peripherals supporting the Camera On/Off feature will allow a user to more efficiently turn on or off their Video during a call or meeting. Instead of fumbling with your mouse or keypad to bring up the Meeting Stage and then press the Video icon, a simple click of a button will allow the user to quickly control their video state. Roadmap ID:95738
  • Microsoft Teams: Teams Button long press to Raise Hand during meeting – Raise Hand is a popular feature in Teams and is something all users can use, often many times over the course of a meeting. This feature allows users the ability to invoke a Raise Hand reaction during a meeting by simply holding the Teams button on their certified peripheral. Roadmap ID:90738

🚂 ROLLING OUT

  • Microsoft Teams: Cameo in PowerPoint Live  – Cameo is a new PowerPoint experience that seamlessly integrates your Teams camera feed into your presentation, letting you customize how and where you want to appear on your slides and offering layout recommendations for optimal viewing. Roadmap ID:87725
  • Microsoft Teams: HID Support for VMware – This feature supports the use of Human Interface Devices (HID) in Microsoft Teams on virtual desktop infrastructure (VDI) for VMware. Roadmap ID:90115
  • Microsoft Teams: Parent App – With Parent Connection, educators can see the roster of the parents and guardians for their students (info provided by School Data Sync) and initiate a Teams chat with them by a single click. So now, instead of the twice-yearly parent-teacher conference or sporadic email, educators and guardians can provide more iterative updates back and forth through Teams chat to help manage and track their student’s progress. Roadmap ID:96942
  • Microsoft Teams: Background Blur and Effects for Citrix  – Microsoft Teams users on virtual desktop infrastructure (VDI) for Citrix will be able to blur their background in a video meeting or call, or replace it entirely with the images provided. Roadmap ID:97951
  • Microsoft Teams: Background Blur and Effects for VMware – Microsoft Teams users on virtual desktop infrastructure (VDI) for VMware will be able to blur their background in a video meeting or call, or replace it entirely with the images provided. Roadmap ID:97952
  • Microsoft Teams: Language Interpretation – Language interpretation will allow language interpreters to translate what the speaker says into another language in real time without disrupting the original flow of delivery of the speaker. This will allow more inclusive meetings, where participants who may not speak the same language can fully collaborate with each other. Roadmap ID:87547
  • Microsoft Teams: User request configuration to external systems (URL redirect)  – Customize the instructions users receive when they request apps and configure the external systems where requests should be placed. Roadmap ID:89288
  • Microsoft Viva: A new app called Microsoft Viva Engage – Viva Engage gives leaders a new way to shape culture at their organizations by unlocking communication and engagement opportunities for everyone. Built on the foundation of Yammer, Viva Engage brings people together across the organization to connect with leaders and coworkers, find answers to questions, share their unique story, and find belonging at work. Roadmap ID:93409
  • Microsoft Teams: Home page for Teams for Education class teams – Home page provides a central destination for the latest announcements, resources, upcoming assignments, class files, and meetings for a class team.  Roadmap ID:93479
  • Microsoft Teams: Pin and hide the room video for Teams Rooms on Windows – Teams Rooms on Windows allows room users to pin or hide room video on the front of room screen. In-room participants can control these options by selecting the room from the roster on the console. This added capability provides greater personalization for room users who feel the room video to be potentially distracting or not needed. Roadmap ID:95258
  • Microsoft Teams: Microsoft Teams: Updated companion mode for Android users – For a better hybrid meeting experience, Teams users on their Android phone can use a single tap to join a meeting on both their device and Microsoft Teams Room. Audio on their device will be automatically turned off to ensure echo doesn’t happen. Furthermore, the landing experience on Android will be optimized for engagement activities to make it easier to raise hand or react, chat, see all participants, and more.   Roadmap ID:97255
  • Microsoft Teams: Live Captions for Anonymous (Guest) Users – Anonymous (Guest) Users are now able to view Live Captions, CART captions and captions in other spoken language in Teams Meetings on desktop. Roadmap ID:93049

⌛ IN DEVELOPMENT

Release – September 2022

  • 🆕 Microsoft Teams: LTI apps integration with Schoology LMS – Microsoft Teams and Schoology can help provide seamless experiences to teachers and students, with the integration of Teams Meetings LTI within Schoology’s LMS, educators and students can access, schedule, and manage Teams Meetings within the Schoology LMS.   Roadmap ID:97149
  • 🆕 Microsoft Teams: Teams Platform Apps in Instant Meetings – All the familiar functionalities of meeting apps – tabs, bots, in-meeting dialogue, and meeting stage – will be supported in Teams Instant Meetings that are started from the Calendar. Users of your apps will enjoy the same familiar app experience as seen in Teams Meetings, in their instant meetings. Roadmap ID:99192
  • Microsoft Viva: Meeting category insights coming to the Viva Insights app in Teams – Meeting category insights can help you align time spent in meetings with your goals by giving you visibility into the categories of meetings where you spend your time. Roadmap ID:93410
  • Microsoft Teams: Teams Platform Apps in Group VOIP Calls – All the familiar functionalities of meeting apps – tabs, bots, in-meeting dialogue, and meeting stage – will be supported in Teams VOIP Calls. Users of your apps will enjoy the same familiar app experience as seen in Teams Meetings, in their Teams VOIP Calls. Roadmap ID:96189

Release – October 2022

  • 🆕 Microsoft Teams: Group chat invitations from unmanaged users – When using external access for Teams, users receiving a group chat invitation from an unmanaged Teams user will be prompted with the option to acknowledge or leave the group chat. Roadmap ID:95051
  • 🆕 Microsoft Teams: RTMP-In for Teams Live Events – Produce your Teams Live Events using an external encoder and leverage RTMP-in (Real Time Messaging Protocol-In) to broadcast to your Teams Live Event Attendees.  Roadmap ID:98481
  • 🆕 Microsoft Teams: Viewing the Full Chat conversation thread after clicking on search message results – When users search for a chat message in Teams and click on a message result, they are taken to a view that contains only the selected message, rather than the entire chat thread. This fix will now land the users on the full chat thread once the message search result is clicked, thereby providing full context of the conversation around the message result. Roadmap ID:97510
  • Microsoft Teams: Approvals in integrated SharePoint Lists – List users will now be able to create and manage simple approval requests directly within integrated SharePoint Lists.  Roadmap ID:91417

Release – November 2022

  • 🆕 Microsoft Teams: Join a meeting by digital code for GCC-High and DoD – User can join a meeting by entering a digital code. Roadmap ID:94620
  • Microsoft Teams: Disable or Enable all Attendees’ Video for DoD – Ability in DoD to disable and enable videos for all attendees before or during a Microsoft Teams meeting. Roadmap ID:91665
  • Microsoft Teams: Disable or Enable a Single Attendee’s Video for DoD – Ability to disable and enable a single attendee’s video in a Microsoft Teams meeting. Roadmap ID:91666

    Release – January 2023

    • Microsoft Teams: Support for breakout rooms for Microsoft Teams Rooms on Android – Ability to consume breakout rooms feature in Teams meetings. Roadmap ID:68745

    Release – March 2023

    • Microsoft Teams: Global sign in and sign out – Teams iOS app will support Global sign-in and sign-out to simplify the experience for Frontline Workers. Employees can now use any device from the shared device pool to sign in with their credentials and sign out of it at the end of the shift. This will remove all their personal and company information from the device. Roadmap ID:85736

    Microsoft 365 monthly update – July 2022

    The Microsoft 365 monthly update includes updates and recently recent features across all of Microsoft 365. Press a button to read about an individual technology or continue reading for more. You can take a look back at previous monthly updates here, plus take a look at our weekly roadmap roundup.


    SharePoint

    In SharePoint: Video collection page, one-time passcode change, nested security groups in AAD, flows from list templates, calendar view conditional formatting, review mode for Word documents, top ten SPFx solutions June 2022

    Video collections page

    Whenever people create a new site, the service auto-generates a static layouts page for video collections. This is a collection of all videos from the site’s document library. For now, to access this new page, you need to append /_Layouts/15/Video_Collections.aspx to the end of the site url. You can then edit and publish this page as you would any other, it will start appearing in the site pages as well.

    The new video collections page in SharePoint Online.

    more: SharePoint Roadmap Pitstop: July 2022

    SharePoint/ OneDrive external sharing ‘One-Time Passcode’ email address change

    To improve reliability for delivery of the one-time passcode e-mails that are sent as part of the external sharing flow, Microsoft will be updating the sending address for these mails from no-reply@sharepointonline.com to no-reply@notify.microsoft.com.

    NOTE: If your organization is using Azure B2B Integration with SP in Microsoft 365, this change will not impact your organization. No other e-mails sent from OneDrive or SharePoint are being changed at this time.

    Find out more: SharePoint Roadmap Pitstop: July 2022

    a: “Nested” groups in Azure Active Directory (Public Preview)

    The ‘memberOf’ component of dynamic Azure Active Directory, or Microsoft 365 groups allows you to “nest” groups within a group. The groups that define the membership of the dynamic group can be any group type represented in Azure Active Directory – user or device security groups, Microsoft 365 groups, and groups synced from on-premises, or a mix of all three. And, unlike existing nested security groups today, memberOf dynamic groups return a flat list of members, so can be used for licensing assignment and application assignment.

    memberOf “Nested” groups allow you to create Dynamic-Group-A with members of Security-Group-X and Security-Group-Y. Members of the groups inside of Security-Group-X and Security-Group-Y don’t become members of Dynamic-Group-A.

    Find out more: Create “nested” groups with Azure AD Dynamic Groups

    Create Power Automate flows embedded within Microsoft Lists templates

    To help improve automation of information, you now have the option to install pre-created Power Automate reminder flows whenever you create a list from select list templates: Work progress tracker, Content scheduler, and the Recruitment tracker.

    You’ll be prompted to install the included Power Automate reminder flow after the list has been created. The reminder flow is an automated flow that runs on a schedule in the background, so it does not appear in the Lists menu, and you can further refine it using the Power Automate flow designer. With a Microsoft 365 E3 or E5 license, or a Power Automate per-user plan, you can create and use the reminder flow that is included with these select ready-made Lists templates.

    Some list templates, such as the Work progress tracker shown above, come with flows that are automatically created when you create a list from that template.

    Find out more: Create a business application from a list template

    Calendar view conditional formatting in Microsoft Lists

    Now you can better customize the calendar view by colour coding items based on conditions or rules. You manage the rules and colouring within the ‘Format current view’ in the top-right section of Calendar view.

    Color-code list items as they appear within Calendar view when they meet certain rules by your design through conditional formatting.

    Find out more: Create a calendar view from a list

    Review mode for Word documents

    When sharing a link to a document in SharePoint or OneDrive, you can assign someone to ‘Review Mode’ in the Share Dialog by using the new ‘Can Review’ option in the permission dropdown. They’ll then have access to review the document – to make edits with tracked changes intact and leave comments.

    Select “Open in review mode only” when sharing Word documents to ensure the recipient can add comments or make edits that have tracked changes on by default.

    Find out more: Roadmap ID: 93400

    Top 10 SharePoint Framework solutions June 2022

    These are the most widely used solutions and their providers last month:

    1. Ichicraft Widgets: Your Digital Workplace – Ichicraft Widgets allows users to personalize their digital workplace in SharePoint or Microsoft Teams. It offers the user a canvas that can be filled with configurable widgets (blocks) that clearly display up-to-date and personalized information.
    2. Navigator 365 – Sharepointalist, Inc. – SharePoint & Teams content aggregation with search, grouping and filtering. 
    3. Cerkl Broadcast for SharePoint – Ensure your internal communications are seen with SharePoint push alerts and newsfeed. Cerkl Broadcast for SharePoint provides unique notifications to employees through your existing SharePoint.
    4. Employee Directory Plus – Support | HR365SharePoint Employee Directory Plus is free, fully featured 30 days trial for one office 365 tenant up to 999 users. Employee Directory Plus displays information of employees in the organization in visually manner.
    5. Image Map – APPS 365 LTD – Supercharge your processes and navigation by using any image to deliver interactive visual content. Create hotspot navigation with image maps.
    6. My Links – Dalikoo – My Links is a SharePoint app where you can add and manage your web links through an intuitive interface.
    7. HM Munich GmbH – Table of Contents – This Web Part helps you to create high-quality documentation. The Modern Pages are ideal for your documentation of content (as a kind of Wikipedia) in Office 365.
    8. Modern FAQ  – The Modern FAQ app provides users a better way to search for the answers to the questions they have in mind. It also helps the organizations to prepare the frequently asked questions, and answers categorized and presented in a readable format. 
    9. Qualtrics Feedback – Add a way for your employees to easily give you feedback from within Viva Connections. Easily add a card to your Viva Connections surface to allow your employees to give you feedback in their flow of work.
    10. Announcements Carousel – Compass365 – The Announcements Carousel by Compass365 allows you to display announcements in an automatic sliding carousel on your SharePoint team site. 

    Find out more: Most used SharePoint Framework solutions from the Store – June 2022


    Teams

    In Teams: Forms enhancements for meetings, LinkedIn integration, remove call from history, call recording announcement, common area phone license updates, DECT device integration with SIP, Teams panels updates, automatic groupings for channel posts, UX updates for iPad, bulk removal for policy assignments, export API support for message reactions

    Government
    Education
    Front line workers

    ms enhancements in Teams meetings

    Microsoft Forms is excited to introduce a number of new features and improvements to existing features within Teams meeting polls. Here’s a quick summary:

    • The “Forms” app within Teams is being replaced with a new app named “Polls” – making it much easier for people to find and add polls to their chats and meetings.
    • UI improvements to the poll suggestions pane, including the ability to:
      • Re-position the list of suggested polls from the bottom to the side pane
      • Provide an entry point in the polls portal page, where users can show/hide the side pane as needed
      • Provide the poll results view (previously, it only showed the voting view), which allows the poll creator to see how the poll will look to the meeting audience after it’s launched
    • You can now see a list of your recently created polls so that you can re-use your past polls created in new meetings and save time.
    • A new poll animation appears after people have entered a response, providing a dynamic confirmation that their votes have been successfully submitted.
    • A new poll question type, Rating, which allows you to provide feedback by rating on the scaled symbols.
    • We’ve improved the poll result view to be a more intuitive and easy-to-read experience, with enrichments such as color indication and dynamic results.
    Microsoft Forms enhancements in Teams meetings.

    Find out more: What’s New in Microsoft Teams | July 2022

    LinkedIn integration

    Use LinkedIn profiles, now integrated with Teams, to get to know your colleagues, connect directly and build deeper relationships. From Teams chat, channels, calls, or meetings, you will now be able to view your colleague’s LinkedIn profile, including their current role, past experiences, and other insights.

    LinkedIn integration with Microsoft Teams.

    Find out more: Use LinkedIn in Teams

    Automatic groupings available for channel posts

    When creating a message post in a team channel, users are now able to notify owners of the team all at once by mentioning “@Team Owners,” removing the need to mention team owners individually. “Team Owners” is automatically grouped and doesn’t require any manual maintenance.

    Automatic groupings available for channel posts.

    Find out more: Send a message to a channel in Teams

    Remove a call from call history

    Streamline your view with the ability to hide calls from your call history list on Teams for desktop and mobile. NOTE: Your call history is available if you have an Enterprise Voice or Business Voice license as part of your Microsoft 365 subscription.

    Remove a call from call history in Microsoft Teams.

    Find out more: View your call history in Teams

    Call recording announcement played in your default language

    Call recording announcements will now be played in your default language for Teams calls to or from a phone number. Both parties will hear the announcement in the same language, at the same time, for both standard and compliance recording scenarios.

    Find out more: What’s New in Microsoft Teams | July 2022

    Common Area Phone license enhancements

    The Common Area Phone offering has been enhanced to serve a wider variety of scenarios for customers without increasing the price.

    Find out more: What’s New in Microsoft Teams | July 2022

    Spectralink Digital Enhanced Cordless Telecommunications (DECT) device integration with SIP Gateway

    DECT devices from Spectralink have been integrated with SIP Gateway, allowing frontline workers to use Teams calling functionality on DECT devices to communicate with colleagues on the go. DECT device integration with SIP Gateway is available on the following compatible handset models from Spectralink:

    • IP-DECT 200/400/6500/Virtual IP-DECT/IP-DECT Base Station
    • Handsets 72xx/75xx/76xx/77xx

    Find out more: Configure SIP Gateway

    Microsoft Teams panels updates

    Here is a summary of the recent updates to Teams panels:

    • Check out for Microsoft Teams panels
    • Extend room reservations for Microsoft Teams panels
    • Peripherals: Camera on/off feature
    The new check out functionality in Teams panels.

    Find out more: What’s New in Microsoft Teams | July 2022

    Bulk removal for individual policy assignments

    Admins can clean up individual policy assignments from users in bulk so that those users can inherit the correct policy either via a group policy assignment or global organization-wide default. Individual policies are always prioritized, in order to clean those induvial policies and make sure that users are getting the correct policy we created this procedure to clean them all in one operation.

    Bulk removal for individual policy assignments.

    Find out more: Assign policies to users and groups

    Export API support for Teams message reactions

    The Teams Export API allows organizations to support Enterprise Information Archiving (EIA) for Teams to solve for retention, indexing, e-discovery, classification, and regulatory requirements. Teams Export API also will now support Teams reactions (heart, thumbs up, laugh, surprised, angry, sad) on a message using the Export API. This is in addition to Teams Messages (1:1 and group chat), attachments (file links and sticker), emojis, GIFs, and user @Mentions.

    Find out more: Export content with the Microsoft Teams Export APIs

    Education

    These features are currently available for Teams for Education customers:

    Reflect is now a featured tab in your class team – To help foster social emotional learning in your class, we’ve updated Reflect to appear as a featured tab in each of your classes – just like Assignments or Grades! Get started with the updated version of Reflect in Teams.

    Additional enhancements to Assignments and Grade Reports – The Insights team has been working to highlight student learning data in Assignments and Grade Reports in a richer, more informative, and easier to use format. Find out more: Changes to Assignments and Grades view in Insights

    Summary Average Grade for Teachers – In the Gradebook for Assignments, you’ve been able to view a summary of all assignments and student grades for each course. Now, we added an average grade for each student, assignment, and all-up class view. As a teacher, you can change the date filter to see updated average grades for your selected date period. Find out more: What’s new in Teams

    Adding Images in Assignment Instructions – A picture is worth a thousand words, and a GIF even more (some say). Now, you can embed pictures and GIFs into your Assignment instructions on both mobile and desktop to make them more engaging and easier to understand for students. Find out more: What’s new in Teams

    Updated Video Options for Students and Educators – This last year we have added the ability to add Video recording to the assignments for both educators and students and added the ability to do Video Recording when given grades or feedback for an assignment. We have updated the video recorder to now support ink and images in your recording, and added options for Mirror recording and Audio recording. Find out more: Video in the Flow of Work

    Challenging Words assignment improvements – Extend your students’ learning by creating a rigorous assignment from the most challenging words. When you navigate to Reading Progress reports in Insights, you can see which words students missed most frequently, select words from the passage, or additional challenge words recommended based on data from students with similar reading challenges. Find out more: create a challenge assignment from Insights.

    Multi-select of words in Teacher Review – Save time with the ability to select multiple words to adjust the error category or mark as correct in bulk. Select any word, then from the dropdown choose Text tools then Select multiple words to manage several words at once. Find out more: What’s new in Teams

    Improvements to Timed Passage –  Now, whenever a timed passage is set and the student doesn’t finish their reading in the allotted time, a small marker will show on the page and gray out the words the student didn’t reach. Find out more: What’s new in Teams

    Create and Review Assignments on iPad and Android tablets – In the past, educators have been able to create and review Reading Progress assignments on Teams for Desktop PC, Mac and Web Browser, but not on Teams for iPad or Android tablets. Support for assignment creation and review on these two mobile platforms is now available. Find out more: What’s new in Teams

    Frontline

    Easily deploy frontline teams at scale – Administrators can deploy up to 500 teams with 25 users per team using one PowerShell command. This enables your organization to roll out teams at scale within a day so your frontline workforce can collaborate and be productive across different stores, locations, and roles. Learn more about deploying frontline teams at scale.

    Device Test for virtual appointments – Device Test allows virtual appointment users to validate and configure hardware components before joining an appointment through Microsoft Teams. Users will be able to validate camera, microphone, and browser compatibility, as well as the internet connection at any moment before the scheduled appointment start time. Learn more about device testing.

    Virtual appointment SMS notifications for UK customers – Now UK customers can send and receive SMS confirmations and reminders with a Teams Meetings link for any virtual appointments that are created from the Bookings app in Teams. Learn more about SMS notifications.

    Government

    These features are currently available to in multi-tenant cloud environments: US Government Community Cloud (GCC), US Government Community Cloud High (GCC-High), and/or United States Department of Defense (DoD):

    Manage Meetings options for DoD  – Organizers are now able to modify the user experience or customize the safety and security settings for their Teams Meetings using the new “Meetings options” feature.

    Large Gallery for Teams on VDI in government clouds – By default, Teams Meetings supports up to nine videos in Gallery. Now, using Large Gallery, users can view up to 49 videos at once in Meetings on virtual desktop infrastructure (VDI). This is available for GCC and GCCH.

    Together Mode for Teams on VDI in government clouds – Together Mode lets you see all your colleagues against a shared background, making you feel like you are all together in a virtual online room. This is now available in Meetings on virtual desktop infrastructure (VDI) for GCC and GCCH.


    Power Apps

    In Power Apps: Managed environments, auto updates, app insights, find/ replace, review feedback, more components, Power Apps on Windows GA, embed an app in Teams, NFC/ markup support, Dependent assemblies for plugins, ESLint rules, formula columns in Dataverse, visualising views

    Managed Environments (Preview)

    This month Microsoft announced the preview of Managed Environments, a set of built-in governance capabilities that will simplify and automate IT administration of the Power Platform at scale. Managed Environments offers out-of-the-box simplicity with premium administration capabilities for low-code asset management at scale. It is designed to streamline governance, increase IT trust, and significantly reduce the burden on IT.

    Simplify and streamline Power Platform governance with Managed Environments.

    Find out more: Managed Environments overview (preview)

    Auto updates for Power Apps & Dynamics CE (Preview)

    The new feature allows automatic updates of third-party apps installed through AppSource, helping both ISVs and customers keep software up to date in a simple and controlled way, with minimal administrative overhead. Customers can control whether to opt-in to enable the feature and indicate which publishers are permitted to automatically update apps in their environment, providing flexibility to pause auto updates based on their needs.

    Auto updates for Power Apps & Dynamics CE.

    Auto app updates (preview)

    Application insights generally available for Dataverse plugins

    The Power Apps team have announced that Application insights is now Generally Available for Dataverse plugins. To ensure that you can monitor your production workloads anywhere in a trustworthy manner, Microsoft have enabled state-of-art monitoring solution built on the Azure Monitor ecosystem designed to help prodevs to diagnose plugin timeouts, create custom alerts and reports, monitor global usage, and automatically detect patterns and anomalies in the telemetry data using the built-in Smart Detection feature, thus helping you to keep it always available, reliable and performant.

    Improve monitoring of Dataverse plugins using Application insights.

    Find out more: Improve monitoring of Dataverse plugins using Application insights

    Find and replace in the Power Apps Studio (Preview)

    In July, the Power Apps team introduced the “Replace” capability to the Search Pane, now in  preview. This new addition to the Search Pane means you can now find and replace variables, collections, media, flow, formula content and more. This new pane allows you to be as broad or as granular with your search as you need – find all of the things you’re looking for in your canvas app or exactly the thing you are looking for.

    Find and replace in the Power Apps Studio.

    Find out more: Use the Search pane (preview)

    Review feedback and ratings (Preview)

    This feature is currently available only for model-driven apps as part of preview. The mechanism to capture feedback for the apps is completely managed by Microsoft and is compliant with all international privacy and security standards. The feedback is processed to generate satisfaction score of an app on a scale of 0 to 200 which is displayed to makers for their apps.

    Review feedback and ratings from your users.

    Find out more: What are app ratings? (preview)

    Form customisation with more components

    You can now add more components to your model-driven forms through the modern form designer! Try customizing the look and feel of your forms with custom components built by Microsoft or other providers available through the marketplace.

    Customizing forms with even more components.

    Find out more: Add, configure, move, or delete components on a form – Power Apps | Microsoft Docs

    Find business data in Microsoft Search

    Allow your Dynamics users to easily locate information from Bing.com, Office.com, and Sharepoint.com by enabling the Dynamics 365 connector. Make your Dynamics users more productive by eliminating switching apps to get to quickly needed business data.

    Find your business data in Microsoft Search.

    Find out more: Dynamics 365 results in Microsoft Search | Microsoft Docs

    Power Apps on Windows generally available

    Find all your canvas and model-driven apps in one place. Just sign in, choose an app, and you’re ready to go! Use your apps wherever you are with or without network thanks to offline support. It works just like it does on iOS and Android. With Intune for application management, you can manage the devices and people in your organization that have access to Power Apps on Windows.

    Power Apps on Windows generally available.

    Find out more: Install Power Apps for Windows – Power Apps | Microsoft Docs

    Embed an app to Teams

    Currently, customers can add their favourite apps to Teams by using the “Add to Teams” button at make.powerapps.com/apps. Now, they can launch their favourite canvas apps and pin these apps in Teams straight from the Web Player’s header. This capability prevents a user from having to leave the app context & return to make.powerapps.com/apps to add the app to Teams. 

    Seamlessly add your apps to Teams.

    Find out more: Embed an app in Teams – Power Apps | Microsoft Docs

    Expanded support for NFC, and markup support in MR controls

    The ReadNFC() function has been improved to return all records on the NFC tag as well as the identifier. These records and identifier make it easy to build Power Apps around asset tracking, inventorying, and attendance tracking.

    The Markup in MR control enables users to paint 3D lines and draw arrows in context of physical space on top of a device’s camera feed. These mixed reality markups can be used during inspections, audits, walkthroughs and more to point out features of the environment and certain objects anchored in space.

    Expanded support for NFC, and markup support in MR controls.

    Find out more: Use the Markup in MR control in Power Apps – Power Apps | Microsoft Docs and ReadNFC function – Power Platform | Microsoft Docs

    Dependent Assemblies for Plug-ins

    This feature is designed to boost developer productivity by eliminating the overhead of using ILMerge to manually merge dependent assemblies. With dependent assemblies, rather than register an individual .NET assembly, you will upload a NuGet Package that contains your plug-in assembly AND any dependent assemblies. Unlike ILMerge, you can also include other file resources, such as JSON files containing localized strings.

    Find out more: Dependent Assembly plug-ins (preview)

    ESLint rules for Power Apps and Dynamics 365 (Preview)

    The Power Apps team have announced the public preview of ESLint rules for Power Apps model-driven apps and Dynamics 365 CE. In 2019, Solution Checker launched helping customers analyze solution for any issues. The ESLint rules for Power Apps and Dynamics 365 takes this a step further, bringing these validations to your development environment to help you find and fix issues in your JavaScript code before being added to a solution. 

    Announcing public preview of ESLint rules for Power Apps and Dynamics 365.

    Find out more: Use solution checker to validate your model-driven apps in Power Apps

    Formula columns in Dataverse (Preview)

    Formula columns are based on Power Fx. Power Fx provides a much richer set of functions than were previously available with calculated columns, especially for text processing and also provides a lowcode way to perform app extensibility. Now you are empowered with the same capability inside Dataverse where you can express your business logic on top of existing columns and reference column from other tables.

    As calculations are done at the Dataverse level, results can be seen and used in all Dataverse endpoints, including the Dataverse for Teams table view, canvas and model-driven Power Apps, Power Automate, Power BI, the Dataverse APIs, to name just a few.

    Dataverse for Teams Formula columns.

    Find out more: Boost maker productivity inside Dataverse using formula columns!

    Visualize views in Power Apps with Power BI generally available

    The Power Apps team have announced that Power BI quick reports in Power Apps are now generally available. Power BI quick reports in Power Apps represent a seamless integration of Power Apps, Power BI and Dataverse into a single experience to enable every business user turn data into insights inside business apps. 

    Power BI quick reports in Power Apps.

    Power Automate

    In Power Automate: Power Automate desktop update, two new bot actions, 44 new verified connectors, 19 new independent publisher connectors, pay-as-you-go, ideas

    Power Automate Desktop – July 2022 update

    The July 2022 update of Power Automate for desktop (version 2.22) has been released and can be downloaded here. Here is a roundup of all the new features and updates:

    • UI automation in a Citrix or RDP virtual desktop is now supported (Preview)
    • New datatable actions are introduced in Power Automate for desktop
    • Flow details are now available in the desktop console
    • Detailed release notes will now be available for each new version
    UI automation in a Citrix or RDP virtual desktop is now supported (Preview).

    Find out more: Power Automate for desktop – July 2022 update

    Two new bot actions in Power Automate

    The Power Automate team have announced two new bot actions that have been highly requested which will help take your flows a step further:

    • Update adaptive card messages in Teams – This action allows makers to update a Flow bot message which contains an adaptive card . Allowing you to make updates to reflect the latest changes in near real time to Microsoft Teams.
    • Trigger a flow when an adaptive card action is submitted – A new trigger that lets you collect inputs from multiple users across a group chat or channel. 
    Update Adaptive card in a chat or channel message.

    Find out more: Create advanced bot scenarios with Power Automate and Microsoft teams

    44 New Verified Connectors released in June 2022

    The Power Automate team launched a huge number of verified connectors in June 2022, including 44 new and 19 updates from different service owners. These connectors have solutions and tools for Content and Files, Productivity, Collaboration, Business Intelligence, IT Operations, Security, and much more. Here are just a few:

    • Azure AD App Registration – Azure Active Directory is an Identity and Access Management cloud solution that extends your on-premises directories to the cloud and provides single sign-on to thousands of cloud (SaaS) apps and access to web apps you run on-premises.
    • Azure AD Identity and Access – A connector for Azure AD Identity and Access. This connector will contain multiple actions to manage Azure AD Identity and Access.
    • Azure Communication Services Chat – Azure Communication Services Chat allows you to add real-time text communication to your cross-platform applications.
    • Azure Communication Services Email – Azure Communication Services Email allows you to send high volume transactional, bulk and marketing emails enabling Application-to-Person (A2P) use cases. 

    Find out more: 44 New Verified Connectors and 19 Updates released in June 2022

    19 New Independent Publisher Connectors in June 2022

    The Power Automate team have announced that 19 new Independent Publisher connectors were published in June 2022. These connectors have solutions and tools for Human Resources, Social Media, Lifestyle and Entertainment, Data, Finance and much more. Here are a few examples:

    • BitlyIP by Troy Taylor Bitly is the most widely trusted link management platform in the world. By using the Bitly API, you will exercise the full power of your links through automated link customization, mobile deep linking, and click analytics.
    • DHL Shipment Tracking by Woong ChoiThe Shipment Tracking API provides up-to-the-minute shipment status reports. Users of this API can: Retrieve tracking information for shipments, Identify the Deutsche Post DHL (DPDHL) service provider involved with the shipment, Verify DPDHL is using the correct delivery address. 
    • Nationalize.io by Tomasz PoszytekNationalize.io predicts the nationality of a person given their name. Use the API for analytics, ad segmenting, demographic statistics etc. The API is free for up to 1000 names/day.
    • RegEx Matching by Mitanshu Garg This connector checks whether a text string matches a specified pattern.

    Find out more: 19 New Independent Publisher Connectors in June 2022

    Power Automate pay-as-you-go (Preview)

    The Power Automate team have announced pay-as-you-go for Power Automate. A easy way for users to only pay for what you use, giving you more flexibility to get started with Power Automate with low risk and then scale your investments over time based on the usage patterns.

    Currently, admins must predict licensing needs in advance, purchase licenses and assign them to makers for them to start using premium features of Power Automate. While it works for situations where admins understand the licensing needs in advance, we’ve heard from customers that there are many scenarios where they don’t yet know their needs, or where they need to scale up/down usage.

    Power Automate pay-as-you-go plan.

    Find out more: Announcing public preview of pay-as-you-go for Power Automate

    Power Automate Ideas

    Between July 18 and July 20, 2022, Power Automate Ideas was migrated to a brand-new platform powered by Dynamics 365 Customer Service Community. On top of providing our community with a brand-new interface to share ideas, the migration will enable our product teams to be much more responsive to user feedback and better integrate your ideas into our product roadmap.

    Find out more: https://ideas.powerautomate.com/


    Power BI

    In Power BI: New license purchase/ management via AppSource, metric visual, desktop feature summary, data in space, improved Power BI in Excel

    Purchase and manage licenses of licensed visuals through Microsoft AppSource

    You can now purchase and manage licenses of licensed visuals through Microsoft AppSource. Now, when you look at licensed visuals in AppSource, you can see all the available licensing plans for each visual. Licensed visuals are visuals marked with price tag “Starts at Free” and has the “Plans + Pricing” tab.

    You can now purchase and manage licenses of licensed visuals through Microsoft AppSource.

    Find out more: Introducing a new way to purchase licensed Power BI visuals and manage licenses through Microsoft platforms

    Metric visual (Preview)

    The Metric visual is now available in preview in the Power BI Service. You can now include individual metrics instead of the entire scorecard and create report pages showcasing metrics alongside other visuals, in the context of the rest of the report data.

    You can either create a new metric or add a metric from an existing scorecard as a visual in the report.

    Find out more: Metric visual is now available in preview

    Power BI desktop feature summary July 2022

    The July 2022 update for Power BI desktop is out now and includes Error Bars general availability, Metric visuals, Datamarts updates and much, much more!

    Power BI desktop feature summary July 2022.

    Find out more: Power BI July 2022 Feature Summary

    Data in space

    Data in space is a new Power BI Mobile feature that uses augmented reality to create spatial anchors in the real world and attach Power BI data to them, so that data can be connected to the physical environment it describes. Using Data in space, you can connect your business data to your real-world scenarios, such as facility management, manufacturing, or retail.

    Data in space is a new Power BI Mobile feature.

    Find out more: “Data in space” in preview: Now Power BI can be truly everywhere

    Improved Power BI Experience in Excel

    The Power BI team have announced several improvements to the Power BI experience in Excel that will help business users easily search data artifacts (including Power BI datasets and Power BI datamarts) and uncover better data insights all inside a spreadsheet environment.

    Better Search in User-Friendly Interface for Power BI in Excel.

    Find out more: Improved Power BI Experience in Excel

    BONUS – more updates!

    Viva Sales

    Microsoft Viva Sales reimagines the selling experience, giving salespeople AI-driven insights and data automation right in the flow of work. Sellers will be able to automatically capture, access, and register data into any customer relationship management (CRM) system. Enriched with data from Microsoft 365,

    Introducing Microsoft Viva Sales.

    Learn more about Viva Sales announcement.

    Bookings with me

    With Bookings with me in Outlook, you can create, customize, and share a personal Bookings page where people can book time with you based on your personal preferences. Start customizing your Bookings page in the web calendar by clicking on Create bookings page.

    Bookings with me in Outlook.

    Find out more: Bookings with me

    Improvements to Office.com

    The newly designed Office.com sign-in and sign-up page greets you with a modern entry point to get your day started on the web. We are introducing a new onboarding experience that helps you understand how to better use and engage with Office. Additionally, with the new Create experience, you can access new creation templates in a single location.

    Improving the Office.com experience.

    Microsoft 365 roadmap roundup – 29th August 2022

    Use the links below to switch between each product’s roadmap updates:

    SharePoint
    Teams
    OneDrive
    Microsoft Information Protection

    Teams

    • Launched (3)
    • Rolling out (6)
    • In development (13)

    🍾 LAUNCHED

    • Microsoft Teams: Attendance Dashboard for GCC-High and DoD – Item has been delayed and is being rescheduled. Measure meeting and webinar registration and attendance data in the Attendance Dashboard. Roadmap ID:94856
    • Microsoft Teams: ‘Share to Teams’ from Teams personal Apps or Tabs – ‘Share to Teams’ now allows users to share URLs from personal app or tab to other user or group or channel within Teams. This launches the ‘Share to Teams’ experience in a pop-up/modal window enabling a faster and seamless sharing experience.  Roadmap ID:91117
    • Microsoft Teams: New default for Teams notification style for DoD – Teams notification style will be defaulted to native notifications for new users. Currently the default style is Teams purple, with this change to native notifications the user will benefit from support for assist mode, action center, accessibility and more. Roadmap ID:86088

    🚂 ROLLING OUT

    • Microsoft Teams: External access chat invitation flow for managed organizations – When receiving a new one-on-one chat from an external user, Teams users will now see an invitation to accept or block the external user. This also provides the ability to block external users at any point, which revokes access to presence and incoming messages.  Roadmap ID:94646
    • Microsoft Teams: Pre-assign Channel members to Breakout Rooms – Ability for organizer to pre-assign participants to a breakout room within Channel meetings for channel members not explicitly invited to the meeting. Currently, pre-assignment can only be completed for participants invited to the meeting. Roadmap ID:96350
    • Microsoft Teams: Leave a meeting on all my devices – When a Teams user has joined a meeting using multiple personal devices they can encounter friction when leaving the meeting, including forgetting to leave the meeting on one of their many devices. This functionality allows Teams users to leave a meeting from all their devices with a single tap. Roadmap ID: 97397
    • Microsoft Teams: View attendance report on Microsoft Teams for Android and iOS – You can now check the attendance information for regular meetings or webinars and also the registration information before webinars on Microsoft Teams for Android and iOS. Roadmap ID: 97466
    • Microsoft Teams: View meeting transcripts on Microsoft Teams for Mobile and iOS – You can now start transcription for your meetings, and view the meeting transcripts after the meetings on Microsoft Teams for iOS and Android. Roadmap ID: 97693
    • Microsoft Teams: Transcription will be turned on together with Recording if the “Record automatically” meeting option is on – If meeting organizer set the “Record automatically” meeting option to on for a meeting, Transcription will be turned on together with Recording when the meeting starts, if transcription is allowed by admins. This will make recording playback experience accessible. Roadmap ID: 97842

    ⌛ IN DEVELOPMENT

    Release – August 2022

    • 🆕 Microsoft Teams: Activate team from inside the Microsoft Teams Classes LTI app within your Learning Management System (LMS) – Now educators can activate a class from the Microsoft Teams Classes LTI app within a LMS and no longer need to leave the LMS to activate a class. The new activation option is intuitive and easy to discover, with a notification banner for classes that need to be activated. Roadmap ID:97406
    • Microsoft Teams: Activate team from inside the LTI app within LMS itself – Now teachers will be able to activate a class from the Class LTI app within LMS itself. They need not go outside LMS anymore to activate a class. The new activation option is quite intuitive and easy to discover. A notification banner is shown for all the classes that need to be activated. Roadmap ID:97953
    • 🆕 Microsoft Teams: Microsoft eCDN – Microsoft eCDN is an enterprise Content Delivery Network that optimizes the streaming experience for Microsoft Teams and other video products. This WebRTC-based solution reduces bandwidth usage helping to mitigate impacts to network and line of business (LOB) applications. Its mesh networks are self-balancing and automatically scale as the number of viewers increases. The technology does not require additional installation on user endpoints or changes to the physical network infrastructure.  Roadmap ID:89824
    • 🆕 Microsoft Teams: Teams Platform Apps in Group VOIP Calls – All the familiar functionalities of meeting apps – tabs, bots, in-meeting dialogue, and meeting stage – will be supported in Teams VOIP Calls. Users of your apps will enjoy the same familiar app experience as seen in Teams Meetings, in their Teams VOIP Calls. Roadmap ID:96189
    • Microsoft Teams: Parent App – With Parent Connection, educators can see the roster of the parents and guardians for their students (info provided by School Data Sync) and initiate a Teams chat with them by a single click. So now, instead of the twice-yearly parent-teacher conference or sporadic email, educators and guardians can provide more iterative updates back and forth through Teams chat to help manage and track their student’s progress. Roadmap ID:96942

    Release – October 2022

    • 🆕 Microsoft Teams: Connectors in GCC – Teams Connectors, which support webhook integrations, will be made available in GCC. Roadmap ID:96290
    • Microsoft Teams: Live reactions in Teams Meetings for DoD – React during a meeting using emojis that will appear to all participants. Roadmap ID:83251
    • Microsoft Teams: Enhancement to app usage report – support for Line of Business apps – An updated version of Teams app usage report with support for Live of business apps in alignment with Teams app usage in M365 admin center. This will help admins track all app usage metrics over time. Roadmap ID:70677

    Release – November 2022

    • Microsoft Teams: Paging on Video Gallery – When you are in gallery view, and there are more videos than what can be shown at once on the meeting stage (the maximum number can vary depending on your device configuration and internet bandwidth), navigation controls and will appear below the Video Gallery to see additional videos of the attendees. You can use these controls to view more video participants. Roadmap ID:86480
    • Microsoft Teams: Modern meeting experience on the web – The modern meeting and calling experience will be available for Teams on the web in Chrome and Edge browsers – including improved pre-join, dynamic view, and the updated control bar.  Roadmap ID:92928

    Release – December 2022

    • Microsoft Teams: Chat Bubbles during Teams meetings for Microsoft Teams Rooms on Android – Ability to view chats sent during a Teams meeting on the front of room display in a Teams Room, calling attention to the chat conversation happening alongside the meeting. Roadmap ID:85441
    • Microsoft Teams: Automatically end stale Teams meetings – If a user is the sole participant in a meeting that has been identified as stale, the user will see a dialog prompting to end the call or dismiss the notification. If no action is taken, the meeting will automatically end.  Roadmap ID:96710

    Release – January 2023

    • Microsoft Teams: New Tag Management Settings – This feature will update default tag management settings in the Teams Admin Center to include ”Team owners and members” and not just “Team owners.” You can still update this to only “Team owners” at the tenant level and override the default.  Roadmap ID:88318

    Microsoft 365 roadmap roundup – 22nd August 2022

    Use the links below to switch between each product’s roadmap updates:

    SharePoint
    Teams
    OneDrive
    Microsoft Information Protection

    Teams

    • Launched (3)
    • Rolling out (2)
    • In development (10)

    🍾 LAUNCHED

    • Microsoft Teams: Co-organizer Meeting Role for GCC-High – Organizers will be able to share control by assigning the new “Co-organizer” role to people they invite. Co-organizers will have almost all of the capabilities of the organizer, including management of Meeting Options. Roadmap ID:81676
    • Microsoft Teams: Give Take Control for Teams for VDI on Azure Window Desktop and Windows 365 – User on Azure Window Desktop and Windows 365 on virtual desktop infrastructure (VDI) will be able to give and take control during calls and meetings. Give control: If you want another meeting participant to change a file, help you present, or demonstrate something, you can give control to that person. You will both be in control of the sharing, and you can take back control anytime. Take control: To take control while another person is sharing, select Request control. The person sharing can then approve or deny your request. While you have control, you can make selections, edits, and other modifications to the shared screen. When you’re done, select Release control to stop sharing control. Roadmap ID:87559
    • Microsoft Teams: Video Streams Out via AJA or Blackmagic Design Hardware for GCC-High and DoD – Isolated video streams can be sent out of Teams meetings via AJA and Blackmagic Design hardware devices. Roadmap ID: 83486

    🚂 ROLLING OUT

    • Microsoft Teams: View Together Mode for everyone for GCC-High and DOD – Meeting organizer and presenters will be able to start Together Mode in the meeting for all the participants. Roadmap ID:94390
    • Microsoft Teams: Intelligent translation in Teams Mobile – Teams iOS will now prompt you to translate messages that are not in your set language. Roadmap ID: 96545

    ⌛ IN DEVELOPMENT

    Release – August 2022

    • 🆕 Microsoft Teams: Leave a meeting on all my devices – When a Teams user has joined a meeting using multiple personal devices they can encounter friction when leaving the meeting, including forgetting to leave the meeting on one of their many devices. This functionality allows Teams users to leave a meeting from all their devices with a single tap. Roadmap ID: 97397
    • Microsoft Teams: Home page for Teams for Education class teams – Home page provides a central destination for the latest announcements, resources, upcoming assignments, class files, and meetings for a class team. Roadmap ID: 93479

    Release – September 2022

    • 🆕 Microsoft Teams: Live Translated Captions in Meetings – Users will now be able to choose the live captions in the language they prefer, with the help of Microsoft Cognitive Service Speech Translation Capabilities. This will help users fully participate in meetings where the spoken language may not be their most comfortable language to use. Roadmap ID: 94843
    • 🆕 Microsoft Teams: Music on hold for call transfer – Music can be played to callers on hold when a call transfer is initiated. Roadmap ID: 98431
    • Microsoft Teams: ISV App Subscriptions instead of 3P app subscriptions. – Ability for Teams users to view and manage in single place all third-party app subscriptions they’ve purchased in the Teams app store, without leaving the Teams client. Easily adding more licenses for the purchased subscriptions, cancel, upgrade and downgrade subscriptions and access invoices. Roadmap ID:92484
    • Microsoft Teams: Choose preferred download location for files – Teams will now enable users to select the default download location where they would like to have their files downloaded. This is applicable only on the desktop client. Teams on the web will continue to honor the setting in the browser.  Roadmap ID:94719
    • Microsoft Teams: ISV App Subscriptions instead of 3P app subscriptions – Ability for Admins to view and manage in single place all third-party app subscriptions they’ve purchased from Teams Admin Center, easily adding more licenses for the purchased subscriptions, cancel, upgrade and downgrade subscriptions and access invoices.   Roadmap ID:95920

    Release – October 2022

    • Microsoft Teams: RTMP-In for Teams Live Events – Produce your Teams Live Events using an external encoder  and leverage RTMP-in to broadcast to your Teams Live Event Attendees. Roadmap ID:84960
    • Microsoft Viva: Quiet time settings in Teams and Outlook – To help create better boundaries and protect your personal time, later this year Viva Insights will offer the ability to configure quiet time to silence mobile notifications from Outlook and Teams outside your working hours as well as provide personalized insights on how well you are disconnecting. You will also be able to set quiet time directly from Teams and Outlook mobile. Roadmap ID: 85627
    • Microsoft Teams: Collaborate in Teams with Excel Live – Collaborate easily in Teams with our new Excel Live feature. You can easily collaborate with all meeting participants on your Excel worksheet during the meeting. Select the file you want to share, grant permissions to meeting participants, and enable all meeting participants to edit the document right from the meeting window. Roadmap ID:96099