In this series of posts, I explain how to manage permissions on a SharePoint List Item using Microsoft Flow. Initially I needed to change the permission on an item just after it is created to only be visible to people based on column values in the item. The building the flow included lots of topics from using REST api, extracting information from a previous step and separating my flow into re-usable parts. This is Part 1 of the series.

Read More
How to manage permissions on a SharePoint List Item using Microsoft Flow – changing Item permissions

Getting Responses from called Flows In the previous parts of this series we have built 1 main flow and two called flows. If a flow calls another flow it shows a success unless the called flow includes a response, even if the called flow fails. In this last post of this series we will add

Read More
How to manage permissions on a SharePoint List Item using Microsoft Flow – Getting Responses from called Flows

In part 3 of this series we built a reusable flow to add contribute permission to one item for one person. Most examples found will give you the most common permission level ids. This post will walk through finding the roleDefId needed for any named permission level and will modify the HTTP request trigger to

Read More
How to manage permissions on a SharePoint List Item using Microsoft Flow – Named Permission Levels

In parts 1 and 2 we built a flow that broke inheritance on a list item and then gave a person contribute permission. Both of these functions are useful and we might want to use them again. Rather than rebuilding the REST api strings every time we need them, this post will look at how to

Read More
How to manage permissions on a SharePoint List Item using Microsoft Flow – Splitting a Flow into reusable parts

This post describes how to add contribute permission for a selected user id to a single item in a list using Microsoft Flow. The flow uses the REST API calls to change the permissions. The walk through uses a custom list with one columns added, Requester which is a Person column. In Part 1 of

Read More
How to manage permissions on a SharePoint List Item using Microsoft Flow – Add Contribute permission

Microsoft Flow has always struck me as having the potential to be the most powerful and useful component of the Office 365 suite, but has always come up just short with the functionality I’ve required.  The post below outlines a custom flow I’ve recently created.  Hopefully this is the first step of moving away from

Read More
How to set a document retention policy with Microsoft Flow in SharePoint Online

Recently I was looking into the On-Premises gateway for Powerapps functionality and how we can send data to on-premise sql database. Here we will see, How to setup the On-Premises gateway. Create a new On-Premise gateway connection. Setting up a flow to send data to the On-Premises database. How to setup the On-Premises gateway The

Read More
How to send data to on-premises SQL Database using Flow, Powerapps, data gateways and connection