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 …

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 Query a SharePoint List from Another SharePoint List Using Microsoft Flow?

Why query multiple SharePoint lists from Microsoft Flow? If you are wondering why on earth would I think of using Microsoft Flow to query one list from another (when there is at least one common metadata to connect line items of both lists), I’ve the same clichéd reason – being a Power User, dependent on …

How to Get Filtered Items from SharePoint List to PowerApps using Microsoft Flow

In this blog post, I will explain “How to get filtered items from SharePoint list to PowerApps” when SharePoint List is able to hold more than 2000 records. It will cover a much more efficient solution: Using the “Send an HTTP Request to SharePoint” and “Request – Response” method. Inside flow, using the action of …