Microsoft PL-600 - Microsoft Power Platform Solution Architect

Box 1: Security role

Microsoft Dataverse uses a role-based security model to help secure access to the database.

Scenario:

You must prevent users from changing inspection order data once an inspection is marked as final.

Supervisors must be able to modify standard checklists. Other employees must be prevented from modifying checklists.

Box 2: Data flow

Dataflows are a self-service, cloud-based, data preparation technology. Dataflows enable customers to ingest, transform, and load data into Microsoft Dataverse environments, Power BI workspaces, or your organization's Azure Data Lake Storage account.

Scenario: Provide a visual representation of the testing measurement limits for each step. Include an indication of how the measured value compares to measurement limits and whether the measurement is within tolerance. Users must be able to configure the visualizations to display the minimum value and maximum value, and whether the reading is within the tolerance of a single targeted value. It must also be able to be used for maintenance inspections once the machine has been installed.

Office 365 Users lets you access user profiles in your organization using your Office 365 account. You can use the Use the connection in your Power Platform app.

Dataverse is part of the Microsoft 365 collaboration and productivity tools. Using federation, applications can connect to Dataverse using the same system user identities and credentials available in an Azure Active Directory based network.

Scenario:

Users must be active employees of Fabrikam.

Quality inspection app: Fabrikam is evaluating Microsoft Power Platform to determine whether it can meet the company’s requirements for a manufacturing defect and quality inspection solution. Each machine produced must be subjected to a quality inspection at various points during production. Each machine must undergo a more extensive quality inspection before the machine can be shipped to the customer.

Business rule can create business recommendations based on business intelligence.

Scenario: Analytics and reporting

The solution must:

Provide metrics including existing and upcoming demand by inspection station, average time spent per user at a station, and average time a machine spends at each inspection point.

Provide metrics per inspector including number of inspections performed by month, and number of inspections per rating type (pass, fail).

Provide a printed quality certificate to be included with each machine.

Box 1: Create a lookup to Dynamics 365 Field Service

Scenario: Machines are assigned serial numbers and placed in stock until they are shipped to customers.

Entity lookup: Allows technicians to choose a Dynamics 365 record. In the inspection designer interface, admins must select an entity and a field to display. For a chosen entity, the Name field and mandatory fields are the entity attributes that can be displayed in the lookup.

Box 2: Create a one-to-many relationship and set the behavior to Parental

Scenario: Inspection orders must:

Allow entry of quality ratings of passed or failed for each quality metric identified for the machine being rated.

Be automatically marked as failed if one inspection step rating is marked as failed.

Each inspection order can have one or many inspection steps, and each inspection step has a rating.

Note: Each pair of tables that are eligible to have a 1:N relationship can have multiple 1:N relationships between them. Yet usually only one of those relationships can be considered a parental table relationship.

Need to store the image in the table.

Scenario: The company uses photos of employees to generate employee badges. Photos are uploaded into Microsoft 365 user profiles.

Scenario: Standardized checklists must be stored in the solution for use by inspectors. A copy must be created when a new inspection is initiated.

Dataverse for Teams – built on Microsoft Dataverse – provides relational data storage, rich data types, enterprise-grade governance, and one-click solution deployment to the Microsoft Teams app store.

Dataverse for teams table creation has all of the things that are great about Microsoft Lists, without the major downsides.

Box 1: Create and embed a Power Bi radial gauge

A radial gauge chart has a circular arc and shows a single value that measures progress toward a goal or a Key Performance Indicator (KPI). The line (or needle) represents the goal or target value. The shading represents the progress toward that goal. The value inside the arc represents the progress value. Power BI spreads all possible values evenly along the arc, from the minimum (left-most value) to the maximum (right-most value).

In this example, you're a car retailer tracking the sales team's average sales per month. The needle represents a 140 cars sales goal. The minimum possible average sales is 0 and the maximum is 200. The blue shading shows that the team is averaging approximately 120 sales this month.

Box 2: Add an inspection order to the work order form

You can add inspections to work orders in Dynamics 365 Field Service.

Field Service inspections are digital forms that technicians use to quickly and easily answer a list of questions as part of a work order. The list of questions can include safety protocols, pass-and-fail tests for a customer asset, an interview with a customer, or other audits and assessments performed before, during, or after a work order.

Example:

Scenario: Information about each machine produced must be transferred to Dynamics 365 Field Service.

Use the Microsoft Dataverse connector when connecting to the Microsoft Dataverse used for Microsoft Dynamics 365 Sales, Microsoft Dynamics 365 Customer Service, Microsoft Dynamics 365 Field Service, Microsoft Dynamics 365 Marketing, and Microsoft Dynamics 365 Project Service Automation.

Box 1: Schedule board

The Dynamics 365 Field Service schedule board provides an overview of resource availability and bookings you can make.

Box 2: Azure IoT Central connector

Information about each machine produced must be transferred to Dynamics 365 Field Service.

The difference between IoT hub and IoT central is that IoT is an application platform that simplifies the creation of Internet of Things solutions. IoT central helps to reduce the challenges of implementing IoT development, operations, and management. IoT Central is a fully managed Software as a Service solution.

Note: There are three ways you can use to connect IoT-enabled devices into the Field Service solution:

Connected Field Service for Azure IoT Central

Connected Field Service for Azure IoT Hub

Connected Field Service for non-Azure IoT providers using the extensible IoT provider framework