Category Archives: Microsoft Flow

Power Automate – Excel – How to create Table and Read the Contents Dynamically?

Recently Microsoft announced Graph API HTTP Request action step. Good news is its not a premium connector. There are lots of potential for this. In this blog I will explain how to create a table and read an Excel sheet … Continue reading

Posted in Microsoft, Microsoft Flow, Microsoft GRAPH API, Microsoft Power Automate | Leave a comment

Power Automate – Execute a SQL Query Action Step

In this blog we will have a look at Power Automate SQL connector action step ‘Execute a SQL Query’. There are no dynamic properties available when you use Power Automate SQL Query Action step. As you can see above there … Continue reading

Posted in #MicrosoftFlow, Microsoft, Microsoft Flow, Microsoft Power Automate, No Code, Power Automate, Power Automate SQL Connector, Power Platform, SQL | 2 Comments

Power Automate – How to remove a user sharing permission from a SharePoint Library folder

By default SharePoint list and libraries inherit permissions from parent site. You can break the inheritance and create unique permissions on a particular list or library. Suppose you have a document library with multiple folders or files where you need … Continue reading

Posted in #MicrosoftFlow, Microsoft Flow, Microsoft Power Automate, Power Automate, Uncategorized | Tagged , , , , , , , | 2 Comments

Microsoft Flow – Retrieve All Files from SharePoint Library Folder & Send Email Attachment

 In this blog I will explain how to retrieve all files from a specified SharePoint folder and send email as an attachment. Every flow needs a trigger to start with so here I am using a manual trigger. Next step … Continue reading

Posted in #MicrosoftFlow, Microsoft, Microsoft Flow, Office 365, PowerApps, Sharepoint | Leave a comment

Microsoft Flow – Filter Excel List Rows

 In this blog I will explain about Microsoft Flow Excel list rows filters. Below is the Excel sheet table ‘ProdDetails’. Retrieve All First retrieve all rows from Excel sheet. This returns all the rows from excel sheet. The maximum size … Continue reading

Posted in Excel, Microsoft, Microsoft Flow, Uncategorized | 5 Comments

Microsoft Flow – Excel Get Row

 In this blog post I will explain Microsoft flow action step Excel Get a row. Flow action Get a row retrieves a single row from an Excel table. Here I am using a valid key value (P2) which exists in … Continue reading

Posted in Excel, Microsoft, Microsoft Flow | 14 Comments

Microsoft Flow – OneDrive Send All Files as Attachment by Email

 In this blog I will explain how to send all files as attachment by email from a OneDrive folder using Microsoft Flow. First step is the trigger. Here I am using a manual trigger. Next action is declaring an array … Continue reading

Posted in Email, Microsoft Flow, OneDrive | 15 Comments

Microsoft Flow – How to determine a string is numeric?

 There are no expression function in Microsoft Flow for checking whether a string is numeric or not. There are different ways you could resolve this. Here I will show you two techniques. First technique I am using here is the … Continue reading

Posted in Microsoft Flow | 5 Comments

Microsoft Flow – SharePoint Document – Restore Previous Version

 This blog explains how to restore a SharePoint document to previous version using Microsoft Flow. Prerequisite: Microsoft Flow (https://flow.microsoft.com/en-us/): Cloud-based service that allows you to create automated workflows between your applications and services. SharePoint Document Library: A document library provides … Continue reading

Posted in Microsoft Flow, REST, Sharepoint | 1 Comment