QuestionQ101
VerifiedBuild business application logic and automationBackground
Contoso Suites is an animal shelter specializing in finding homes for dogs that have been surrendered by their owners. The shelter can accommodate up to 20 dogs.
The shelter is implementing a single model-driven Power Apps app to track dogs and schedule meetings with potential adopters. No other apps will be created.
The model-driven app uses Dataverse and out-of-the-box functionality where possible.
Dataverse has the following configuration:
- The solution prefix “cs” is used for all new components.
- Only the root business unit is used.
- All tables are stored in Dataverse and do not require rapid scaling.
- Exchange server-side sync is not configured.
Adopters
- Adopter information is stored in a Contact table.
- Contacts are considered duplicates when they have the same email address and last name.
- Adopters are frequently late to meetings, so a reminder email is sent two hours before their meeting.
- The email reminders must not be tracked in the system.
Dogs
- Dog information is stored in a Dog table, which is organization owned.
- Breed, size, and weight are fields in the table.
Dog residency
- A Resident table tracks each dog’s stay.
- Each resident record contains a lookup for the dog and its food.
- The food type and amount are logged on each resident record. Auto-posting is not configured for food type and amount changes.
- A fee of $120 is in a currency column named Adoption Fee. This fee can be changed based on the adoption circumstances.
- A formula column named Deposit is automatically populated with 20% of the adoption fee.
- A resident record is automatically generated when a dog record is created. This is the only way to create a resident record.
Exercise and feedings
- Exercise for the dogs is recorded in an Exercise table.
- Feedings are recorded in a Feeding table.
- Exercise and feeding records appear in a resident record timeline.
Care staff
- The care staff must be able to view who changed the food type and the amount that was given, for up to three months ago.
- The staff must be able to update a dog’s weight on the resident record.
- The staff report that the buttons are too small on the touch screen used to log exercise and feeding.
- The staff must be able to view the adopters for upcoming meetings. The staff must not be able to update adopter information.
Administrative staff
- Administrative staff must receive a weekly list of duplicate contacts. Duplicate alerts must not appear when a staff member saves a new contact.
- When an adopter wants to adopt a dog, the staff must perform a series of adoption duties in order.
The following duty list must appear on the screen:
- Commitment:
- Obtain adopter signature in a commitment document.
- Collect deposit.
- Pre-pickup:
- Document spay or neutering date.
- Perform spay or neutering.
- Document pickup date.
- Pickup:
- Collect full payment.
- Verify dog is picked up.
- A dog must be picked up no sooner than two days after spaying or neutering.
- A pop-up window must appear with an error message if the Pickup date is too soon.
- Only administrative staff must be able to add new adopters and dogs.
You need to set up the Deposit column.
How should you write the formula?
Community Discussion