https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/xrm-webapi/updaterecord

Topic 6, City Power & Light
Background
City Power & Light is an energy and utilities company that has offices in Europe. The company subsidizes home improvements for domestic customers, to improve energy efficiency and to meet environmental commitments. The company also distributes and generates electricity for domestic and commercial customers.
The company has 2,000 employees in multiple offices and in work-from-home locations.
City Power & Light uses a team of schedulers, assessors, field engineers, and customer support agents for home improvements in a program named Get Energy Fit.
Current Environment
Get Energy Fit Program
City Power & Light uses the following to manage the Get Energy Fit program:
* The company uses a Microsoft Excel spreadsheet named Planning Hub on Microsoft SharePoint Online to store information about customer appointments, customer details, and customer eligibility in the program.
* The company records sensitive customer information that includes the document identification numbers and the customer's financial information.
* The company uses an assessor to verify customer eligibility in the program and to perform a suitability assessment. The assessor completes the suitability assessment by using a paper and clipboard at the customer property and enters the data to tte Planning Hub after the assessment is completed. The assessor also uploads
* photographs to an on-premises document library. The assessor completes the eligibility assessment by using an application written in React.
* Schedulers use Microsoft Outlook to schedule engineers and assessors for home improvement appointments.
About 200 appointments are scheduled daily.
* Employees for the company submit funding claims on behalf of the customer by uploading evidence and compliance checks information to an application named the Claim Submission Portal.
Technical Environment
* Schedulers use Windows 11 desktop and laptop computers with the latest version of Microsoft Edge.
* Assessors use iOS and Android tablet devices.
* The Claim Submission Portal uses REST-based APIs for all operations and a dedicated testing environment.
Authentication to the API is provided by using the following example header key and value pair o Authentication: 2C8D41431415E429C7FC7A74D8315
* The company uses Microsoft Azure for hosting multiple applications.
Requirements
Overview
City Power & Light plans to implement Microsoft Power Platform to improve the customer experience and increase delivery for the Get Energy Fit program.
Business Requirements
* Only team leaders and senior managers should have access to read personally identifiable information (Pll).
* All development changes must be tested in a separate environment.
* The company requires out-of-the-box solutions, when possible.
* Sensitive credentials, such as user passwords and API secrets, must be stored securely.
* The Claim Submission Portal must allow citizen developers to create automated solutions.
* Customer and appointment information must be accessible to all applications.
Planning Hub Application
The company is planning to replace the Planning Hub spreadsheet with a new application. The new application has the following requirements:
* The application must support a component design that provides rapid changes requested by the schedulers.
* The data model for the application must capture the following information:
* The application must support a component design that provides rapid changes requested by the schedulers.
* The data model for the application must capture the following information; o Information about customers such as name, address, and other PH.
o The data and time for an assessor's or engineer's appointment. Schedulers must be able to view all appointments without filters, o Records the details of the home improvements installed for the customer, o Contains all the information and evidence for submission to the Claim Submission Portal.
* After an assessor uploads the funding application and all evidence after a home improvement has been complete, the company requires that the status of the application is set to Submit and should run the following:
o Retrieve the details about the customer and the improvement installed, o Send an approval to a senior manager to review and approve in Microsoft Teams.
o Upload the information to the API endpoint.
o if the upload fails to complete, it should retry after a delay of 30 seconds up to three times. If an error occurs after three times, the application should send an email notification to the application support team.
o Must record the status on the funding application.
Suitability Assessment Tool
The company plans to implement a new application named the Suitability Assessment Tool for the assessors.
The new application has the following requirements:
* Must integrate with Microsoft Power Platform.
* Assessors must be able to complete the eligibility assessment by using the Suitability Assessment Tool. The assessors must be able to upload photographs to the on-premises file share.
* Must be developed by using modular components that can be used by other applications.
* Must be optimized for use on tablet devices.
* All changes to the application must be completed in the Suitability Assessment Tool solution.
Reporting
The company has the following requirements for a reporting solution:
* The data source for the reporting solution must support incremental refreshes.
* The solution must report accurate data if an error occurs.

Explanation:
Box 1: SortByColums
The SortByColumns function can be used to sort a table based on one or more columns.
The parameter list for SortByColumns provides the names of the columns to sort by and the sort direction per column. Sorting is performed in the order of the parameters (sorted first by the first column, then the second, and so on).
Box 2: Filter
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.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-sort

Explanation:
To design a component that can be used in all the departmental apps to display the total number of client issues in bold colors, you should perform the following four actions in sequence:
* Create a connection to the engineering issues list and retrieve the total number of critical issues.
* Create an output parameter and set the value of the parameter to the total number of critical issues.
* Create a new component in the first department app.
* Create and format a label to display the total number of critical issues, and display the counter output parameter in the department app.