Demonstrate the capabilities of Power Apps

A retail company uses Power Apps to build a mobile app for store managers to approve discount requests. The app must work offline and sync when connected. Which type of app should the developer choose?

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?

A company has a canvas app that uses a SharePoint list as its data source. The app works fine for most users but a few users report that they cannot submit new items. They receive a generic 'Access denied' error. What is the most likely cause?

Which TWO of the following are capabilities of Power Apps that help organizations build custom business applications without writing traditional code?

Drag and drop the steps to deploy a solution from a development environment to a production environment in Power Platform in the correct order.

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 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?

A company uses Power Apps to manage customer service cases. They want to implement a business rule that automatically sets the priority to 'High' when the customer is a VIP. Where should the business rule be defined?

A business user wants to build a Power Apps app without writing any code. Which type of app should they create?

Which TWO actions can be performed using Power Apps? (Choose two.)

Which THREE components are part of a model-driven app in Power Apps? (Choose three.)

Which TWO data sources can be directly connected to a Power Apps canvas app without using an on-premises data gateway? (Choose two.)

Refer to the exhibit. An ARM template deploys a Power App with a connection to Office 365 Outlook. What is the purpose of the 'dependsOn' element?

Refer to the exhibit. A Power Apps canvas app uses the Filter function as shown. What does this expression do?

A company wants to build a canvas app to allow field technicians to report equipment issues from their mobile devices. The app must work offline and sync data when connectivity is restored. Which feature should the developer use?

A team is creating a model-driven app to manage customer service cases. They want to ensure that only users with a specific security role can delete cases. What should they configure?

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?

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?

An organization wants to build a Power Apps solution that uses AI to extract information from invoices automatically. Which feature should they use?

A user wants to edit the fields displayed in a model-driven app form. Where should they go to customize the form?

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?

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?

A company uses a Power App to track inventory. The app displays a gallery of items filtered by a dropdown. When the user selects 'Electronics', the gallery shows all electronics items. However, after the user clears the dropdown, the gallery remains empty. What is the most likely reason?

A Power App uses a Patch function to update a Dataverse table. The app runs into delegation warnings for large datasets. Which approach best resolves delegation warnings while maintaining functionality?

A manager wants to create a Power App that shows a list of customer orders with the ability to drill into each order's details. Which approach is most efficient?

A model-driven app uses a custom table 'Service Request' with a status field. The business requires that when a status changes to 'Resolved', the app automatically sends an email to the requester. Which approach should be used?

A company wants to build an app that allows external vendors to submit invoices through a web portal. The app must be accessible without signing in with a Microsoft account. Which Power Platform solution should they use?

A Power Apps app uses a Dataverse table with a choice column 'Priority' (Low, Medium, High, Critical). The app must display the priority as a color-coded badge in a gallery. Which method is most efficient?

A model-driven app has a subgrid showing related opportunities. Users want to be able to edit opportunity fields directly in the subgrid without opening the record. Which feature should be enabled?

A company has a canvas app that uses Microsoft Dataverse. The app is shared with many users, and some users report that they cannot see any data. What is the most likely cause?

A Power Apps developer needs to store an image uploaded by a user in a canvas app. The app uses Microsoft Dataverse. Which column type should be used for the image?

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?

Which THREE components are part of a model-driven app? (Choose three.)

Which TWO data sources can be used directly in a canvas app without a premium connector? (Choose two.)

A company wants to create a custom app to track inventory in their warehouse. The app needs to integrate with their existing SQL Server database and allow users to scan barcodes to update stock levels. Which type of Power Apps should they use?

A team is designing a model-driven app for customer service. They need to ensure that only agents in the 'Premium Support' role can see a custom field named 'SLA Level'. What is the best way to implement this security requirement?

A business analyst wants to build an app quickly using a pre-built template. Which Power Apps capability should they use?

An organization uses a Canvas app to capture customer feedback. The app writes data to a Dataverse table. Recently, users have been submitting duplicate records due to double-clicking the submit button. What is the best way to prevent duplicates?

A company wants to use Power Apps to create a mobile app for field technicians. The app must work offline and sync data when connectivity is restored. Which feature should they use?

Which TWO of the following are capabilities of Power Apps? (Choose TWO.)

Which THREE of the following are true about model-driven apps? (Choose THREE.)

You are designing a model-driven app for a sales team. The app must show related opportunities on an account form using a subgrid. The subgrid should only display open opportunities. Which configuration should you apply?

An organization needs a Power App that allows employees to submit expense reports by filling out a form and attaching receipts. Which type of app should you create and why?

A company wants to build a Power App that uses AI to extract information from uploaded invoices. Which capability should they use?

You are troubleshooting a canvas app that loads slowly. The app uses over 50 data sources and many formulas. Which action is most likely to improve performance?

A business analyst wants to create a Power App without writing code. They need to build a mobile-friendly form for inventory tracking. Which approach should they use?

Which TWO data sources can be used directly in a canvas app without a gateway? (Choose two.)

A Power Apps canvas app uses a SharePoint list as its data source. Users report that the app is slow to load when the list contains over 10,000 items. What is the best approach to improve performance?

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?

A company wants to build an app that allows employees to submit expense reports. The app must include approval workflow. Which Power Platform component should be used to define the approval process?

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?

A manager wants to create an app without writing any code. Which Power Apps type should they use?

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?

Which THREE of the following are capabilities of Power Apps?

A company wants to build a custom app that allows employees to submit expense reports from their mobile devices. The app must be easy to customize and deploy without writing code. Which type of Power App should they use?

An organization needs to create a custom app that displays data from Dynamics 365 Sales and allows users to update records. The app should automatically generate a responsive UI based on the data model. Which type of app should they build?

A company uses a canvas app to collect customer feedback. The app stores data in Microsoft Dataverse. Users report that some submissions are not saved when the app loses internet connection. How should the app be modified to prevent data loss?

A user wants to create a simple app to track personal expenses using an Excel file stored in OneDrive. Which Power Apps approach should they use?

Which THREE components are part of a canvas app's formula language?

Which TWO data sources can be directly connected to a canvas app without using a premium connector?

A developer is creating a custom control using Power Apps Component Framework (PCF). After importing the solution, the control appears but does not show any data. What is the most likely issue based on the exhibit?

A user wants to build an app that allows field technicians to view work orders and capture photos offline. Which type of Power App should be chosen?

A company wants to create a Power App that allows employees to submit expense reports with receipts. The app must be accessible from both mobile devices and desktop browsers, and must include a workflow for approval. Which combination of Power Platform components should be used?

A user reports that a canvas app is loading slowly. The app connects to a large SharePoint list with over 10,000 items. Which change would most improve performance?

Which TWO features are available in canvas apps but NOT in model-driven apps?

You are reviewing a Power Automate flow that uses an Office 365 Users connector. The exhibit shows a JSON definition of an action. What does this action do?

You are reviewing a FetchXML query used in a Power Apps component. The exhibit shows the query. What data will this query return?

An organization has a canvas app that uses a SharePoint list as its data source. Users report that the app loads slowly and sometimes times out. The developer needs to improve performance. Which approach should the developer take?

A business analyst wants to create a simple app to track employee vacation requests without writing code. Which type of Power App should they use?

An organization plans to build a Power App that will be used by external partners. The app must allow partners to log in with their own credentials (Azure AD B2B). Which feature should be configured?

A developer builds a canvas app that uses a custom connector to call an external API. The API requires an OAuth 2.0 client credentials flow. Which authentication type should the developer configure in the custom connector?

Which TWO data sources can be directly connected to a canvas app without using an on-premises data gateway?

Refer to the exhibit. A developer is creating a model-driven app based on a custom Dataverse table defined by this JSON. The app needs a form that shows the Approved field only when the amount is greater than 1000. Which feature should the developer use?

Refer to the exhibit. An administrator wants to enforce a mobile app management policy that prevents screen capture in Power Apps. Which Microsoft service should the administrator use to deploy this policy?

A company wants to create a mobile app for field technicians to log service calls. The app will connect to an existing SQL database. Which type of Power App should they build?

A business analyst wants to create an app that uses a SharePoint list as its data source. They need to include conditional formatting to highlight overdue tasks. Which type of app should they use?

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?

A user built a canvas app that uses a SharePoint list. When they add the app to a Teams channel, some users cannot see the data. The app works fine when opened directly from Power Apps. What is the most likely cause?

A sales team needs an app to track customer interactions. The app should display a list of accounts, and when an account is selected, show related opportunities and contacts. Which type of app is best suited?

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?

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?

Which THREE are capabilities of model-driven apps?

Which TWO are benefits of using Dataverse as the data source for Power Apps?

Which TWO are benefits of using model-driven apps over canvas apps? (Choose two.)

You are designing a canvas app for field service technicians. The app must capture photos of equipment and store them with the service record. Which control and data source combination is most suitable?

You have a canvas app that uses a SharePoint list as its data source. The app needs to filter records based on the current user's email. Which function should you use in the Items property of the gallery?

You are designing a Power Apps solution for a global sales team. The app must display data in the user's local time zone. The data is stored in Dataverse in UTC. What is the best practice for time zone handling?

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?

A model-driven app uses a business process flow to guide users through a sales process. The flow has multiple stages, and users complain that they can move to the next stage without completing required fields. What should the app maker do to enforce data entry?

A user wants to create an app that allows employees to submit expense reports from their mobile devices. The app should capture photos of receipts and store them. Which type of app is most suitable?

A company uses a model-driven app to manage customer service cases. The team wants to automatically assign cases to the appropriate queue based on the case category. What feature should they use?

A model-driven app includes a custom entity 'Project' with a lookup to 'Account'. Users need to see the account name and phone number on the Project form. What is the best way to display these fields?

A company wants to allow external partners to submit support tickets via a web interface. The data should be stored in Dataverse. Which type of app should they build?

Which TWO data sources can be used with a canvas app? (Choose two.)

Refer to the exhibit. The JSON describes a Power Apps function. What is the correct usage of this function to return a date 7 days from today?

Refer to the exhibit. The JSON describes a Power Apps function. Which call to this function will return a table of records where the 'Status' column equals 'Active'?

A Power Apps canvas app uses a SharePoint list as a data source. Users report that the app is slow when loading data. The list has 10,000 items. Which optimization should you recommend?

A company has a Power Apps model-driven app for sales. Sales reps need to see their assigned leads only. Which security feature should be configured?

A company wants to create a Power Apps app that can be embedded in Microsoft Teams. Which type of Power Apps should they use?

A model-driven app uses a custom business process flow. Users report that they cannot progress beyond a stage even after completing all required fields. What should you check?

Which THREE components are part of Power Apps Studio for building Canvas apps? (Choose three.)

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?

Your company is migrating a legacy paper-based expense report process to Power Apps. Employees will submit expenses via a Canvas app. The app must integrate with the corporate travel system to fetch trip details (e.g., dates, destination). The travel system exposes a REST API with OAuth 2.0 authentication. Finance requires that all expense reports over $1,000 receive a second-level approval from a manager. Additionally, the app must be available on mobile devices. Which combination of technologies should you use?

A small business wants to create a Power Apps app to track customer interactions. They have limited budget and no dedicated IT staff. The app must be easy to maintain and should use a data source that requires minimal setup. The app will be used by 5 sales reps. Which approach should they take?

A company uses Power Apps to build a canvas app for field technicians to report equipment issues. The app includes a GPS location control and requires offline capability. During a pilot, technicians report that the app fails to load data when they are in remote areas with no internet. Which design change should the app maker implement to address this issue?

A company uses Power Apps to create a canvas app for employee expense reporting. The app needs to integrate with the corporate HR system to fetch employee details such as manager email and cost center. The HR system exposes a REST API that requires an API key in the header. Which approach should the app maker use to securely connect to the HR system?

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?

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?

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?

A company uses Microsoft Power Apps to build a leave request application. The app uses SharePoint as the data source. Users report that when they submit a leave request, the app sometimes fails to save the data and shows a generic error. Which should you investigate first?

A power user is designing a canvas app for inventory management. The app has a gallery that displays products. The user wants to filter the gallery to show only products with stock less than 10. Which formula should the user use in the Items property of the gallery?

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?

A business analyst wants to quickly create a simple app to track team tasks without writing complex formulas. Which Power Apps option is most suitable?

In a model-driven app, a user wants to see a map of all customer addresses on a form. Which feature should be enabled?

Which TWO are valid ways to share a canvas app with other users in your organization?

Which THREE are capabilities of Microsoft Dataverse in Power Apps?

Which TWO are types of apps you can create with Microsoft 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?

Fabrikam, Inc. uses Power Apps to create a canvas app for expense reporting. The app is connected to a SharePoint list named Expenses. The app allows users to submit expenses, attach receipts, and view their history. The manager wants to add a feature where users can scan a receipt using the mobile app camera and automatically extract the amount and date using AI Builder. The extracted data should be populated into the form fields. The development team needs to implement this feature. Which steps should they take?

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.)

A company wants to create a Power App that uses AI to extract information from uploaded invoices. The app should allow users to upload an invoice image and then automatically populate fields like invoice number, date, and total amount. Which Power Platform feature should you use? A) AI Builder's prebuilt invoice processing model. B) Custom Vision service in Azure. C) Power Automate with OCR actions. D) Use the 'Scan' function in Power Apps.

Which THREE of the following are capabilities of model-driven apps? (Choose THREE.)

Which TWO of the following data sources can be used directly in a canvas app without using a gateway? (Choose TWO.)

A company uses a model-driven app built on Microsoft Dataverse to manage customer cases. The support team wants to ensure that when a case is escalated, the system automatically sends an email notification to the assigned manager and updates the case priority. The team does not want to write any code. What should they use to implement this automation?

A sales team needs a mobile-friendly app to view and update customer information stored in Microsoft Dataverse. The app should be generated automatically from the data model and provide a consistent interface across devices. Which type of Power Apps app should they create?

A sales team uses a canvas app to manage customer leads. The app currently connects to a SharePoint list as its data source. The team wants to move to a more robust data platform that supports complex relationships between leads, accounts, and contacts. They also need to enforce business rules and security at the data level. Which data source should they use?

You are building a canvas app for a field service team. Technicians need to capture customer signatures on a tablet and store the image with the work order record in Dataverse. Which control should you use?

A canvas app uses a SQL Server database as its data source. The database is hosted on-premises and is not exposed to the internet. Users report that the app fails to load data. What must be configured to allow the canvas app to connect to the on-premises SQL Server?

A Power Apps maker has built a canvas app that uses a SQL Server database as its data source. The app is used by employees in the office and remote workers. Remote workers report that the app is slow when loading data. The maker suspects that the issue is related to data retrieval. Which action should the maker take to improve performance for remote users?

You are building a canvas app in Power Apps. The app needs to display a chart that shows the monthly sales trend from a SharePoint list. The chart must update automatically when new sales records are added to the list. What should you use to display the chart?

A company uses Power Apps to manage field service inspections. Inspectors need to capture GPS coordinates, photos, and digital signatures while offline in remote areas with no internet connectivity. The app must sync data automatically when connectivity is restored. Which type of Power Apps app should the company build?

A canvas app includes a gallery that displays customer records from a SharePoint list. The app designer wants to ensure that when a user selects a record, the details are shown on a separate screen. Which Power Apps feature should be used to pass the selected record's data to the detail screen?

A business analyst needs to create a simple canvas app that lets employees submit expense reports. The app must show a form with fields for amount, category, and receipt photo, and save the data to a SharePoint list. The analyst has no programming experience. Which Power Apps feature should the analyst use to build the form quickly?

A supply chain analyst uses a Power Apps canvas app to scan barcodes in a warehouse where network connectivity is intermittent. The app must store scanned records locally and upload them later when connectivity returns. Which Power Apps capability should the analyst use?

A company has a canvas app that uses a SharePoint list as its data source. The list contains 8,000 items. Users report that the app's gallery only shows the first 100 items when they scroll. The app's gallery Items property is set to Filter(Expenses, Status = "Pending"). What should the maker do to ensure all pending items are displayed?

A team lead wants to give a colleague permission to edit the structure of a canvas app, including adding screens and modifying formulas, but not to publish it to end users. Which sharing role should be assigned in Power Apps?

A team is building a canvas app that must allow users to work with data from multiple sources. The app will use Microsoft Dataverse as the primary data source and also needs to display data from an on-premises SQL Server database. Which two components are required to connect the canvas app to the on-premises SQL Server data? (Choose two.)

A maker builds a canvas app that reads from a SharePoint list containing 50,000 rows. Users report the gallery shows only a subset of records and search results are incomplete. The maker needs the app to return complete results for filter and search operations. What should the maker do?

A sales team at a manufacturing company needs a mobile app where field representatives can look up customer records, view related orders, and update account details. The company already stores all this data in Microsoft Dataverse with defined relationships and business rules. The team wants to build the app with minimal custom coding and have it automatically respect the Dataverse security roles. Which type of Power Apps app should they create?

A company is planning a model-driven app for managing equipment inspections. The app must support business process flows, role-based security, and a unified interface across devices. Which two components are required to build this model-driven app? (Choose two.)

A sales team at a manufacturing company needs a mobile-friendly app that shows a product catalog and lets reps submit orders. The team has no developers and wants to build the app quickly by dragging controls onto a blank screen and connecting to an existing SharePoint list. Which type of Power Apps app should the team create?

A field technician needs a mobile app that reads the device camera to capture equipment photos and writes each photo together with a work order number to a Microsoft Dataverse table. The technician wants to build it quickly with drag-and-drop controls and no server-side code. Which Power Apps app type fits best?

A company wants to create a model-driven app to manage customer cases. The app must include a custom table for cases, a form to enter case details, a view to list open cases, and a dashboard to show case metrics. The company has a Microsoft Dataverse environment. What is the minimum set of components the maker needs to create in the Power Apps maker portal?

A sales team uses a Power Apps canvas app to view and update customer records stored in a Microsoft Dataverse table. A new requirement states that when a user selects a customer in the app, the app must automatically retrieve the 10 most recent related orders from a different Dataverse table and display them in a gallery. Which Power Apps capability should the maker use to retrieve and display the related orders?

A maker is building a canvas app that connects to a Microsoft Dataverse table named Projects. The app includes a gallery that displays project records and a form for editing them. The maker wants to ensure that when a user selects a project in the gallery, the form automatically shows the details of that selected project. Which Power Apps control property should the maker set on the form to bind it to the gallery's selected item?

You are troubleshooting a canvas app that connects to a SQL Server database through an on-premises data gateway. Users in the finance department receive an error stating the app cannot reach the data source, while users in IT can use the app normally. What is the most likely cause?

A support organization is building a model-driven app for case management and wants to standardize how agents create and update case records. The organization wants to control which fields appear on the case form, enforce required fields, and define the columns shown in the case list view. Which two components should the maker configure to meet these requirements? (Choose two.)

You are building a canvas app for a field service team. Technicians need to open the app on a phone, capture a photo of damaged equipment, and attach that photo to a work order record stored in Microsoft Dataverse. You add a Camera control and a Form control bound to the Work Order table. What should you configure to store the captured image with the work order record?

A maker is authoring a canvas app in Power Apps Studio and wants to reuse logic and control appearance across multiple screens. Which two capabilities support this goal? (Choose two.)

You are building a canvas app for a field service team. The app must allow technicians to capture a customer signature on a touch screen and attach it to a work order record. Which Power Apps control should you add to the screen to meet this requirement?

A company is building a Power Apps canvas app that will be used by field technicians on mobile devices. The app must allow technicians to capture photos and store them with related work order records in Microsoft Dataverse. The maker needs to add a control that lets users take a photo using the device camera. Which control should the maker add to the app?

A field technician uses a canvas app on a tablet to inspect equipment in areas with no network connectivity. The technician needs to record inspection results while offline and have them synchronized when connectivity returns. The app must continue to work without an internet connection. Which capability should the maker configure to meet this requirement?

A retail company wants to build a mobile app that allows store employees to scan product barcodes and check inventory levels in real time. The company has no professional developers and wants to minimize coding. Which Power Apps approach should they use?

A maker is building a canvas app that connects to a SharePoint list containing 20,000 items. Users report that a gallery showing filtered results displays only part of the expected records, and some filters seem to be ignored. The maker wants the app to return accurate results for the filtered queries. What should the maker do?

A company wants to give external partners a secure, branded website where they can view and update order information stored in Dataverse. Partners should sign in with their own credentials, and the company wants to control which records each partner can see. Which Power Platform capability should the company use?

You are designing a model-driven app for a claims department. The team needs a consistent, form-based experience driven by Microsoft Dataverse tables. Which two capabilities should you expect from a model-driven app? (Choose two.)

A maker is building a canvas app that will be used by employees to submit expense reports. The app must allow users to enter multiple line items for each expense report, and the maker wants to store the data in Microsoft Dataverse. The maker needs to choose appropriate controls for the app. Which two controls should the maker use to allow users to enter and manage multiple line items? (Choose two.)

A team wants to create a mobile app for inspecting equipment. The app should allow inspectors to capture photos, record audio notes, and submit the inspection report to a SharePoint list. The team has limited coding experience and wants to build the app quickly. Which type of Power Apps should they use?

A business analyst wants to create a Power Apps canvas app that connects to a Microsoft Excel workbook stored in OneDrive for Business. The analyst needs to display data from a table in the workbook and allow users to update records directly from the app. Which statement is true about using Excel as a data source in a canvas app?

A user wants to create a canvas app that displays a list of products from a SharePoint list and allows filtering by category. The user has no coding experience. Which approach should they use to build the app quickly?

A company has a canvas app that connects to a Microsoft Dataverse table containing sensitive customer information. The app is shared with a group of users, but the security team wants to ensure that users can only see records that they own and cannot modify records owned by others. The maker needs to implement record-level security. What should the maker do?