Power Apps interview questions test whether you can build apps that stay correct and fast with real data: canvas versus model-driven apps, Dataverse, Power Fx functions such as Filter, LookUp and Patch, delegation, variables and named formulas, and application lifecycle management with solutions and environments. Senior candidates are pushed on performance, security and governance.
Details below were checked on Microsoft Learn on November 17, 2026. One number to know: when a query can't be delegated, Power Apps processes only the first 500 records by default, and the Data row limit setting can be raised to 10,000 (many older articles still say 2,000). The data and reporting side is in Power BI interview questions.
Power Apps fundamentals: questions 1–9
- Canvas vs model-driven apps? Canvas apps start from a blank screen where you place every control and formula and can connect to many data sources; model-driven apps are generated from Dataverse tables, forms, views and business process flows, with less layout control and a strong data and security model. Power Pages is the separate product for external websites.
- What is Dataverse? The Power Platform's managed database: tables, relationships, choices, business rules, role-based security down to rows and columns, auditing and solutions. Most uses need premium licensing.
- What is Power Fx? The low-code formula language of Power Apps, based on Excel: formulas recalculate when inputs change, and behaviour functions such as
Set,PatchandNavigateare allowed only in behaviour properties such asOnSelect. - Set vs UpdateContext vs collections?
Set(gblUser, User())makes a global variable,UpdateContext({locShowPopup: true})a screen-level one, andClearCollect(colItems, ...)an in-memory table. Prefer named formulas or direct references when you don't need mutable state. - Filter vs LookUp vs Search?
Filter(Orders, Status = "Open")returns a table;LookUp(Customers, ID = varID)returns the first matching record or one field of it;Search(Products, txtSearch.Text, Name)searches text columns. Each can delegate on supporting data sources. - Patch vs SubmitForm?
SubmitForm(frmEdit)saves an Edit form with its validation andOnSuccessandOnFailurehandling;Patch(Orders, Defaults(Orders), {Title: txtTitle.Text})creates or updates records directly, for custom layouts or several records at once. - How do galleries work? A gallery repeats a template for each record in its
Items;galOrders.Selectedis the chosen record andThisItemis the current record inside the template. - Standard vs premium vs custom connectors? Standard connectors such as SharePoint, Outlook and Teams come with Microsoft 365 licences; premium connectors such as SQL Server, Dataverse and HTTP need Power Apps premium licensing; custom connectors wrap your own REST API with an OpenAPI definition.
- What is an environment? A container for apps, flows, connections and at most one Dataverse database, with its own security and region. A typical setup has development, test and production environments.
Intermediate Power Apps questions: 10–18
- What is delegation? Power Apps sends the query to the data source when the formula is delegable; otherwise it fetches only the first 500 records by default, the Data row limit, adjustable from 1 to 10,000, and processes them locally, which can silently return wrong results. A yellow warning and blue underline flag it.
- Which functions can't be delegated? Microsoft lists
FirstN,Last,LastN,Choices,Concat,Collect,ClearCollect,GroupByandUngroup, and string functions such asLen,MidorLowerinside a filter block delegation. Support for the rest depends on the data source. - How do you test for delegation problems? Set the Data row limit to 1 while testing, as Microsoft suggests: anything not delegated then returns a single record, so the problem shows up immediately rather than in production.
- What are named formulas? Definitions in
App.Formulas, such asUserEmail = User().Email;, that are always up to date, can't be changed elsewhere and are calculated only when needed. Microsoft recommends them over setting global variables inOnStart, which can slow app loading. - OnStart vs StartScreen vs OnVisible?
StartScreenchooses the first screen (Microsoft has retired usingNavigatein OnStart);OnVisibleruns when a screen appears;OnStartstill works for caching but runs non-blocking by default, so other formulas may read its variables before it finishes. - How do you handle errors? Wrap risky calls in
IfError(), checkErrors(DataSource)after a Patch, tell the user withNotify(), and useApp.OnErrorwithTrace()to log centrally, for example to Application Insights. - Why use components? Reusable controls with custom input and output properties, such as a header or an address block, kept in component libraries so many apps get updates at once.
- Managed vs unmanaged solutions? Unmanaged solutions are for development and stay editable; managed solutions are deployed to test and production, locked against direct edits and removable as a unit. Environment variables and connection references let a solution move between environments unchanged.
- How do you secure a canvas app? Hiding a button isn't security. Secure the data: Dataverse security roles and column security, SharePoint permissions or SQL permissions, share the app with groups, and check what each connector exposes to users.
Experienced Power Apps questions: 19–27
- How do you make an app load and run faster? Delegate queries, load only needed columns, run independent loads in parallel with
Concurrent(), keep OnStart light, use named formulas, limit controls per screen, and trace slow calls with Monitor. - How do you update many records efficiently?
Patch(Orders, colChanges)with a table of changed records,ForAllwith Patch when each record needs its own logic (slower), or a Power Automate flow or Dataverse plug-in for large batches. - How would you set up ALM for Power Apps? Keep solutions in source control (export and unpack with the Power Platform CLI,
pac solution exportandpac solution unpack), build managed solutions in Power Platform Pipelines, Azure DevOps or GitHub Actions, set environment variables per stage and keep production locked. - What are data loss prevention policies? Admin policies that group connectors as business, non-business or blocked, so an app or flow can't mix, for example, SharePoint with a personal social connector. They apply per environment or across the tenant.
- How do you support offline use? Model-driven apps on mobile use Dataverse offline profiles; canvas apps can cache with
SaveDataandLoadDataor use Dataverse offline support, then sync and resolve conflicts on reconnect. State the limits rather than promise full offline. - How do you extend model-driven apps? Forms, views, business rules, business process flows, command bar buttons with Power Fx, JavaScript web resources for complex form logic, and custom pages that embed canvas screens.
- SharePoint lists or Dataverse as the back end? SharePoint suits simple, low-volume apps without premium licences, but relationships, delegation and security are limited. Dataverse suits relational data, row-level security, auditing and scale, at a licence cost. Say both sides.
- How do you handle two users editing the same record? Assume the last write wins unless you design for it: re-read the record before updating, save only changed fields, catch and show errors, and use Dataverse autonumber columns for IDs instead of computing them in the app.
- Where does Copilot fit in Power Apps? Makers can describe an app or table in plain language to generate a starting point, and add Copilot features to apps. Interviewers mainly want to hear that you review generated formulas, data models and security before shipping.
Power Apps scenario and troubleshooting questions: 28–30
- A gallery shows only 500 of 3,000 SharePoint items. A non-delegable formula. Find the warning, rewrite with delegable functions on indexed columns, or filter on the server. Raising the Data row limit is a stopgap, not a fix.
- The app takes 15 seconds to open. Move OnStart work to named formulas or screen OnVisible, load data with
Concurrent(), remove unused data sources, and use Monitor to find the slowest call. - Users get connection errors after deployment to production. Look for missing or unshared connection references, a DLP policy blocking a connector combination, users without permission on the data source, or users without a licence for a premium connector.
How interviews test Power Apps
| Round | What they ask | What a strong answer shows |
|---|---|---|
| Screen | Canvas vs model-driven, Dataverse, licensing basics | Picking the right app type for a scenario |
| Technical round | Write Filter, LookUp and Patch formulas; explain delegation | Formulas that stay correct past 500 records |
| Build exercise | A small app from a list or table, often timed | Clean screens, error handling, sensible variables |
| Senior round | ALM, DLP, security model, performance | Governance and a deployment plan |
Candidates commonly report a live build or a take-home app followed by a walk-through, so practise explaining each formula aloud. Apps often sit on SharePoint lists and call Power Automate flows, and analyst-style roles overlap with business analyst interview questions.
Where CoPilot Interview fits
CoPilot Interview is an AI interview assistant whose free AI mock interview builds Power Apps and Power Platform questions from your résumé and the job description, reads them aloud and scores each spoken answer out of 10, which is a quick way to find the answers above that you can't yet explain without notes. The free plan gives 15 minutes a day of live help in sessions of up to 15 minutes, with AI mock interviews included. The browser demo at /try has 145 practice questions in 10 tracks with typed answers scored out of 10, no signup needed. Paid plans are Standard at $24.99 a month and Pro at $39.99 a month, and the desktop app runs on Windows 10 and 11 and macOS 12 or later. Technical screens, take-home tasks, online assessments and proctored tests usually forbid outside help, so prepare for those rather than use any tool during them; in any live interview, follow your employer's rules.
Disclosure: CoPilot Interview is our product, so weigh what we say about it accordingly.
Frequently asked questions
What are the most common Power Apps interview questions?
Canvas vs model-driven apps, delegation and the Data row limit, Patch vs SubmitForm, Set vs UpdateContext, Dataverse vs SharePoint, galleries, and managed vs unmanaged solutions.
What is the delegation limit in Power Apps?
When a query isn't delegated, Power Apps works on the first 500 records by default; the Data row limit can be set from 1 to 10,000, according to Microsoft Learn as of November 17, 2026.
Do I need to know Dataverse for a Power Apps job?
For most enterprise roles, yes: tables, relationships, security roles and solutions come up often. Smaller teams may build mainly on SharePoint, but Dataverse knowledge sets you apart.
How do I practise Power Apps for an interview?
Use a free developer plan environment to build one canvas app on a large list (to meet delegation), one model-driven app on Dataverse, and move both through a solution to a second environment.
Practice this interview before the real one
The AI mock interview builds questions from your resume and the job description, reads them aloud and scores each spoken answer out of 10. Included on the free plan.
Start a mock interview