nerdexam
Microsoft

PL-900 · Question #271

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…

The correct answer is B. Two controls: an edit form control and a button control. To create an interface in a Power Apps canvas app for saving a new record to an Excel spreadsheet, you minimally need an Edit form control to handle input fields and a Button control to submit the data.

Submitted by anjalisingh· Apr 18, 2026Demonstrate the capabilities of Power Apps

Question

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?

Options

  • AOne control: an edit form control
  • BTwo controls: an edit form control and a button control
  • CThree controls: a text input control, a date picker control, and a combo box control
  • DFour controls: a text input control, a date picker control, a combo box control, and a button control

How the community answered

(16 responses)
  • A
    6% (1)
  • B
    88% (14)
  • D
    6% (1)

Why each option

To create an interface in a Power Apps canvas app for saving a new record to an Excel spreadsheet, you minimally need an Edit form control to handle input fields and a Button control to submit the data.

AOne control: an edit form control

While an Edit form control displays input fields, it requires a separate control, such as a button, to perform the action of submitting and saving the new record.

BTwo controls: an edit form control and a button controlCorrect

An Edit form control can automatically generate input fields based on the data source (Excel) schema, and a Button control is then used to trigger the submission of the new record to the spreadsheet.

CThree controls: a text input control, a date picker control, and a combo box control

Individual controls like text input, date picker, and combo box handle specific data types, but an Edit form control simplifies managing all fields for a record and automatically connects to the data source for saving.

DFour controls: a text input control, a date picker control, a combo box control, and a button control

While individual input controls along with a button could work, an Edit form control streamlines the process by generating fields automatically and simplifying data submission, making option B the minimum and most efficient approach.

Concept tested: Power Apps canvas app data forms

Source: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-forms

Topics

#Power Apps Canvas Apps#Data Entry Forms#Edit Form Control#Button Control

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-900 Practice