75 of 238 questions · Page 3/4 · Power Apps Capabilities topic · Answers revealed
Which TWO data sources can be directly connected to a canvas app without using a premium connector?
Correct: Excel files in OneDrive or SharePoint are standard.
Why this answer
SharePoint and Excel are standard connectors included with Power Apps. Dataverse and SQL Server require premium licenses, and Salesforce is premium.
Your organisation has a Power Apps canvas app that uses a custom connector to call an external API. The API key is stored in a global variable. What is the security concern with this approach?
Global variables are part of the app code and can be seen by users with edit permissions or through debugging tools.
Why this answer
Storing an API key in a global variable within a Power Apps canvas app is insecure because the app's code is accessible to end users. Anyone with access to the app can view the global variable's value through the App object or by inspecting the app's formulas, potentially exposing the API key. The correct answer is D.
Option A is incorrect because custom connectors can be used with Power Apps. Option B is incorrect because global variables in Power Apps are writable, not read-only. Option C is incorrect because API keys typically do not expire quickly; the security concern is exposure, not expiration.
An organization has a model-driven app built on Dataverse. Users report that when they try to save a record, they receive an error about missing required fields, but they believe they filled them in. What is the most likely cause?
Correct. A business rule can conditionally require a field, which might not be obvious to the user, leading to the error.
Why this answer
Business rules can dynamically set field requirements based on conditions, which may cause users to see missing required fields even if they filled in all originally required fields. Option B is incorrect because write permissions would prevent saving entirely, not just show missing required fields. Option C is incorrect because Power Automate flows run after a record is saved, not before, so they cannot block the save.
Option D is incorrect because custom connectors are used for integrating external systems, not for Dataverse field validation.
A canvas app uses a SharePoint list with a choice column 'Status' (Pending, Approved, Rejected). The app needs to filter the gallery to show only 'Pending' items. The list has 50,000 items. Why does the filter not work as expected?
SharePoint choice columns are not delegable, so Filter runs on all 50,000 items locally.
Why this answer
SharePoint choice columns are non-delegable in Power Apps. When filtering a gallery with a choice column, the filter is applied locally, which fails to return all items when the list exceeds the delegation limit (default 500 items). This explains why filtering for 'Pending' does not work as expected with 50,000 items.
Option A is incorrect because the issue is delegation, not the column type itself (choice columns are delegable for some operations but not for filters with '='). Option B is incorrect because the gallery's Items property is set using the Filter function; the problem is that Filter is non-delegable for choice columns. Option D is incorrect because the syntax is not the issue; the formula may be syntactically correct but still fails due to non-delegable filter.
A company wants to build a mobile app for field service technicians to view and update work orders. The app must work offline when technicians are in areas with no connectivity. Which Power Apps capability should the developer use?
The Power Apps mobile app allows offline data caching and sync.
Why this answer
The Power Apps mobile app includes built-in offline sync capabilities that allow field service technicians to view and update work orders even when there is no network connectivity. Data is cached locally and synchronized with the server once connectivity is restored. Option A is incorrect because while canvas apps can be configured for offline use, the question specifically asks about the capability that enables offline functionality, which is the mobile app's offline sync feature rather than the development tool.
Option B is incorrect because Microsoft Dataverse offline profiles are a configuration option within Dataverse, but the enabling feature for offline use in Power Apps is the mobile app itself. Option C is incorrect because model-driven apps rely on Dataverse and can support offline, but again, the key capability that makes offline possible is the Power Apps mobile app's offline sync, not the app type.
A business needs to build a Power Apps app that allows sales representatives to view customer information and update order status while offline. The data source is Microsoft Dataverse. Which type of Power App should the maker create?
Canvas apps can cache Dataverse data for offline use.
Why this answer
Canvas apps can be enabled for offline use with Dataverse, allowing sales reps to view customer information and update order status without connectivity. Option A is incorrect because model-driven apps require online connectivity for full functionality; although offline profiles exist for mobile clients, they do not support all operations like creating new records or updating data while completely offline. Option B is incorrect because Power Pages is for external-facing websites, not offline mobile app scenarios.
Option C is incorrect because AI Builder provides AI capabilities, not offline data access.
A Power App uses a Timer control to refresh data every 5 minutes. The app experiences performance degradation after running for several hours. What is the most likely cause?
Non-delegable queries load entire dataset, consuming memory
Why this answer
If the data source does not support delegation, Power Apps loads all rows into memory each time the Timer control triggers a refresh. Over several hours, the accumulation of data in memory causes performance degradation. Option A is incorrect: while a Timer control could contribute to memory usage if not properly disposed, it does not inherently have a memory leak.
Option B is incorrect: a 5-minute interval is not excessively short for typical data refresh scenarios. Option C is incorrect: CDNs are used for static content delivery, not for resolving memory buildup from non-delegated queries.
A user creates a model-driven app for incident management. They want a custom button on the Incident form that, when clicked, creates a new activity record of type 'Phone Call' with the incident number in the subject. What is the recommended approach?
This is the standard, license-efficient method for custom actions in model-driven apps.
Why this answer
Adding a custom ribbon button with a JavaScript command that uses Xrm.WebApi.createRecord allows creating a new activity record with specific values directly from the form. Option A is incorrect because business rules cannot create new records; they can only set field values or show/hide fields. Option B is incorrect because custom connectors are used for external APIs, not for standard Dataverse operations.
Option C is incorrect because while Power Automate flows can create records, they require additional licensing and are more complex than a simple client-side script.
A model-driven app for project management uses a custom entity 'Project' with a status field. The app maker wants to show a timeline of project phases using a timeline control. What must be configured for the timeline to display correctly?
Timeline control displays activities related to the record; an activity entity is needed.
Why this answer
The timeline control requires a relationship to an activity entity (like Appointment) or a custom entity configured as an activity. Option A is wrong because the timeline does not require a specific field. Option B is wrong because timeline does not use subgrid.
Option D is wrong because timeline is not a standard SharePoint integration.
In a model-driven app, a user wants to see a map of all customer addresses on a form. Which feature should be enabled?
Map control renders addresses on a Bing Maps control.
Why this answer
The Map control in model-driven apps displays addresses on a map. Option A is wrong because the Notes section is for attaching notes to records. Option C is wrong because the Associated View shows related records in a list.
Option D is wrong because the Timeline control shows activities and communications.
A company wants to build a Power App that uses AI to analyze survey responses and extract sentiment. Which Power Platform capability should they use?
AI Builder offers sentiment analysis as a pre-built model.
Why this answer
AI Builder (C) provides pre-built models for sentiment analysis. A is for reporting. B is for automation.
D is for low-code, not AI.
Refer to the exhibit. You are reviewing the app definition XML for a model-driven app. Based on the exhibit, which tables are included in the app?
These are the three table components listed.
Why this answer
The <component> elements list account, contact, and opportunity, which are the tables included in the app. Option A is incorrect because 'lead' is not listed among the components; Option B is incorrect because it omits 'opportunity'; Option D is incorrect because 'salesDashboard' is a dashboard component, not a table.
A user wants to create a Power Apps canvas app that displays data from an Excel spreadsheet stored in Microsoft OneDrive for Business. Which connector should be used?
This connector works with Excel files in OneDrive for Business.
Why this answer
The correct connector for accessing an Excel spreadsheet stored in OneDrive for Business is the Excel Online (Business) connector. This connector enables Power Apps to read and write data from Excel files hosted in OneDrive or SharePoint. Option A (Dataverse) is a database service, not for file storage.
Option B (OneDrive for Business connector) is for file and folder operations, but not for reading Excel data directly. Option C (SharePoint connector) is for SharePoint lists and libraries, but the question specifies OneDrive storage, not SharePoint. Therefore, Option D is correct.
You have a model-driven app that includes a custom table. You need to add a field that calculates a value based on other fields (e.g., total price = quantity * unit price). Which type of field should you create?
Calculated fields allow formulas that compute values from other fields.
Why this answer
Calculated fields perform calculations at the data source level, such as total price = quantity * unit price. Option A is correct. Option B is wrong because text fields store plain text, not calculations.
Option C is wrong because choice fields provide a dropdown list of options. Option D is wrong because rollup fields aggregate data from related records, not compute values from fields in the same record.
A business analyst wants to create a simple expense report app without writing code. The app should allow users to submit expenses and managers to approve or reject them. Which type of Power App should the analyst use?
Canvas apps are designed for simple form-based apps with drag-and-drop ease
Why this answer
Canvas apps (Option A) are the correct choice because they allow business analysts to build custom apps without writing code, using drag-and-drop interfaces. They are ideal for simple forms like expense reports. Option B (Power Pages) is for creating external-facing websites, not apps.
Option C (Copilot Studio) is for building conversational AI chatbots. Option D (Model-driven apps) requires a Dataverse database and schema, which adds complexity and is not necessary for a simple expense report app.
Refer to the exhibit. You deploy this ARM template to create a Power Apps environment. What will be the SKU of the created environment?
The template explicitly sets environmentSku to Production.
Why this answer
The property 'environmentSku' is set to 'Production'. Options B, C, and D are incorrect because they do not match the value in the template.
An organization uses Power Apps to submit expense reports. The app connects to Dataverse. Users report that some submissions fail with a 'table not found' error. The developer verified the table exists. What is the most likely cause?
The app's service principal lacking read permissions can result in a 'table not found' error even though the table exists, because the app cannot access it.
Why this answer
The 'table not found' error despite the table existing most likely indicates a permissions issue. Option C is correct because if the app's service principal lacks read permissions, the app cannot access the table, resulting in a 'not found' error. Option A is wrong because a missing required column would cause a validation or submission error, not a 'table not found' error.
Option B is wrong because the developer verified the table exists, so renaming would have been noticed. Option D is wrong because a deprecated connector would cause connection issues, not a table-specific error.
Which THREE components are part of Power Apps Studio for building Canvas apps? (Choose three.)
Correct: Used to write Power Fx formulas.
Why this answer
Options A, C, and D are correct because Power Apps Studio for building canvas apps includes the Formula bar, Tree view, and Property pane. Option B (Solution Explorer) is incorrect because it is a component of Power Apps for model-driven apps, not canvas apps. Option E (Report Designer) is incorrect because it is a component of Power BI, not Power Apps Studio.
A user created a canvas app to collect feedback. The app writes data to an Excel file stored in OneDrive. When multiple users submit feedback simultaneously, some entries are lost. What is the most likely cause?
Excel cannot handle simultaneous writes; data conflicts or loss occurs.
Why this answer
Excel is not designed for concurrent multi-user writes. When multiple users submit data simultaneously, conflicts and data loss occur. Option A is incorrect because the issue is not performance but concurrency.
Option B is incorrect because OneDrive sync does not lock the file in a way that causes data loss; the underlying problem is Excel's lack of concurrent write support. Option C is incorrect because a Power Automate flow would not cause entries to be lost; it might introduce delays but not data loss.
A Power App connected to Dataverse uses a column of type 'Choice' with two options: 'Active' and 'Inactive'. The app needs to display only active records by default. Which filter expression should be used in the app's OnStart property?
Correct. Uses proper syntax: column name (no quotes) = 'Choice value'.
Why this answer
Uses the correct syntax: Filter(Accounts, Status = 'Active') with no quotes around the column name and single quotes around the choice value. Option D incorrectly uses double quotes around both the column name and value, which will cause an error. Options B and C also have wrong quotation usage.
Therefore, only Option A is correct.
Which TWO of the following data sources can be used directly in a canvas app without using a gateway? (Choose TWO.)
Dataverse is a cloud data source that does not require a gateway.
Why this answer
The correct answers are D (Dataverse) and E (SharePoint Online). Both are cloud-based data sources that can be directly accessed in a canvas app without needing an on-premises data gateway. On-premises data sources such as SQL Server, Oracle Database, and SAP HANA (options A, B, and C) require a gateway to connect from a cloud canvas app.
An organization is building a model-driven app on Dataverse. They need to ensure that only managers can delete records, and all other users can only edit them. What should be configured?
Security roles control create, read, write, delete, and share permissions.
Why this answer
Custom security roles allow you to define granular permissions for each user or team. By assigning a role with Delete privilege to managers and a role without Delete privilege (but with Write privilege) to other users, you can restrict deletion to managers only. Option A is incorrect because business rules run on the client side and cannot enforce server-side security; they are for business logic validation, not permission control.
Option B is incorrect because Power Automate flows are designed for automation and may not reliably intercept all delete actions, plus they can be bypassed. Option C is incorrect because business process flows guide users through stages but do not control record-level permissions.
Refer to the exhibit. The app uses a Dataverse entity 'contoso_inventory'. Users report that the gallery does not show items with Stock < 10. What is the most likely cause?
Correct. The data source filter 'status eq Active' is applied at the data source level. If items with Stock < 10 have a different status (e.g., 'Inactive'), they are excluded before the gallery sees them.
Why this answer
The data source filter 'status eq Active' is applied to the datasource before the gallery's Filter function. If records with Stock < 10 have a status other than 'Active', they are excluded by the datasource filter and never reach the gallery, causing the issue. Option B is false because Dataverse supports filter delegation for many operations.
Option C is the delegation limit of 500 records would limit the number of items shown, but it would not exclude all items with Stock < 10 unless they are all beyond the limit, which is unlikely. Option D is false because Dataverse supports delegation for numeric comparisons like '<' on the Stock column, so the Filter function is delegable and should apply to all records.
A healthcare organization needs a Power Apps app to track patient visit data. The data must be stored in Microsoft Dataverse, and the app should automatically generate a timeline of visits for each patient. Which app type is most suitable?
Model-driven apps provide built-in timeline and Dataverse integration.
Why this answer
A model-driven app is the most suitable choice because it is designed for complex, data-centric business applications that require rich relational data modeling, automated business logic, and built-in timeline controls. Dataverse provides the underlying relational storage, and model-driven apps natively support timeline components that automatically aggregate and display patient visit records in chronological order without custom development.
Exam trap
The trap here is that candidates often choose Canvas app because they think custom UI is needed for a timeline, but model-driven apps already include a native timeline component that automatically binds to Dataverse relationships, making it the correct choice for structured data tracking.
How to eliminate wrong answers
Option A is wrong because a Portal app is intended for external-facing, anonymous or authenticated user access (e.g., patient self-service), not for internal staff to track and manage patient visit data with a timeline. Option C is wrong because Power Automate is a workflow automation tool, not an app type; it can trigger actions but cannot serve as the primary user interface for data entry and timeline visualization. Option D is wrong because a Canvas app provides pixel-perfect custom UI but lacks the built-in timeline control and automatic Dataverse relationship handling that model-driven apps offer, requiring manual implementation of timeline functionality.
Refer to the exhibit. An administrator sees this JSON output from a Power Apps management command. The administrator needs to change the owner of the app to another user. Which tool should they use?
Admin center provides ownership management.
Why this answer
The Power Platform admin center provides the environment-level management capabilities needed to change app ownership. Option A is incorrect because Power Apps PowerShell cmdlets can also change ownership, but the admin center is the recommended and more accessible tool for non-scripting administrators. Option C is incorrect because Power Apps Studio is used for designing and editing apps, not for administrative tasks like changing ownership.
Option D is incorrect because Azure portal is used for managing Azure resources, not Power Apps administration.
Which THREE components are required to build a model-driven app in Power Apps? (Choose three.)
Tables define the data structure for the app.
Why this answer
Dataverse tables are the core data storage and management layer in model-driven apps. They provide the structured schema, relationships, and business logic (such as calculated columns and rollups) that model-driven apps rely on for data operations. Without Dataverse tables, there is no data source to bind forms, views, or the sitemap to, making them a mandatory component.
Exam trap
The trap here is that candidates often confuse canvas controls (used in canvas apps) with the form components of model-driven apps, or assume Power Automate flows are a core structural requirement rather than an optional add-on.
A company needs to create a mobile app for field service technicians to view and update work orders. The app should work offline and sync when connected. Which type of Power App should they build?
Canvas apps offer flexible design and can be built with offline capabilities.
Why this answer
A Canvas app is the correct choice because it supports offline capability via the Power Apps mobile player, which can cache data locally and sync changes when connectivity is restored. This is ideal for field service technicians who need to view and update work orders without constant internet access, as Canvas apps allow custom UI tailored to mobile scenarios and can leverage the Offline-first pattern with explicit sync logic.
Exam trap
The trap here is that candidates often confuse Model-driven apps with offline support because they think Dataverse's offline profiles are equivalent to Canvas apps' built-in offline, but Model-driven apps require complex configuration and are less suited for custom mobile UIs, while Canvas apps are the straightforward choice for offline-first mobile scenarios.
How to eliminate wrong answers
Option B is wrong because a SharePoint list app is simply a view or form on a SharePoint list, which does not natively support offline data caching or sync; it requires constant connectivity to the list. Option C is wrong because Power Automate is an automation tool for workflows, not an app-building platform; it cannot create a user interface for technicians to view or update work orders directly. Option D is wrong because Model-driven apps are designed for data-centric, form-heavy interfaces that rely on Dataverse and do not provide built-in offline capabilities without additional configuration (e.g., mobile offline profiles), and they are less flexible for custom mobile UI compared to Canvas apps.
You are designing a Power Apps model-driven app for a sales team. The app must enforce that a discount field cannot exceed 50% of the total price. Where should you implement this validation?
Business rules provide declarative validation on forms without code.
Why this answer
Business rules in model-driven apps provide real-time validation on forms. Option B is correct. Option A is wrong because the formula bar is for canvas apps.
Option C is wrong because Power Automate is for backend automation, not instant form validation. Option D is wrong because JavaScript can be used but is not the recommended low-code approach.
An organization needs to create a form for employees to submit vacation requests. The form should automatically calculate the number of days requested based on the start and end dates. Which type of app should they build?
Canvas apps provide flexible formulas to calculate values like date differences, making them ideal for this scenario.
Why this answer
Canvas apps allow flexible formulas, such as DateDiff, to automatically calculate the number of days between two dates, making them ideal for forms requiring custom calculations. Option A is wrong because Power Apps portal is designed for external-facing websites, not internal employee forms. Option C is wrong because Power Automate is an automation tool, not a form-building app.
Option D is wrong because model-driven apps use standardized forms and custom calculations are less straightforward compared to canvas apps.
A business analyst creates a model-driven app using Dataverse. They need to ensure that when a new lead is created, a task is automatically assigned to the sales team. Which component should be used?
A flow can automatically create a task when a lead is created.
Why this answer
Power Automate flows can be triggered by Dataverse events (e.g., when a record is created) to automate tasks. Therefore, option C is correct. Option A is wrong because a business rule can show or hide fields but not create records.
Option B is wrong because a calculated field computes a value but does not create tasks. Option D is wrong because a canvas app requires user interaction and does not automate the task creation process.
Refer to the exhibit. You are deploying a Power Apps environment using an ARM template. The template deploys a Production environment with Dataverse and the D365_FieldService template. After deployment, you need to ensure that users can create model-driven apps based on the Field Service tables. What additional step is required?
Licenses and app installation are required to use Field Service tables
Why this answer
After deploying the environment with Dataverse and the Field Service template via ARM template, users need appropriate Dynamics 365 licenses (which include rights to use Field Service) and the Field Service app must be installed in the environment (typically done through the Power Platform admin center or license assignment). This step is required to make the Field Service tables available for model-driven app creation. Option B is incorrect because the ARM template already includes Dataverse, so no manual database addition is needed.
Option C is incorrect because the deployed environment already contains the necessary template. Option D is incorrect because model-driven apps do not require Power Automate flows for basic functionality.
Which TWO features are unique to model-driven apps compared to canvas apps? (Choose two.)
Model-driven apps include BPF.
Why this answer
Options B and C are correct. Business process flows are unique to model-driven apps; they provide a guided workflow. Responsive design that adapts to screen size is built into model-driven apps, while canvas apps require manual layout adjustments.
Option A is incorrect because custom controls from Microsoft AppSource are available for both canvas and model-driven apps. Option D is incorrect because Power Fx formulas are primarily used in canvas apps (model-driven apps use forms and views with limited formula support). Option E is incorrect because offline capability can be configured in both canvas and model-driven apps.
A company is building a canvas app to track sales leads. The app must display a count of leads grouped by status (New, Contacted, Qualified, Closed). Which data source and visualization control should the app maker use to meet this requirement?
GroupBy groups records by Status, and CountRows(ThisItem.AllItems) counts records in each group.
Why this answer
Using a Gallery control with GroupBy(Leads, Status) groups the leads by status, and adding a Label with CountRows(ThisItem.AllItems) displays the count for each group, meeting the requirement to display counts per status. Option A is incorrect because a Data table control with GroupBy and CountRows in a column does not inherently group and aggregate correctly; the CountRows function would need to be applied per group, which is more complex. Option C is incorrect because a Form control is for data entry, not aggregating and displaying grouped counts.
Option D is incorrect because a Pie chart control can show proportions but requires an aggregated data source; directly connecting to a SharePoint list without grouping may not display counts correctly, and the description of 'Values as Count of Status' is ambiguous and not directly supported by the chart control without pre-aggregation.
Which TWO features are available in model-driven apps but not in canvas apps?
Correct: Model-driven apps have built-in BPF.
Why this answer
Model-driven apps include business process flows and dashboards natively, while canvas apps require custom implementation. Custom connectors and offline capability are available in both.
A company wants to build a Power App that allows sales representatives to capture customer feedback offline on their mobile devices. The feedback includes text, images, and signature. Which feature should be used to handle offline image and signature capture?
Canvas apps with offline mode can capture images and signatures using built-in controls and sync later
Why this answer
Canvas apps in Power Apps support offline capability, and the Camera and Signature controls can capture images and signatures while offline, syncing to Dataverse when connectivity is restored. Option A is incorrect because a SharePoint list with Power Apps integration does not support offline capture of images and signatures; SharePoint requires connectivity for such data. Option B is incorrect because although the Offline template and Dataverse provide offline capabilities, the Offline template is designed for basic data types and does not inherently support image and signature capture; you would need to use Camera and Signature controls as in option C.
Option D is incorrect because model-driven apps with Dataverse offline sync have limitations on which controls can be used offline, and typically they do not support the Camera and Signature controls in the same way a canvas app does.
A company needs to build a Power App that allows employees to submit IT support tickets. The app must be available from both Microsoft Teams and the web, and must use Dataverse for storage. Which type of app should be used?
Model-driven apps are built on Dataverse, can be embedded in Microsoft Teams, and are accessible via the web, making them the best fit for this scenario.
Why this answer
Model-driven apps are the correct choice because they are designed to work with Dataverse and can be embedded in Microsoft Teams and accessed via the web. They provide a structured, data-centric interface that aligns well with IT support ticket scenarios. Option A is incorrect because Power Pages sites are for external-facing websites, not internal apps.
Option B is incorrect because although canvas apps can connect to Dataverse, they are not primarily optimized for Dataverse-driven, structured data apps and may require more custom development. Option C is incorrect because Power Automate is a workflow automation tool, not an app platform.
A model-driven app has a business rule that sets the 'Priority' field to 'High' when the 'Request Type' is 'Urgent'. However, the rule does not fire when the request type is changed from the form. What is the most likely cause?
Business rules by default run on form load unless configured to run on change.
Why this answer
The most likely cause is that the business rule is configured to run only when the form loads, not when a field is changed. In model-driven apps, business rules can be set to trigger 'on form load' or 'on every change'. If the rule is set to 'on form load', it will execute only when the form initially opens and will not re-fire when the 'Request Type' field is changed later.
This matches option C. Option A is incorrect because scope 'All Forms' includes custom forms. Option B is incorrect because the condition type ('contains' vs 'equals') would not prevent the rule from firing; it would affect which records meet the condition.
Option D is incorrect because a deactivated rule would never fire, not just when changing a field.
A company uses a model-driven app to manage support tickets. Users want to automate the creation of a follow-up task when a ticket is resolved. Which component should be used?
Power Automate can automate task creation based on triggers.
Why this answer
Power Automate can trigger on record changes (e.g., status change to resolved) to automatically create a follow-up task. Option B is wrong because Microsoft Copilot Studio is for building chatbots, not for task automation. Option C is wrong because a custom Power Apps page would require manual interaction, not automation.
Option D is wrong because Business Rules are limited to simple form logic and cannot create records.
A company is designing a Power Apps canvas app for inventory management. They want to allow managers to approve or reject requests directly from their mobile devices. Which control should be used to collect the manager's decision?
Radio buttons are best for mutually exclusive choices like Approve/Reject.
Why this answer
A Radio control allows selecting one option from a set, ideal for Approve/Reject decisions. Option D is correct because a Radio control presents mutually exclusive choices clearly on mobile. Option A is wrong because a Drop down requires an extra tap to expand, less intuitive for two options.
Option B is wrong because a Checkbox is typically for binary yes/no but is not as clear for a single choice among two. Option C is wrong because a Text input requires typing, which is inefficient for a simple approval decision.
A company wants to create a Power Apps app that can be embedded in Microsoft Teams. Which type of Power Apps should they use?
Correct: Canvas apps can be easily embedded in Teams.
Why this answer
Canvas apps can be directly embedded in Microsoft Teams using the 'Add to Teams' feature. Option A is incorrect because Power Pages are for building public-facing websites, not for embedding in Teams. Option B is incorrect because Copilot Studio is a tool for creating conversational AI, not a Power Apps type.
Option C is incorrect because Model-driven apps are not directly embeddable in Teams; they require additional integration steps.
Which TWO are valid ways to share a canvas app with other users in your organization? (Select two.)
Security groups simplify access management
Why this answer
Adding users to a security group that has been granted access to the app is a valid way to share. Option C is correct because sharing the app directly with individual users or Microsoft Entra ID groups is the primary sharing method. Option A is wrong because the app must be published before sharing a link.
Option D is wrong because Power Apps does not generate public URLs for sharing. Option E is wrong because exporting as a .msapp file is for transferring between environments, not for sharing with users.
Which TWO data sources can be used directly in a canvas app without a premium connector? (Select two.)
SharePoint is a standard connector
Why this answer
SharePoint is a standard connector in Power Apps canvas apps. Option E is correct because Excel files stored in OneDrive for Business can be used through the standard OneDrive for Business connector. Option B is incorrect because SQL Server requires a premium connector.
Option C is incorrect because Dataverse requires a premium license. Option D is incorrect because Salesforce requires a premium connector.
Which TWO data sources can be directly connected to a Power Apps canvas app without using an on-premises data gateway? (Choose two.)
Outlook is cloud-based.
Why this answer
Microsoft 365 Outlook is a cloud-based service that can be directly connected to a Power Apps canvas app using built-in connectors without requiring an on-premises data gateway. The Outlook connector uses Microsoft Graph API to access mail, calendar, and contacts, making it a native cloud-to-cloud integration.
Exam trap
The trap here is that candidates often confuse 'on-premises' data sources (which require a gateway) with cloud-based services like SharePoint Online and Outlook, mistakenly thinking all Microsoft data sources need a gateway, or overlooking that SharePoint Online is a cloud service.
A user reports that a canvas app is loading slowly on mobile devices. The app uses multiple galleries with large data sources. What is the most effective optimization to improve performance?
Delegation reduces data loaded into the app.
Why this answer
Delegable queries reduce the data loaded into the app. Option A is wrong as it increases load. Option B is wrong as it adds overhead.
Option D is wrong as it moves data, not optimize.
Which TWO features are available in Canvas apps but NOT in model-driven apps? (Choose two.)
Correct: Canvas apps can use custom connectors; model-driven apps cannot.
Why this answer
Options C and D are correct because Canvas apps allow custom connectors to external APIs and custom JavaScript/Power Fx formulas, while model-driven apps use predefined logic and connectors. Option A is wrong because both Canvas and model-driven apps can embed Power BI reports. Option B is wrong because both support Dataverse integration.
Option E is wrong because both types support offline capability.
Which THREE components are part of a canvas app's formula language?
Correct: Functions are a key part of Power Apps formulas.
Why this answer
Canvas app formulas use functions, operators, and controls. Dataverse tables are data sources, not formula components. Power Automate flows are separate.
A company wants to build a Power App that can be used on mobile devices and tablets. They need the app to adapt to different screen sizes. Which feature should they use?
Enables adaptive design for various screen sizes.
Why this answer
Power Apps responsive layout containers allow controls to automatically resize and reposition. Option A is wrong because static layouts do not adapt. Option C is wrong because the mobile app does not automatically adapt layouts.
Option D is wrong because screen templates are fixed.
Which TWO of the following are capabilities of Power Apps? (Choose TWO.)
Power Apps is a low-code platform for building apps.
Why this answer
Options B and D are correct. Power Apps enables users to create custom business applications with low-code or no-code development, and these apps can be embedded directly into Microsoft Teams for easy access. Option A is incorrect because building interactive dashboards and reports is a capability of Power BI, not Power Apps.
Option C is incorrect as running serverless code in the cloud is done via Azure Functions. Option E is incorrect as workflow automation is the domain of Power Automate.
A company wants to build a Power Apps solution that integrates with Microsoft Teams. They want to embed the app directly into a Teams channel. Which type of app should they build?
Canvas apps can be embedded as a tab in a Teams channel, allowing users to interact with the app directly within the channel. This is the recommended approach for embedding a custom app into a channel.
Why this answer
Canvas apps can be embedded directly into a Teams channel using the Power Apps app in Teams. Option B is incorrect because AI Builder is not an app type; it is a feature for adding AI models to apps. Option C is incorrect because model-driven apps are designed for data-centric business applications and, while they can be added to Teams as a tab, they are not typically embedded directly into a Teams channel like a canvas app.
Option D is incorrect because Power Virtual Agents are chatbots, not the type of app needed for embedding into Teams.
A business user wants to build a Power Apps app without writing any code. Which type of app should they create?
Canvas apps are built with a visual designer and require no code.
Why this answer
Canvas apps are designed for low-code/no-code development, allowing business users to create custom applications by dragging and dropping elements onto a canvas and connecting them to data sources without writing code. This aligns directly with the user's requirement to build an app without coding.
Exam trap
The trap here is that candidates often confuse model-driven apps (which also require minimal code but rely on pre-defined data structures and business logic) with true no-code app creation, leading them to select D instead of recognizing that canvas apps offer the most straightforward no-code, drag-and-drop experience for custom UI design.
How to eliminate wrong answers
Option A is wrong because Power Automate flow is a workflow automation tool, not an app-building platform; it automates processes and tasks rather than creating user interfaces. Option B is wrong because Power Pages sites are for building external-facing websites, not custom business apps, and they require more configuration and often code for advanced functionality. Option D is wrong because model-driven apps are built using a metadata-driven architecture that requires defining data models and business logic, which typically involves more configuration and is less suited for a purely no-code, drag-and-drop approach compared to canvas apps.
You are troubleshooting a Power Apps issue. Using PowerShell, you run Get-AdminPowerApp and see the exhibit output. What does the EnvironmentName field indicate?
Each environment has a unique GUID.
Why this answer
The EnvironmentName field in Get-AdminPowerApp output is a GUID that uniquely identifies the Dataverse environment where the app is hosted. Option A is incorrect because it is not a license key; Option C is incorrect because it is not a custom connector name; Option D is incorrect because it is not a SharePoint site name. Only Option B correctly describes the field.
A user wants to create a canvas app from a Microsoft Dataverse table that contains customer information. The app should allow users to view, add, edit, and delete records. Which type of app should the user create?
Canvas apps can be built directly from a Dataverse table to manage records.
Why this answer
A canvas app created from a Dataverse table provides a customizable interface to view, add, edit, and delete records from that table. Option A is incorrect because Power Pages is for creating external websites, not canvas apps. Option B is incorrect because while model-driven apps can use Dataverse, they are not typically built from a single table with the same record management flexibility.
Option C is incorrect because Power Automate is for automating workflows, not for building record management interfaces.
A company wants to create a canvas app for field technicians to report equipment issues. The app must work offline and sync data when connectivity is restored. Which Power Apps feature should you enable?
This feature caches app data and syncs when connectivity is restored.
Why this answer
The 'Enable offline' feature in the Power Apps mobile app settings allows canvas apps to cache data locally and sync with the server when connectivity is restored, enabling offline operation. Option A is incorrect because Power Automate flows can queue operations but do not provide native offline data caching for canvas apps. Option B is incorrect because Dataverse offline profiles are used for model-driven apps, not canvas apps.
Option C is incorrect because the on-premises data gateway is for accessing on-premises data sources, not for enabling offline capabilities.
Contoso, Ltd. is a multinational company with a global sales team. They use Microsoft Power Apps to build a model-driven app for managing customer accounts and opportunities. The app uses Microsoft Dataverse as the data source. The sales team accesses the app on mobile devices while traveling. Recently, users have reported that the app is slow when loading large numbers of opportunities. The app has a custom page that displays a list of all opportunities without any filters. The page uses a gallery that loads all records at once. The app also uses several custom connectors to external systems, but the slowness is primarily observed when loading the opportunities list. The IT team has confirmed that the Dataverse environment is in the same region as the users, and network latency is not an issue. They need to improve the performance of the app. Which two actions should the IT team take? (Choose two.)
Delegation ensures large datasets are processed server-side, improving performance.
Why this answer
The correct answers are D and E. Implementing delegation in the gallery (D) ensures that filtering and sorting operations are performed server-side in Dataverse, reducing the amount of data transferred and improving load times. Adding a search box with a delegable filter (E) allows users to search for specific opportunities, and when the filter is delegable, the filtering happens on the server, further reducing the data retrieved.
Option A is incorrect because disabling real-time synchronization with Microsoft Entra ID would not address data loading performance and could cause authentication issues. Option B is incorrect because simply replacing a model-driven app with a canvas app does not inherently improve performance; both app types can be optimized, and the issue is with data loading, not the app type. Option C is incorrect because increasing Dataverse storage capacity does not affect query execution speed; it only increases available storage space.
Which THREE of the following are capabilities of model-driven apps? (Choose THREE.)
Model-driven apps support Dataverse business rules.
Why this answer
Correct answers: B, D, E. Option B: Business rules allow enforcing data validation on forms. Option D: Model-driven apps provide a unified interface across tablet and mobile devices.
Option E: They have responsive design that adapts to screen size. Option A is incorrect because model-driven apps use predefined forms and views, not custom drag-and-drop layouts — that capability is for canvas apps. Option C is incorrect because the built-in camera control is a feature of canvas apps, not model-driven apps.
A canvas app uses a gallery to display records from a SharePoint list. The app loads slowly because the gallery is set to load all items. The list contains 10,000 items. What is the most efficient way to improve performance?
Delegation pushes filtering to the data source, improving performance.
Why this answer
Adding a search box with a Delegation-compatible filter allows Power Apps to push the filtering operation to the data source (SharePoint), retrieving only matching records instead of downloading all 10,000 items locally. This drastically improves performance. Option A is incorrect because the function is named `LoadData`, not `Variables.loadData`, and `LoadData` loads data from a local cache, not from a datasource efficiently.
Option C is incorrect because setting the gallery's Items property to 'None' results in an empty gallery, which does not solve the performance problem. Option D is incorrect because `ClearCollect` loads all 10,000 items into a collection on the client side, causing the same slow performance as loading all items directly.
A non-profit organization uses Power Apps to manage volunteer information. They have a Dataverse table called 'Volunteers' with columns: Name, Email, Phone, Status (Active/Inactive). They want to create a dashboard that shows the count of active volunteers by city. The city information is stored in a separate 'Address' table related to Volunteers. Which approach should you use to display this data in a canvas app? A) Add a chart control and configure it to aggregate data from the Volunteers table. B) Use a group by in a gallery and apply a filter to count active volunteers by city. C) Create a Power BI tile embedded in the app. D) Use the 'CountRows' function in a label with a filter.
Group by in a gallery allows aggregation and display of counts by city.
Why this answer
Using a gallery with group by and filters can aggregate data. Option A: Chart control in canvas apps does not support related table data directly. Option C: Power BI tile requires additional licensing and setup.
Option D: CountRows in a label gives a single number, not breakdown by city.
A company wants to create a mobile app for field technicians to view and update work orders. The work orders are stored in a SharePoint list. Technicians need to filter work orders by status and take photos of completed work, attaching them to the work order. Which type of Power App should you recommend? A) Model-driven app B) Canvas app C) Power Pages website D) Power Automate flow
Canvas apps provide flexible UI, camera control, and easy integration with SharePoint.
Why this answer
Canvas apps provide a flexible, customizable user interface that supports camera controls for taking photos and can easily connect to SharePoint lists for data storage and filtering. Option B (Power Automate flow) is incorrect because it is an automation tool, not an app builder. Option C (Model-driven app) is less suitable due to limited UI customization for camera integration.
Option D (Power Pages) is designed for external websites, not mobile field technician apps.
A Power Apps model-driven app includes a business process flow (BPF) for order processing. After editing the BPF, some users see the old version while others see the new version. What is the most likely reason?
Correct: BPF changes are cached; refreshing the app loads the new version.
Why this answer
BPF changes are cached and refreshed when users reload the app. Admin vs. user views can differ due to security roles, but the inconsistency is due to caching.
Refer to the exhibit. The JSON defines a business process flow for expense reports in a model-driven app. How many stages must be completed before the process is considered complete?
The business process flow requires all stages to be completed.
Why this answer
Both stages 'Submit' and 'Approval' must be completed because the process flow includes them. Option C is correct. Option A is wrong because the process has two stages.
Option B is wrong because the Approval stage also needs completion. Option D is wrong because the process does not have three stages.
Which TWO components are required to create a model-driven app in Power Apps? (Choose two.)
Model-driven apps require Dataverse tables to store data.
Why this answer
Dataverse tables (Option B) are the fundamental data storage structure for model-driven apps. Every model-driven app must be built on top of at least one Dataverse table to provide the data schema, relationships, and security context that the app's views, forms, and dashboards rely on. Without a Dataverse table, the app has no data source to interact with.
Exam trap
The trap here is that candidates often confuse 'required components' with 'commonly used components'—they may think Power Automate flows or Power BI dashboards are mandatory because they are frequently integrated, but the exam specifically tests the minimal structural prerequisites (Dataverse table and a form).
An app maker wants to add a button in a model-driven app that, when clicked, creates a new record of a custom entity called 'Inspection'. The maker should use which feature?
Custom commands allow adding buttons that run actions.
Why this answer
A custom command can be added to the command bar in a model-driven app to create a new record for a custom entity. Option B (Power Automate flow) is wrong because while a flow can be triggered from a command, the question is about the feature used to add the button itself. Option C (Business rule) is wrong because business rules are used for validation and show/hide logic, not for adding buttons.
Option D (Form editor) is wrong because the form editor is used for form layout, not for adding command bar buttons.
Which TWO actions can be performed using Power Apps? (Choose two.)
Correct. Power Apps enables users to create custom mobile apps, such as one to capture customer feedback, without extensive coding.
Why this answer
Power Apps allows users to create custom apps with minimal code. Option D (create a mobile app to capture customer feedback) is a core use case for Power Apps, enabling rapid development of data-driven mobile applications. Option E (build a custom portal for external users to submit support tickets) can be achieved using Power Apps portals, which extend app capabilities to external audiences.
Option A describes Power BI (dashboards and visualizations). Option B is Power Virtual Agents (chatbots). Option C is Power Automate (workflow automation).
Therefore, the correct choices are D and E.
Which THREE are valid data sources for canvas apps in Power Apps?
SQL Server is supported via the SQL Server connector.
Why this answer
Correct: A, C, and D. SQL Server (A), SharePoint lists (C), and Microsoft Dataverse (D) are all supported data sources for canvas apps. Option B is incorrect because local Excel files are not directly supported; they must be stored in OneDrive or SharePoint to be used with the Excel Online connector.
Option E is incorrect because Oracle Database is not a built-in connector in Power Apps.
Refer to the exhibit. The following JSON shows a Power Apps component (canvas app) manifest snippet: { "properties": { "dataSources": [ { "name": "SalesData", "type": "Microsoft Dataverse", "entity": "accounts" } ], "screens": [ { "name": "MainScreen", "controls": [ { "name": "AccountGallery", "type": "Gallery", "items": "Filter(SalesData, status = 'Active')" } ] } ] } } What is the data source for the gallery named AccountGallery?
The Items property applies a filter to the data source.
Why this answer
The gallery's Items property uses the Filter function on SalesData, which is defined as a Dataverse entity 'accounts'. This means the data source is a filtered version of the Accounts entity (only records where status is 'Active'). Option B is incorrect because there is no SQL Server table referenced.
Option C is incorrect because SalesData is a Dataverse entity, not a SharePoint list. Option D is incorrect because the gallery uses a filtered set, not the raw, unfiltered Accounts entity.
A model-driven app uses a custom button that runs a Power Automate flow to send an email notification. Users report that the button sometimes does not appear on the command bar. The app maker checks the form customizations and confirms the button is configured correctly. What is the most likely cause?
Command bar customization allows role-based visibility; the user may be in a restricted role.
Why this answer
Custom buttons in model-driven apps can have visibility rules based on security roles, which would hide the button for users without the appropriate role. Option A is incorrect because browser compatibility does not affect button visibility. Option B is incorrect because the button was configured for all form factors.
Option D is incorrect because flow permissions affect the execution of the flow, not the visibility of the button.
Your organization is a multi-national corporation using Microsoft Power Platform. The compliance team requires that all Power Apps apps be auditable: every data modification (create, update, delete) must be logged with the user, timestamp, and old/new values. Additionally, the app must enforce that only users from the same business unit can view each other's records. The app uses Dataverse as the data source. You need to design the solution. Which approach should you take?
Correct: Dataverse auditing logs all changes, and business unit security limits record visibility.
Why this answer
Dataverse provides built-in auditing that logs data modifications (create, update, delete) with user, timestamp, and old/new values. Business unit security in Dataverse can restrict record visibility to users within the same business unit, meeting the compliance requirement. Option B is incorrect because hierarchy security is not designed for record visibility restrictions based on business units; business unit security is the appropriate feature.
Option C is incorrect because while Power Automate can create custom logs, it is not a native auditing solution and adds unnecessary complexity; field-level security does not restrict record visibility but rather specific field access. Option D is incorrect because creating a separate audit table and using Power Automate for logging is redundant since Dataverse auditing already provides this capability.
Which TWO data sources can be directly connected to a canvas app without using an on-premises data gateway?
Cloud-based, no gateway needed.
Why this answer
Options C and E are correct because SharePoint Online and Microsoft Dataverse are cloud-based data sources that can be directly connected to canvas apps without an on-premises data gateway. Options A, B, and D are incorrect because SQL Server on-premises, SAP ERP on-premises, and Oracle database on-premises all require an on-premises data gateway to connect.
Northwind Traders uses Power Apps to build a simple help desk ticketing system. The app uses Microsoft Dataverse as the data source. The help desk team wants to ensure that only members of the 'Help Desk Agents' security role can edit tickets, while all employees can view tickets. The app is a model-driven app. The administrator needs to configure the appropriate security. Which two actions should the administrator take? (Choose two.)
Assigning the 'Help Desk Agents' role grants agents edit permissions.
Why this answer
To achieve the desired security, the administrator should assign the 'Help Desk Agents' security role to the help desk team (option C) and ensure the 'Employees' security role has read privilege on the ticket table (option E). Option A is incorrect because creating a new table does not control permissions. Option B is incorrect because business rules do not manage security.
Option D is incorrect because sharing the app does not grant data-level permissions.
Which TWO of the following are types of apps you can create with Power Apps?
Canvas apps allow free-form design.
Why this answer
Canvas apps allow you to design a custom user interface by dragging and dropping elements onto a blank canvas, giving you full control over the layout and appearance. They connect to a wide range of data sources, such as SharePoint, Excel, or SQL Server, and are ideal for building task-specific or role-specific applications quickly.
Exam trap
The trap here is that candidates may confuse the broader Power Platform components (like Power Automate) or generic app categories (like web apps) with the two specific app types—canvas and model-driven—that Microsoft officially recognizes in Power Apps.
A company is building a canvas app to track inventory. The app needs to display the current stock level from a SharePoint list and allow users to update quantities via a form. Which connector should be used to read and write data?
SharePoint connector allows reading and writing to SharePoint lists.
Why this answer
The SharePoint connector, which provides read/write access to SharePoint lists. The Teams connector is for messaging, Power Automate is for workflows, and Microsoft Dataverse is a different data source.
You are developing a canvas app that uses a SQL Server database as a data source. The app needs to display a list of orders and allow users to filter by date range. The SQL table has millions of rows. To ensure optimal performance, which approach should you use? A) Use the 'Filter' function in Power Apps to filter the data on the client side. B) Use a SQL view that filters data server-side and call it via the SQL connector. C) Use Power Automate to retrieve data and pass it to the app. D) Use the 'Search' function on the gallery.
Using a SQL view that filters data server-side reduces data transfer over the network and leverages database indexing, ensuring optimal performance.
Why this answer
Using a SQL view that filters data server-side minimizes data transfer over the network, improving performance with large datasets. Option A: Using Power Automate adds unnecessary latency and complexity. Option B: The Filter function in Power Apps retrieves all rows from the SQL table and then filters client-side, which is inefficient for millions of rows.
Option D: The Search function also operates on client-side data, leading to performance degradation.
A developer is troubleshooting a canvas app that uses a SharePoint list as a data source. The app works for some users but fails for others with the error 'Access denied.' All users have read access to the SharePoint list. What could be the issue?
Power Apps inherits SharePoint permissions; users need read access to the list.
Why this answer
Even though all users have read access to the SharePoint list, the issue may be that some users lack specific permissions at the item or column level, or the app may be trying to access data beyond read permissions (e.g., creating or modifying items). Option B is incorrect because if the list were set to private, no users would have read access. Option C is incorrect because Power Apps licenses are not required for accessing SharePoint data through an app shared with them.
Option D is incorrect because the environment does not affect data source permissions.
A business analyst creates a model-driven app to manage customer service cases. The app includes a custom form with a field called 'Priority' that has three options: Low, Medium, High. The analyst wants to ensure that only users in the 'Service Managers' security role can change the priority of a case. What should the analyst do?
Field security profiles control read and write access per field per role.
Why this answer
Field security profiles allow restricting write access to specific fields based on user roles. Option B is wrong because editing the Service Manager security role to include write privileges for the Case entity would grant write access to all fields, not just Priority, and would not restrict other roles. Option C is wrong because setting the field to 'Read-Only' in the form editor applies to all users, not based on roles.
Option D is wrong because a business rule to hide the field does not prevent users with direct URL access or other methods from changing the field; it only hides it in the form.
An app maker creates a canvas app that uses Microsoft Dataverse as the data source. The app includes a gallery that displays all accounts. The app maker wants to filter the gallery to show only accounts where the 'City' field equals 'Seattle'. Which formula should be used in the Items property of the gallery?
Filter returns all records that satisfy the condition.
Why this answer
The Filter function in Power Apps filters a table based on a condition, returning a subset of records that meet the condition. In this case, Filter(Accounts, City = "Seattle") will return all accounts where the City field equals "Seattle". Option A is incorrect because the parentheses syntax does not filter; it is not a valid Power Apps function.
Option C is incorrect because the LookUp function returns a single record, not a filtered set. Option D is incorrect because the Search function searches for a string across one or more columns, not for an exact match on a specific field; it returns records containing the search term, not exact equality.
Ready to test yourself?
Try a timed practice session using only Power Apps Capabilities questions.