Microsoft Power Platform Fundamentals — Question 170

You create a canvas app that uses a Microsoft Excel spreadsheet as a data source.

The spreadsheet contains a list of pets. Each column in the spreadsheet is a different attribute about a pet.

You need to create an interface to allow users to save a new pet record to the spreadsheet.

What is the minimum number of controls you need to implement to create the interface?

Answer options

• A. One control: an edit form control
• B. Two controls: an edit form control and a button control
• C. Three controls: a text input control, a date picker control, and a combo box control
• D. Four controls: a text input control, a date picker control, a combo box control, and a button control

Correct answer: B

Explanation

The correct answer is B because you need at least an edit form control to capture the pet's information and a button control to submit that information to the spreadsheet. Option A is insufficient as it lacks the button for submission, while options C and D include unnecessary controls beyond what is required for saving a single record.