How to use the SharePoint 2016 On Premise Data in Microsoft Flow using On Prem Data GateWay Connection


Sathish Nadarajan
SharePoint MVP
Published On :   25 Mar 2018
Visit Count
Today :  4    Total :   1207



In the earlier article, we saw how to install and create a data gateway and how to connect to On Prem data sources. Here, we will see how to consume a data source from the Microsoft Flow.

The use case is very simple. On a button click, I am trying to retrieve the Data from SharePoint 2016 On Premise from my Microsoft Flow.

The Prerequisites are as follows.

1. Install the Data GateWay on a machine which is not an AD and which is running always. If the data gateway machine is switched off, then the flow will fail.

2. Create a connection

3. Add a Data Source.

All the above items, were discussed in the earlier articles.

Now, let us open the flow site.

1. Go to https://flow.microsoft.com with valid credentials and go to “My Flows”

clip_image002

2. Click on “Create from blank”

clip_image004

3. Click on “Search hundreds of connectors and triggers”

clip_image006

4. Select the Button trigger as shown in the below figure.

clip_image008

clip_image010

5. Click on Add an action

clip_image012

6. I am adding an action “Get Items” under the SharePoint service.

7. The flow will looks like below.

clip_image014

8. Click on the three dots on the top right corner on the action.

clip_image016

9. Click on “add new connection”

clip_image018

10. Select the Check Box “Connect via on-premise data gateway”

clip_image019

11. Enter the credentials of the On Premise server details and click on “Create”

12. Enter the details of the SharePoint List.

clip_image020

13. Save the flow and Run it.

clip_image022

14. On the Output section of the Get Items action, we can see the data from the SharePoint OnPremise List.

clip_image024

15. The important thing is, my SharePoint On Prem server is not internet facing, it is not publicly accessible. But through the gateway, the Online apps can access my On Prem Data. This can be leveraged for various use cases, such as , the data can be maintained in house.

Happy Coding,

Sathish Nadarajan.

Categories