© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
D. DingTransitioning to Microsoft Power Platformhttps://doi.org/10.1007/978-1-4842-9239-6_7

7. SharePoint Lists

David Ding1  
(1)
Sydney, NSW, Australia
 

This chapter may come as a bit of a surprise after SQL Query. It is mostly true that SQL Server is a better data storage solution than SharePoint list. The issue with SQL Server is that most analysts cannot add or edit the data in a SQL table. This ability to edit data records is fundamental for the following chapters on automation and building business applications.

This chapter is an important bridging chapter between business intelligence and business applications. A SharePoint list is preferred over other ...

Get Transitioning to Microsoft Power Platform: An Excel User Guide to Building Integrated Cloud Applications in Power BI, Power Apps, and Power Automate now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial