'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
SharePoint Storage Costs, Limits, and Power Apps Licensing Explained
Question details
The user is seeking information on SharePoint storage costs, list limitations, and Power Apps licensing requirements when migrating an application from Dataverse.
- Product
- Microsoft SharePoint & Power Apps
- Device & OS
- not provided
- Scenario
- Migrating a database from Dataverse to SharePoint for an application with over 500 users and approximately 2 TB of storage to reduce premium connector costs.
- Observed behavior
- The user needs clarity on whether additional SharePoint or Power Apps licenses are required for standard connectivity and what the storage and list limits are within Microsoft 365.
Ensure you have global or billing administrator access to the Microsoft 365 Admin Center to check your current tenant's subscription plan, storage allocation, and user licenses.
Review Microsoft 365 Licensing and SharePoint Limitations
Verify your current Microsoft 365 licenses and understand standard SharePoint limits before fully migrating from Dataverse.
When shifting from Dataverse to SharePoint to avoid premium connector costs, standard Microsoft 365 E3 or E5 licenses typically cover Power Apps usage with SharePoint as a standard connector.
SharePoint lists and libraries can contain up to 30 million items, but the list view threshold is limited to 5,000 items. Additionally, permission inheritance cannot be broken or re-established for folders containing more than 100,000 items.
Log in to the Microsoft 365 Admin Center, navigate to 'Billing' and select 'Licenses' to confirm your users have Microsoft 365 E3 or E5 plans which include Power Apps for standard connectors.
Go to 'Active sites' in the SharePoint Admin Center to monitor your current storage usage. To check additional storage pricing, visit 'Billing' > 'Purchase services' in the Microsoft 365 Admin Center, as costs depend on your specific tenant and region.
Review your application's Power Apps architecture. Ensure it only relies on standard connectors like SharePoint. If it still connects to other external services classified as premium connectors, additional licenses will be required.
Looking for a cost-effective alternative to Microsoft Office?
While SharePoint and Power Apps are powerful for enterprise database management, your everyday document, spreadsheet, and presentation tasks don't have to be expensive. WPS Office is a highly compatible, lightweight, and free alternative to Microsoft Office for your entire organization.
- 1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the software: Run the downloaded installer file and follow the simple on-screen instructions to set up WPS Office.
- 3. Open and edit files seamlessly: Launch WPS Office and instantly open your existing Microsoft Office documents without formatting loss.
Frequently Asked Questions
Do I need to pay extra for Power Apps if I use SharePoint as my database?
No. If your users are already licensed under Microsoft 365 E3 or E5, using Power Apps with standard connectors like SharePoint does not incur additional per-user premium costs, unlike Dataverse.
What is the maximum number of items a SharePoint list can hold?
A SharePoint list or library can hold up to 30 million items. However, the list view threshold is limited to 5,000 items, meaning you must use indexing and filtered views to manage and display large datasets effectively.
How much does additional SharePoint storage cost for my tenant?
SharePoint storage pricing varies based on your specific tenant, region, and Microsoft licensing agreement. You can view exact pricing options and purchase additional storage directly through the Microsoft 365 Admin Center under the Billing section.
