Measure Microsoft/Office 365 Adoption with Collaboration Score

I have been working with a few organizations helping with their user adoption of Microsoft/Office 365 tools and services. Analyzing various Microsoft/Office 365 admin reports forms a core part of that exercise, which provides a fair understanding of usage patterns of various tools. However, it can quickly become overwhelming if we try to identify say top 5% of users who are making most/best use of the these tools, specially in medium to large organizations. Problem Statement As the introduction text explains, we are looking for a way to be able to easily find out users who are using various tools/services […]

Continue Reading

Export/Archive Microsoft Teams Chat Messages

Article updated on 31st Oct 2020 to use v1 API instead of Beta one to get the list of chats Recently I came across a requirement about being able to export all the chat messages. The expectation was to get something like the Conversation History in Outlook, we used to have in Skype days. Quick google search made it evident that there is no such feature available as of date. So, it was time to start a fun journey of finding it out and getting it done! Initial Findings As it goes, some initial googling led to a few articles […]

Continue Reading

Using Tags in Microsoft Teams

As the Microsoft Teams usage grows, so does the number of teams workspaces and list of members in each of those. Users quickly started to look for ways to just refer a smaller subset of the all the members of a team/channel. Recently, Private Teams Channel feature was rolled out and that served some purpose, but I see that doing more harm to actual “collaboration” then helping it. Mostly because many business users just started to create private teams to isolate their sub teams even though the purpose was just to ensure that larger team doesn’t get bothered with unrelated […]

Continue Reading

Get Instant Office 365 Health Status Notifications with Power Automate Using Service Communications API

I have written a couple of articles about this topic earlier like this which explains how to monitor the office 365 health status using PowerShell and this one which does the same using Power Automate. But I kept thinking about that both of these solutions are more like “Pull” status. Meaning, we check every 30 minutes and see if there are any new messages in the health center. Not very efficient if you want yourself to be kept updated and take actions quickly. Why this Article This article is about following a similar approach as already described in the previous […]

Continue Reading

Automate Office 365 Health Status Monitoring with Power Automate/Flow Using Service Communications API

This article is outdated now since Microsoft retired the Service Communication API in Dec 2021. Please look at this article instead, which uses Microsoft Graph API to achieve the same. I wrote an article on the same topic a couple of weeks ago that explains how to monitor Office 365 Health Status with PowerShell. I know, like me, there are a lot of other Power Automate/Flow enthusiasts who would prefer to achieve the same without writing any lines of scripts. So, here is it. Before you get started, ensure that the account you are using with Power Automate/Flow at least has a […]

Continue Reading

Automate Office 365 Health Status Monitoring Using Office 365 Service Communications API

This article is outdated now since Microsoft retired the Service Communication API in Dec 2021. Please look at this article instead, which uses Microsoft Graph API to achieve the same. I wrote an article on how to Automate Office 365 Health Status Monitoring using PowerShell a couple of years ago, which was found very useful for many Office 365 Admins. It was based on the API “shdtenantcommunications”, which has now been discontinued by Microsoft. I have put an update on that article about this, so that you can save your time by NOT attempting to try n make that work […]

Continue Reading

Suppress User Consent Popup in PowerApps

PowerApps Consent

By default when you deploy any PowerApps application which uses connections to various data sources like SharePoint, Azure AD etc, it would show a popup to all the users trying to access the application and ask for their consent to be able to connect to the backend data sources on their behalf. In general, from security point of view, this might still be acceptable to some organizations. Since also, this appears to be a one time consent granted by end users. But is it? Everytime, you make any update in the PowerApps application related to those data sources, the consent […]

Continue Reading