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
- Download the gateway installer here
- 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
- Enter the email address you wish to use with this gateway. On the next screen of the wizard, press Sign in
- Select Register a new gateway on this computer, press Next
- Give your new on-premises data gateway a name, enter a recovery key and confirm it. Press Configure
- In the PowerApps Studio, under Gateways you should now see your Gateway listed
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!