Case Study 3 - Bellows College
Background
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
Environment
- Custom code is not allowed in the system.
- Server-side synchronization is configured for emails, appointments, contacts, and tasks.
- The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
- Birthdate is a custom date and time field.
- Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
- Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
- The Evaluation table is a custom table used to track evaluation criteria.
- Evaluation records cannot be manually created.
- Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
- The consent forms completed by the parents are stored as records in the Consent table.
- Occasionally, a parent cannot complete the consent online and a paper copy must be printed.
The signed copy must be scanned and stored with the consent record.
Team website
- The team website is created by using Power Pages.
- A starter layout template was used to create the site.
- The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
- Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
Registration
- Parents and prospects are created as contacts and must be linked.
- The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
- Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
- When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
- A view named Underage Prospects that lists all underaged prospects is required.
- The Underage Prospects view must run once a week without requiring modifications to display correct information.
- A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect o contain a link to the team website o be automatically sent weekly and tracked to the contact record in Dataverse o include the current date using the full month name, date, and year Evaluations
- Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
- The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
Hotspot Question
You need to create a filter for the Underage Prospects view.
How should you set up the expression for the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Drag and Drop Question
A company plans to create a Power Virtual Agents chatbot.
The bot has the following requirements:
- Prompt for a location of the customer and the call must be routed to
a support agent for the location.
- Transfer support calls at each location to a support bot that uses
the Bot Framework.
You need to configure the bot.
Which components should you use? To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct select is worth one point.

Hotspot Question
You create a model-driven app for an automobile parts help desk.
A help desk agent uses a form to gather information about customers' automobiles in two custom tables. The names of the tables are Client and Automobile, The form must prepopulate the following information about the customer from the client table:
- First name
- Last name
The agent must be able to type the following information about the automobile:
- Automobile make
- Automobile model
You need to implement the form.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You are creating a cloud flow for an automation targeting Dataverse.
When a new account is created in Dataverse, the name of the account must be updated based on the following logic:
- If the Account Category Code equals Preferred Customer (1), pre
append the value Preferred | to the name.
- If the Account Category Code equals Standard (2) or is not populated, pre-append Standard | to the name.
You need to define the correct formula to use for the automation.
Which formula should you use?

A company sells all types of bicycles, bicycle parts, and accessories. You are creating a chatbot by using Microsoft Power Virtual Agent for the bicycle shop.
When someone types in a bicycle brand name or terms such as helmet or shoes, the chatbot must automatically go to the accessories section of the chatbot.
You need to configure the chatbot functions.
Which two functions should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.