Flow Archives - Cloud Decoded

Automate Newsletter Generation using Power Automate

November 15, 2020 No Comments

Most people working with various organizations are used to receiving nicely formatted newsletters/communications over email about various subjects like IT Security Updates, HR Updates or some know how about certain Applications. While bigger organizations may have a separate team(s) and specific tools to do so, in most small to medium organizations, this process remains ad-hoc and mostly manual. So, what about we help them with some simple to use tool to generate such templated emails much faster! Problem Statement Continuing from the Introductory statement, I have seen in smaller and medium sized organizations and even various groups within larger organizations, […]

Office 365

Measure Microsoft/Office 365 Adoption with Collaboration Score

August 17, 2020 No Comments

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 […]

MS Teams, Office 365

Export/Archive Microsoft Teams Chat Messages

July 29, 2020 14 Comments

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 […]

Office 365

Disable Delve for Selected Users using PowerShell/MS Flow

April 9, 2019 12 Comments

Office 365 users seem to have love and hate relationship with Delve. Some love it for ease of access to content which would otherwise be difficult to find and others hate it for the very same reason, that it opens up the fault lines in their SharePoint setup where sites permissions are not kept updates when users move around various teams. Problem Statement The best way to define it would be – The “fear of unknown”, like “I don’t know which of my files will start appearing to everyone else”, is common among senior management and some users working in […]

Office 365

Automate On-Premise AD Account Creation with MS Flow

November 29, 2018 32 Comments

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 […]

SharePoint Online

Send Meeting Invites to SharePoint Online Calendar

August 28, 2018 41 Comments

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. This solution makes use of Power Automate/Flow. If you want to know about some of the […]

Office 365

How to Call SharePoint REST WebService from Microsoft Flow

March 22, 2018 11 Comments

Microsoft Flow is getting better and better with each passing day. It now has thousands of templates to get you started quickly and provides connectors for hundreds of other services. Flow can be invoked from across various external applications as well, but I guess, the most immediate users would come from SharePoint world 🙂 I wrote an article earlier about how Microsoft Flow can be used to Enable Incoming Mails in SharePoint Online. In this article, I am going to explain how to connect with SharePoint Online, extract some data using REST Services and send it for further processing. Getting […]

SharePoint Online

How to Enable Incoming Mails in SharePoint Online

February 23, 2018 11 Comments

Updated on 05-Feb-2021: There is an improved implementation possible to achieved this feature now. Refer this article – https://anupams.net/send-documents-by-mail-to-sharepoint-online/ – to know more about it. Incoming emails or sending documents to SharePoint document libraries has been one of the most loved features of SharePoint by business users for long. This has been there since SharePoint 2007 and all on-premise versions including the latest SharePoint 2016. Even though, it requires quite some steps and infra components to do the initial setup, once running, it gives business users real ease of uploading documents to SharePoint library directly from their mail client like […]