nerdexam
Microsoft

PL-100 · Question #271

A company uses a model-driven app to track customer information and the products that they have purchased. You must use a Microsoft Word template to generate a warranty report for customers that…

The correct answer is C. data from a single record including related records. A Word template in a model-driven app must use a single-record dataset that includes related records so that one customer record can enumerate all related purchased product records in the same report.

Create business solutions

Question

A company uses a model-driven app to track customer information and the products that they have purchased. You must use a Microsoft Word template to generate a warranty report for customers that lists all items that the customer has purchased in the past year. Customers who have not purchased a product in the last year must not receive a warranty report. You need to select a dataset. Which type of dataset can you use?

Options

  • Adata from a single record and no related records
  • Bdata from multiple unrelated records
  • Cdata from a single record including related records

How the community answered

(44 responses)
  • A
    11% (5)
  • B
    5% (2)
  • C
    84% (37)

Why each option

A Word template in a model-driven app must use a single-record dataset that includes related records so that one customer record can enumerate all related purchased product records in the same report.

Adata from a single record and no related records

A single record with no related records would provide only the customer's own fields and could not include the list of products purchased, which live in a related (child) entity.

Bdata from multiple unrelated records

Multiple unrelated records have no shared relationship context, so there is no way to associate each product record back to the correct individual customer within a single generated report.

Cdata from a single record including related recordsCorrect

Model-driven app Word templates support a primary (single) record as the anchor - in this case the customer - along with its related records through entity relationships, which are the purchased products. This structure lets the template iterate over the customer's related purchase records and include only those from the past year. Customers with no qualifying related records are simply excluded at the report-generation step, meeting the business rule without additional filtering logic in the template schema itself.

Concept tested: Word template dataset with related records in model-driven apps

Source: https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/using-word-templates-dynamics-365

Topics

#Reporting#Dataverse#Data relationships#Word templates

Community Discussion

No community discussion yet for this question.

Full PL-100 Practice