PL-900 Demonstrate the capabilities of Power Apps — All Questions With Answers

Refer to the exhibit.

Error log:
{
  "error": {
    "code": "0x80040220",
    "message": "Business Process Flow instance creation failed. The selected entity is not valid for the selected process.",
    "details": {
      "ActivityId": "a1b2c3d4-e5f6-7890-abcd-ef1234567890"
    }
  }
}

Refer to the exhibit.

Power Fx formula:
If(
    IsEmpty(SortByColumns(Filter(Accounts, 'Account Name' = "Contoso"), "Created On", Descending)),
    "No records found",
    First(SortByColumns(Filter(Accounts, 'Account Name' = "Contoso"), "Created On", Descending)).'Account Name'
)

Refer to the exhibit.

```
{
  "name": "Order Approval",
  "type": "canvas",
  "dataSources": [
    {
      "type": "Microsoft Dataverse",
      "entities": ["Orders", "OrderDetails"],
      "relationships": [
        {
          "fromEntity": "Orders",
          "toEntity": "OrderDetails",
          "relationshipType": "OneToMany",
          "fromKey": "OrderID",
          "toKey": "OrderID"
        }
      ]
    }
  ],
  "controls": [
    {
      "type": "Gallery",
      "name": "OrderGallery",
      "items": "Orders",
      "template": {
        "fields": ["OrderID", "OrderDate", "Total"],
        "controls": [
          {
            "type": "Button",
            "name": "DetailButton",
            "text": "View Details",
            "action": "Navigate(OrderDetailScreen)"
          }
        ]
      }
    }
  ]
}
```

Refer to the exhibit.

{
    "name": "PowerAppPermissions",
    "type": "Microsoft.Authorization/roleDefinitions",
    "apiVersion": "2022-04-01",
    "properties": {
        "roleName": "Custom Power Apps User",
        "description": "Can use Power Apps",
        "type": "customRole",
        "permissions": [
            {
                "actions": [
                    "Microsoft.PowerApps/apps/read",
                    "Microsoft.PowerApps/apps/install"
                ],
                "notActions": [],
                "dataActions": [],
                "notDataActions": []
            }
        ],
        "assignableScopes": [
            "/subscriptions/12345/resourceGroups/RG1"
        ]
    }
}

Refer to the exhibit.

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "resources": [
    {
      "type": "Microsoft.Web/connections",
      "apiVersion": "2016-06-01",
      "name": "shared_office365",
      "location": "[resourceGroup().location]",
      "properties": {
        "displayName": "Office 365 Outlook",
        "api": {
          "id": "/subscriptions/123/resourceGroups/RG/providers/Microsoft.Web/locations/eastus/managedApis/shared_office365"
        },
        "parameterValues": {
          "token:clientId": "client-id-here",
          "token:clientSecret": "secret-here",
          "token:resourceUri": "https://outlook.office365.com"
        }
      }
    },
    {
      "type": "Microsoft.PowerApps/apps",
      "apiVersion": "2022-04-01",
      "name": "MyApp",
      "location": "eastus",
      "properties": {
        "appId": "app-id-here",
        "connectionReferences": {
          "shared_office365": {
            "connectionName": "shared_office365",
            "source": "Embedded",
            "id": "[resourceId('Microsoft.Web/connections', 'shared_office365')]"
          }
        }
      },
      "dependsOn": [
        "[resourceId('Microsoft.Web/connections', 'shared_office365')]"
      ]
    }
  ]
}

Refer to the exhibit.

Filter(array1, Status = "Active")

Refer to the exhibit.

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "resources": [
    {
      "type": "Microsoft.PowerApps/environments",
      "apiVersion": "2022-05-01",
      "name": "[parameters('environmentName')]",
      "location": "[parameters('location')]",
      "properties": {
        "environmentType": "Production",
        "dataverse": {
          "templates": [
            "D365_FieldService"
          ]
        }
      }
    }
  ]
}

Refer to the exhibit.

Gallery1.Items:
Filter(Accounts, StartsWith(Title, TextSearchBox1.Text))

Refer to the exhibit.

Set(VarOrder, Patch(Orders, Defaults(Orders), {Title: "New Order", Customer: "Contoso", Amount: 1500}))

Refer to the exhibit.

```json
{
  "name": "TestPolicy",
  "rules": [
    {
      "entity": "account",
      "conditions": [
        {
          "attribute": "revenue",
          "operator": "greater-than",
          "value": 1000000
        }
      ],
      "actions": [
        {
          "type": "set-attribute",
          "attribute": "description",
          "value": "High-value account"
        }
      ]
    }
  ]
}
```

Refer to the exhibit.

```xml
<app xmlns="http://schemas.microsoft.com/powerapps/2019/app">
  <id>c1e2f3g4-h5i6-j7k8-l9m0-n1o2p3q4r5s6</id>
  <displayName>Sales App</displayName>
  <description>Model-driven app for sales team</description>
  <components>
    <component type="table" id="account" />
    <component type="table" id="contact" />
    <component type="table" id="opportunity" />
    <component type="dashboard" id="salesDashboard" />
  </components>
  <siteMap>
    <area title="Sales">
      <group title="Customers">
        <subArea title="Accounts" table="account" />
        <subArea title="Contacts" table="contact" />
      </group>
      <group title="Deals">
        <subArea title="Opportunities" table="opportunity" />
      </group>
    </area>
  </siteMap>
</app>
```

Refer to the exhibit.

```
{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "environmentName": {
      "type": "string",
      "defaultValue": "MyEnvironment"
    }
  },
  "resources": [
    {
      "type": "Microsoft.PowerApps/environments",
      "apiVersion": "2016-11-01",
      "name": "[parameters('environmentName')]",
      "location": "[resourceGroup().location]",
      "properties": {
        "environmentSku": "Production",
        "provisionDatabase": true
      }
    }
  ]
}
```

Refer to the exhibit.

{
  "allowedApplications": [
    {
      "id": "00000007-0000-0000-c000-000000000000",
      "displayName": "Power Apps"
    },
    {
      "id": "00000009-0000-0000-c000-000000000000",
      "displayName": "Power Automate"
    }
  ]
}

Refer to the exhibit.

{
  "name": "Contoso_Expense_App",
  "type": "CanvasApp",
  "datasources": [
    {
      "name": "Expenses",
      "type": "SharePointList",
      "connectionReferenceId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/..."
    }
  ],
  "appVersion": "1.0.0.0"
}

Refer to the exhibit.

{
  "businessProcessFlow": {
    "name": "Expense Approval Process",
    "entity": "expenses",
    "stages": [
      {
        "name": "Submit",
        "category": "Submit",
        "steps": [
          {"name": "Expense Report Completed", "required": true}
        ]
      },
      {
        "name": "Approval",
        "category": "Approval",
        "steps": [
          {"name": "Manager Approval", "required": true},
          {"name": "Finance Approval", "required": false}
        ]
      }
    ]
  }
}

Refer to the exhibit. The following JSON shows a Power Apps component framework (PCF) manifest:

{
  "namespace": "MyCompany",
  "control": "MyControl",
  "version": "1.0.0",
  "display-name-key": "MyControl_Display_Key",
  "description-key": "MyControl_Desc_Key",
  "properties": [
    {
      "name": "TextProperty",
      "display-name-key": "Text_Display_Key",
      "description-key": "Text_Desc_Key",
      "type": "singleLine.text"
    }
  ],
  "abilities": {
    "data": ["dataset"]
  }
}

Refer to the exhibit. The following is a Power Automate flow snippet used in a Power Apps app:

"triggers": {
  "manual": {
    "inputs": {
      "schema": {
        "type": "object",
        "properties": {
          "email": {
            "type": "string"
          },
          "score": {
            "type": "number"
          }
        }
      }
    }
  }
}

Refer to the exhibit. The following is a Power Apps formula for a label's Text property:

Text = "Welcome, " & User().FullName & "!"

Refer to the exhibit.
```json
{
  "name": "GetUserProfile",
  "type": "OpenApiConnection",
  "inputs": {
    "host": {
      "connectionName": "shared_office365users",
      "operationId": "GetUserProfile"
    },
    "parameters": {
      "User": "@{triggerOutputs()?['body/owner']}"
    }
  }
}
```

Refer to the exhibit.
```
PowerShell cmdlet: Get-AdminPowerApp
Sample output:
AppName        : SalesPipelineApp
CreatedTime    : 2024-01-15T10:30:00Z
LastModifiedTime : 2024-06-20T14:00:00Z
Owner          : user@contoso.com
EnvironmentName : Default-12345678-1234-1234-1234-123456789abc
```

Refer to the exhibit.
```xml
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="account">
    <attribute name="name" />
    <attribute name="accountid" />
    <attribute name="createdon" />
    <order attribute="name" descending="false" />
    <filter type="and">
      <condition attribute="statecode" operator="eq" value="0" />
      <condition attribute="createdon" operator="last-x-days" value="30" />
    </filter>
  </entity>
</fetch>
```

Refer to the exhibit.

{
  "name": "ExpenseReport",
  "fields": [
    {"name": "Title", "type": "text"},
    {"name": "Amount", "type": "currency"},
    {"name": "Date", "type": "dateonly"},
    {"name": "Approved", "type": "boolean", "default": false}
  ]
}

Refer to the exhibit.

{
  "policies": [
    {
      "name": "BlockScreenCapture",
      "description": "Prevent screen capture in Power Apps mobile app",
      "settings": {
        "screenCaptureEnabled": false
      }
    }
  ]
}

Refer to the exhibit.

{
  "app": {
    "id": "/providers/Microsoft.PowerApps/apps/myApp",
    "properties": {
      "displayName": "My App",
      "owner": {
        "id": "user@contoso.com"
      },
      "environment": {
        "name": "Default-12345"
      }
    }
  }
}

Refer to the exhibit.

```json
{
  "name": "App1",
  "type": "CanvasApp",
  "dataSources": [
    {
      "type": "ConnectionReference",
      "name": "SharePointOnline1",
      "connectionId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
    }
  ],
  "appComponents": []
}
```

Refer to the exhibit.

```
Get-AzureADUser -ObjectId user@contoso.com | Select-Object -Property DisplayName, UserPrincipalName, AssignedLicenses
```

Refer to the exhibit.

```
{
  "permissions": [
    {
      "scope": "environment",
      "role": "Environment Admin"
    },
    {
      "scope": "app",
      "appId": "00000000-0000-0000-0000-000000000001",
      "role": "Can Edit"
    }
  ]
}
```

{
  "name": "AddDays",
  "type": "function",
  "parameters": [
    {
      "name": "interval",
      "type": "integer",
      "description": "Number of days to add"
    },
    {
      "name": "date",
      "type": "date",
      "description": "Start date"
    }
  ],
  "returnType": "date"
}

{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "resources": [
    {
      "type": "Microsoft.Web/connections",
      "apiVersion": "2016-06-01",
      "name": "mySharePointConnection",
      "properties": {
        "api": {
          "id": "/subscriptions/{subscription-id}/providers/Microsoft.Web/locations/{location}/managedApis/sharepointonline"
        },
        "displayName": "SharePoint Connection",
        "parameterValues": {}
      }
    }
  ]
}

{
  "name": "Filter",
  "parameters": [
    {
      "name": "source",
      "type": "table",
      "description": "The data source to filter"
    },
    {
      "name": "formula",
      "type": "boolean",
      "description": "A boolean expression to evaluate for each record"
    }
  ],
  "returnType": "table"
}

{
  "name": "Contoso Inventory App",
  "type": "Canvas",
  "dataSources": [
    {
      "name": "Inventory",
      "type": "Microsoft Dataverse",
      "entity": "contoso_inventory",
      "filter": "status eq 'Active'"
    }
  ],
  "components": [
    {
      "name": "Gallery1",
      "items": "Filter(Inventory, Stock < 10)",
      "fields": ["ProductName", "Stock"]
    }
  ]
}