Community Q&A
PL-200 — frequently asked questions
Community-vetted answers to 46 common questions about this exam, each traced back to a specific practice question.
Questions from real practice questions
Each Q&A comes from a specific question — follow the link for the full analysisMinimizing Dataverse Storage with SharePoint Integration
Why is SharePoint on-premises better for Dataverse storage?
It stores files outside Dataverse, preserving Dataverse quota for structured data and avoiding BLOB storage limits.
Is SharePoint on-premises supported with Dataverse?
Yes, Microsoft supports integration between Dataverse and on-premises SharePoint Server for document management.
Preventing Duplicate Rows in Dataverse Tables
Why doesn't Duplicate Detection stop duplicates?
It displays a warning dialog but allows the user to click 'Save Anyway'. It is a advisory tool, not an enforcement constraint.
How to strictly prevent duplicates in Dataverse?
Use Alternate Keys. They act as unique constraints and will throw a runtime error if a duplicate value is submitted, blocking the save.
Power Pages Security Configuration for Store Managers
Why is Option B incorrect in this scenario?
Option B is incorrect because table permissions are indeed the correct mechanism to enforce record-level security in Power Pages.
Do I need web roles if I have table permissions?
Yes, table permissions must be associated with web roles to apply the restrictions to the specific users (managers).
Power Pages Site Security Configuration
Why isn't Entra ID enough for Power Pages security?
Entra ID only handles authentication (verifying identity). It does not handle authorization (permissions), which is needed to restrict users to specific store data.
How do I restrict users to specific stores in Power Pages?
You must create Security Profiles and assign them to Teams or Users, then configure record-level permissions to limit access to specific business units or records.
Power Automate Cloud Flow Formula for Dataverse
Why is triggerOutputs() used instead of outputs('trigger')?
In Power Automate, triggerOutputs() is the standard function to retrieve the entire output of a trigger action, allowing access to dynamic content fields like body properties.
What if the Account Category Code is null?
The requirement states that if the code is not populated (null), it should default to 'Standard'. The else clause in the if statement handles this default case.
How Do You Lock a Power Pages Chatbot to Entra ID Users?
Why is "set up a new channel" not enough to keep the chatbot on Power Pages?
Adding a channel only creates another entry point, and anyone who obtains the bot ID could still use it. Web channel security is the setting that limits the bot to your Power Pages domain.
Why does manual authentication fit the Entra ID requirement for a Power Pages bot?
Manual authentication lets you configure the OAuth connection to Microsoft Entra ID, so only signed-in Entra ID users can chat when sensitive data is involved.
Storing Scanned Consent Forms in Power Platform
Why can't I use Notes to store scanned forms?
Notes are stored directly in Dataverse. Given the constraint to minimize Dataverse storage costs, using Notes for large scanned PDFs would increase expenses significantly compared to SharePoint.
Does SharePoint integrate with Model-Driven Apps?
Yes, SharePoint integrates well with Power Platform. You can add a lookup column in Dataverse that points to a SharePoint library, allowing seamless access to documents from the app interface.
Power Apps Environment Variable Resolution in Managed Solutions
Why isn't B (Remove current value) the best answer?
Removing the current value can cause import failures if no default is set. Updating the current value A provides a more controlled state.
Does updating the current value in Dev affect Prod?
No, the current value is environment-specific. You update it in Dev to define the solution's intent, then manage Prod's specific values via deployment or defaults.
Preventing Table Display Name Changes in UAT
Why can't I set managed properties in a Managed solution?
Managed solutions are immutable. You cannot edit components or their properties within them. Restrictions must be defined in the Unmanaged solution before export.
Does importing a solution as Managed automatically lock all fields?
No. Only the fields explicitly marked with 'Can be changed' set to false in the Unmanaged solution will be locked upon import.
What Features Are Supported by Microsoft Power Fx?
Why is Power Fx described as using Excel-like formulas?
Power Fx adopts Excel's expression model — '=' followed by functions such as If, Filter, and Sum — so spreadsheet-literate makers can build Power Platform solutions without learning a new syntax.
Is Power Fx the same as the model-driven app formula language?
No. Power Fx is a separate, Excel-derived language that model-driven apps can use; it originated from the canvas app formula language and now spans multiple Power Platform surfaces.
Does Power Fx use synchronous data operations?
No. Power Fx formulas are declarative and its data operations are generally asynchronous, with functions like Concurrent and Asynchronous controlling behavior.
What Is a Capability of Virtual Tables in Dataverse?
Why can't a virtual table be configured for user or team ownership?
Virtual tables do not hold their own rows in Dataverse, so they remain organization-owned; user and team ownership applies to standard tables that store data locally.
Do virtual tables support Dataverse auditing?
No. Auditing tracks changes to data stored in Dataverse, while virtual table records live in the external system, so Dataverse auditing does not apply to them.
Does an alternate key prevent duplicate rows in a Dataverse table?
Why does an alternate key stop duplicate rows in Dataverse?
An alternate key is a platform-level uniqueness constraint over one or more columns, so Dataverse rejects any insert or update that repeats the same combined values, no matter which app writes the row.
Would a Power Automate flow or duplicate detection rule be better here?
No. Flows and duplicate detection rules are conditional or advisory and can be bypassed or disabled, while an alternate key is a hard constraint enforced by Dataverse itself.
Can Power Fx Formula Columns Prevent Duplicate Dataverse Rows?
Why doesn't a Power Fx formula column prevent duplicate Dataverse rows?
Formula columns compute a value for the current row using Power Fx; they cannot query the table to block an insert with the same Name, Company, and Contacted On values.
What Dataverse feature should be used instead to stop duplicate rows?
Define an alternate key or a duplicate detection rule on the table, which Dataverse enforces at the platform level for canvas and model-driven apps.
Where Should You Create a View for All Users in Dataverse?
Why is the List view of the table (C) not the correct place to create an organization-wide view?
The list view in an app is where users see records and can create personal views. An organization-wide system view must be authored from the table component in a solution.
Does creating a system view in a Dataverse solution require custom code?
No. Views are configuration components; adding a table to a solution and creating a view in its table component uses built-in designer tools without writing code.
Does enabling table attachments minimize Dataverse storage?
Why does enabling table attachments increase Dataverse storage?
Attachments are stored in the Dataverse environment and consume file storage capacity, so they add to usage instead of reducing it.
What is the recommended way to minimize Dataverse storage for documents?
Use SharePoint integration so documents remain in SharePoint and Dataverse stores only a reference to each document.
Which tool displays a sorted, expandable record list in Power Apps?
Why is a gallery better than a card for showing a sorted list of records?
A gallery repeats its layout for every row of a data source and its Items property can be sorted with SortByColumns, while a card represents only one field inside a form and cannot render a list.
How does a gallery expand or hide the list by subtopics?
Use a nested or grouped gallery and control its Visible property with a context variable toggled by a header control, so each subtopic group can be shown or collapsed by the user.
Viewing Website Questions and Comments in Power Pages
Does the Feedback entity replace the Contact entity?
No. Feedback stores the form submission content. Contact stores the person's profile. They are linked but distinct.
Can I change the Contact Us form to save to Leads?
Yes, by customizing the form logic or using Power Automate, but the default starter layout uses Feedback.
How Should You Auto-Create Evaluation Records for a Prospect?
Why can't a classic Dataverse workflow create the Evaluation record?
Classic workflows are legacy, and Power Automate cloud flows are the recommended no-code automation for Dataverse; cloud flows also integrate more easily with the coaches' canvas apps.
Why is a plug-in wrong for creating the Evaluation record?
Plug-ins are compiled C# code, and the case study states custom code is not allowed. They also cannot be created without a developer deployment.
Why is a quick create form not the answer?
The Evaluation table explicitly states records cannot be manually created, and a quick create form only supports manual entry by a user.
Promoting Power Platform Solutions via Solution Package
Why not use the Power Platform admin center?
The admin center is for governance and environment settings, not for building or exporting solutions.
Can I use Azure DevOps for this?
While integration exists, the standard method for creating the initial package is via the maker portal.
Does Local Authentication Secure a Power Pages Site for Store Managers?
Why is local authentication wrong for Power Pages store managers?
Local authentication issues its own username and password, so it cannot validate the managers' corporate identity or enable Microsoft Entra ID-based weekly sign-in.
How do I restrict managers to their own store's stock records?
Use Power Pages web roles and table permissions so each authenticated manager can only read and update rows tied to their store.
How to Automate Qualification Verification in Power Automate?
Why is the Outlook connector not needed for qualification verification?
The Outlook connector sends client emails only in the separate service request completion flow; qualification verification just updates Dataverse Qualification records.
Why is an on-premises data gateway not required here?
The authority website is public and Dataverse is cloud-based, so no on-premises data source connection is needed for this flow.
How Should a Power Virtual Agents Chatbot Handle Unrecognized Questions?
Why not just create new topics for the questions users ask?
New topics only match utterances you anticipated and authored trigger phrases for; unrecognized questions by definition have no matching topic, so the effort never ends.
Doesn't the Escalate system topic already handle unrecognized input?
No. Escalate fires on explicit escalation intent or when a topic redirects to it, so it never triggers on an unmatched utterance — only the Fallback topic does.
← Back to Microsoft PL-200 Power Platform Functional Consultant Study Guide