The gateway is a bridge from your app to the on-premises or virtual machine where your data is stored. The gateway can be deployed centrally and you can connect to your on-premises data and manage it securely from PowerApps. In this blog, I’ll demonstrate how we can create a simple App in PowerApps which can connect to on-premises SQL database. The App is created to capture Leads information from the user’s phone and the submitted data is saved to SQL database which is on-premises.

This post is part one of two parts.

The gateway is a bridge from your app to the on-premises or virtual machine where your data is stored. The gateway can be deployed centrally and you can connect to your on-premises data and manage it securely from PowerApps. In this blog, I’ll demonstrate how we can create a simple App in PowerApps which can connect to on-premises SQL database. The App is created to capture Leads information from the user’s phone and the submitted data is saved to SQL database which is on-premises.

This post is part two of two parts

One of the common requirements I run into when it comes to app forms of any kind is Cascading Dropdowns. So since I'm sure we'll all need them at one time or another, let's run through the steps to create them in PowerApps.

Goal:

This will be demonstrated on a Change Request app form that collects very basic information about change requests. The app will have three fields: Category, Sub-Category, and Answer. The sub-category will depend on the category selected, and the question the user will have to answer will depend on the sub-category selected.