PL-400 Microsoft Power Platform Developer Exams demo
Create and configure Power Apps
Testlet 1
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on this
exam. You must manage your time to ensure that you are able to complete all questions included on this exam
in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case
study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and
to make changes before you move to the next section of the exam. After you begin a new section, you cannot
return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore
the content of the case study before you answer the questions. Clicking these buttons displays information
such as business requirements, existing environment, and problem statements. If the case study has an All
Information tab, note that the information displayed is identical to the information displayed on the subsequent
tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
Contoso Pharmaceuticals manufactures and sells drugs to retail and wholesale pharmacies, hospitals, and
research facilities.
The company plans to implement Dynamics 365 Sales and Dynamics 365 Finance.
Current environment
Contoso maintains a Microsoft Excel workbook that lists all drugs they supply.
Pharmacies submit order requests through email.
All information at customer locations is handwritten by customer representatives.
Contoso uses Cerner, which is a medical industry application that uses a proprietary database.
Some accounts are referrals from other pharmacies.
Every pharmacy has its own Dynamics 365 Sales instance.
Requirements
General
Contoso wants to ensure that there is minimal custom code and custom connectors in the system.
Accounts
Ensure that the names of the pharmacies are synced between the accounting and the customer
management systems.
Account numbers should be entered automatically into the pharmaceutical system that is in a Cerner
database and kept in sync.
When the account is entered into the system, extra fields must appear if the referral customer box is
selected. If the box is not selected, the extra fields must not appear.
A trigger must be created that changes the Priority field to 1 in the Account record 10 days after an Account
record is created.
96CE4376707A97CE80D4B1916F054522
A field named Priority_Trigger must be created to trigger the Priority field.
A field named Facility type field must be added in order to select whether a customer is a retail pharmacy,
wholesale pharmacy, research facility, or hospital.
Users
UserA must be able to create and publish Power Apps apps.
UserB must be the owner of all the systems and be able to provide permissions and create all new
environments.
UserC must be able to create apps connected to the systems and update the security roles and entities.
Pharmacy representatives must only be able to run the apps and access their own records.
Access to the accounting Power Apps app must be restricted to accounting team members.
End users must have minimum access to the required systems.
Only supervisors must be able to view phone numbers in the Accounts form.
Developers must be able to create new apps for all users.
Sales users must only have access to their own records.
Reporting
Pharmacy orders must be displayed in four graphs as follows:
Annual revenue over $100,000
Annual revenues under $100,000
Research facilities
Hospitals
The graphs must be interactive, and users must be able to drill down on any dimension.
Customizations
Ensure that notifications are sent to the sales team when a lead is added by using Slack.
Ensure that leads have a review stage added to the sales process.
Doctors must be manually added to a custom entity named Doctor if the doctor is not listed.
Refill dates for customer prescriptions should be automatically determined and a notification should be sent
to the customer.
Fields for the doctor’s name and phone number must be displayed in the customer record.
The doctor entered on the customer’s record must be validated against doctors that exist in the system.
The new solution will be sold to other pharmacies for use. The application must not allow changes to be
made.
The solution must be error free so that when it is installed in other environments it does not cause issues.
A custom mobile app must be created to allow salespeople to add or search by pharmacy name.
Pharmacy records must be uniquely identified by pharmacy name, address, contact name, and phone
number.
When a pharmacy is added by using the mobile app, the phone number must be validated to be all digits.
QUESTION 1
You need to ensure that users can create the required charts.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Create a quick view form to show the Accounts entity.
B. Configure filter fields in the Annual revenue field.
C. Add the Facility field to the account form.
D. Delete the Annual revenue field from the account form.
E. Create a view with annual revenue sorted lowest value to highest value.
96CE4376707A97CE80D4B1916F054522
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Pharmacy orders must be displayed in four graphs as follows:
Annual revenue over $100,000
Annual revenues under $100,000
Research facilities
Hospitals
The graphs must be interactive, and users must be able to drill down on any dimension.
96CE4376707A97CE80D4B1916F054522
Create and configure Power Apps
Testlet 2
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on this
exam. You must manage your time to ensure that you are able to complete all questions included on this exam
in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case
study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and
to make changes before you move to the next section of the exam. After you begin a new section, you cannot
return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore
the content of the case study before you answer the questions. Clicking these buttons displays information
such as business requirements, existing environment, and problem statements. If the case study has an All
Information tab, note that the information displayed is identical to the information displayed on the subsequent
tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
Current environment
Adventure Works Cycles wants to replace their paper-based bicycle manufacturing business with an efficient
paperless solution. The company has one manufacturing plant in Seattle that produces bicycle parts,
assembles bicycles, and distributes finished bicycles to the Pacific Northwest.
Adventure Works Cycles has a retail location that performs bicycle repair and warranty repair work. The
company has six maintenance vans that repair bicycles at various events and residences.
Adventure Works Cycles recently deployed Dynamics 365 Finance and Dynamics 365 Manufacturing in a
Microsoft-hosted environment for financials and manufacturing. The company plans to leverage the Microsoft
Power Platform to migrate all of their distribution and retail workloads to Dynamics 365 Unified Operations.
The customer uses Dynamics 365 Sales. Dynamics 365 Customer Service and Dynamics 365 Field Service.
Retail store information
Adventure Works Cycle has one legal entity, four warehouses, and six field service technicians.
Warehouse counting is performed manually by using a counting journal. All warehouse boxes and items are
barcoded.
The Adventure Works Cycles retail location performs bicycle inspections and performance tune-ups.
Technicians use paper forms to document the bicycle inspection performed before a tune-up and any
additional work performed on the bicycle.
Adventure Works Cycles uses a Power Apps app for local bike fairs to attract new customers.
A canvas app is being developed to capture customer information when customers check in at the retail
location. The app has the following features:
- Customer selects yes or no if they are on the mailing list.
- Customer selects the amount of times they have visited the store.
- Customer selects the type of service needed.
- The search result returns all last name records that match the search term.
96CE4376707A97CE80D4B1916F054522
Technology
Requirements
A plug-in for Dynamics 365 Sales automatically calculated the total billed time from all activities on a
particular customer account, including sales representative visits, phone calls, email correspondence, and
repair time compared with hours spent.
A shipping API displays shipping rates and tracking information on sales orders. The contract allows for
3,000 calls per month.
Ecommerce orders are processed in batch daily by using a manual import of sales orders in Dynamics 365
Finance.
Microsoft Teams is used for all collaboration.
All testing and problem diagnostics are performed in a copy of the production environment.
Customer satisfaction surveys are recorded with Microsoft Forms Pro. Survey replies from customers are
sent to a generic mailbox.
Automation
A text message must be automatically sent to a customer to confirm an appointment and to notify when a
technician is on route that includes their location.
Ecommerce sales orders must be integrated into Dynamics 365 Finance and then exported to Azure every
night.
A text alert must be sent to employees scheduled to assist in the repair area of the retail store if the number
of repair check-ins exceeds eight.
Submitted customer surveys must generate an email to the correct department. Approval and follow-up
must occur within a week.
Reporting
The warehouse manager’s dashboard must contain warehouse counting variance information.
A warehouse manager needs to quickly view warehouse KPIs by using a mobile device.
Power BI must be used for reporting across the organization.
User experience
Warehouse counting must be performed by using a mobile app that scans barcodes on boxes.
All customer repairs must be tracked in the system no matter where they occur.
Qualified leads must be collected from local bike fairs.
Issues
Warehouse counting must be performed by using a mobile app that scans barcodes on boxes.
All customer repairs must be tracked in the system no matter where they occur.
Qualified leads must be collected from local bike fairs.
Internal
User1 reports receives an intermittent plug-in error when viewing the total bill customer time.
User2 reports that Azure consumption for API calls has increased significantly to 100 calls per minute in the
last month.
User2 reports that sales orders have increased.
User5 receives the error message: ‘Endpoint unavailable’ during a test of the technician dispatch ISV
solution.
The parts department manager who is the approver for the department is currently on sabbatical.
External
CustomerB reports that the check-in app returned only one search result for their last name, which is not
the correct name.
Nine customers arrive in the repair area of the retail store, but no texts were sent to scheduled employees.
96CE4376707A97CE80D4B1916F054522
Customers report that the response time from the information email listed on the Adventure Works Cycles
website is greater than five days.
CustomerC requested additional information from the parts department through the customer survey and
has not received a response one week later.
QUESTION 1
You need to resolve CustomerB’s issues with the check-in application.
Which two options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. LookUp to Filter
B. Filter to LookUp
C. Search to LookUp
D. LookUp to Search
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
Explanation:
CustomerB reports that the check-in app returned only one search result for their last name, which is not the
correct name.
The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records that match
one or more criteria and to discard those that don't.
The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record
that matches one or more criteria.
The Search function finds records in a table that contain a string in one of their columns.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
Create and configure Power Apps
Question Set 3
QUESTION 1
HOTSPOT
A company uses SharePoint for its intranet and other functions. The company has also implemented modeldriven
apps.
SharePoint users must be able to create contact records in the Common Data Service (CDS), without having to
navigate to the model-driven apps.
You need to create a link in SharePoint to open the CDS contact from displaying data from SharePoint.
How should you complete the URL? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Buy full version for more questions
Testlet 1
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on this
exam. You must manage your time to ensure that you are able to complete all questions included on this exam
in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case
study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and
to make changes before you move to the next section of the exam. After you begin a new section, you cannot
return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore
the content of the case study before you answer the questions. Clicking these buttons displays information
such as business requirements, existing environment, and problem statements. If the case study has an All
Information tab, note that the information displayed is identical to the information displayed on the subsequent
tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
Contoso Pharmaceuticals manufactures and sells drugs to retail and wholesale pharmacies, hospitals, and
research facilities.
The company plans to implement Dynamics 365 Sales and Dynamics 365 Finance.
Current environment
Contoso maintains a Microsoft Excel workbook that lists all drugs they supply.
Pharmacies submit order requests through email.
All information at customer locations is handwritten by customer representatives.
Contoso uses Cerner, which is a medical industry application that uses a proprietary database.
Some accounts are referrals from other pharmacies.
Every pharmacy has its own Dynamics 365 Sales instance.
Requirements
General
Contoso wants to ensure that there is minimal custom code and custom connectors in the system.
Accounts
Ensure that the names of the pharmacies are synced between the accounting and the customer
management systems.
Account numbers should be entered automatically into the pharmaceutical system that is in a Cerner
database and kept in sync.
When the account is entered into the system, extra fields must appear if the referral customer box is
selected. If the box is not selected, the extra fields must not appear.
A trigger must be created that changes the Priority field to 1 in the Account record 10 days after an Account
record is created.
96CE4376707A97CE80D4B1916F054522
A field named Priority_Trigger must be created to trigger the Priority field.
A field named Facility type field must be added in order to select whether a customer is a retail pharmacy,
wholesale pharmacy, research facility, or hospital.
Users
UserA must be able to create and publish Power Apps apps.
UserB must be the owner of all the systems and be able to provide permissions and create all new
environments.
UserC must be able to create apps connected to the systems and update the security roles and entities.
Pharmacy representatives must only be able to run the apps and access their own records.
Access to the accounting Power Apps app must be restricted to accounting team members.
End users must have minimum access to the required systems.
Only supervisors must be able to view phone numbers in the Accounts form.
Developers must be able to create new apps for all users.
Sales users must only have access to their own records.
Reporting
Pharmacy orders must be displayed in four graphs as follows:
Annual revenue over $100,000
Annual revenues under $100,000
Research facilities
Hospitals
The graphs must be interactive, and users must be able to drill down on any dimension.
Customizations
Ensure that notifications are sent to the sales team when a lead is added by using Slack.
Ensure that leads have a review stage added to the sales process.
Doctors must be manually added to a custom entity named Doctor if the doctor is not listed.
Refill dates for customer prescriptions should be automatically determined and a notification should be sent
to the customer.
Fields for the doctor’s name and phone number must be displayed in the customer record.
The doctor entered on the customer’s record must be validated against doctors that exist in the system.
The new solution will be sold to other pharmacies for use. The application must not allow changes to be
made.
The solution must be error free so that when it is installed in other environments it does not cause issues.
A custom mobile app must be created to allow salespeople to add or search by pharmacy name.
Pharmacy records must be uniquely identified by pharmacy name, address, contact name, and phone
number.
When a pharmacy is added by using the mobile app, the phone number must be validated to be all digits.
QUESTION 1
You need to ensure that users can create the required charts.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Create a quick view form to show the Accounts entity.
B. Configure filter fields in the Annual revenue field.
C. Add the Facility field to the account form.
D. Delete the Annual revenue field from the account form.
E. Create a view with annual revenue sorted lowest value to highest value.
96CE4376707A97CE80D4B1916F054522
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
Explanation:
Pharmacy orders must be displayed in four graphs as follows:
Annual revenue over $100,000
Annual revenues under $100,000
Research facilities
Hospitals
The graphs must be interactive, and users must be able to drill down on any dimension.
96CE4376707A97CE80D4B1916F054522
Create and configure Power Apps
Testlet 2
Case study
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on this
exam. You must manage your time to ensure that you are able to complete all questions included on this exam
in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case
study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and
to make changes before you move to the next section of the exam. After you begin a new section, you cannot
return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore
the content of the case study before you answer the questions. Clicking these buttons displays information
such as business requirements, existing environment, and problem statements. If the case study has an All
Information tab, note that the information displayed is identical to the information displayed on the subsequent
tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
Current environment
Adventure Works Cycles wants to replace their paper-based bicycle manufacturing business with an efficient
paperless solution. The company has one manufacturing plant in Seattle that produces bicycle parts,
assembles bicycles, and distributes finished bicycles to the Pacific Northwest.
Adventure Works Cycles has a retail location that performs bicycle repair and warranty repair work. The
company has six maintenance vans that repair bicycles at various events and residences.
Adventure Works Cycles recently deployed Dynamics 365 Finance and Dynamics 365 Manufacturing in a
Microsoft-hosted environment for financials and manufacturing. The company plans to leverage the Microsoft
Power Platform to migrate all of their distribution and retail workloads to Dynamics 365 Unified Operations.
The customer uses Dynamics 365 Sales. Dynamics 365 Customer Service and Dynamics 365 Field Service.
Retail store information
Adventure Works Cycle has one legal entity, four warehouses, and six field service technicians.
Warehouse counting is performed manually by using a counting journal. All warehouse boxes and items are
barcoded.
The Adventure Works Cycles retail location performs bicycle inspections and performance tune-ups.
Technicians use paper forms to document the bicycle inspection performed before a tune-up and any
additional work performed on the bicycle.
Adventure Works Cycles uses a Power Apps app for local bike fairs to attract new customers.
A canvas app is being developed to capture customer information when customers check in at the retail
location. The app has the following features:
- Customer selects yes or no if they are on the mailing list.
- Customer selects the amount of times they have visited the store.
- Customer selects the type of service needed.
- The search result returns all last name records that match the search term.
96CE4376707A97CE80D4B1916F054522
Technology
Requirements
A plug-in for Dynamics 365 Sales automatically calculated the total billed time from all activities on a
particular customer account, including sales representative visits, phone calls, email correspondence, and
repair time compared with hours spent.
A shipping API displays shipping rates and tracking information on sales orders. The contract allows for
3,000 calls per month.
Ecommerce orders are processed in batch daily by using a manual import of sales orders in Dynamics 365
Finance.
Microsoft Teams is used for all collaboration.
All testing and problem diagnostics are performed in a copy of the production environment.
Customer satisfaction surveys are recorded with Microsoft Forms Pro. Survey replies from customers are
sent to a generic mailbox.
Automation
A text message must be automatically sent to a customer to confirm an appointment and to notify when a
technician is on route that includes their location.
Ecommerce sales orders must be integrated into Dynamics 365 Finance and then exported to Azure every
night.
A text alert must be sent to employees scheduled to assist in the repair area of the retail store if the number
of repair check-ins exceeds eight.
Submitted customer surveys must generate an email to the correct department. Approval and follow-up
must occur within a week.
Reporting
The warehouse manager’s dashboard must contain warehouse counting variance information.
A warehouse manager needs to quickly view warehouse KPIs by using a mobile device.
Power BI must be used for reporting across the organization.
User experience
Warehouse counting must be performed by using a mobile app that scans barcodes on boxes.
All customer repairs must be tracked in the system no matter where they occur.
Qualified leads must be collected from local bike fairs.
Issues
Warehouse counting must be performed by using a mobile app that scans barcodes on boxes.
All customer repairs must be tracked in the system no matter where they occur.
Qualified leads must be collected from local bike fairs.
Internal
User1 reports receives an intermittent plug-in error when viewing the total bill customer time.
User2 reports that Azure consumption for API calls has increased significantly to 100 calls per minute in the
last month.
User2 reports that sales orders have increased.
User5 receives the error message: ‘Endpoint unavailable’ during a test of the technician dispatch ISV
solution.
The parts department manager who is the approver for the department is currently on sabbatical.
External
CustomerB reports that the check-in app returned only one search result for their last name, which is not
the correct name.
Nine customers arrive in the repair area of the retail store, but no texts were sent to scheduled employees.
96CE4376707A97CE80D4B1916F054522
Customers report that the response time from the information email listed on the Adventure Works Cycles
website is greater than five days.
CustomerC requested additional information from the parts department through the customer survey and
has not received a response one week later.
QUESTION 1
You need to resolve CustomerB’s issues with the check-in application.
Which two options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. LookUp to Filter
B. Filter to LookUp
C. Search to LookUp
D. LookUp to Search
Correct Answer: AD
Section: (none)
Explanation
Explanation/Reference:
Explanation:
CustomerB reports that the check-in app returned only one search result for their last name, which is not the
correct name.
The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records that match
one or more criteria and to discard those that don't.
The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record
that matches one or more criteria.
The Search function finds records in a table that contain a string in one of their columns.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
Create and configure Power Apps
Question Set 3
QUESTION 1
HOTSPOT
A company uses SharePoint for its intranet and other functions. The company has also implemented modeldriven
apps.
SharePoint users must be able to create contact records in the Common Data Service (CDS), without having to
navigate to the model-driven apps.
You need to create a link in SharePoint to open the CDS contact from displaying data from SharePoint.
How should you complete the URL? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Buy full version for more questions
Leave a comment