As the Power Platform evolves and becomes a Low-Code Application Platform (LCAP) of choice for enterprise organizations (a leader in Gartner 2023 Magic Quadrant for LCAPs), the need to consider a more robust data source than SharePoint Lists for your Power Apps becomes critical. There are a couple of options to consider including Dataverse for Teams, Dataverse, Azure SQL, and SQL Server. This post will focus on two common data source options, SharePoint Lists and Dataverse (not Dataverse for Teams), and the considerations for using one over the other in your Power App.
Let’s start with the basics:
A SharePoint List is a collection of data that you can share with others. A Power App can be created to interact with the data in a SharePoint List. SharePoint Lists have been around for many years and often, organizations already have their data stored in Lists. SharePoint Lists are part of your SharePoint/M365 subscription and do not require additional licensing.
Dataverse (formerly Common Data Service – CDS) is a relational database like SQL Server that allows you to securely store and manage data in the cloud. Dataverse provides robust options for complex enterprise requirements and comes with an additional licensing cost.
Important questions when choosing between SharePoint Lists and Dataverse
If licensing is not a consideration, we’d likely recommend Dataverse for all but the simplest personal productivity applications. To determine which option, SharePoint Lists or Dataverse, is best for you, you’ll want to ask the following questions:
- What types of data (and how much of it) will your Power App require?
- How do you want to search the data?
- How will the app be made available to your users?
- Will guests be accessing the app?
- Who will build the app – low-code or pro-code developers?
- What special capabilities does your application need?
- Are any integrations required?
Admin and Governance:
- What are your organization’s security and compliance requirements?
- Are there special requirements for backing up and restoring data?
- Is premium licensing available or can it be purchased?
From there, you’ll want to have a Power Apps Architect review the answers to these questions along with the following considerations between SharePoint Lists and Dataverse, adapted with our comments from the Microsoft Learn Site.
Considerations between SharePoint Lists and Dataverse
While the capabilities of Dataverse are full-featured and preferred for enterprise-grade Power Apps, the licensing implications have been a key consideration for our customers. Depending on the size of the organization and who is commissioning the Power App, the business and IT stakeholders may be far removed from the Microsoft 365 Platform Owner and unclear as to how to request licensing, especially if early on in the Power Platform journey.
Get expert help with the Power Platform
If you are new to the low-code/pro-code approach using the Power Platform and would like to work with a qualified partner, reach out at any time to discuss Compass365’s Power Platform Consulting Services We are happy to help. Please contact us to arrange for a complimentary consultation.
Compass365, a Microsoft Gold Partner, delivers SharePoint, Microsoft Teams, and Power Platform solutions that help IT and Business leaders improve the way their organizations operate and how their employees work.