Power of Power Automate and a Big Limitation!

Like me, I know, many of you also belong to the Fan club of Power Automate (or MS Flow as it used to be). It makes many of the complex data processing and computations a piece of cake. I so liked the combination of SharePoint, PowerApps and Power Automate that they became my defacto combo to start thinking about any solution with Teams to put everything together. So, if the Power Platform with other Microsoft 365 Applications is so great, then why this article? Background Let’s set some background before we jump into the topic. Recently, I was working on […]

Continue Reading

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

Automate On-Premise AD Account Creation with MS Flow

Solution Design

I was recently asked to work on Automating the on-premise Active Directory Account creation. The idea was simple – Hiring manager fills up a form with the required details about the new joinee and submits and then the account should get created in On-premise AD and eventually be synced with Azure AD with required licenses assigned. The obvious expectation was to use available tools only which come as part of Office 365 E3 license suite. Unfortunately Custom HTTP calls to Microsoft Graph became a Premium Connector in February 1, 2019 and now requires a P1 or P2 license. Implicit Requirements […]

Continue Reading