Power Apps Data Source Guide: Dataverse vs SharePoint for App Makers
Choose the right Power Apps data source with the five-trigger test, delegation realities, licensing notes, and a clean graduation path.
This category covers Power Apps concepts with a strong focus on Power Apps Code, PAC CLI, React project structure, Dataverse, and data-source integration. It is designed for makers and developers who want to understand where low-code and pro-code development meet.
Open the Power Apps Code learning hubYou will learn how to set up developer tooling, create a first Power Apps Code app, connect to Dataverse, understand generated project files, and think through data access. The articles are practical setup and build notes for real development work.
This article archive collects the concepts, setup steps, design choices, and common implementation patterns behind Power Apps. Use them as practical references while planning, building, testing, and improving Microsoft 365 solutions.
12 articles in “Power Apps”
Choose the right Power Apps data source with the five-trigger test, delegation realities, licensing notes, and a clean graduation path.
Name every screen, control, variable, collection, and data source in a canvas app so any maker can read your formulas at a glance — with prefix tables, good-vs-bad examples, and the community resources to go deeper.
Stop scrolling a 200-function alphabetical list. This hub groups every Power Fx function by the job makers hire it for, calls out the dozen you will use every week, and points to the official syntax whenever you need the full detail.
Learn how React components work in Power Apps Code Apps, including props, state, events, reusable UI patterns, data binding, accessibility, and project structure.
Learn how to connect Power Apps Code apps to Azure SQL Database with PAC CLI, secure authentication, queries, stored procedures, and scalable enterprise data patterns.
A practical first-app walkthrough for Power Apps Code: create the Vite React starter, authenticate PAC CLI, initialize the code app, run it locally, build it, and publish it to Power Apps.
A hands-on guide to connecting a Power Apps Code app to Microsoft Dataverse with the PAC CLI: prerequisites, authenticating your environment, adding a Dataverse table as a data source, the auto-generated service and model files, and full create, read, update, and delete examples.
A folder-by-folder, file-by-file tour of a Power Apps Code (React + Vite + TypeScript) project scaffolded by the PAC CLI. What .power, node_modules, public, src and generated are for, what App.tsx, main.tsx, package.json and power.config.json do, and which files to leave alone.
A plain-English introduction to Microsoft Power Fx — the Excel-like, low-code language behind Power Apps and the wider Power Platform. What it is, why it "thinks spreadsheet", how declarative formulas auto-recalculate, the no-code to pro-code spectrum, its design principles, and where you use it.
The current focus is Power Apps Code and developer-oriented Power Apps patterns.
Some articles are beginner-friendly, but Power Apps Code is most useful when you are comfortable with front-end development basics.