DRAG DROP (Drag and Drop is not supported)You are modifying a model-driven app. You set up a customer table in Microsoft Power Platform to retrieve user data.You set up a form with the following columns for users to enter their data. The form includes the following columns:The form must do the following:The Country/region column must automatically populate with US when English is chosen as a language. If the user selects Other for this column, the column must remain blank so that user can enter a value. The Passport expiration date column must appear only if the user selects Yes in the Passport ownership column.You need to configure the app with the least amount of effort.What should you configure? To answer, drag the appropriate solution component to the correct requirements. Each solution component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
Answer(s): A
Box 1: FormulaThe Country/region column must automatically populate with US when English is chosen as a language. If the user selects Other for this column, the column must remain blank so that user can enter a value.Formula columns are columns that display a calculated value in a Microsoft Dataverse table. Formulas use Power Fx, a powerful but human-friendly programming language. Build a formula in a Dataverse formula column the same way you would build a formula in Microsoft Excel. As you type, Intellisense suggests functions and syntax, and even helps you fix errors.Box 2: Business ruleThe Passport expiration date column must appear only if the user selects Yes in the Passport ownership column.By combining conditions and actions, you can do any of the following with business rules:Set column valuesClear column valuesSet column requirement levels*-> Show or hide columnsEnable or disable columnsValidate data and show error messagesCreate business recommendations based on business intelligence.
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-business-rule
You have a canvas app.The canvas app must store data in a variable that is available only to the current screen.You need to create the variable.Which two functions should you use? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
Answer(s): A,B
Types of variablesPower Apps has three types of variables:* Context variablesScreenGreat for passing values to a screen, much like parameters to a procedure in other languages. Can be referenced from only one screen.Functions that establish: UpdateContext, Navigate* Global variablesFunctions that establish: Set* CollectionsFunctions that establish: Collect, ClearCollect
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-variables
DRAG DROP (Drag and Drop is not supported)You plan to create a canvas app with multiple screens.The app needs to store temporary data while the app is running. The app has the following data requirements:Each screen must maintain a separate copy of data and pass the data to another screen.The app must be able to update separate rows of a table independently.You need to configure variables for the data.Which variable types should you use? To answer, drag the appropriate variable types to the correct requirements. Each variable type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
Box 1: Context variableEach screen must maintain a separate copy of data and pass the data to another screen.Types of variablesPower Apps has three types of variables:* Context variablesScreenGreat for passing values to a screen, much like parameters to a procedure in other languages. Can be referenced from only one screen.Functions that establish: UpdateContext, NavigateIncorrect:* Global variablesFunctions that establish: SetBox 2: CollectionThe app must be able to update separate rows of a table independently.* CollectionsFunctions that establish: Collect, ClearCollect
HOTSPOT (Drag and Drop is not supported)You plan to create a canvas app.The app must meet the following requirements:Send an email after a record is saved.Display the expiration column on a form if the creation date of the record is older than 90 days.You need to configure the app.Which features should you use? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
Box 1: Power Automate flowSend an email after a record is saved.Box 2: FormulaDisplay the expiration column on a form if the creation date of the record is older than 90 days.
DRAG DROP (Drag and Drop is not supported)A company plans to create two Microsoft Power Platform applications.One of the applications requires a custom control layout without using code. The other application will be used primarily by external users.You need to create the applications.Which application types should you use? To answer, drag the appropriate application types to the correct requirements. Each application type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.Select and Place:
Box 1: Canvas appOne of the applications requires a custom control layout without using code.You can design and build a business app from a canvas in Microsoft Power Apps without writing code in a traditional programming language such as C#. Design the app by dragging and dropping elements onto a canvas, just as you would design a slide in PowerPoint. Create Excel-like expressions for specifying logic and working with data. Build apps that integrate business data from a wide variety of Microsoft and third-party sources. Share your app so that users can run it in a browser or on a mobile device, and embed your app so they can run it in SharePoint, Power BI, or Teams.Model-driven and canvas apps comparedIn canvas apps, the app maker has total control over the app layout. With model-driven apps, much of the layout is determined by the components you add. The emphasis is more on quickly viewing your business data and making decisions instead of on intricate app design.Box 2: Power Pages PortalThe other application will be used primarily by external users.Microsoft Power Pages is also a software as a service platform where business users can interact with business data stored in the Dataverse. There is one big difference between Power Apps and Power Pages:Power Pages was built specifically for external users.
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/getting-started https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/model-driven-app-overview https://www.cobalt.net/power-pages-microsoft-vs-power-apps/
You create a Power Apps app.The app must be able to display a list of records that are sorted by category. The app must also expand or hide the list by subtopics.You need to configure the app.Which tool should you use?
Answer(s): C
Show a list of items from any data source by adding a Gallery control to your canvas app.Filter and sort a galleryThe Items property of a Gallery control determines which items it shows. In this procedure, you configure that property so that it also determines which records appear based on filter criteria and in what order.
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/add-gallery
A company is implementing Power Apps and Power Automate.Several components are created within Power Apps, Microsoft Dataverse, and Power Automate. These components must be promoted from the development environment to the user acceptance test environment in a single solution package.You need to create the solution package for promotion.Where should you create the package?
Answer(s): D
HOTSPOT (Drag and Drop is not supported)You are building a model-driven app for a company.You identify several custom commands that the app must support, including the following commands:Save a row.Move the user to a different row in the application.Navigate the user to an external webpage.Show a notification that the user can accept or decline.You need to identify the formula to use for each requirement.Which formulas should you identify? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
Box 1: SubmitForm()Save a rowUse the SubmitForm function in the OnSelect property of a Button control to save any changes in a Form control to the data source.Before submitting any changes, this function checks for validation issues with any field that's marked as required or that has one or more constraints on its value. This behavior matches that of the Validate function.Incorrect:* SaveData()SaveData, LoadData, and ClearData functionsApplies to: Canvas appsSaves and reloads a collection from the app host's storage.The SaveData function stores a collection for later use under a name.Box 2: Navigate()Move to a different row* NavigateApplies to: Canvas apps Model-driven appsIn the first argument, specify the name of the screen to display.In the second argument, specify how the old screen changes to the new screenIncorrect:* Back()Applies to: Canvas appsThe Back function returns to the screen that was most recently displayed. For each Navigate call, the app tracks the screen that appeared and the transition. You can use successive Back calls to return all the way to the screen that appeared when the user started the app.* Exit()The Exit function exits the currently running app. The user is returned to the list of apps. The user can then select another app to open.* Launch()Navigate the user to an external webpage.Box 3: Launch()Navigate the user to an external webpage.Launches a webpage or a canvas app. The function supports: Address (required), the URL of the webpage or App URI (app id prefixed with /providers/Microsoft. PowerApps/apps/ ) of the canvas app.Box 4: Confirm()Show a notification with optionsPower Fx, Confirm functionThe Confirm function displays a dialog box on top of the current screen. Two buttons are provided: a confirm button and a cancel button, which default to localized versions of "OK" and "Cancel" respectively. The user must confirm or cancel before the dialog box is dismissed and the function returns. Besides the dialog button, cancel can also be selected with the Esc key or other gestures that are platform specific.Incorrect:* Notify()DescriptionThe Notify function displays a banner message to the user at the top of the screen. The notification remains until the user dismisses it or the timeout expires which defaults to 10 seconds.An appropriate color and icon are used depending on the type of the message. The type is specified by the second argument to the function:
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-form https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/page-powerfx-in-model-app https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-param https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-confirm https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-navigate
Post your Comments and Discuss Microsoft PL-200 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the PL-200 content, but please register or login to continue.