I’ve recently been playing with PowerApps for the first time, I set myself a challenge of creating an IT service desk in PowerApps using a SharePoint 2016 on premise environment as the main data source.

So before I start going through all the steps I found were needed for me to setup the default gateway, this article from Microsoft is a great place to start and contains most of the steps I’ll go through below:

Setting up the default gateway

1. Download the gateway installer here
2. Run and begin the install of the default gateway, this can be installed anywhere that is able to connect to the server name provided. Press Next
3. Specify the install location for the gateway and accept the terms of use. Press Install
   
   
4. Enter the email address you wish to use with this gateway. On the next screen of the wizard, press Sign in
   
   
   
5. Select Register a new gateway on this computer, press Next
   
   
   
6. Give your new on-premises data gateway a name, enter a recovery key and confirm it. Press Configure
   
   
   
7. In the PowerApps Studio, under Gateways you should now see your Gateway listed

NOTES

I found that the internal firewall where I had setup the gateway was blocking connections, in my case the system admin allowed these connections and it worked a treat!

I also found that the 365 account used to register the default gateway needed a Power BI license assigned to it to be able to connect to a SharePoint on premise data connection.

I’m planning on doing a series of posts over the next few weeks on my fun with PowerApps so part 2 will be coming soon!