You need to create an app for a client's janitors, who will only access the app via their mobile phones.
The app must connect directly to a Microsoft Excel workbook to track cleaning tasks. Also, the janitors should have the ability to check completed tasks off on a checklist.
Which of the following actions should you take?
To create an app that connects directly to a Microsoft Excel workbook and allows janitors to check off completed tasks on a checklist via their mobile phones, a canvas app is the most appropriate choice. Canvas apps are designed for mobile-first experiences and can connect to various data sources, including Excel. They also provide the flexibility needed to build a user-friendly interface with checklists, which is ideal for the described scenario.
A for me.
A is the correct answer, because 1) Must connect directly to Excel so it has to be a Canvas App, 2) the checklist data is coming from the Excel Spreadsheet (workbook to track cleaning tasks). B, C and D are all incorrect because they all connect directly to Dataverse (Common Data Service).
Model driven apps can only connect to Dataverse, not Excel spreadsheets.
Seriously, does someone get paid to choose the wrong answer? Some of these are so blatant
How could you connect to Excel using MDA?
Canvas App can be used directly via mobile phone, as an App, instead of needing to open the model driven app. Furthermore Model Driven App can't edit Excel Files directly.. It has to be A from my point of View.
A. You should consider creating a canvas app. Here’s why: Canvas apps are ideal for creating custom apps that need to connect to a variety of data sources, including Microsoft Excel. They provide a lot of flexibility in terms of design and user interface, which would be beneficial for creating a checklist for janitors to check off completed tasks.
Canvas apps are a great choice for this situation because: They are designed for creating user-friendly, mobile-ready applications. They can connect to various data sources, including SharePoint and Excel (with limitations). While directly connecting to an Excel workbook might not be ideal due to data security and version control concerns, you could explore options like storing the data in a SharePoint list and connecting the canvas app to it. They allow for building customizable interfaces with features like checklists and checkboxes, perfect for marking completed tasks.
Of course it is A
For the first requirement we were able to answer without any doubts, mobile app = Canvas App, Second: connection to Excel = Canvas App
Yep A is definitely the best
Yes, model driven apps cannot be linked to an excel workbook or sheet as a data source.
Option A is the correct answer: You should consider creating a canvas app.
Based on your requirements, you should consider creating a canvas app. Canvas apps are designed to be used on mobile devices and can connect directly to Microsoft Excel workbooks. They also allow you to create checklists that users can check off when tasks have been completed. https://www.testpreptraining.com/tutorial/microsoft-pl-100-power-platform-app-maker-sample-questions/
connection to Excel
It is oviously A because it has to be a mobile app which only Canvas can provide.
my first thought is also Canvas App, but why answer is Model Driven
A Canvas app does the job perfectly.