This post details an issue with document libraries in SharePoint Online when there are more than 30 folders within a ‘grouped’ view, causing files not to be visible to users.
Intro
I’ve been working through a large-scale migration project for some time now, and have recently moved several document libraries from SharePoint 2010 into SharePoint Online. Although the library in question is large (approx. 200K items), it is well structured employing two levels of folder then using metadata to arrange files within.
The problem I’ve observed does not just apply to large libraries, it applies to all libraries that contain more than 30 folders.
The problem
Since migrating the document library I’ve noticed an issue with using group by views. A grouped by view is purely just a view that is grouped by a particular column, by clicking on the column name and pressing “group by”.
Group by selected within a document library view in SharePoint Online.
The library has a default view that has group by enabled to group items by a custom “document type” column. With grouped by views, a limit is automatically applied to the number of folders shown (30) and a “show all” link appears at the bottom of the view. When you click on this, it shows all the subfolders, but also automatically applies a filter to the view to the effect of “document type = empty”. This causes all the files within the subfolders to not display.
Clicking on “show all” applies an empty filter based on the group by column, causing all files within the document library to not display.
This issue only occurs for custom columns, any in-built columns (name, created by etc.) will let you group by and not apply the empty filter.
Response from Microsoft
I raised this issue with Microsoft via support and the response I received was:
“Although it is not desirable behaviour, it is expected”.
Microsoft support response to my issue
It was explained to me that the way these large libraries are structured, which, in my opinion has been considered to be best practice for well over a decade is no longer support in SharePoint Online. In essence this advice was don’t use grouped by views for document libraries with more than 30 folders.
We then proceeded to talk through how to re-build the affected document libraries using a different structural approach to overcome this issue which I will talk through below.
Temporary solutions/ workarounds
#1 Rebuild all affected document libraries
In my example, the document library is for storing employee files, so the first solution to this would be to completely re-build the document library, starting with splitting the library up into smaller, individual libraries (A-Z). Then, instead of interacting directly with the libraries, instead use a combination of pages, the highlighted content and document library web parts, with KQL queries to present the relevant files in a sort of address book style.
For example: there would be an address book page with highlighted content web parts displayed for each A – Z folder. Each highlighted content web part would have a KQL query to only shows the site pages for each employee with the relevant A-Z letter in the title. If this is something you’d like me to do a separate demo on, let me know in the comments section.
An address book page with a highlighted content web part for each A-Z folder, with a query that filters each HCWP to only show the relevant employee pages.
Alongside splitting up the large library into smaller libraries, for this solution you would also have to create a page per employee and add a document library to the employee page, pointing to the relevant library/ folder
#2 Use multiple views to navigate folders/ files
For this workaround I created two views: All Documents and All Folders. The All Folders view does not have grouped by enabled and allows you to navigate through all the folders without running into the empty filter. Once a users arrives at the relevant folder, they switch to the All Documents view which has the grouped by view enabled, allowing the user to view the files within the folder grouped by the custom column.
Two views to switch between All Files and All Documents to allow users to navigate the folder structure and see files grouped by custom columns.
#3 Manually remove the filter
This workaround is by far the simplest option, but puts the most burden on the end user. With this issue, it is possible to just remove the filter after it gets applied by pressing “show all”. Users are able to just untick the filter and continue to use the document library. This is what my users are currently doing.
Manually removing the empty filter allows all files to be displayed within the grouped by view.
#4 Classic view
My least favourite option of them all, but worth including as it does get around the issue. Classic view does not apply the “show all” link or restrict the number of folders displayed within a document library view. Switching to classic view will allow users to interact with the library without issue, but would potentially have other issues if any modern features are being used elsewhere within the library.
Classic view will show all folders without applying the “show all” restriction.
OneDrive and SharePoint: Access your Teams standard and private channel files – When you navigate to a site in SharePoint or OneDrive, you’ll be able to access the files stored in the Teams standard and private channels associated with that site. Roadmap ID: 88911
đźš‚ ROLLING OUT
Microsoft Stream: Record a new video on the Stream Start page in Office – Users can create a new video directly from the Stream Start page on Office.com by recording their webcam or screen. The new video is uploaded to OneDrive and ready to share. Roadmap ID: 88522
⌛ IN DEVELOPMENT
Release – August 2022
OneDrive: Activity column in My Files – When you navigate to the “My Files” page in OneDrive for Business Web, you’ll see an Activity column that shows which of your shared documents have unseen edits and comment. Roadmap ID: 88913
OneDrive: Review mode for Word documents in the sharing dialog – In any Word document, share a document for review by clicking the Share button, and then clicking the Share command in the menu. In Word for the web, add the people that you want to review the document, and then select the Can review option. Roadmap ID: 93400
⌛ IN DEVELOPMENT
Release – August 2022
🆕OneDrive: Bulk Automated Rename – When OneDrive can’t sync a file or folder because its name contains invalid characters, OneDrive can sometimes rename it for you. During automatic renaming, OneDrive replaces each invalid character with an underscore. Roadmap ID: 93425
OneDrive: Sharing experience – Share menu dropdown – We’re updating the Share menu to provide easy access to additional sharing options like Email, Copy link, Teams chat as well as Manage access settings. Feature ID:83727
OneDrive: Sync app- Automatic Account Configuration – The OneDrive sync app will automatically sign in if there are existing credentials available to Microsoft applications (Teams, Office, Edge, Windows). Roadmap ID: 93242
Microsoft Stream: Add chapters to help viewers find the right part of a video – Users with edit access to a video uploaded to SharePoint, OneDrive, Teams, and Yammer can now add chapters to help viewers identify information in the video. For each chapter you can specify a point in time in the video and title of that chapter which will show up in the table of contents side pane for the video as well as on the video timeline. Roadmap ID: 88525
Microsoft Stream: Improve audio quality with Noise suppression for Stream (on SharePoint) – Noise suppression helps both creators and viewers isolate speech from ambient noise, music, and other sounds, making voice more intelligible. Noise suppression significantly reduces ambient noise, bringing more clarity to speech in videos. Roadmap ID:88949
OneDrive: Large folder delete in OneDrive and SharePoint Document Libraries on web – Users will be able to delete large folders (10k items) on OneDrive and SharePoint Document Libraries on web.  Roadmap ID:88979
đźš‚ ROLLING OUT
N/A
⌛ IN DEVELOPMENT
Release – July 2022
OneDrive: Sharing experience – Share menu dropdown – We’re updating the Share menu to provide easy access to additional sharing options like Email, Copy link, Teams chat as well as Manage access settings. Feature ID:83727
Microsoft Stream: Record a new video on the Stream Start page in Office – Users can create a new video directly from the Stream Start page on Office.com by recording their webcam or screen. The new video is uploaded to OneDrive and ready to share. Roadmap ID: 88522
The Microsoft 365 monthly update includes updates and recently recent features across all of Microsoft 365. Press a button to read about an individual technology or continue reading for more. You can take a look back at previous monthly updates here, plus take a look at our weekly roadmap roundup.
In SharePoint: Inline playback of videos in Hero web part, control vertical section reflow, updated site logo management, streamlining the multilingual user interface, Planner cards in activity feed, SharePoint 2013 Workflows migration assessment tool, LGBTQ+ Employee Resource Group site template
Inline playback of videos in Hero web part
When you create a Communication site, the Hero web part is included on your page by default. It is pre-populated with default content that you change to display your own images, text, pages, links, documents, or videos. When someone clicks to play a video in the Hero web part section of a SharePoint site, the video will now play inline. No launch out of your established context, watch inline, return, browse, and continue to scroll through the other contents of the page uninterrupted.
When you add a video to a Hero web part on a communications site, it now plays inline (no longer launching out to the video’s Stream page).
Currently the vertical section in pages goes to the bottom of the page when viewed on smaller screens. We’re adding the ability for page authors to control this reflow and choose whether the vertical section goes to the top or bottom of the screen when the screen is condensed to a smaller size.
When you click to edit a vertical column, you’ll now see a new option to have the vertical column appear on the top or bottom when the full page resizes to a single column on smaller devices or low resolutions.
The SharePoint team are centralizing the management of your site logo. To update or manage your site logo, you will now exclusively visit the Header panel under the ‘Change the Look’ settings. Site owners will be able to navigate to the ‘Header’ panel from the ‘Change the Look’ settings, and then scroll to the bottom of the panel where the site logo options will be located.
Control all header options within the ‘Change the Look’ settings.
Streamlining the multilingual user interface when editing team sites
This new release includes other improvements to the navigation and site title editing experience for users whose preferred language differs from the site’s default language:
Additional language information is available when editors update navigational labels, site descriptions, footers, and the site’s name.
The new language information displays even if multilingual settings have not been enabled for the site.
When editors change site content that is not in their preferred language, it will modify the label instead of creating a translation.
Additional information appears in tool tips next to the content that’s being edited to confirm the language.
Streamlining the SharePoint multilingual user interface when editing team sites.
Planner cards now appear within the team site activity feed
Now, when a team member assigns a task to you within a plan, beyond the Planner user interface, a card will show up on your site activity feed if you are within two days of the due date. Timely tasks are visible when you need to see them.
When a task in Planner nears its due date, it will appear to your view in the team site activity feed.
The SharePoint team have developed a new, open-source Microsoft 365 Assessment tool – available to help you identify and evaluate your existing use of SharePoint 2013 workflows within your tenant and generating a Power BI report to help plan your migration of 2013 workflows to a modern workflow orchestration service.
By embedding Teams chat within Dynamics 365, Teams users can now seamlessly exchange ideas and collaborate directly and in context right in the workflow. You’ll be able to link existing or new chats to your Dynamics 365 records, such as sales opportunities and service cases, for convenient access for all participants.
Microsoft Teams chat embedded within Dynamics 365.
E-sign approvals fully embedded within Team Approvals
Users can now seamlessly create, view, review and e-signature approval requests that require a signature right from Teams. This update removes the need for users to log into each e-sign provider website. The login process has also been improved with users no only needing to login every 30 days.
E-signature approvals on mobile – view & take action.
E-signature approvals on mobile – view & take action
Users can now easily action e-signature approval requests from any mobile device. As a recipient users can view or review them, as a creator they can edit or cancel them.
DocuSign e-signature approvals in chats & channels
Users can now create DocuSign e-signature requests directly from the compose extension within a chat or a channel maintaining the context for the request. When users review the request, any updates will be shown in the adaptive card in the chat or channel meaning users respond faster as they understand the context of the request.
DocuSign eSignature for Approvals in Microsoft Teams
You can view and edit Adobe Acrobat PDF files right in Teams, removing the need to open another window which disrupts your workflow. This setting is in private preview and IT administrators can set Adobe as a default setting through the Teams admin center.
Users will be able to find the apps they use regularly via app flyouts, and just @mention their favourite bot to start using it seamlessly in a new chat/team. This capability will ensure that regularly used apps show up first and that the user doesn’t have to install them every time.
iPad users will have an updated Teams mobile meeting experience via a multitasking panel. Users will see a collapsible right panel during meetings, which enables richer experiences such as chat alongside the ongoing meeting, faster roster views, and more.
Chat bubbles are now available for iOS and Android users. When chat bubbles are enabled, chat messages appear on the mobile screen where you can preview the two most recent messages. You can temporarily turn them off in the current meeting by tapping on the snooze icon. Otherwise, you can also turn them off permanently by tapping on Don’t show chat bubbles on the More Actions (…) menu.
Organizers can share control by assigning the new “co-organizer” role to up to 10 meeting attendees. Co-organizers have most of the same capabilities as the organizer, including management of Meeting Options. Limitations of the co-organizer role include an inability to create and manage breakout rooms, manage meeting recordings, and view or download attendance reports. Organizers can add co-organizers through Meeting Options. Only invitees within the same tenant as the organizer are eligible for the co-organizer role.
Disable chat write access for anonymous/ unauthenticated users
IT administrators can disable chat write access for non-federated users and unauthenticated users who join Teams meetings through a shared link. This provides an added layer of security, especially in the financial sector where chat messages can be used as part of a data security breach.
Disable the chat write access via PowerShell using syntax [-MeetingChatEnabledType = Enabled, Disabled, or EnabledExceptAnonymous]. You can also do this through the admin portal under Chat in Meetings policy > Turn it on for everyone but anonymous users. This setting can be applied to a subset or all tenant users. Once this is set by an IT administrator, a meeting organizer cannot override this setting through meeting options.
Web users can view captions coming from a CART (Communication Access Realtime Translation) provider within the Microsoft Teams meeting window instead of a secondary window. Users can follow along with what is being said without having to choose between the captions and presentation.
Live Captions and transcriptions for Teams meetings on Web
Real-time captioning and transcription are now available for web users in Teams meetings in 27 spoken languages. To enable, click on the More Actions menu […] and select Turn on live captions and/or Start transcription. Web users can see who is speaking along with what’s being said during and after the meeting, making meetings more inclusive and easier to follow.
Live Captions and transcriptions for Teams meetings on Web.
Additional spoken languages available for Live captions and transcriptions for Teams Meetings
Microsoft have added six more spoken languages for live captions and transcriptions, including Czech, Thai, Hebrew, Portuguese, Vietnamese, and Turkish. Speakers of these languages will be more comfortable in a meeting, enabling a more inclusive environment.
Usability improvements to notifications in meetings for Android
Microsoft have added a notification drawer, which users will see at the top of their screen for in-meeting system messages. Users can preview, collapse, and clear all notifications with just one tap using the Clear All button. This helps reduce distracting clutter on your mobile device while you’re in a meeting.
Usability improvements to notifications in meetings for Android.
Support of Transcription for Teams on VDI for Azure Virtual Desktop
Transcription is available on VDI (Virtual Desktop Infrastructure) for Azure Virtual Desktop users. Live transcription allows you to follow conversations alongside the meeting video or audio in real time, promoting inclusivity for participants who are deaf/hard of hearing or different levels of language proficiency. After a meeting, the transcript file is automatically saved in the chat tab for that meeting.
Give and Take Control for Teams on VDI for VMware and Azure Window Desktop
Give and Take Control for Microsoft Teams is now available on VDI (Virtual Desktop Infrastructure) for VMware and Azure Window Desktop. Give and Take Control allows a meeting participant to control the presenter’s shared content during screensharing. A presenter can give control of the shared content to another meeting participant to take actions such as present or modify files. Both the presenter and the meeting participant have control of the sharing. The presenter can take back control at any time.
A meeting participant can request control while another participant is sharing content. The participant sharing content can approve or deny the request. When the requester has control, they can make selections, edit, and make other modifications to the shared screen.
Updates in Teams is an out-of-the-box app that enables users to create, submit, and review all their updates, check-ins, and reports in the flow of work. These can be recurring processes that happen on a regular basis, like a weekly update, store opening, or facility inspection. They can also be in the moment updates that might be needed at any time, like a shift handoff, maintenance request, or incident report.
These features are currently available to in multi-tenant cloud environments: US Government Community Cloud (GCC), US Government Community Cloud High (GCC-High), and/or United States Department of Defense (DoD):
Suggested Replies on mobile for Government Clouds – Quickly respond to an incoming message by tapping one of the three suggested reply options. Suggested replies in Teams chat uses assistive AI to create short responses based on the context of the previous message.
Sensitivity labels for Teams templates for GCC – Sensitivity labels are supported when creating teams with templates in GCC. Sensitivity labels allow Teams administrators to protect and regulate access to sensitive organizational content created during collaboration within Teams.
Manage meeting options – Organizers can modify the user experience by using the new Meeting Options to customize their meeting safety and security settings. Meeting Options can be accessed in the Teams meeting invitations details in Outlook and Teams Calendar. Available in DOD.
Attendee restriction to remove another attendee from chat – Only meeting organizers can remove an attendee from chat. If a user has an attendee role from the participant roster, they will not be permitted to remove other attendees from the chat window. Available in GCC.
Channel owner(s) can delete meeting chat messages within channel meetings – Currently, Teams channel owner(s) are unable to delete chat messages in the meeting chat window. Now, IT administrators can enable Owners can delete sent messages and assign this Messaging policy to a user or group of users. Once this is completed, channel owner(s) see this option on Member Permissions through Manage Teams > Settings. Available for GCC. Learn more.
Anonymous meeting join across clouds – Join meetings in other clouds anonymously from your Teams desktop app. Previously, if you wanted to join a meeting hosted in a cloud different from your tenant’s, you were directed to use the Teams web experience. Now, GCC and GCC-High users will be able to join meetings in Commercial, GCC, DOD, and GCC-High clouds from their desktop, enabling an improved meeting experience. Available in GCC and GCC-High. Learn more.
Music Mode – High-fidelity music mode enables Teams users to experience richer sound experiences when sharing non-speech content such as live music, songs through other applications, or medical signals during a virtual appointment with a physician. High-fidelity music mode enables significantly improved audio quality in Teams calls and meetings. Available in DOD. Learn more.
Presenter mode: Controls to move and resize presenter video – There is a new enhancement to the Presenter mode feature. Now, a presenter can choose whether to show up on the left or right side of the content and resize their video feed while automatically adjusting content size accordingly. This can be applied to all modes on Desktop or Window sharing, including standout, side-by-side, and reporter. Available in DOD.
Integrated Communication Access Realtime Translation CART captioning in meetings – You can now view captions coming from a CART (Communication Access Realtime Translation) provider within the Teams meeting window instead of a secondary window. Follow along with what is being said without having to choose between the captions and presentation. Meeting organizers and participants can enable CART captions from their meeting options. Available in GCC-High. Learn more.
Usability improvements to notifications in meetings for Android and iOS – A notification drawer, which you will see at the top of your screen for in-meeting system messages, allows users to preview, collapse, and clear all notifications with just one tap using the Clear All button. This helps reduce distracting clutter on your mobile device while you’re in a meeting. Available for GCC.
Improved meeting support in Firefox browser – Firefox browser users now experience the full audio and desktop and window screen sharing support in Teams meetings. Available in GCC.
Large Gallery Teams Meetings on Web – Web users can change the Teams meeting layout to Large Gallery. With Large Gallery, you can see up to 49 participants in a single screen, enhancing your overall virtual meeting experience. Available in DOD.
Together Mode in Teams Meetings on Web – Web users can change the Teams meeting layout to Together mode. In Together mode, participants are digitally placed in a shared background, making it feel like they are sitting in the same room with everyone else, even when participants are remote. Available in DOD.
Give and Take Control for Teams on VDI for VMware and Citrix – Give and Take Control for Microsoft Teams is available on VDI (Virtual Desktop Infrastructure) for VMware and Citrix. Presenters are able to give control of their shared content to other meeting participants, allowing them to take actions such as presenting or modifying files. The presenter and the meeting participant both have control of the sharing and the presenter can take back control at any time.
Support of Live Caption for Teams on VDI for VMware – Live captions are now generally available in Teams on VDI (Virtual Desktop Infrastructure) for VMware. Teams on VDI for VMware can detect what’s being said and who is saying it with real-time captions. See use live captions in a Teams meeting on how to get started. Available in GCC.
Multi-window support for Teams for VDI for Azure Virtual Desktop, Windows 365 and Citrix – Teams multi-window support is available for VDI (Virtual Desktop Infrastructure) for Azure Windows Desktop, Windows 365, and Citrix. Multi-window capability allows users to pop out chats, meetings, or calls into separate windows to help streamline their workflows.
Dynamic Emergency Calling for work from home on VDI for VMware – Dynamic Emergency Calling is now enabled for Teams on VDI (Virtual Desktop Infrastructure) for VMWare, allowing users to make emergency calls (E911) while working from home. It also lets users validate (and if necessary, edit) the address that emergency responders receive. Learn more how to configure dynamic emergency calling. Available GCC and GCC-High.
Support of Transcription for Teams on VDI for Azure Virtual Desktop – Transcription is available on VDI (Virtual Desktop Infrastructure) for Azure Virtual Desktop users. Live transcription allows you to follow conversations alongside the meeting video or audio in real time, promoting inclusivity for participants who are deaf/hard of hearing or have different levels of language proficiency. Available in GCC and GCC-High.
Bots in GCC-High – GCC-High customers will be able to build and deploy bots in their Microsoft Teams environment through Azure bot Service. This release supports custom, line-of-business bots.
Power Apps
In Power Apps: Power Apps for Windows GA, Dataverse Service Client GA, Dataverse experiences GA, Wrap GA, modern commanding GA, canvas components/ component libraries GA, portals update, developer tools refresh, command line updates v1.15.x
Power Apps for Windows General Availability
The Power Apps team have announced the general availability (GA) of our new Power Apps application for Windows. With Power Apps for Windows you can find all your canvas and model-driven apps including your Dynamics 365 apps and use them online or offline just like you can on iOS and Android! You can configure model-driven apps to work automatically offline by creating an offline profile. For canvas apps, you can use the LoadData/SaveData functions to create a seamless offline experience.
With the new Power Apps for Windows, you get device capabilities like camera, microphone, file picker, barcode scanning, geo-location and many others.
The Power Apps team have announced that the Dataverse service client is now Generally Available for developers to use. Dataverse Service client has been in preview for a while, which is why the team can provide developers with a Generally Available version of this SDK. This new Dataverse Service Client SDK has the following capabilities, which enables the community to extend the value of their applications:
Dataverse experiences on Power Apps General Availability
The Power Platform team announced the general availability of new data focused experiences for Dataverse, including:
Updated list of tables: An updated the list of tables to make it simpler to find what you need with extensive support for filtering, sorting, search and have provided some key pivots on this list.
Table hub: When you open a table, you’ll see a hub layout giving you an overview of the table with its properties and grouped links for related table components (like forms, views or columns).
Table designer: When you need to dive into the full data set, you can edit the table in a full-screen experience that gives you access to all the data in the table.
Create an app quickly: Now that you have found or built your table, it is just one-click away to create a new modern app over that table, whether you’re on the table hub or in the full-screen experience.
What’s using this table: You can select a command on the table hub to view the list of apps and flows that are using this table.
Columns, data types and formats: Focused on columns as they are key to storing meaningful data – the majority of columns created are text, whole number or date/time so these are all readily available in a single-click.
Choice columns: Enhanced management of these column types to make it easy to sort, drag/drop reorder, set colors and get access to all the other properties of the choice, including support for extending out-of-the-box Status Reasons.
Wrap for Power Apps – empowering makers to create secure, custom-branded, standalone Android and iOS enterprise mobile apps with Power Apps – has reached general availability (GA). Wrap for Power Apps is the next step, integrating low-code enterprise apps with Power Apps mobile technology to produce secure (Intune managed) enterprise mobile apps with rich native mobile experiences and seamless end-to-end branding suitable for customer-facing frontline worker scenarios.
The Power Apps team have announced modern commanding with Power Fx is now generally available (GA). Modern commanding provides a maker friendly low-code/no-code experience for customizing model-driven app command bars – with the first ever in-product command designer and the ability to use Power Fx (or JavaScript) for expressing business logic.
General availability of Power Apps modern commanding.
Canvas components/ component libraries general availability
The Power Apps team have announced the general availability (GA) of canvas components and component libraries. Canvas components enable low code/no-code developers to build reusable UX components using default Power Apps controls as core building blocks. These custom components can then be shared across app screens or multiple apps both within and across Power Apps environments.
Makers can now package their apps and component libraries inside a single or multiple solutions and import them into a different environment. If a canvas app is using a component library, it is now tracked as a solution dependency. ALM support ensures that the dependency relationship is maintained in the target environment and any further library versions imported via solutions can deliver the updated components to the app.
With the announcement of Power Pages, several capabilities within Power Apps portals are now been optimized, or depreciated. Changes include: OAuth 2.0 implicit grant flow, list OData feed, Portal content editor and more.
The Power Platform team have announced the release of a new update (Version: 1.16.5+gba7d6a4) for the Power Platform Command line. This refresh comes with capabilities ranging from support for single sign-on to things like showing whether solutions are managed or unmanaged when listing out the solutions.
You can now reassign a solution flow to a new owner from the Power Automate portal. This feature enables owners, co-owners, and admins to change the owner of a solution flow to enable business continuity when the original owner is switching teams or leaving the organization.
In May 2022, the Power Automate team launched 13 new verified connectors and 14 updates from different service owners. Let’s take a look at some of the new connectors:
Alkymi – Alkymi transforms enterprise workflows by placing machine learning and automation technology into the hands of business users, turning operational data headaches into a source of efficiency.
Cascade – Cascade is a cloud-based strategic planning and execution platform for teams to plan, execute, measure, and adapt their strategy all in one place.Â
Cyberday – Cyberday splits chosen security frameworks (e.g. ISO 27001, NIST CSF, ISO 27701) down to prioritized security tasks and guides you in implementing them directly inside Microsoft Teams.
DomainTools Iris Enrich – The DomainTools Iris Enrich API supports high query volumes of domain name attributes including Whois, DNS, SSL certificate, and risk scoring elements to help build out the needed context for appropriate disposition of indicators.Â
DomainTools Iris Investigate – The Iris Investigate API delivers dozens of domain name attributes on every result including Risk Score, DNS, Whois, SSL, and more.Â
Exasol – Exasol’s analytics database delivers next-level performance, ease of use and choice of deployment for diverse analytics use cases.Â
InQuba Journey – inQuba Journey offers a deep understanding into your customer journeys across channels and the ability to guide customer behaviour using real-time and personalised interventions.
My Acclaro – My Acclaro is a portal that streamlines translation workflows for your enterprise from order creation through review.
Progressus Advanced Projects – Use Progessus Advanced Projects connector to make OData calls to Progresssus Advanced Projects data.
Tribal – Tribal Edge modules, such as Tribal Admissions, provide staff and students the tools they need to succeed in the world of education.
TuxMailer – TuxMailer is a tool for email validation and marketing services.
Uber Freight – Uber Freight is a logistics platform providing 24/7 access to truckload freight with instant quoting + booking, price transparency, and real time visibility.
Vineforce – The Vineforce Power Automate Connector helps you build workflows by automating task creation and notifications triggered by actions in your favorite productivity apps.
15 new independent publisher connectors
In May 2022, the Power Automate team launched 15 new independent publisher connectors. Let’s take a look at some of the new connectors:
Aviationstack by Troy Taylor – The aviationstack API was built to deliver accurate data about global flights both in real-time as well as for historical flights.
BIN Checker by Troy Taylor – Checks and verifies BIN (Bank Identification Number). Available for both credit card and debit cards.
CDC Content Services by Troy Taylor – Content syndication allows CDC to offer web content to other sites and applications. Media, topics, and organizations data is available.
Lit Ipsum by Troy Taylor – Lit Ipsum is a dummy text generator for web designers and developers. As an alternative to boring old Lorem Ipsum generators, it chooses passages from copyright-free literature courtesy of the Gutenberg Project.
NHTSA vPIC by Troy Taylor – The NHTSA Product Information Catalog Vehicle Listing (vPIC) Application Programming Interface (API) provides different ways to gather information on Vehicles and their specifications.
OpenAI by Robin RosengrĂĽn – OpenAI is an artificial intelligence research laboratory. The company conducts research in the field of AI with the stated goal of promoting and developing friendly AI in a way that benefits humanity as a whole.
ProPublica Campaign Finance by Troy Taylor – The Campaign Finance API includes information about electronic filings, which are submitted to the Federal Election Commission on nearly every day of the year. ProPublica Congress by Troy Taylor – Using the Congress API, you can retrieve legislative data from the House of Representatives, the Senate and the Library of Congress.
ProPublica Nonprofit Explorer by Troy Taylor – ProPublica Nonprofit Explorer provides summaries of 3 million tax returns from tax-exempt organizations and see financial details such as their executive compensation and revenue and expenses.
Reachability by Troy Taylor – Check reachability of any site/webpage from any country in the world.
Sessionize by Nanddeep Nachan – Sessionize is the smart way to manage Call for Papers, Speakers and Agenda for your conference.
Storm Glass by Paul Culmsee – The Storm Glass API allows you to fetch weather data for any coordinate on the globe in a simple, programmatic way using conventional HTTP requests.
Udemy by Nanddeep Nachan – The Udemy helps one to get the information about Udemy learning courses.
WorldTime by Andras Fordos – A simple API to get the current time based on a request with a timezone.
XSOAR by Landon Chelf – Provides the ability to submit content to XSOAR integrations when using instance.execute.external to expose integration instances over HTTPS. Tested to work with the Generic Webhook integration.
Application Lifecycle Management (ALM)Â is the end-to-end lifecycle management of applications and automations, considerations like governance, development, and maintenance. Based on your feedback, Power Automate has two categories of enhancements that are improving the ALM story:
Solution cloud flow improvements
Core ALM improvements
Making application lifecycle management (ALM) easier in Power Automate.
In Power BI: Preview data in dataset details page, Power BI Desktop Feature Summary, email subscription updates for Premium Gen2, SQL Server Reporting Services 2022, Enhanced refresh Power BI REST API GA
Preview data is now available in the dataset details page
The dataset details page helps you explore, monitor, and leverage datasets. When you click on a dataset in the data hub, a workspace, or other place in Power BI, the details page for that dataset opens. A new feature – preview data, lets you select data from dataset’s tables on the side panel. If you do not see a side panel, click on “Show tables” from the action bar.
In this month’s desktop feature summary is the announcement of the general availability of the new Format Pane, error bars and information protection updates, table navigation improvements, Connect to datamarts, plus lots more!
SQL Server Reporting Services 2022 (Public Preview)
This release introduces the public preview of SQL Server 2022 Reporting Services (SSRS). Â In this new release of SSRS, Microsoft have done lots of accessibility work to make sure we are empowering people to achieve more. It includes enhanced Windows Narrator support, security enhancements, performance improvements, bug fixes, and reliability updates.
Reminder of features being removed with the next release of SQL Server.
Enhanced refresh with the Power BI REST API generally available
Enhanced refresh with the Power BI REST API (formerly asynchronous refresh) from public is now generally available in Power BI Premium, Power BI Premium per User, and Power BI Embedded. As noted in the public preview announcement, this feature not only eliminates the need for synchronous client connections to perform a refresh, but also unlocks enterprise-grade refresh capabilities.Â
The Microsoft Forms team have updated creating, editing and tracking experiences for educators, here are 4 new features:
Quickly create a form/quiz for your daily workflow – With this feature, teachers can quickly select and create templates including feedback surveys from students, daily workflow requests forms and assessment quizzes based on different needs through forms.office.com.Â
Convert paper tests into online ones – You can now import and convert paper tests into Microsoft Forms by using our latest “Smart convert” functionality.Â
Quiz is fully supported across all devices, including mobile – Whether you are creating a Form or Quiz from scratch, want to edit an existing one, or want to analyze the results, now you can do this fully end-to-end across your various devices.
Keep track and remind non-response people by one click – If you want to share a form or quiz directly to your class or anyone in your organization, you can easily use the invitation channel.Â
Microsoft have announced an improved Office.com experience with updates that will allow users to create, share, and collaborate all in one place with their favourite apps. A new sign-in and sign-up page greets you with a modern entry point to get your day started on the web. Additionally, with the new Create experience, you can access new creation templates in a single location.
OneDrive: Sync admin reports macOS support – New dashboard to check sync app versions, sync status, top sync errors on individual macOS devices and monitor deployment progress of Known Folder Move. Roadmap ID: 81982
Microsoft Stream: Comment on a video or audio file in SharePoint and OneDrive – This feature builds on top of the already existing comments found in OneDrive and SharePoint Online but presents these comments with a new Office look and feel within the player. This feature allows users with view permissions to leave a comment and users with edit permissions to @ mention, which are both default changes in behaviour in terms of permissions for video and audio files. Roadmap ID: 88521
đźš‚ ROLLING OUT
N/A
⌛ IN DEVELOPMENT
Release – July 2022
🆕 OneDrive: Review mode for Word documents in the sharing dialog – In any Word document, share a document for review by clicking the Share button, and then clicking the Share command in the menu. In Word for the web, add the people that you want to review the document, and then select the Can review option. Roadmap ID: 93400
To remove results using the search results removal option, you will need to use an account that has administrator privileges to access the SharePoint admin center.
Option 1: remove URL’s from search results
Navigate to the SharePoint Online admin center > press more features
Open Search
Under more features, open search from the SharePoint Online admin center.
On the search page, press Remove Search Results
Enter the full URL(s) of the items you want to remove from the search results. I enter each URL on a separate line
Press Remove Now
Enter the full URL of the document or item you want to remove, then press Remove Now.
Option 2: stop items appearing in search results at the library level
Here’s another way to remove items from the search results, this time by disabling indexing from the library where the item is stored:
Navigate to the library > press the cog button > library settings
Advanced settings > under Search > set Allow items from this document library to appear in search results? to No
Press OK
Set Allow items from this document library to appear in search results? to No.
NOTE: This option is only available at the library level and thus will stop everything from within the library appearing in the search results. If you only wanted say one item removed from search results, it would be better to use option 1.
A note on retrieving the crawl logs
I also wanted to call out one other part of the search results puzzle that you can make use of in modern SharePoint – that being the crawl log.
You can use SharePoint PnP cmdlets in PowerShell to return entries from the search crawl log in SharePoint. To do so you will need to be granted access to the crawl log via the SharePoint admin center.
You can use PnP cmdlets in PowerShell to query the crawl log.
This could be a useful way of viewing indexed content, however it isn’t the same as the classic crawl log, in as much as you can’t remove items from the index and it is limited to the site collection you are connected to.
Use these buttons to switch between each product’s roadmap updates.
OneDrive
Launched (0)
Rolling out (0)
In development (1)
🍾 LAUNCHED
đźš‚ ROLLING OUT
N/A
⌛ IN DEVELOPMENT
OneDrive: Sync admin reports – bulk data export – Support for bulk export of device status, including username, sync app version, known folders, last sync date, and sync errors. Roadmap ID: 88870
Use these buttons to switch between each product’s roadmap updates.
OneDrive
Launched (2)
Rolling out (0)
In development (0)
🍾 LAUNCHED
OneDrive: Rename Add to OneDrive shortcuts – We’ve added the ability to rename shortcuts you’ve added using the “Add to OneDrive” feature within OneDrive web. Roadmap ID: 93279
OneDrive: Sharing experience – Copy Link in command bar – We are updating the copy link command to give customers the ability to change their link type and permissions prior to generating a new link and pasting it into the app of their choice. Roadmap ID: 88866