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.
5 Minute Vlog – Database for PowerApps
Unsure which database is right for your PowerApp? Watch the vlog on this topic of “What’s the best Database for PowerApps” by clicking the image below.
Article by: Dougie Wood
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.
Microsoft Excel Spreadsheet: Database for Power Apps
A Microsoft Excel Spreadsheet hosted in either SharePoint Online or a OneDrive for Business is a viable option for small teams to store data. Using Excel would be the smallest scaled database.
This would be sufficient for personal use Power Apps or if you only plan to store up to a few thousand rows of data. Main benefits of this option include being quick to setup and not requiring an Office 365 Admin to setup an area to store your data.
Microsoft Lists (SharePoint Lists): Database for Power Apps
The most commonly chosen place to store data that we recommend is within Microsoft Lists. These Lists are essentially stored on SharePoint sites and are great for small (SMB) organisations to store up to one hundred thousand rows of data.
Using Microsoft Lists within Office 365 as a DataSource is also a chosen option as SharePoint Online is included within the majority of Microsoft 365 licenses, meaning there is no additional cost.
Microsoft SQL: Database for PowerApps
If you need to store hundreds of thousands or more rows of data to use with your PowerApp, then Microsoft SQL could be considered.
However, it will have a few down sides including additional premium licenses that are required for end users to access SQL data.
Your PowerApp might be being built to interface with an existing SQL database. However, it can be a very costly process to setup and support a new Microsoft SQL environment for your new PowerApp.
So, if you require a database to store large volumes of data then consider Dataverse (Formerly Common Data Service) instead.
Dataverse (Formerly Common Data Service): Database for PowerApps
Dataverse is the best option if you need to store hundreds of thousands of rows of data.
Choose Dataverse if you are looking for a database that will scale to enterprise levels over time.
The key difference of Dataverse is that it is a relational database just like Microsoft SQL compared with the other options. This will allow you to form relationships and lookups to other tables of data.
The downside of this option is that it will require premium licenses which can be quite costly.
Contact our Experts
I hope you found this article useful, if you are interested in getting some assistance with Power Apps, please feel free to contact me with any questions using our contact us form.
If you are interested in PowerApps then please download our free PowerApps white paper.