You are creating a canvas app. A small amount of tabular data must be available only to the app. The data must be available before user interaction. You need to create the data source for this data…

The correct answer is C. Use a formula to populate a table when the app starts. Using a formula (such as ClearCollect()) in the App.OnStart or App.Formulas property populates an in-memory collection when the canvas app loads, before any user interaction occurs. The data lives entirely within the app - it is not stored in an external service - which…

Create business solutions

Question

You are creating a canvas app. A small amount of tabular data must be available only to the app. The data must be available before user interaction. You need to create the data source for this data. What should you do?

Options

AUse the Excel Online connector to retrieve the data.
BRead the data from a file on the device.
CUse a formula to populate a table when the app starts.
DCreate a Microsoft Dataverse table and use the Microsoft Dataverse connector.

How the community answered

(39 responses)

A
15% (6)
B
8% (3)
C
72% (28)
D
5% (2)

Explanation

Using a formula (such as ClearCollect()) in the App.OnStart or App.Formulas property populates an in-memory collection when the canvas app loads, before any user interaction occurs. The data lives entirely within the app - it is not stored in an external service - which satisfies the 'available only to the app' requirement. Option A (Excel Online) depends on an external file and network connectivity, and the data is not exclusive to the app. Option B (reading from a device file) is not a supported pattern for canvas apps. Option D (Dataverse) is a shared, external database that involves infrastructure and is far heavier than needed for a small, app-only dataset.

Topics

#Power Apps Canvas Apps#Local Data Sources#Collections#App OnStart

Community Discussion

No community discussion yet for this question.

Full PL-100 Practice