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. Implicit Requirements Even though the stated requirements seem quite straight forward, there were a few implicit ones which had to be taken care of: The […]

Continue Reading

Access On-Premise Extension Attributes from Azure AD in MS Flow

Complete Flow

I recently came across a requirement where I needed to read SamAccountName and some ExtensionAttributes from Azure AD which are synced with On-Premise AD. I thought since all the On-premise attributes are being synced using Azure AD Connect, it should be easy enough to read those values from Azure AD using PowerShell or Microsoft Graph APIs. Getting Started Before I jumped into the solution, I wanted to be sure that Extension Attributes are indeed being synced. So, I looked into the connector properties and it was clear at that at least some of the Extension Attributes are being synced. Let […]

Continue Reading

Easily Switch Between Multiple Accounts in Office 365

All Propfiles

More often than not, in Office 365, IT workers find themselves using multiple accounts. Like one account for normal user access, another with Tenant Admin permissions and so on. Even though, the interface for switching logged in accounts in office 365  has become better now, than it used to be few months ago, it still leaves a lot to be desired. What’s the Problem Let’s take a look at what we are talking about. Suppose you have 2 different accounts, you use to access Office 365 – One a normal user account and another a tenant admin account and you […]

Continue Reading

Automate License Assignments in Office 365

Office 365 Licenses

License assignments has been one of the core governance concerns in Office 365 . With ever growing list of Office 365 Services and mix of license types (like E1, E3, E5 and a combination of those), this has created another world of processes (and PowerShell scripts) to keep up. So, what can we do to help reduce the amount of efforts spent on this? Yes, you got it right, Automate! Why bother about it? Before we jump into the solution, let’s spend some time on understanding “why” it is required in the first place. In most medium to large size organizations, […]

Continue Reading

Send Meeting Invites to SharePoint Online Calendar

Final Calendar Flow

Sometime ago, I wrote an article about How to enable Incoming Mails in SharePoint Online. In that article, I talked about how can we use Microsoft Flow to achieve the functionality. But there is another common functionality available in SharePoint on-premise versions which allows us to send meeting invites to SharePoint calendars. This functionality has been widely used to make a SharePoint calendar as Leave Tracker or to track important events. Let’s take a look at how this can be achieved in SharePoint Online. The Problem First thing that may come in mind – SharePoint Calendar is also “technically” a […]

Continue Reading

Implement Custom Alert Policies in Office 365

Alert Policy

Alert Policies are a bit of hidden gems in Office 365. There are a wide list of activities which can be tracked using these alert policies and a notification can be received when such activities/events occur. As per the official definition, we can use alert policies to track user and admin activities, malware threats, or data loss incidents in Office 365. After choosing the activity you want to be alerted on, refine the policy by adding conditions, deciding when to trigger the alert, and who should receive notifications. Alert Policies Alert Policies are part of Office 365 Security & Compliance […]

Continue Reading

Office 365 Management Activity API to Automate SharePoint Governance

API Permissions

In one of my previous articles, I talked about How to use Azure Text Analytics Service to Automatically Tag SharePoint Documents. One of the alternatives for implementation I pointed out was using Office 365 Management Activity API to identify when a document gets uploaded and trigger the metadata tagging. In this article, I am going to go in a bit more detail about how that can be achieved. However, by the end of this article, it should be fairly clear to you that similar solution can also implement various different scenarios to automate SharePoint governance. Introduction Summarizing the introduction from […]

Continue Reading

Use Azure Text Analytics Service to Automatically Tag SharePoint Documents

Automatic content classification or metadata tagging has been one of the “wishes” for knowledge workers across organizations. SharePoint has provided a solution for Managed Metadata and manual tagging for long and some third party solutions exist which claim to provide automatic keywords extraction from the content of the uploaded documents. In this article, we will explore how can we use Azure Text Analytics Service to Automatically Tag  Documents stored in SharePoint from the keywords extracted from the content of those documents. So, let’s’ get started. Prerequisites Before we can jump in to extract keywords from SharePoint documents, we need to setup […]

Continue Reading

Plan Extranet Sites Migration to SharePoint Online

Extranet sites or Sites having access to external users in SharePoint have been in use for long, across various organizations. It provides great collaboration when working with multiple vendors/partners. There are various articles about external sharing capabilities of SharePoint Online. In this article I am just going to focus on migration scenarios only. Extranet Sites in SharePoint On-Premise There are various ways to implement external access in on-premise SharePoint farms like External Users created in Active Directory in a separate OU and/or account names starting something like ext_ or gst_ to easily identify external/guest users External Users in a separate trusted […]

Continue Reading

Hub sites in SharePoint Online

Microsoft recently announced a major feature rollout, SharePoint Online Hub Sites, for Targeted Release Users. This is expected to be rolled out for all by end of May 2018. This has created a lot of buzz and rightly so, with the set of features it comes packed with. A common landing page for related sites was one of the most sought after requirements from various customer I have worked with. What is SharePoint Hub Site We can’t create a hub site directly using create site option. There is not specific or separate template for that. This is just regular Team Site […]

Continue Reading
1 2 3 6