nerdexam
Microsoft

PL-900 · Question #100

You have a Microsoft Excel workbook that contains a list of tasks for a project. You store the file in OneDrive for Business. You need to create a canvas app that allows team members to update the…

The correct answer is A. the Generate an app from data feature. The 'Generate an app from data' feature in Power Apps can connect directly to an Excel workbook stored in OneDrive for Business and automatically scaffold a three-screen canvas app (browse, detail, and edit screens) based on the spreadsheet's structure. This is the intended…

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

Question

You have a Microsoft Excel workbook that contains a list of tasks for a project. You store the file in OneDrive for Business. You need to create a canvas app that allows team members to update the status of their tasks. What should you use?

Options

  • Athe Generate an app from data feature
  • Ba custom action in Common Data Service
  • CPower Apps Checker
  • Dthe Open entity data in Excel feature

How the community answered

(55 responses)
  • A
    91% (50)
  • B
    2% (1)
  • C
    2% (1)
  • D
    5% (3)

Explanation

The 'Generate an app from data' feature in Power Apps can connect directly to an Excel workbook stored in OneDrive for Business and automatically scaffold a three-screen canvas app (browse, detail, and edit screens) based on the spreadsheet's structure. This is the intended Power Apps feature for this scenario. Power Apps Checker (C) is a governance/analysis tool, not an app builder. 'Open entity data in Excel' (D) is a Dynamics 365/Dataverse feature for editing entity records in Excel, not for building apps. Custom actions in Common Data Service (B) are for extending model-driven apps, not canvas apps from Excel.

Topics

#Canvas Apps#App Creation#Data Connectors#Excel

Community Discussion

No community discussion yet for this question.

Full PL-900 Practice