How to Use Graph API to Read SharePoint Online Excel Data from Microsoft Flow

Microsoft Flow provides many different actions to interact with SharePoint Online list and libraries. Recently, we had a requirement where excel data to be processed as soon as user upload the file to the document library. Limitation/Issues Initial idea was to utilize the Excel Online (Business) connector related actions like “List rows present in a …

SharePoint Online – No code Status Column Formatting with Color Palette

Preface I always find visual analysis more perceptible. Hence, even if means color-coding choice columns, I’d not think twice since color-based distinction seems faster to me. While SharePoint Online list/library columns supported JSON formatting for some time now, the recently introduced no-code formatting gives a reason to rejoice to Out Of the Box users like …

How to recreate SharePoint On-Premise Email Enabled List in SharePoint Online with Microsoft Flow

Introduction Amongst the various SharePoint on-premise to SharePoint Online migration activities that I do in my organization for different customer projects, off late I came across migration of email enabled lists. While many a times we discover that such migrations are just for data since the end-users stopped using this feature, in this case, the …

How to Migrate SharePoint Online Modern Client-Side Pages?

I have been working on all possible versions of SharePoint and deployed custom solutions for many projects. However, with the introduction of Modern UI in SharePoint Online, it has become a nightmare for developers to deploy solutions and move around sites from Dev to UAT or to Production. One of the most common activities that …

How to Choose Between SharePoint Online or a CMS for Your New Intranet

I often get asked this question from customers, whether they should use SharePoint Online out of the box or if they should purchase a Content Management System (CMS) that integrates with SharePoint and Office 365. Before this year, I would have recommended them to go with one of the CMS systems.  There are several that …