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:
An alphabet list that will act as our index, storing all the letters of the alphabet as list items.
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
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.
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.
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.
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 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
In this post we describe how to use a hidden taxonomy list to allow us to change the format and store metadata terms, plus their parents in SharePoint Online.
Intro
Lists and libraries in SharePoint Online have the ability to show a term or the term plus parents within a managed metadata column by editing said column and changing a neat little option called display format.
You can configure managed metadata columns in SharePoint to show terms plus parents.
However, when you turn on this option your term plus parents displays in the following way: Parent:Term. What if you wanted to change the way the parent plus child terms are displayed into either a different or user friendly format? Let’s do exactly that:
The taxonomy hidden list
There is a secret list within each SharePoint site called the taxonomy hidden list that, as the name suggests is a hidden list that stores cached managed metadata terms used within site. The taxonomy hidden list is unique to the site and each time terms are used within the site, they get stored within the taxonomy hidden list.
This list contains a lot of repeated stuff that might look confusing, but it does specifically contain the full path of a term including it’s parent, which is what we are looking for.
Solution
So in my example I want to replace the colon in the parent plus term with a comma and a space, so it looks like this: Parent, Term. In the below example my managed metadata column is called Department. Here’s how I did it step-by-step:
In your target list/ library, create a new single line of text column to store you formatted parent plus term (DeptCopy in my example).
Create a new flow in Power Automate based on the when a new item is created SharePoint trigger, making sure your site address and list name are added and configure the actions below:
Get item action
Set the site address as the target SharePoint site and the list name as TaxonomyHiddenList. Note: you will need to enter a custom value here and type this in.
Set the Id to equal the managed metadata column (Department) WssId from the when a new item is created trigger.
Initialize variable
Create a new variable to store the full path of the term from the get items action. Give the variable a name set the value to equal Path from the get items action.
Compose (optional)
Use the compose data operation to create an expression to replace the colon with a comma and space. You don’t have to do this step, I just use it for troubleshooting to easily see what the outputs are of my input value.
replace(variables('varDept'),':',', ')
Update item
Update your previously created column to show the newly formatted term plus parent with the output from the compose action. Note: If you don’t use the compose action from the previous step, just write the expression above directly in the column you want to update.
Notes
There is quite a bit online about seeing empty values in your managed metadata column. Although I’ve not personally noticed this, the taxonomy hidden list is set to have unique permissions by default and has the following permissions:
Anonymous users: view items
Everyone: read
There is a good write up of the taxonomy hidden list here.
Although there are a number of dynamic content options available, none of them seem to contain the parent + term like they do in the hidden taxonomy list. For example the path column that’s available from the ‘create an item’ trigger, outputs ‘null’.
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 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
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.
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.
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.
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.
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.
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.
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.
These are the most widely used solutions and their providers last month:
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.
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.
Employee Directory Plus – Support | HR365 – SharePoint 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.
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.
My Links – Dalikoo – My Links is a SharePoint app where you can add and manage your web links through an intuitive interface.
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.
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.
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.
Announcements Carousel – Compass365 – The Announcements Carousel by Compass365 allows you to display announcements in an automatic sliding carousel on your SharePoint team site.
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
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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 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.
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.
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.
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 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.
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.
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.
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.
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.
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.
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).
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.
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.
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 Choi – The 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 Poszytek – Nationalize.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.
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.
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.
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.
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.
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!
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.
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.
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,
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.
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.
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 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
This post details an issue with document libraries in SharePoint Online when there are more than 30 folders within a ‘grouped’ view, causing files not to be visible to users.
Intro
I’ve been working through a large-scale migration project for some time now, and have recently moved several document libraries from SharePoint 2010 into SharePoint Online. Although the library in question is large (approx. 200K items), it is well structured employing two levels of folder then using metadata to arrange files within.
The problem I’ve observed does not just apply to large libraries, it applies to all libraries that contain more than 30 folders.
The problem
Since migrating the document library I’ve noticed an issue with using group by views. A grouped by view is purely just a view that is grouped by a particular column, by clicking on the column name and pressing “group by”.
Group by selected within a document library view in SharePoint Online.
The library has a default view that has group by enabled to group items by a custom “document type” column. With grouped by views, a limit is automatically applied to the number of folders shown (30) and a “show all” link appears at the bottom of the view. When you click on this, it shows all the subfolders, but also automatically applies a filter to the view to the effect of “document type = empty”. This causes all the files within the subfolders to not display.
Clicking on “show all” applies an empty filter based on the group by column, causing all files within the document library to not display.
This issue only occurs for custom columns, any in-built columns (name, created by etc.) will let you group by and not apply the empty filter.
Response from Microsoft
I raised this issue with Microsoft via support and the response I received was:
“Although it is not desirable behaviour, it is expected”.
Microsoft support response to my issue
It was explained to me that the way these large libraries are structured, which, in my opinion has been considered to be best practice for well over a decade is no longer support in SharePoint Online. In essence this advice was don’t use grouped by views for document libraries with more than 30 folders.
We then proceeded to talk through how to re-build the affected document libraries using a different structural approach to overcome this issue which I will talk through below.
Temporary solutions/ workarounds
#1 Rebuild all affected document libraries
In my example, the document library is for storing employee files, so the first solution to this would be to completely re-build the document library, starting with splitting the library up into smaller, individual libraries (A-Z). Then, instead of interacting directly with the libraries, instead use a combination of pages, the highlighted content and document library web parts, with KQL queries to present the relevant files in a sort of address book style.
For example: there would be an address book page with highlighted content web parts displayed for each A – Z folder. Each highlighted content web part would have a KQL query to only shows the site pages for each employee with the relevant A-Z letter in the title. If this is something you’d like me to do a separate demo on, let me know in the comments section.
An address book page with a highlighted content web part for each A-Z folder, with a query that filters each HCWP to only show the relevant employee pages.
Alongside splitting up the large library into smaller libraries, for this solution you would also have to create a page per employee and add a document library to the employee page, pointing to the relevant library/ folder
#2 Use multiple views to navigate folders/ files
For this workaround I created two views: All Documents and All Folders. The All Folders view does not have grouped by enabled and allows you to navigate through all the folders without running into the empty filter. Once a users arrives at the relevant folder, they switch to the All Documents view which has the grouped by view enabled, allowing the user to view the files within the folder grouped by the custom column.
Two views to switch between All Files and All Documents to allow users to navigate the folder structure and see files grouped by custom columns.
#3 Manually remove the filter
This workaround is by far the simplest option, but puts the most burden on the end user. With this issue, it is possible to just remove the filter after it gets applied by pressing “show all”. Users are able to just untick the filter and continue to use the document library. This is what my users are currently doing.
Manually removing the empty filter allows all files to be displayed within the grouped by view.
#4 Classic view
My least favourite option of them all, but worth including as it does get around the issue. Classic view does not apply the “show all” link or restrict the number of folders displayed within a document library view. Switching to classic view will allow users to interact with the library without issue, but would potentially have other issues if any modern features are being used elsewhere within the library.
Classic view will show all folders without applying the “show all” restriction.
SharePoint Stuff 