What is the best database for PowerApps?
In this article we will give you all the information you need to choose the best database for PowerApps.
Your final PowerApp solution might be integrating to all kinds of third-party systems such as Facebook, Twitter, Salesforce etc to pull and push data. This article will be useful for people looking to start building a canvas PowerApp solution and a place to store the data from scratch. Scroll down for more information.
Design your database for PowerApps First
A common mistake that is made when embarking on a PowerApps project is to focus on the user interface design before considering where the data will be stored.
First agree where the data is going to be stored and what columns of data will be required before you start designing your Power App interface.
Questions to ask when choosing a database for PowerApps
There are multiple factors to consider to help you choose the best database for PowerApps. As part of your initial project meeting to discuss PowerApps ask your Team the following questions:
Examples of Database for PowerApps
You can watch the 5 minute webinar on this topic by clicking the picture below. You can also see some live examples of powerapps in our other blog resource.
Content by: Dougie Wood
Top 4 Microsoft Databases for PowerApps
There are many different types of databases available on the market. We will not be discussing any of the third-party databases such as MySQL, Oracle, IBM Db2, SAP or AWS (Amazon Relational Database Service) as these are typically not used in combination with PowerApps.
Below we have listed the most commonly used Microsoft products to store data with Canvas PowerApps.