Show or hide fields based on choice values in Power Apps

This post describes how to show or hide fields based on a choice column from a SharePoint list in Power Apps.

I was recently working on a Power App form for new site/ teams requests. The fields were all based on SharePoint list columns and one of the key fields was a choice column. What I wanted to do was have an additional field default to being hidden from the screen unless a particular choice value was selected.

Now I’ve used the Microsoft guidance to create dependant drop-downs before but this scenario was slightly different and it was based on a choice column which isn’t compatible to my knowledge. I’d done something before in my Power App to toggle the display mode of a button in my app if fields are blank. So starting with this I used a simple if function in my formula to show/ hide my field based on the selected choice value.

Solution

Here’s how to hide a field based on a choice value in Power Apps:

  • Open your Power App to edit it > ensure both the choice field and the field you want to hide are added to the screen
In this example, a drop-down list will be hidden by default until project site is selected from within the request type choice field.
  • Select the data card for the field you want to hide until a choice value is selected
  • In the top, left-hand corner of the Power Apps editor, select the visible property
Select the Visible property when selecting the hidden field in your PowerApp.
  • Add the following if statement to the formula bar, replacing the parts highlighted below:

If(rdoRequestType.Selected.Value="Project site",true,false)

  • Replace rdoRequestType with the name of your choice control
  • Replace “Project site” with the selected value from your choice field

Now, by default your field will be hidden from the screen until you select the relevant choice value!


Microsoft 365 roadmap roundup – 13th September 2021

Use these buttons to switch between each product’s roadmap updates.

Teams

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

🍾 LAUNCHED

  • Microsoft Teams: Create a task from a message in the Desktop Client for Microsoft Teams – With the “create a task from a message” feature in Teams, you’ll be able to create a task from a message in group or 1:1 chats or from a channel post or reply. Roadmap ID: 68696
  • Microsoft Teams: Collaborative Calling – Collaborative calling enables customers to connect a call queue to a channel in Teams. Users can collaborate and share information in the channel while taking calls in the queue. Roadmap ID: 68770
  • Microsoft Teams: Reading Progress in Teams for Education – reading practice and review software – Reading Progress is a reading practice and fluency experience that is part of Microsoft Teams for Education Assignments. Roadmap ID: 72240
  • Microsoft Teams: Missed Activity Email in DOD – Missed activity email enables the user to stay on top of their Microsoft Teams notifications. A missed activity email is generated in case a user is away from Microsoft teams and has not reviewed their notifications. Roadmap ID: 83061
  •  Microsoft Teams: New default for Teams notification style – 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: 83062
  • Microsoft Teams: New assignment experience in modal window for Breakout Rooms – Enhanced UX for participant assignment. This includes new capabilities such as sorting participants and rooms and performing multiple selections and assignments to rooms. Roadmap ID: 81389

🚂 ROLLING OUT

N/A

⌛ IN DEVELOPMENT

Release – September 2021

  • 🆕 Microsoft Teams: Teams now available on CarPlay – When Teams is connect to CarPlay, you can now handsfree call or message one or a group of Teams contacts, as well as join your next meeting. Roadmap ID: 84391
  • Microsoft Teams: Better Together feature for Calls on Teams phones and displays – Better together allows Microsoft Teams devices to seamlessly integrate with your PC to bring a companion experience for cross-device interaction. With the new feature support, users can make and receive calls from either Teams device or PC client with a distributed calling experience across both devices. Roadmap ID: 84308

Release – October 2021

  • 🆕 Microsoft Teams: Press “Ctrl Spacebar” to speak – Introducing the capability to allow meeting participants to temporarily unmute by press “Ctrl Spacebar” to speak. Roadmap ID: 83419
  • 🆕 Microsoft Teams: Queue view for virtual visits scheduled in the Microsoft Bookings app – Real time updates to meeting state in a queue view for virtual visits scheduled in the Microsoft Bookings app. Roadmap ID: 86718
  • Microsoft Teams: Guest Access in GCC – High – Teams now supports Guest Access between tenants inside the GCC-H Cloud. Roadmap ID: 82803

Release – November 2021

  • 🆕 Microsoft Teams: Dynamic Emergency Calling for Work From Home for VDI on Azure Virtual Desktop – This feature enables users on Azure Virtual Desktop on VDI to make an emergency call while working from home. It will allow users to validate (and if necessary, edit) the address that will be communicated to emergency responders.  Roadmap ID: 83555
  • Microsoft Teams: Up to 25K members per team in GCCH – You can now add up to 25,000 members per team in GCCH. Roadmap ID: 85339
  • Microsoft Teams: Multi-Window support for VDI – VMware – Multi-Window is available for VMware. Users will be able to view meetings and calls in separate windows from the main Microsoft Teams client. Roadmap ID: 85691

Release – December 2021

  • 🆕 Microsoft Teams: Attendance Dashboard in GCC – Measure meeting and webinar registration and attendance data in the Attendance Dashboard. Roadmap ID: 87061
  • Microsoft Teams: Teams Q&A – Question & Answer application for Teams webinars & meetings. By adding this application to any Teams Webinars or Meetings, users will be able to create either moderated or unmoderated Q&A experience. Roadmap ID: 84027
  • Microsoft Teams: Multi-Window support for VDI – Citrix – Multi-Window is available for Citrix. Users will be able to view meetings and calls in separate windows from the main Microsoft Teams client. Roadmap ID: 84192
  • Microsoft Teams: Related content during meeting scheduling on mobile – Related Content makes meetings more effective by providing customers with important information from their mailboxes, OneDrive for Business and SharePoint sites. Related content during scheduling will help meeting organizers schedule more effective meetings by attaching relevant files to the meeting. Roadmap ID: 81800

Release – January 2022

  • Microsoft Teams: Up to 25K members per team in DoD – You can now add up to 25,000 members per team in DoD. Roadmap ID: 85338

Microsoft 365 roadmap roundup – 6th September 2021

Use these buttons to switch between each product’s roadmap updates.

Teams

  • Launched (8)
  • Rolling out (5)
  • In development (56)

🍾 LAUNCHED

  • Microsoft Teams: Tasks in Teams in GCC – Tasks in Teams gives you a new unified view of your personal and team tasks, powered by Planner and To Do. It consolidates your tasks across Microsoft To Do, Planner and Outlook. Roadmap ID: 68950
  • Microsoft Teams: Tasks for Information Workers in Teams in GCC – Tasks in Teams gives you a new unified view of your personal and team tasks, powered by Planner and To Do. Roadmap ID: 68951
  • Microsoft Teams: Meetings – Live Captions in additional languages – Today, Teams meetings live captions is available for English. We will enable live captions in additional spoken languages such as German, French, Spanish, Japanese, Brazilian Portuguese, and Dutch. Roadmap ID: 70593
  • Microsoft Teams: Simplified Global Notification Settings for GCC-High and DoD – Government users can now configure and customize their notification settings through a newly designed notification settings section. Roadmap ID: 70663
  • Microsoft Teams: Microsoft Teams meetings LTI application for educational learning management systems (LMS) – Microsoft Teams meetings LTI app helps educators and students easily incorporate Teams meetings into their Learning Management System course. Users can view past & upcoming meetings, schedule individual or recurring meetings, and join the Teams meetings related to the course all from within their LMS. Roadmap ID: 83072
  • Microsoft Teams: Security, compliance, and data protection capabilities for apps – For Microsoft 365 Certified Teams apps, admins can view security, compliance, and data protection capabilities in a new tab on the app’s detail page in the Teams Admin Center. Roadmap ID: 83077
  •  Microsoft Teams: Live transcript in Teams meetings in additional spoken languages – Meetings held in one of the supported languages now are supported by Live Transcript. We have expanded from just English (US) to include EN*, German, French (France), French (Canada), Spanish (Spain), Spanish (Mexico), Japanese, Portuguese (Brazil), Dutch, Chinese (simplified), Chinese (traditional), Hindi, Italian, Korean, Russian, and Swedish. Roadmap ID: 83615

🚂 ROLLING OUT

  • Revised in-meeting Share experience for GCC-High – The user interface for the in-meeting Share feature in Microsoft Teams has been redesigned to help presenters find their desired content more quickly and easily. Roadmap ID: 70561
  • Revised in-meeting Share experience in DoD – The user interface for the in-meeting Share feature in Microsoft Teams has been redesigned to help presenters find their desired content more quickly and easily. Roadmap ID: 70562
  • Microsoft Teams: Walkie Talkie on iOS (Preview) – Walkie Talkie, a push-to-talk experience that enables clear and secure voice communication over the cloud, enables teams to communicate instantly and always stay on the same page. Roadmap ID: 80915
  • Microsoft Teams: New assignment experience in modal window for Breakout Rooms – Enhanced UX for participant assignment. This includes new capabilities such as sorting participants and rooms and performing multiple selections and assignments to rooms. Roadmap ID: 81389
  • Microsoft Teams: Teams Device Management in GCC-High – Customers who have tenants in the GCCH environment can also manage their Teams devices from the Teams Admin Centre. Admins can now control the entire lifecycle of their Teams devices which include an increasing variety of supported device types – IP Phones, Collaboration bars, Teams displays, Teams Meeting Room devices. Roadmap ID: 81503

⌛ IN DEVELOPMENT

Release – September 2021

  • 🆕 Microsoft Teams: Chat supervisors can delete messages – This feature, designed with our Teams for Education users in mind, allows chat supervisors to delete inappropriate, off-topic, or other messages in a Teams chat. Roadmap ID: 82939
  • Room Remote for Microsoft Teams Room and collaboration bar – This experience in Teams mobile will provide meeting device controls, such as the ability to join and leave the meeting, mute and unmute the room, adjust audio volume, and turn cameras on and off. Roadmap ID: 65960
  • Meeting room capacity notifications for Microsoft Teams Room – Alerts in-room meeting participants if the room is over-capacity based on data defined in a room account. Not all cameras will support this feature. Roadmap ID: 65965
  • Microsoft Teams: Wired HDMI support on collaboration bar – Allows users to project a mirror image of their PC to a screen supported by a Teams device, through a HDMI cable. Roadmap ID: 66357
  • Whiteboard: Attribution – Participants in Teams and on Web can see who added content to the board. Roadmap ID: 66765
  • Whiteboard: Additional facilitation features – Participants in Teams and on Web will have additional facilitation features. Roadmap ID: 66766
  • Microsoft Teams: Reporting and scheduling APIs for meetings – Scheduling and reporting APIs will be available for integration into 3rd party applications. Roadmap ID: 66867
  • Microsoft Teams Include computer sound when sharing a Desktop or Window on Mac for GCC-High and DoD – You can now include your computer’s sound when you share a Desktop or Window on Mac. Roadmap ID: 67169
  • Microsoft Teams: Microsoft Graph API for Teams Export (Preview) – Enterprise Information Archiving (EIA) for Microsoft Teams is a key scenario for our customer as it allows them to solve for retention, indexing, e-discovery, classification, and regulatory requirements. Roadmap ID: 68731
  • Microsoft Teams: IP Based audio/video support for Microsoft Teams Rooms on Windows – IP based audio and video devices can be selected as sources in Teams Rooms making device installation and deployment easier, by avoiding long USB cable runs and use of USB extenders. Roadmap ID: 68737
  • Microsoft Teams: Teams casting for Microsoft Teams Rooms on Windows – For quick ad-hoc sessions that don’t necessarily require setting up a formal meeting, people can use Teams casting to wirelessly connect to a Teams Room running on Windows, and display content from their mobile phone. Roadmap ID: 68739
  • Microsoft Teams: Room Remote Microsoft Teams Rooms on Android – Control in-room meeting devices using a new experience on the Teams mobile app. Controls include: turn mic on/off, turn camera on/off, adjust audio, leave the meeting. Roadmap ID: 68744
  • Microsoft Teams: Power Automate actions for meetings, teams, channels, and chat – New Power Automate actions: “Create a Teams meeting”, “Send message to a channel”, “get @mention token”, “Create a team”, “Add users to a team”; New Power Automate triggers: “User leaves a team”. Roadmap ID: 68752
  • Microsoft Teams: New Power Automate entry points in-Teams – Users will soon be able to use message extensions and message actions to start building a Power Automate flow from a template. Roadmap ID: 68753
  • Microsoft Teams: Tasks in Teams in GCC – Tasks in Teams gives you a new unified view of your personal and team tasks, powered by Planner and To Do. It consolidates your tasks across Microsoft To Do, Planner and Outlook. Roadmap ID: 68950
  • Microsoft Teams: Tasks for Information Workers in Teams in GCC – Tasks in Teams gives you a new unified view of your personal and team tasks, powered by Planner and To Do. Roadmap ID: 68951
  • Top hits in Search Autosuggest – Top Hits introduces a new section at the top of the autosuggest suggestions where the most relevant results, across domains, for a given query are represented. Roadmap ID: 70563
  • Microsoft Teams : Follow or Mute Conversations in GCC – This feature will empower users to have finer controls at a conversation thread level within a channel. Roadmap ID: 70569
  • Microsoft Teams: Meetings – Live Captions in additional languages – Today, Teams meetings live captions is available for English. We will enable live captions in additional spoken languages such as German, French, Spanish, Japanese, Brazilian Portuguese, and Dutch. Roadmap ID: 70593
  • Microsoft Teams: Share to Microsoft Teams from Outlook – Send a copy of email messages or conversations, including attachments, into Teams chats and channels or start a Teams chat related to a specific email message. Share to Teams supports Outlook on the web, Outlook for Windows, and the new Outlook for Mac Preview. Roadmap ID: 70598
  •  Microsoft Teams: Live transcript in Teams meetings in additional spoken languages – Meetings held in one of the supported languages now are supported by Live Transcript. We have expanded from just English (US) to include EN*, German, French (France), French (Canada), Spanish (Spain), Spanish (Mexico), Japanese, Portuguese (Brazil), Dutch, Chinese (simplified), Chinese (traditional), Hindi, Italian, Korean, Russian, and Swedish. Roadmap ID: 83615
  • Microsoft Teams: Disable/Enable all Attendees’ Video GCC-High and DoD – Ability in GCC-High and DoD to disable and enable video for all attendees before or during a Microsoft Teams meeting. Roadmap ID: 80221
  • Microsoft Teams: Disable/Enable a Single Attendee’s Video – Ability to disable and enable a single attendee’s video in a Microsoft Teams meeting. Roadmap ID: 80224
  • Microsoft Teams: Share to Teams from Outlook – Share to Teams from Outlook allows you to send a copy of email messages or conversations, including attachments, into Teams chats and channels. Roadmap ID: 80721
  • Microsoft Teams: Walkie Talkie on iOS (Preview) – Walkie Talkie, a push-to-talk experience that enables clear and secure voice communication over the cloud, enables teams to communicate instantly and always stay on the same page. Roadmap ID: 80915
  • Microsoft Teams: Power Automate templates to be added to teams templates – Team templates enable end users to create the right team with predefined channels and preinstalled apps. Roadmap ID: 81090
  • Microsoft Teams: Reply to a specific message – When chatting in Teams, you will be able to reply a specific message. The original message will be quoted in the reply text box, helping everyone in the chat to more easily understand the message’s context. Roadmap ID: 81113
  • Microsoft Teams: New assignment experience in modal window for Breakout Rooms – Enhanced UX for participant assignment. This includes new capabilities such as sorting participants and rooms and performing multiple selections and assignments to rooms. Roadmap ID: 81389
  • Microsoft Teams: MacOS native notifications in Teams for DoD – Users can now choose to get Microsoft Teams notifications, either via Teams built-in notifications or via macOS native notifications. Roadmap ID: 86067
  • Microsoft Teams: Live Transcript in Channels Teams Meetings – Channel meetings in Teams are now supported by Live Transcript. Roadmap ID: 81809
  • Microsoft Teams: New Search experience in mobile app – When searching in the Teams mobile app, you will receive suggestions as you type. You will also be able to scroll to past and future dates in the calendar using a date picker. Roadmap ID: 70755
  • Microsoft Teams: Mobile app visual update – The Teams mobile app will get a new visual look and feel that delivers new headers, icons, and styling along with the ability to automatically switch to dark theme when you set your device to dark. Roadmap ID: 70756
  • Microsoft Teams: Organize chats in mobile app – In the Teams mobile app, you will be able to pin chats and filter the Chat list. Roadmap ID: 70757
  • Microsoft Teams: Emoji library and GIFs in mobile app – In the Teams mobile app, there will be an expanding library of emojis, and the ability to trim GIFs directly in the app. Roadmap ID: 70758
  • Microsoft Teams: Interoperability with Azure Communication Services – Use Azure Communications Services to deliver a better customer experience by easily connecting users of a custom-built app with users on Microsoft Teams via voice, video, or chat. Roadmap ID: 70770
  • Microsoft Teams: Teams user usage report in Teams client – The Teams user usage report provides users a view into their Teams activities and usage. A user can generate insights and metrics on a per-team and cross-team basis to understand their interaction with peers and across the organization. Roadmap ID: 70773
  • Microsoft Teams: Co-author in encrypted docs using Office Apps – Multiple users can now simultaneously edit an Office document that has been encrypted using Microsoft Information Protection, including using AutoSave. Roadmap ID: 70782
  • Microsoft Teams: Task publishing editing – Corporate teams can now edit published tasks without having to recall the entire task list. Roadmap ID: 70785
  • Microsoft Teams: Answer Meeting Nudges with Video for iOS – This feature brings the ability for iOS devices to automatically answer incoming meeting nudges with their video on. The feature availability is controlled through AutoAnswerwithVideo. Roadmap ID: 82325
  • Microsoft Teams: Admin notifications for Custom app submissions – When a developer submits a custom app for IT admin approval, admins will receive a notification in a dedicated Teams channel, so they can review and take next steps to publish the app. Roadmap ID: 82512
  • Microsoft Teams: Suggested Replies in chats – Suggested replies presents users with up to three recommended responses to choose from in the context of a chat. This functionality will be enabled by default for teachers and faculty, and completely disabled for all students. Roadmap ID: 82877
  • Microsoft Teams: Music on Hold for Consult/Transfer – Music on Hold for Consult/Transfer scenarios ensures that users placed on hold will hear music while consultation and transfer occurs, ensuring that the caller knows that the call is still active. Roadmap ID: 82957
  • Microsoft Teams: Dual-tone multi-frequency support for VDI (Citrix only) – Dual-tone multi-frequency (DTMF) for Teams on Citrix dial an outside number via dialer. Call is connected but DTMF is not sent. For example, if user is trying to use Teams to join a Teams meeting by dialing the PSTN number, the conference ID cannot be entered. Roadmap ID: 83014
  • Microsoft Teams: Missed Activity Email in DOD – Missed activity email enables the user to stay on top of their Microsoft Teams notifications. A missed activity email is generated in case a user is away from Microsoft teams and has not reviewed their notifications. Roadmap ID: 83061
  • Microsoft Teams: Direct app purchases and invoice billing support in Teams Admin Center – Admins can complete orders for paid app licenses directly within Teams Admin Center. In addition, invoice billing is a new supported payment method. Roadmap ID: 83144
  • Microsoft Teams: Speaker Attribution in Live Transcript in Teams Meetings in GCC Clouds – Teams Meetings in GCC clouds will now have live transcript utterances attributed to the speaker of the utterance. Roadmap ID: 83382
  • Microsoft Teams: Lower all raised hands for GCC-High and DoD – Meeting organizers and presenters will see an option to lower all raised hands from the participant pane. Roadmap ID: 83487
  • Microsoft Teams: Music Mode for Teams – In music mode, we support up to 32 kHz sampling rate mono audio at 128 kbps, and optimize our internal audio processing settings for reproducing music with high fidelity. Teams will automatically adjust the audio bitrate based on the available bandwidth, going down to 48 kbps while still delivering good music quality. Roadmap ID: 83520
  • Microsoft Teams: Prompt to set Meeting Options for Large Teams Meetings in Outlook for Windows in GCC – Teams users in Outlook for Windows will be prompted to set meeting options when organizing Teams meetings for 40 or more participants or 10 or more distribution lists. Roadmap ID: 78699
  • Microsoft Teams: Prompt to set Meeting Options for Large Teams Meetings in Outlook for Windows in GCC-High – Teams users in Outlook for Windows will be prompted to set meeting options when organizing Teams meetings for 40 or more participants or 10 or more distribution lists. Roadmap ID: 78700
  • Microsoft Teams: Support open-text question poll for Teams meeting – For Microsoft Forms poll in Teams meeting, there is a new question type – open text. You can use this question type to collect attendees’ open-ended information before/during/after the meeting. Roadmap ID: 79464
  • Microsoft Teams: Data reports for polls after Teams meeting – If user has used Forms poll in a Teams meeting, a summary report for all the polls used in this meeting will be generated and shared with meeting organizer and presenters. Roadmap ID: 79498
  • Microsoft Teams: Data reports after Teams meeting class – If a teacher has used Forms polls in a Teams meeting class, a summary report for all the polls used in this meeting will be generated and shared with teacher. Roadmap ID: 79499
  • Microsoft Teams: Day view in calendar on iOS and Android – View all meetings and events for the day to easily see when you’re available or busy. Roadmap ID: 80106
  • Microsoft Teams: Teams Device Management in GCC-High – Customers who have tenants in the GCCH environment can also manage their Teams devices from the Teams Admin Centre. Admins can now control the entire lifecycle of their Teams devices which include an increasing variety of supported device types – IP Phones, Collaboration bars, Teams displays, Teams Meeting Room devices. Roadmap ID: 81503
  • Microsoft Teams: Public Preview: Teams follow Office preview – Coming up in June 2021, not only can users be opted-in to use Teams Public Preview, but IT admins can even configure Teams users preview state to follow Office preview state. All of this functionality will be accessible from the Teams Admin Center. Roadmap ID: 81704
  • Microsoft Teams: Whiteboard integration with Assignments – Digital whiteboards give educators and students a canvas to spark creativity and collaboration. Now, educators can include a Whiteboard as reference material or the content type of a Teams assignment. Roadmap ID: 82020

Release – October 2021

  • 🆕 Microsoft Teams: Enable Teams users to purchase Teams apps through the Teams store – Microsoft Teams users have now the ability to purchase third-party Teams app subscriptions from the Teams store. Roadmap ID: 83502
  • 🆕 Microsoft Teams: Microsoft Teams panels Check in notifications to Microsoft Teams Rooms – For Teams panels deployment with Microsoft Teams Rooms, when this feature is enabled, checking in on Teams panels will send a notification to the Teams Rooms front of room display to inform the people in the room that their meeting room reservation is over and others are waiting for the room outside. Roadmap ID: 86719
  • Microsoft Teams: Team Templates maintenance – Enhancements to Team Templates content with additional apps and channels in the Microsoft-provided predefined team structure. Roadmap ID: 85917
  • Microsoft Teams: Tags are available in DOD – Tags are available in DoD. Tags in Teams let users quickly reach a group of people without having to @mention or type out everyone. Roadmap ID: 81096

Release – November 2021

  • 🆕 Microsoft Teams: Support of live captions for Teams on VDI for Citrix – Teams users on virtual desktop infrastructure (VDI) will be able to use live captions. Live captions display the text version of the audio during the call. Roadmap ID: 86774

Microsoft 365 roadmap roundup – 30th August 2021

Use these buttons to switch between each product’s roadmap updates.

Teams

  • Launched (2)
  • Rolling out (7)
  • In development (16)

🍾 LAUNCHED

  • Microsoft Teams: Live Events in GCC-High, and DoD – Soon, you will be able to use Live Events in GCCH and DoD for your needs. Roadmap ID: 82954
  • Microsoft Teams: Dual-tone multi-frequency support for VDI (Citrix only) – Dual-tone multi-frequency (DTMF) for Teams on Citrix dial an outside number via dialer. Call is connected but DTMF is not sent. For example, if user is trying to use Teams to join a Teams meeting by dialing the PSTN number, the conference ID cannot be entered. Roadmap ID: 83014

🚂 ROLLING OUT

  • Microsoft Teams Include computer sound when sharing a Desktop or Window on Mac for GCC-High and DoD – You can now include your computer’s sound when you share a Desktop or Window on Mac. Roadmap ID: 67169
  • Microsoft Teams: Reading Progress in Teams for Education – reading practice and review software – Reading Progress is a reading practice and fluency experience that is part of Microsoft Teams for Education Assignments. Roadmap ID: 72240
  • Yammer and Microsoft Teams for Business: Customize branding & link previews – Microsoft Teams admins can customize the branding for the Yammer Communities app in Teams with their preferred app logos, naming, accent colour, and more. With this Communities app, users see a rich Yammer preview in chats and channel conversations when the user pastes a URL of a conversation from a public Yammer community. Roadmap ID: 82243
  • Microsoft Teams: Reporter and Side-by-Side Presenter Mode in desktop or window sharing – Two new presenter modes are now coming available. Reporter places content as a visual aid above your shoulder like a news story. Side-by-side displays your video feed next to your content. You can now select a mode that fits your needs and promotes a more engaging presentation and consumption experience. Roadmap ID: 83371
  • Microsoft Teams: Lower all raised hands for GCC-High and DoD – Meeting organizers and presenters will see an option to lower all raised hands from the participant pane. Roadmap ID: 83487
  • Microsoft Teams: Disable/Enable all Attendees’ Video GCC-High and DoD – Ability in GCC-High and DoD to disable and enable video for all attendees before or during a Microsoft Teams meeting. Roadmap ID: 80221
  • Microsoft Teams: Disable/Enable a Single Attendee’s Video – Ability to disable and enable a single attendee’s video in a Microsoft Teams meeting. Roadmap ID: 80224

⌛ IN DEVELOPMENT

Release – September 2021

  • 🆕 Microsoft Teams: 2×2 video in Gallery view for web meetings in Safari – Gallery view now can show up to 4 participant videos during a meeting in Safari browser. Roadmap ID: 86513
  • Microsoft Teams: Integrated CART Captioning in Meetings – Users will now be able to view captions coming from a CART provider (real-time captioning) within the Microsoft Teams meeting window. Roadmap ID: 70588
  • Microsoft Teams: Music on Hold for Consult/Transfer – Music on Hold for Consult/Transfer scenarios ensures that users placed on hold will hear music while consultation and transfer occurs, ensuring that the caller knows that the call is still active. Roadmap ID: 82957
  •  Microsoft Teams: New default for Teams notification style – 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: 83062
  • Microsoft Teams: Music Mode for Teams – In music mode, we support up to 32 kHz sampling rate mono audio at 128 kbps, and optimize our internal audio processing settings for reproducing music with high fidelity. Teams will automatically adjust the audio bitrate based on the available bandwidth, going down to 48 kbps while still delivering good music quality. Roadmap ID: 83520
  • Microsoft Teams: Guest access in DoD – Teams now supports Guest Access between tenants inside the DoD Cloud. Roadmap ID: 83676
  • Microsoft Teams: Sharing device audio on iOS and Android for GCC High and DoD – Include device audio when sharing on iPhones/iPads and Android devices. Roadmap ID: 85005
  • Microsoft Teams: Microsoft Teams Rooms on Surface Hub – This next generation of Teams on Surface Hub has been redesigned to bring your favourite features from the desktop and Microsoft Teams Rooms into the meeting space. Roadmap ID: 85447

Release – October 2021

  • 🆕 Microsoft Teams: Export Teams list from Teams Admin Center – Administrators can export Teams list as a csv file from Teams admin center. Roadmap ID: 85704
  • 🆕 Microsoft Teams: Anonymous meeting join across clouds – Microsoft are enabling anonymous meeting join in other clouds anonymously from your Teams desktop app (across clouds). First, Commercial and GCC customers will be able to join meetings in GCC-High and DOD clouds. Roadmap ID: 86311
  • 🆕 Microsoft Teams: Multi-Window support for VDI – Azure Virtual Desktop – Users will be able to view meetings and calls in separate windows from the main Microsoft Teams client. Additionally, meeting and call controls such as mute, video, chat, leave and others will now be located at the top of the meeting window so that they are always available and never block the underlying content. Roadmap ID: 86548
  • 🆕 Microsoft Teams: 2×2 video in Gallery view for web meetings in Safari – Gallery view now can show up to 4 participant videos during a meeting in Safari browser. Roadmap ID: 86906

Release – November 2021

  • Microsoft Teams: Co-organizer Meeting Role – Organizers will now be able to share control by assigning the new “Co-organizer” role to people they invite. Roadmap ID: 81391

Release – December 2021

  • Microsoft Teams: Support for breakout rooms for Microsoft Teams Rooms on Android – Ability to consume breakout rooms feature in Teams meetings. Roadmap ID: 68745
  • Microsoft Teams: Direct guest join for Zoom and Webex meetings on video-enabled certified Teams Android devices – Direct guest join (aka Third-party meeting join) is an ability to join meetings of other meeting providers from Microsoft Teams. Third-party meetings will appear on the Teams calendar and users will be able to join them the same way they join any other Teams meeting. This functionality will be limited to video-enabled certified Teams Android devices and will support only Zoom and Webex meetings. Roadmap ID: 81482

Release – March 2022

  • Microsoft Teams: Co-organizer Meeting Role for GCC-High and DoD – Organizers will now be able to share control by assigning the new “Co-organizer” role to people they invite. Roadmap ID: 81676

Microsoft 365 monthly update – July 2021

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: Boost SharePoint news, collapsible sections, custom list templates, SharePoint Server Subscription Edition

Boost SharePoint news

The SharePoint news service now lets you can prioritize important news and announcements, so they appear at the top of employee news feeds across Microsoft 365. You can boost the visibility of a news article for a set time, until an employee has seen your content, or until a viewer has seen the item in their feed a set number of times.

  • You can boost news posts from organization news sites only.
  • Boosted news posts are currently shown in auto news digests only.
  • A maximum 10 news posts can be boosted at one time.
  • You must have edit permissions on the organization news site to boost news posts.
thumbnail image 2 captioned Boost important news and announcements from your organization to prioritize their visibility and increase readership.
Boost SharePoint news.

Find out more: Boost news from organization news sites

Collapsible sections

Collapsible sections allow users to show page in an accordion view (collapsed or expanded) or as tabs.

NOTE: The accordion view will be collapsed by default, but can be set to show expanded.

thumbnail image 3 captioned Make SharePoint page sections collapsible - supplying a section display name and choosing its default display (expanded or collapsed).
Collapsible sections on modern pages in SharePoint.

Find out more: Roadmap ID 67147

Custom list templates

Microsoft Lists now supports custom list templates! You can create and manage custom list templates using Microsoft PowerShell – leveraging the Add-SPOSiteScript cmdlet. When users create new lists, they can select one of your custom list templates from the new “From your organization” tab. This new tab will appear next to the “From Microsoft” tab that showcases the out-of-box ready-made templates from Microsoft.

The "Contoso customer tracking" template on the "From your organization" tab of the Create a list dialog box.
Custom list templates in Microsoft Lists.

Find out more: Creating custom list templates

SharePoint Server Subscription Edition

SharePoint Server Subscription Edition represents the next step in the SharePoint Server journey emphasizing the specific needs of our on-premises customers. This new way of staying up-to-date with SharePoint Server means new levels of reliability and performance, delivering features and capabilities that simplify administration, protect communications and information.

thumbnail image 8 captioned SharePoint Server Subscription Edition [Preview] information.
SharePoint Server Subscription Edition.

Find out more: A new day for SharePoint Server


Teams

In Teams: Find recordings based on what was said, lock meetings, slide translate, auto recording, video gallery paging, org-wide backgrounds, real-time telemetry, related content for mobile, hard audio mutes PSTN, Human Interface Device support, call transfer, speed dial, emoji picker, immersive reader, inline message translation, Headspace integration, share-to-stage support, app risk evaluation, multi-geo support, safe links

Teams (Education)

Teams (Government)

Teams

Find a meeting recording based on what was said

You can now find meeting recordings in Microsoft Search based on the meeting transcript. This feature is available to all users by default and makes it easier to find videos in Microsoft 365. You can access this feature through the search bar in Teams you use to find other file types.

Find out more: Teams cloud meeting recording

Lock a meeting from additional joins

You can now choose to lock their meetings to prevent subsequent join attempts. Anyone attempting to join a locked meeting from any device is informed with a message that they are not able to join as the meeting is locked. This helps avoid distractions from late joiners during the meeting. This feature is currently available in Desktop app only.

thumbnail image 2 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Lock a meeting from additional joins.

Find out more: Manage meeting settings in Microsoft Teams

Slide translate in PowerPoint Live in Teams

Make your slides more inclusive with slide translate in PowerPoint Live in Teams. This private setting allows you to see a personalized view of the slide where text is translated in your chosen language. Now you can better understand the presented content privately. This feature supports 19 languages with more to come.

thumbnail image 3 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Slide translate in PowerPoint Live in Teams.

Find out more: Share PowerPoint slides in a Teams meeting

Meeting auto recording

Meeting organizers are now able to set a single meeting occurrence or series to auto-record by enabling the “Record automatically” setting from Meeting Options. The meeting automatically starts recording once the first participant from the same organization joins the meeting. The recording is saved to initiator’s OneDrive (privately scheduled meetings) or SharePoint (channel meetings).

This feature is available in Desktop and Mobile and not available to an A1 user.

thumbnail image 4 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Record meetings automatically in Microsoft Teams.

Find out more: Manage meeting settings in Microsoft Teams

Paging on video gallery

When you are in gallery view mode, and there are more videos than what can be shown at once on the meeting stage, navigation controls < and > now appears below the Video Gallery. You can use these controls to view more video participants. The maximum number of videos on the meeting stage can vary depending on your device configuration and internet bandwidth.

thumbnail image 5 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Paging on video gallery in Microsoft Teams.

Find out more: Using video in Microsoft Teams

Organisation wide backgrounds

You can now tailor your Teams meetings background to your organization. To enable this feature, simply upload images in the Microsoft Teams Admin Center under Meeting policies and they are available to all your users. You can add up to 50 images.

NOTE: Organization-wide backgrounds is now temporarily available and will require an Advanced Communications license when it becomes generally available by the end of the year. 

thumbnail image 6 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Org-wide backgrounds in Microsoft Teams.

Find out more: Change your background for a Teams meeting

End user real-time telemetry for meetings

Call health panel provides Teams end-users functionality that helps identify issues during a Teams meeting or a VOIP call. This empowers your users with diagnostics to investigate audio, video, content sharing or network related issues.

The real-time metrics are updated every 15 seconds, providing the ability to trace issues as they occur.

thumbnail image 7 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
End user real-time telemetry for meetings.

Find out more: Monitor call and meeting quality in Teams

Related meeting content on mobile

Related Content makes meetings more effective by providing you with important information from your mailboxes, OneDrive for Business, and SharePoint sites. This helps you prepare before meetings by offering content you haven’t had a chance to read or may want to revisit. You can find this content on the Meeting Details page.

thumbnail image 8 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Related Content for Teams Meetings for mobile.

Find out more: Set up your Teams mobile apps

Hard audio mute includes PSTN attendees in meetings

Meeting presenters and organizers can now prevent PSTN participants from unmuting during the meeting and enable specific attendees to unmute when they raise their hand. The PSTN participant can request to speak by raising their hand in a meeting via dial-pad command (press *5).

Find out more: Manage attendee audio and video permissions in Teams meetings

Support for Human Interface Devices on Windows Virtual Desktop

Now you can connect external devices like a headset or mouse to interact in Teams on the Windows Virtual Desktop platform. For example, if you have a mute or unmute button on your headset, the controls are now recognized when using it in a Teams meeting in WVD.

Find out more: What is Azure Virtual Desktop?

Transfer Calls between desktop and mobile

Teams makes it easy to place and receive calls from several different endpoints, including desktop and mobile devices, but sometimes you need to move locations or devices to finish your call. The new endpoint transfer capability allows you to seamlessly move your calls between different devices, such as from your laptop to mobile phone, without any interruption in call service or quality.

thumbnail image 9 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Transfer Calls between desktop and mobile.

Find out more: Join a Teams meeting on a second device

Speed dial for mobile

Calling users on mobile devices can now access their Speed Dial contacts that were available on Mac, Windows and Teams devices. You can also add or remove speed dial contacts. This feature gives mobile users one tap access to reach their most important contacts.

Teams-Contacts button-435

Find out more: First things to know about calls in Microsoft Teams

Expanded emoji picker

Now with more than800 emojis, select a category and easily find the emoji you need and use the skin tone selector to pick an emoji that better represent you. Quickly add emojis directly when composing a chat, use the short code picker to add emojis using text.

thumbnail image 14 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Expanded emoji picker in Teams.

Find out more: Send an emoji, GIF, or sticker in Teams

Immersive reader support for Mobile

Immersive Reader, which uses proven customization techniques to support reading across ages and abilities, is coming to Teams iOS and Android apps. You can now hear posts and chat messages read aloud using Immersive Reader on the Teams mobile apps. This functionality was previously available only on the web and desktop apps.

Select Immersive Reader from the More options menu.
Immersive reader now available in the Teams mobile app.

Find out more: Use Immersive Reader in Microsoft Teams

Inline Message Translation in channels for Android and iOS

Inline message translation in Channels lets you translate Channel posts and replies into your preferred language. To translate a message, press-and-hold the channel post or reply and then select “Translate”. The post/reply will be translated to your UI language by default. If you want to change the translation language, go to Settings > General > Translation.

Find out more: Translate a message in Teams mobile

Headspace integration with Microsoft Viva Insights

A curated set of guided meditations and mindfulness exercises from Headspace are now available in the Viva Insights app in Teams to help you start your day grounded, relax your mind before a big presentation, or disconnect from work in the evening.

Headspace integration with Microsoft Viva Insights.

Find out more: Mindfulness content from Headspace

Share-to-stage support for meeting apps

Developers can now configure their Teams meeting apps to use the “main stage” – enabling several collaboration scenarios. This integration allows the app content from the meeting side panel to take full screen and allow users to interact with it. 

thumbnail image 15 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Share-to-stage support for meeting apps.

Find out more: Configure your app for meeting scenarios

App risk evaluation

Teams admins are now able to view the security, compliance, and data privacy details for apps coming from Microsoft Cloud App Security. This helps Teams admins save time on security reviews and enable a more focused selection-based security specifications, resulting in increased app quality.

Find out more: Ensuring security of your Microsoft Teams apps with Microsoft Cloud App Security

Multi-Geo support

To help customers meet data residency requirements, Microsoft 365 Multi-Geo has been extended to include Microsoft Teams. This allows organizations to specify where their Teams core customer data sits, down to the team and end user. 

Find out more: Multi-Geo capabilities in Microsoft Teams

Safe links in Teams

Safe links are now available to protect users in Microsoft Teams. You can enable or disable Safe Links protection for Microsoft Teams within Safe Links policies. Specifically, you use the Select the action for unknown or potentially malicious URLs within Microsoft Teams setting.

Find out more: Safe Links settings for Microsoft Teams

Teams (Education)

Class Teams from Canvas

Educators can now create class teams based on the enrolment roster of their courses in Canvas. Each class team will have the appropriate user roles and students and educators can navigate to their respective class teams directly from their Canvas courses using desktop, mobile, or web platforms.

thumbnail image 16 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s New in Microsoft Teams | July 2021
Class Teams from Canvas.

Find out more: Teams integrations with Canvas and other Learning Management Systems

Group assignments

With the new group assignment feature, groups of students can work together to create, collaborate, and submit one assignment for the whole group. Educators can give individual comments and grades or group grades, and all students in the group will receive credit. This makes it easy to encourage student collaboration and for the educator to grade group work. 

Group assignments in Teams for Education.

Find out more: Assignments and grading class work

“Return for edit” Assignment option

Now, educators can return an assignment to students for edits. This way it’s easy to share feedback and allow students to learn from and incorporate that feedback into the original assignment. If you’re an educator just select the More options next to return and select “Return for edits”.

Find out more: Grade, return, and reassign assignments

Filter assignments by class in main assignment view

Now educators and students can filter their Assignments by the class in the main assignment view. It’s a small tweak, but a great one if you like things organized and visible by class.

Find out more: Assignments in Teams for Education

Teams Advisor Education deployment

For IT admins looking to set up Microsoft Teams in their tenants for the first time, now there is an education tailored plan in Teams Advisor. The Teams Advisor helps IT plan their overall deployment, and helps bring the project team together to create a cohesive strategy to deploy Teams in their education institution.

Find out more: Use Advisor for Teams to help you roll out Microsoft Teams

Education policy wizard now automatically incorporates new features and policies

IT admins can now easily apply education tailored policies for a secure learning environment for students, educators and staff in few clicks. With the new improvements, whenever a new feature is added to Teams, the appropriate policy for that feature will be automatically added by default without any admin’s intervention.

Find out more: Introducing new policy wizard to easily apply admin policies in Teams for Education

Cortana for Education

Cortana voice assistance is now available in the Microsoft Teams for Education mobile app. With this new capability, you can perform a variety of tasks with the click of the microphone button and a voice command such as check your class schedule, join a class and much more.

Find out more: Cortana voice assistance in Teams

Suggested Replies in chats now available for educators

Now, educators using the Teams mobile app can easily see up to three recommended responses to choose from while in chat, helping you save time and respond quickly. This is enabled by default for educators and faculty and disabled for all students.

Find out more: Use suggested replies to respond to messages without typing

Teams (Government)

These features currently available to Microsoft’s commercial customers in multi-tenant cloud environments are now rolling out to our customers in US Government Community Cloud (GCC), US Government Community Cloud High (GCC-High), and/or United States Department of Defense (DoD).

Virtual Breakout Rooms – Breakout rooms allow meeting organizers to divide the meeting into smaller groups to facilitate discussions and brainstorming sessions. 

Guest Access – You can invite users in other DOD tenants to collaborate on documents in Teams channels, resources, chats, and applications while still maintaining control over your data.

Together Mode for Teams Rooms – Together Mode for Teams Rooms uses AI segmentation technology to digitally place participants in a shared background, making it feel like you’re sitting in the same room with everyone else in the meeting or class. Available in GCC-High.

Teams Meetings Auto Recording – Meeting organizers are now able to set a single meeting occurrence or series to auto-record by enabling the “Record automatically” setting from Meeting Options. Available in GCC.

Live reactions in Teams Meetings – All attendees can now use emojis to react during a meeting. Available in GCC and GCC-High

End user real-time telemetry for meetings – Call health panel provides Teams end-users functionality that helps identify issues during a Teams meeting or a VOIP call. Available in GCC, GCC-High, and DOD.

Spotlighting multiple users in a meeting – Organizers and presenters can now spotlight up to 7 participants simultaneously during meetings. Available in GCC.

Organization-wide background – You can now tailor your Teams meetings background to your organization. Available in GCC.

Live Events with Live Caption – You can now schedule and host a live event in the DOD environment – broadcasting video and meeting content to large online audiences. Available in DOD

Large meeting support – Hold interactive meetings and webinars with more attendees—up to 1,000 people, including chats and polls. Available in GCC-High and DOD.

Windows 10 Native Notifications in Teams – You can now choose the style of your notifications: built-in Teams or Windows native notifications. Available in GCC.

Chat preview notification settings – Now, you can change your settings and control whether the message previews shows up on your screen. Available in GCC.

Missed activity email – You can now continue and monitor your Teams’ notifications via email. Available in DoD.

Device management capabilities – Device management capabilities in Teams admin center are now included in the GCC-High environment.

Tags – Tags in Microsoft Teams let users quickly and easily connect with a subset of people on a team. Available in GCC-High. 


Power Apps

In Power Apps: Command designer with Power Fx (preview), custom pages, performance insights, Portals & Power BI enhancements, multi-table lookups, pricing changes

Command designer with Power Fx (preview)

You can now customize command bars in model-driven apps without code! These new capabilities play a major role in the convergence of canvas and model-driven apps. These new capabilities are built on a new, modern infrastructure that’s conducive to both model-driven and canvas app technologies and will scale into the future. Key improvements include:

  • Enhances custom pages (or the convergence of canvas and model-driven apps), open custom pages as dialogs, trigger cloud flows from a button
  • Power Fx support for visibility and action logic, or use JavaScript for advanced logic
  • Command designer simplifies customization – whether low-code or pro-code
  • Better ALM support along with standardized localization and presence in the solution interface
  • Better app level control – commands are applied to individual apps
  • Simple, flat data model
  • Classic commands remain supported, Apps can run both classic + modern commands side by side

Commanding GIF
Command designer with Power Fx (preview).

Find out more: Announcing command designer with Power Fx (preview)

Custom Pages for converging model-driven apps and canvas apps

Custom pages are now in public preview. A custom page can be used in places where all pages are supported including main area, dialogs, and the new app side pane. This allows scenarios like a pixel perfect landing page with data pulled from across the organization, data driven pages that use a record’s data to change the experience, dialog designed to optimize specific business actions, and productivity tools that support the main tasks for the app.

App designer live preview of custom page and runtime navigation
Custom pages.

Find out more: Announcing public preview of Custom Pages for converging model-driven apps and canvas apps

Performance Insights (preview) for Model-driven apps

Performance Insights, now in preview is a self-service tool for enterprise app makers that analyzes runtime user data and provides a prioritized list of recommendations to help improve the performance of Model-driven apps. With this feature, raw telemetry data is converted into actionable work items for you to tackle.

Performance Insights (preview) for Model-driven apps.

Find out more: Introducing Performance Insights (preview) for Model-driven apps

Power Apps portals/ Power BI integration enhancements

Power Apps portals has native support for Power BI reports and dashboard. Portals with version 9.3.4.x have additional support for more Power BI functionality, including:

Portals with version 9.3.6.x or later support the following capabilities:

  • Azure AD guest user support for “Embed for organization” access type (i.e., authentication_type:”AAD”)
Power Apps portals/ Power BI integration enhancements.

Find out more: Power Apps portals and Power BI integration enhancements

Multi-table lookups (preview)

Multi-table lookups are now available in preview for use via API. Multi-table lookups (also sometimes known as polymorphic lookups) allow the creation of a lookup in one table that looks up records in multiple other tables at once.

With multi-table lookups, you can perform a lookup on 2 or more tables at the same time and locate the record you want from the referenced tables. For the current preview:

  • Lookups can be constructed and managed through API only
  • Model driven apps currently provide the best experience with the lookups

Find out more: Multi-table Lookups

Updates to Power Apps pricing and licensing

Microsoft have announced the following changes to Power Apps pricing and licensing coming into effect on October 1, 2021:

  • The Power Apps per user plan will be priced at $20 per user/month, a decrease from the previous price of $40 per user/month. The plan will be available across Microsoft’s commerce channels – Volume Licensing (VL), Cloud Solution Provider (CSP) and web direct – without license minimums or other purchase requirements. Plan entitlements remain unchanged, including the ability for users to run unlimited apps and portals.
  • The Power Apps per app plan will be priced at $5 per user/app/month, a decrease from the previous price of $10 per user/app/month. Like the per user plan, the per app plan will also be available across the same commerce channels without license minimums or other purchase requirements.

Additionally, Microsoft are simplifying entitlements for the per app plan by providing users with the ability to run one app or access one portal, in contrast with the current entitlement of two apps and one portal. This approach more directly aligns with the plan’s intent of providing flexibility for customers seeking to license users one app at a time. Customers with existing per app plan subscriptions purchased prior to Oct 1, 2021 will maintain the current entitlement for the duration of their agreement term.

Find out more: Pricing and licensing updates coming to Power Apps


Power Automate

In Power Automate: Desktop update, new connectors via independent publisher program, 7 new connectors, AI Builder update

Power Automate Desktop July 2021 update

The July 2021 update of Power Automate Desktop has been released and this month’s offering includes the following new features and updates:

  • Silent registration for machines
  • Automatic detection of Windows proxy settings
  • Ability to remove unused UI elements and images from a flow
  • Introduction of new action ‘Take screenshot of UI element’
  • Improvement of the action ‘Convert datetime to text’
  • The ‘Set variable’ action now supports multi-line text input
Take screenshot of UI element
Take a screenshot of a UI element in Power Automate Desktop.

Find out more: Power Automate Desktop July 2021 update

New connectors through the Independent Publisher connector program

Independent Publisher connectors are connectors developed, tested, published, and supported by connector developers that are independent from the end service or API. Independent Publishers include Microsoft employees, MVPs, developers, and other community members focused on helping the community make the best use of Microsoft Power Platform connectors. 

As part of the new Independent Publisher connector program, you can view and use connectors to the following services: Airtable, HubSpot Marketing, Jira Search plus more.

Independent Publisher connector program.

Find out more: New connectors through the Independent Publisher connector program

7 new connectors

7 new connectors were released in July 2021 for Power Automate, including:

  • Amazon S3 – Amazon S3 Connector provides connectivity to the Amazon S3 API, enabling processes to interface with Amazon S3 to store objects, and build applications that require internet storage.
  • Amazon SQS – Amazon SQS connector will connect to the Amazon Simple Queue Service (SQS) Service provided by Amazon Web Services, allowing queue management, push and get messages.
  • CardPlatform – CardPlatform allows users to send Adaptive Cards to Outlook inboxes, other email platforms, as well as service desks and ServiceNow. 
  • Elfsquad Data – Elfsquad CPQ enables sellers, or even end-customers to configure complex products. Using the Elfsquad Data connector you can easily integrate your internal IT-systems with Elfsquad.
  • Alemba ITSM Azure Connector – Alemba Service Manager is a leading IT Service Management (ITSM) platform that leverages the Azure ecosystem to provide product extensibility and enhanced customer experiences.
  • Lasso X – Lasso X makes it easy to connect to Danish public data sources, delivering information about companies and their finances, properties, ownerships, and much more. 
  • IN-D Aadhaar Number Masking – Use IN-D Aadhaar Number Masking connector in your process to eliminate risks and ensure compliance by redacting first eight digits of Aadhaar Number and QR Code from Aadhaar images.

Find out more: Introducing Seven New Connectors

AI Builder July 2021 update

Several new capabilities were added in this months AI Builder update, including:

  • Invoice processing – Read and save information from invoices which now also include the ability to extract line items.
  • Receipt processing – Read and save information from receipts, with support now for sales receipts from Australia, Canada, United States, Great Britain, and India.
  • Identity document reader – Read and save information from identity documents.
Invoice processing is now generally available in AI Builder.

Find out more: AI Builder July 2021 update


Power BI

In Power BI: Admin APIs to Determine Access Rights, visualise SharePoint lists now GA, July 2021 Feature Summary, PivotTable refresh, Streaming dataflows in Power BI premium, On-premises data gateway July 2021, free virtual workshops

Admin APIs to Determine Access Rights (Public Preview)

Now in Public Preview, a suite of new admin APIs that provide much-enhanced visibility into user access and permission levels. These new APIs allow you to programmatically retrieve user and permission information for most Power BI assets (reports, dashboards, datasets, dataflows, workspaces, and capacities), or asset permission for any user or security group. 

Additionally, Microsoft are enhancing the read-only scanner admin API by including user permission information in the scan results. With these versatile new tools, you will be able to easily produce access reports for various Power BI assets on demand.

Find out more: Announcing Admin APIs to Determine Access Rights (Public Preview)

Power BI – SharePoint list visualisation available to all users

A few months ago Microsoft launched a new Power BI integration for visualizing SharePoint lists. This feature is now available to Standard release users and is now accessible to everyone! This experience empowers SharePoint list and Microsoft List users to easily explore your data. With just a couple of clicks, you’re able to go from looking at a list of data to interacting with an auto-generated report. You’ll find this new option under the Integration menu on any list.

Find out more: Visualizing SharePoint lists now available to all users

Power BI July 2021 Feature Summary

The Power BI July 2021 feature summary includes making small multiples generally available, as well as the new model view and sensitivity labels in Desktop plus lots more:

Find out more: Power BI July 2021 Feature Summary

PivotTable refresh in Excel for the web now available

PivotTable refresh in Excel for the web is now 100% available to all eligible Office users. This feature is part of a broader investment to enable seamless and secure data sharing and collaboration with Power BI data in Excel for the web.

Connected PivotTable refresh in Excel for the web allows users to work with PivotTables connected to Power BI in a web browser just like in Excel desktop. With the Microsoft Information Protection (MIP) label integration, you can control sharing while keeping your data secure in Excel as an MIP label applied to a Power BI dataset is inherited in Excel.

Refreshing connected PivotTable in Excel for the web.

Find out more: Connected PivotTable refresh in Excel for the web is now 100% available to Office tenants

Streaming dataflows in Power BI premium

Streaming dataflows in Power BI premium is now available in public preview. Streaming dataflows allow authors to connect to, ingest, mashup, model, and build reports but based on continuous streaming, near real-time data. This is done directly in the Power BI service with beautiful, drag and drop, no-code experiences.

Graphical user interface, application Description automatically generated
Streaming dataflows in Power BI premium now available in public preview.

Find out more: Streaming dataflows in Power BI premium now available in public preview

On-premises data gateway July 2021

The July 2021 update for the On-premises data gateway (version 3000.89.6) has been released. This month’s updates include:

  • FHIR and Amazon Athena connectors available via the on-premises data gateway
  • Compatible with the July PBI desktop
FHIR connector available via the on-premises data gateway.

Find out more: On-premises data gateway July 2021 update is now available

Virtual workshops and training to get started with Power BI

Microsoft have announced a series free 60-minute trainings where you will be able to follow along with live demonstrations and ask Microsoft trainers questions in real time. This training is open to anyone curious about Power BI.

There are no required pre-requisites and courses are offered at least once a week. This training provides an overview and demo of Power BI to show how you can get maximum value out of your data in a way that was previously not possible.

Find out more: Virtual workshops and training


BONUS! Other related updates

Congratulations if you have made it this far through the monthly update! For getting to the end you will be rewarded with other related titbits from around Microsoft 365…

Organisation Explorer

he new Organization Explorer in Outlook allows you to find, discover, and explore people and relationships through a new organizational browser experience. Find colleagues, discover team relationships, explore their skills, see their current availability, and more right within Outlook. Organization Explorer is now in preview and available for Office 365 Insiders. 

thumbnail image 1 captioned Org Explorer screenshot
Organisation Explorer in Outlook.

Find out more: Visualize and contextualize people and teams with a new organization browser in Outlook

New Microsoft Graph connectors for Microsoft Search

New Microsoft Graph connectors for Microsoft Search enable your organization to bring in information from systems like ServiceNow, so you can find what you need wherever you’re working, whether in one of your favourite productivity apps or one of the many Microsoft 365 services such as SharePoint or Office.com. Connectors are now generally available and can be installed in just a few clicks in the Search and intelligence admin center.

thumbnail image 1 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							What’s new and what’s next for Microsoft Search
New Microsoft Graph connectors for Search.

Find out more: What’s new and what’s next for Microsoft Search

New features for Microsoft Bookings

There are now stricter administrative controls to help ensure each user within Bookings has the appropriate level of access and control. Additional customization and branding options for company logos, coloured themes, and a rich text editor to customize confirmations, cancellations, and reminders have also been added.

Finally, improvements have been made to the appointment scheduling to provide a simpler experience with easier calendar switching, more filtering options, and more. To try out the new experience, toggle on the Try the new Bookings switch on the top right corner of the Bookings web app.

thumbnail image 1 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							A new, more powerful, and customizable Microsoft Bookings is here
Try the new Microsoft Bookings experience.

Find out more: A new, more powerful, and customizable Microsoft Bookings is here

Automatic meeting scheduling with Scheduler

Scheduler is a new Microsoft 365 service that works with Cortana to automate meeting scheduling. Just add Cortana to your email and ask something as simple as “Cortana, please find a time to meet next week.” Cortana will then work with the Scheduler service to find times that work best for everyone and send out invites.

thumbnail image 1 of blog post titled 
	
	
	 
	
	
	
				
		
			
				
						
							Scheduler, a new Microsoft 365 service, makes scheduling meetings easier and faster
Microsoft Scheduler.

Outlook extension for Microsoft Edge

The Outlook extension in Microsoft Edge to quickly read, send, and receive emails, manage your calendar, tasks, and more in any browser tab, no need to go back to Outlook.

Product image
Outlook extension for Microsoft Edge.

Find out more: Microsoft Outlook extension for Edge

New features in Microsoft Forms for Education and Government

The Microsoft Forms team have announced five new features for both education and government customers:

Education – Launch Multiple Choice Quizzes in Microsoft Teams meetings, Create and edit a quiz directly from a Microsoft Teams assignment, Analyze responses with word clouds, rich text formatting in Forms & Send and share your forms more smoothly.

Government – Add a File Upload question to your form, Send a form using a shortened URL, Launch Polls in Teams Meetings, rich text formatting in Forms & Access your forms in a new interface

thumbnail image 1 captioned Multiple Choice Quiz in Teams Meetings
Launch Multiple Choice Quizzes in Microsoft Teams meetings in Forms for Education.

Microsoft 365 roadmap roundup – 23rd August 2021

Use these buttons to switch between each product’s roadmap updates.

Teams

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

🍾 LAUNCHED

  • Microsoft Teams: Live Transcript for Teams Meetings for GCC- Teams Meetings now have a real-time transcript during their meetings as well as a post-meeting transcript. Roadmap ID: 82836
  • Microsoft Viva: Personal wellbeing insights in Teams – Users can create mental bookends to productively start and mindfully end the work day with a virtual commute, tap into dedicated moments of mindfulness with Headspace and use emotional check-ins to pause and reflect. Roadmap ID: 68748
  • Microsoft Teams: Speaker Attribution in Live Transcript in Teams Meetings in GCC Clouds – Teams Meetings in GCC clouds will now have live transcript utterances attributed to the speaker of the utterance. Roadmap ID: 83382
  • Microsoft Teams: Cortana now available for EDU customers – Cortana voice assistance in the Teams mobile app is now available for EDU customers in en-US to help you streamline communication, collaboration, and class-related tasks in school using spoken natural language. Roadmap ID: 83484
  • Microsoft Teams: Simplified class team navigation for Teams for Education – Access Assignments, Grades, Class Notebook and Insights more easily from your main class team navigation. Roadmap ID: 84886
  • Microsoft Teams: Windows 10 native notifications – Choose the style of your notifications: built-in Teams or Windows native notifications. The latter brings a suite of benefits, like respecting focus assist mode which enables you to avoid distracting notifications when you need to focus, and integrating with Windows 10 action center to helps you review your notifications in one place. Roadmap ID: 85417
  • Microsoft Teams: Chat preview notification settings – Users can change settings and manage previews for their chat notification toasts. Roadmap ID: 85421
  • Microsoft Teams: MacOS native notifications in Teams for GCC – Users can now choose to get Microsoft Teams notifications, either via Teams built-in notifications or via macOS native notifications. Roadmap ID: 86064
  • Microsoft Teams: MacOS native notifications in Teams for GCC High – Users can now choose to get Microsoft Teams notifications, either via Teams built-in notifications or via macOS native notifications. Roadmap ID: 86066
  • Microsoft Teams: Group Assignments – With the new group assignment feature you can organize your students into groups so they can work together to create, collaborate and submit the same work – like a Whiteboard file or Word document. Roadmap ID: 82017

🚂 ROLLING OUT

  • Microsoft Teams: Present from PowerPoint to Teams with Microsoft 365 Apps for Business license – The capability of presenting your slides directly from the PowerPoint desktop apps to a meeting via PowerPoint Live in Teams is now extended to the Microsoft 365 Apps for Business license. Roadmap ID: 83640
  • Microsoft Teams: Starting recording will also start live transcription – If both recording and policy settings are enabled, turning on recording will also start live transcription. Roadmap ID: 85837

⌛ IN DEVELOPMENT

Release – August 2021

Release – September 2021

  • 🆕 Microsoft Teams: Sensitivity labels for Teams templates and graph API – Sensitivity labels enable admins to protect and regulate access to sensitive organization content. Microsoft now support sensitivity labels when creating teams via Graph APIs and templates. Roadmap ID: 84232
  • 🆕 Microsoft Teams: Teams meetings roster update for Teams Rooms on Windows – The updated meeting roster (viewable on the Teams Rooms console) more closely aligns with the experience available through the Teams desktop app, and includes capabilities like participant grouping, sort roster by raised hand, integrated user search. Roadmap ID: 84578
  • 🆕 Microsoft Teams: Microsoft Teams Rooms on Surface Hub – This next generation of Teams on Surface Hub has been redesigned to bring your favourite features from the desktop and Microsoft Teams Rooms into the meeting space. Roadmap ID: 85447
  • 🆕 Microsoft Teams: Chat bubbles during Teams Meeting for Teams Rooms on Windows – 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: 85810
  • 🆕 Microsoft Teams: Dynamic view on single and dual displays for Teams Rooms on Windows – New controls let you personalize the view to suit your preferences and needs, such as the ability to show shared content and specific participants side-by-side or to view content or people only. Roadmap ID: 85811
  • 🆕 Microsoft Teams: Large gallery view and Together Mode for GCC High – Ability for Teams Rooms to support different video gallery layouts including in large gallery and Together mode, in GCC High clouds. Roadmap ID: 85812
  • 🆕 Microsoft Teams: Room video fits to frame for Teams Rooms on Windows – Conference room video fits to frame by default and provide a full view of the room on Teams desktop app. Users can choose to fill frame for room video as needed. Roadmap ID: 85813
  • 🆕 Microsoft Teams: Support for large meeting controls for Teams Rooms on Windows – Ability for a Teams Room on Windows to join a large meeting as a presenter or attendee. Based on the role assumed by the Teams Room, appropriate meeting controls are made available to presenters for meeting moderation and for attendees. Roadmap ID: 85814
  • 🆕 Microsoft Teams: Lock meeting support for Teams Rooms on Windows – Ability to lock a meeting, preventing additional participants from joining. Users attempting to join a locked meeting will be informed that the meeting is locked. Roadmap ID: 85815
  • 🆕 Microsoft Teams: Pin multiple video streams in Teams Rooms on Windows – Ability to pin multiple video streams (up to 9 participants) simultaneously during a Teams meeting. User can select which participants to pin from the center of room console. Roadmap ID: 85819
  • 🆕 Microsoft Teams: Presenter mode support in Teams Rooms on Windows – Ability for presenter mode views to appear on the front of room display in a Teams Room. Presenter mode is a feature in PowerPoint Live that helps you customize how your video feed and content appear to the meeting audience. Roadmap ID: 85820
  • 🆕 Microsoft Teams: Split video layout across multiple screens for Teams Rooms on Windows – Ability to split the video gallery across all available displays in a Teams Room, when content isn’t being shared, maximizing screen space and bringing greater attention to the people joining remotely. Roadmap ID: 85821
  • 🆕 Microsoft Teams: Spotlight multiple video streams for Teams Rooms on Windows – Ability to Spotlight multiple video streams (up to 7 participants) simultaneously during a Teams meeting. Users can select which participants to pin from the center of room console. Roadmap ID: 85822
  • 🆕 Microsoft Teams: Paging on Video Gallery – When you are in Gallery view and there are more than 9 videos, navigation controls will appear below the Gallery. You can use these controls to view more video participants. Roadmap ID: 86480
  • Microsoft Teams: View switcher – The new view switcher in the top bar of a Teams meeting allows participants to control how they prefer to see the meeting content. Choose between Together mode, Focus, Gallery at top, and Full screen. Roadmap ID: 70754
  • Microsoft Teams: End-to-end encryption option for Teams 1:1 VoIP Calls – Teams will support an option to use end-to-end encryption (E2EE) for ad hoc 1:1 Teams VoIP calls, providing an additional option for conducting sensitive online conversations. Roadmap ID: 70780
  • Microsoft Teams: Video Streams Out via AJA or Blackmagic Design Hardware – Isolated video streams can be sent out of Teams meetings via AJA and Blackmagic Design hardware devices. Roadmap ID: 82812
  • Microsoft Teams: Music on Hold for Consult/Transfer – Music on Hold for Consult/Transfer scenarios ensures that users placed on hold will hear music while consultation and transfer occurs, ensuring that the caller knows that the call is still active. Roadmap ID: 82957
  • Microsoft Teams: Teams webinar capabilities for GCC – Schedule and deliver 1,000 person webinars with the same Teams app you use for meetings! Webinar capabilities support registration page creation, email confirmation for registrants, host management for attendee video and audio, attendance report, plus interactive features like polls, chat and reactions. Roadmap ID: 83611
  • Microsoft Teams: Whiteboard integration with Assignments – Digital whiteboards give educators and students a canvas to spark creativity and collaboration. Now, educators can include a Whiteboard as reference material or the content type of a Teams assignment. Roadmap ID: 82020

Release – October 2021

  • Microsoft Teams: Dynamic Emergency Calling for Work From Home – This feature enables users to validate (and if necessary, edit) the address that will be communicated to emergency responders in the event that an emergency call is placed by an individual working from home. Roadmap ID: 82956
  • Microsoft Teams: Auto-Expiration of Meeting Recordings stored on OneDrive and SharePoint – Newly created Teams meeting recordings in OneDrive and SharePoint will be automatically deleted by the service based on a default Teams policy setting. Teams Admins will be able to modify the default meeting recording expiration time via a setting in the Teams Admin Portal or by modifying policy attributes using Powershell scripts. Roadmap ID: 84580
  • Microsoft Teams: Apps in Assignments – Educators and students rely on a variety of tools to support learning. With this new feature, educators can include links to content from other learning and resource tools directly into a Teams assignment. Roadmap ID: 82019

Applying site templates in SharePoint Online

This post describes a change to how site designs/ templates are applied to sites in SharePoint Online.

Intro

Microsoft published MC249248 in the Message Center on 7 April 2021 stating the following:

This new SharePoint release of scenario-based site templates will help you expand what’s possible with content, pages, and web parts while helping you quickly get started building your own site. Each template contains pre-populated content and web parts that are fully customizable to meet the needs of your organization. This is rolling out on SharePoint Online and mobile.

This was updated on 23 July 2021 with a new timeline stating that this will be complete for Standard Release in late August 2021. What the message doesn’t detail is how this affects the current process for applying site designs to sites you are creating via the SharePoint admin center.

This change landed in my Standard Release environment around the week commencing 16 August. We first noticed it because we no longer had the ability to apply site designs in the admin center!

Before this change you applied your site designs at the point of site creation:

Before the recent site template change, site designs were applied to SharePoint sites at the point of creation.

Following this change the “choose a design” option is no longer present for team or communication sites through the SharePoint admin center. In order to apply designs you now have to apply a site template within the sites settings after you create it.

How to apply a site template

  • Navigate to the site you wish to apply the template to
  • Press the cog > then select apply a site template

Here you are able to choose from Microsoft pre-built templates, or those you have created and deployed into your SharePoint Online environment (from your organization). The experience is slightly different depending on whether you are using pre-built or your own templates.

Using Microsoft pre-built templates

  • Under From Microsoft > select the template you wish to use > press use template
  • The wizard below will show you a progress bar as the template is applied
When applying a Microsoft template, a progress bar will appear as the template is applied.
  • This wizard will disappear once the progress bar reaches 100% and your template will be applied to your site.
A SharePoint site with a Microsoft template applied.

Using custom site templates from your organization

If like me you had already deployed site designs, these are now shown as site templates available from your organization.

  • Press the cog > then select apply a site template
  • Select From your organization > select the template you wish to use > press use template
  • Once you press use template, an orange message bar will appear letting you know that the site template is being applied.
  • The orange message bar will change to green once the site template has been applied. You have to refresh to see the changes
A SharePoint site with a custom template applied.

Resources

Working with the SharePoint Service Administrator Group in SharePoint Online

In this post we take a look at the SharePoint Service Administrator Group, what it is and how to use it in SharePoint Online.

In this post:

Background

Recently I had the task of creating, then modifying a few hundred sites in SharePoint Online. In our case we provisioned the Microsoft 365 group connected SharePoint sites using PnP PowerShell, but as part of this we set the primary owner as an individual admin.

During the process of updating the sites manually, it become more and more annoying that other SharePoint admins had to keep adding themselves into the recently provisioned sites in order to do anything – that is until I found the SharePoint Service Administrator group!

What is the SharePoint Service Administrator group?

The SharePoint Service Administrator is a security group that includes everyone that has been assigned the SharePoint Admin role in Microsoft 365. It’s also worth noting there is also a Company Administrator group also, which includes all users with the Global Admin role.

Greg Zelfond has provided a great write up of these roles over at SharePoint Maven. For the purposes of this post I will be focusing on the SharePoint Service Administrator group.

How to assign the SharePoint Service Administrator group to a site

Follow the steps below to add the SharePoint Service Administrator group as an additional admin of a SharePoint site:

  • Open the SharePoint admin center
  • Under Sites > Active sites > select the site you wish to add the SharePoint Service Administrator group to
  • Press Permissions > Manage additional admins
Select your site then press Permissions > Manage additional admins.
  • Under Add an admin > enter SharePoint Service Administrator
  • Press Save

Issues and troubleshooting

#1 Cannot add SharePoint Service Administrator as a group owner

If you are creating or editing Microsoft 365 group connected SharePoint team sites, you are unable to add security groups as owners or members of a M365 group. Security group driven M365 group membership has been a long-standing request of Microsoft, but Roadmap ID: 83113 added in May 2021 has group driven membership management as targeted for release in December 2022.

Workaround: When creating new sites, set the group owners/ members as you would normally (i.e. one or more individuals), then edit the site once created to add the SharePoint Service Administrator group as an additional admin.

For existing sites, just update the additional admin as per the guidance above.

#2 No SharePoint Service Administrator group to choose from

If you have not assigned the SharePoint admin role to anyone in your tenant yet, the SharePoint Service Administrator role will not be available to select from when trying to assign it as an additional admin. In the below example, this tenant only had one global administrator, but the SharePoint admin role had not been explicitly assigned.

When I tried to add the company administrator role it worked no problem.

Workaround: Assign the SharePoint admin role to those you want to be included in the SharePoint Service Administrator group, or use the Company Administrator group if you only have global admins in your tenancy.

Microsoft 365 roadmap roundup – 16th August 2021

Use these buttons to switch between each product’s roadmap updates.

Teams

  • Launched (7)
  • Rolling out (2)
  • In development (16)

🍾 LAUNCHED

  • Microsoft Teams: Inline Message Translation in channels for iOS – Inline message translation in Channels lets users translate Channel posts and replies into their preferred language. Roadmap ID: 63219
  • Microsoft Teams: Meeting attendee engagement dashboard – Measure attendee engagement through participation, including registration, attendance and interactions during the meeting. This data is also available for download. Roadmap ID: 66585
  • Microsoft Teams: Block Downloads for Teams meeting recordings on OneDrive and SharePoint – All users with view-only permissions of a Teams meeting recording uploaded to OneDrive & SharePoint will now be blocked from downloading the recording by default. Roadmap ID: 70543
  •  Microsoft Teams: Guest Access in DoD – Teams now supports Guest Access between tenants inside the DoD Cloud. Roadmap ID: 82742
  • Microsoft Teams: Inline Message Translation in channels for Android – Inline message translation in Channels lets users translate Channel posts and replies into their preferred language. Roadmap ID: 83399
  • Microsoft Teams: Breakout Room Timer, Room Retention, and Participant Reassignment for GCC-High – Organizers can now set a timer for Breakout rooms from the Breakout Room settings. After timer has expired, rooms will automatically close and participants will come back to the main meeting. Roadmap ID: 85009
  • Microsoft Teams: Live Transcription with speaker attribution (for additional SKUs) – Live transcripts provide another way to follow along with what has been said and who said it. After a meeting, the transcript file is automatically saved in the chat tab for that meeting. We are now expanding this feature to Office 365 E1, Office 365 A1, Office 365/Microsoft 365 A3, Office 365/Microsoft 365 A5, Microsoft 365 F1, Office 365/Microsoft 365 F3, Microsoft 365 Business Basic SKUs. Roadmap ID: 82029

🚂 ROLLING OUT

  • Microsoft Teams: Dual-tone multi-frequency support for VDI (Citrix only) – Dual-tone multi-frequency (DTMF) for Teams on Citrix dial an outside number via dialer. Call is connected but DTMF is not sent. For example, if user is trying to use Teams to join a Teams meeting by dialing the PSTN number, the conference ID cannot be entered. Roadmap ID: 83014
  • Microsoft Teams: Simplified class team navigation for Teams for Education – Access Assignments, Grades, Class Notebook and Insights more easily from your main class team navigation. Roadmap ID: 84886

⌛ IN DEVELOPMENT

Release – August 2021

  • 🆕 Microsoft Teams: Spam Call Notifications – The spam call notification feature automatically evaluates incoming calls and identifies probable spam calls as “spam likely” in the call toast.  Users still have the option to answer or reject the call, and all “spam likely” calls (regardless of whether they were answered or rejected) will also be reflected in the call history list. Roadmap ID: 85386

Release – September 2021

  • 🆕 Microsoft Teams: Scale Teams Live Events to 100k attendees – 100k Teams Live Events are now supported when you engage the Microsoft LEAP team for assistance producing & delivering your event. Roadmap ID: 85151
  • 🆕 Microsoft Teams: Multi-Window support for VDI – VMware – Multi-Window is available for VMware. Users will be able to view meetings and calls in separate windows from the main Microsoft Teams client. Roadmap ID: 85691
  • Microsoft Teams: Pairing the channel and the corresponding SharePoint folder name – When renaming a Teams’ channel, the corresponding SharePoint folder will be renamed and reflect the new name. This new feature will be available for all Standard and Private channels. For Standard channels – The corresponding folder in SharePoint will be renamed. For Private channels – The corresponding site name and the folder in SharePoint will be renamed. For legacy Teams channels that were renamed prior to this rollout, there will be no change in experience. When a legacy channel is renamed after this release, it will simultaneously rename the corresponding SharePoint folder. Roadmap ID: 72211
  • Microsoft Teams: Restart Live Event – With this new feature, you will be able to restart your live event after you have ended it or if you have encountered a problem during it. Roadmap ID: 82953
  • Microsoft Teams: RTMP Streaming Support – Enables support for your users to stream their Teams meetings to large audiences through RTMP, including endpoints outside your organization. Roadmap ID: 83562
  • Microsoft Teams: Pilot and deploy Teams for frontline with the FLW onboarding wizard – This wizard allows admins to streamline team creation, license assignment, and policy package assignment in a few simple steps. Roadmap ID: 84468
  • Microsoft Teams: Breakout Room Presenter support – Extend the management of Breakout Rooms to specific presenters. Roadmap ID: 81118
  • Microsoft Teams: Breakout Room pre-meeting room creation and participant assignment – Introducing capability for organizer to perform breakout room configuration and participant assignment before the meeting starts. Roadmap ID: 81390

Release – October 2021

  • 🆕 Microsoft Teams: Parent connection in Teams for Education – With Parent connection in Teams for Education, educators can easily connect and engage with the parents and guardians of their class using Teams chat. All parent and guardian data is provisioned using School Data Sync, saving educators and IT staff valuable time. Roadmap ID: 83593
  • 🆕 Microsoft Teams: Multi-Window support for VDI – Citrix – Multi-Window is available for Citrix. Users will be able to view meetings and calls in separate windows from the main Microsoft Teams client. Roadmap ID: 84192
  • Video filters – Before joining a meeting, you can use the filters to subtly adjust lighting levels and soften the focus of the camera to customize your appearance. Roadmap ID: 65944
  • Microsoft Teams: Data reports for polls after Teams meeting – If user has used Forms poll in a Teams meeting, a summary report for all the polls used in this meeting will be generated and shared with meeting organizer and presenters. Roadmap ID: 79498

Release – January 2022

  • 🆕 Microsoft Teams: Breakout Room pre-meeting room creation and participant assignment for GCC-High – Introducing capability for organizer to perform breakout room configuration and participant assignment before the meeting starts. Roadmap ID: 85436

Release – February 2022

  • 🆕 Microsoft Teams: Breakout Room pre-meeting room creation and participant assignment for DoD – Introducing capability for organizer to perform breakout room configuration and participant assignment before the meeting starts. Roadmap ID: 85437

Release – March 2022

  • Microsoft Teams: Join a meeting by digital code – User can join a meeting by entering a digital code. Roadmap ID: 80668

How to remove commas from number columns in Lists

This article describes how you can remove commas (thousand separator) from number columns in Microsoft/ SharePoint Lists.

Introduction

You may have noticed a comma or thousand separator appearing when using the number column in Microsoft/ SharePoint Lists. Commas appearing in number columns in SharePoint have been a long-standing issue, going back as far as SharePoint 2010 and beyond.

In classic SharePoint, a common way to solve this problem was to convert the number column into a text column and validate it to remove commas using a formula such as =ISNUMBER([ColumnName]+0). However, with modern SharePoint, plus the advent of Microsoft Lists it’s now become easier to manipulate columns using column formatting to achieve the desired result.

I personally encountered this issue when importing data from excel into a modern SharePoint list. In my situation, the preview offered when importing from Excel did not show the commas in my data. It was only once it was imported into SharePoint that the commas appeared.

Remove commas from number columns

  • Left-click on your number column
  • Under Column Settings > select Format this column
  • Ensure the Format Columns tab is selected, scroll down and press Advanced mode
  • Remove the text from the box and add the following JSON:
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "attributes": {
    "class": "=if(@currentField > 0,'', '')"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block"
      }
    },
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

  • Press Save
How to add JSON formatting to number columns to remove commas.

Note

Microsoft added roadmap item 68716 in October 2020 for Microsoft/ SharePoint lists to include support for thousand separator in number columns. As this time of writing, the roadmap states this feature is due for release in June 2021 which will allow List owners/ members to choose if the comma should appear or not.