PL-900 Describe the business value of Microsoft Power Platform — All Questions With Answers

{
  "name": "Sales Dashboard",
  "dataSources": [
    {
      "type": "SQL Server",
      "connectionString": "Server=myserver.database.windows.net;Database=SalesDB;..."
    },
    {
      "type": "Excel",
      "path": "https://sharepoint.com/sites/sales/Shared%20Documents/Report.xlsx"
    }
  ],
  "refreshSchedule": {
    "frequency": "Daily",
    "time": "02:00"
  }
}

{
  "flows": [
    {
      "name": "Approval Flow",
      "triggers": [
        {
          "type": "When a file is created in SharePoint",
          "site": "https://contoso.sharepoint.com/sites/ExpenseReports",
          "folder": "Pending"
        }
      ],
      "actions": [
        {
          "type": "Start an approval",
          "assignedTo": "manager@contoso.com",
          "item": "@{triggerOutputs()?['headers/{Filename}']}"
        },
        {
          "type": "Condition",
          "expression": "@equals(outputs('Start_an_approval')?['status'], 'Approved')",
          "ifTrue": [
            {
              "type": "Move file",
              "to": "Approved"
            }
          ],
          "ifFalse": [
            {
              "type": "Move file",
              "to": "Rejected"
            }
          ]
        }
      ]
    }
  ]
}

{
  "app": {
    "name": "Asset Management",
    "dataSource": "Microsoft Dataverse",
    "tables": [
      {
        "name": "Asset",
        "columns": [
          {"name": "Name", "type": "Text"},
          {"name": "SerialNumber", "type": "Text"},
          {"name": "AssignedTo", "type": "Lookup", "targetTable": "User"},
          {"name": "Status", "type": "Choice", "options": ["Active", "Inactive", "Disposed"]}
        ]
      }
    ],
    "roles": [
      {
        "name": "Asset Manager",
        "permissions": "Create, Read, Write"
      },
      {
        "name": "Employee",
        "permissions": "Read"
      }
    ]
  }
}

Refer to the exhibit.

```json
{
  "triggers": [
    {
      "type": "When a file is created",
      "inputs": {
        "location": "SharePoint",
        "folder": "/documents/invoices"
      }
    }
  ],
  "actions": [
    {
      "type": "Send an email",
      "inputs": {
        "to": "finance@contoso.com",
        "subject": "New invoice uploaded",
        "body": "Invoice @{triggerOutputs()?['headers/Content-Disposition']} has been uploaded."
      }
    }
  ]
}
```

Refer to the exhibit.

```dax
Sales Growth % = 
DIVIDE(
    SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date])),
    CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date]))
) * 100
```

Refer to the exhibit.

```yaml
# Example: Power Apps component library reference
App.OnStart = Set(
    varUserEmail,
    User().Email
);
Set(varUserRole, LookUp(Roles, UserEmail = varUserEmail).Role)
```

Refer to the exhibit.

{
  "triggers": {
    "When_a_new_email_arrives": {
      "type": "ApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_office365"
        },
        "operationId": "OnNewEmail",
        "parameters": {
          "folderPath": "Inbox",
          "importance": "Any",
          "includeAttachments": true
        }
      }
    }
  },
  "actions": {
    "Create_item": {
      "type": "ApiConnection",
      "inputs": {
        "host": {
          "connectionName": "shared_commondataserviceforapps"
        },
        "operationId": "CreateItem",
        "parameters": {
          "entityName": "Leads",
          "item/email": "@{triggerOutputs()?['body/from']}"
        }
      }
    }
  }
}

Refer to the exhibit.

```
Measure = 
VAR SelectedYear = SELECTEDVALUE('Date'[Year])
RETURN
CALCULATE(
    SUM(Sales[Amount]),
    'Date'[Year] = SelectedYear - 1
)
```

Refer to the exhibit.

```json
{
  "property": "CopilotStudioBot",
  "schema": {
    "topics": [
      {
        "name": "Greeting",
        "triggerPhrases": ["hello", "hi", "good morning"]
      },
      {
        "name": "CheckOrderStatus",
        "triggerPhrases": ["order status", "where is my order", "track order"]
      }
    ]
  }
}
```

Refer to the exhibit.
```json
{
  "name": "New Employee Onboarding",
  "triggers": {
    "manual": true,
    "schedule": {
      "frequency": "Day",
      "interval": 1,
      "startTime": "2026-05-01T08:00:00Z"
    }
  },
  "actions": [
    {
      "type": "CreateRecord",
      "entityName": "Users",
      "fields": {
        "FirstName": "{{triggerOutputs()?['name']}}",
        "Department": "IT"
      }
    },
    {
      "type": "SendEmail",
      "to": "hr@contoso.com",
      "subject": "New employee created",
      "body": "User {{triggerOutputs()?['name']}} has been created."
    }
  ]
}
```

Refer to the exhibit.
```dax
Total Sales = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice])
```

Refer to the exhibit.
```json
{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "resources": [
    {
      "type": "Microsoft.PowerApps/environments",
      "apiVersion": "2023-06-01",
      "name": "[parameters('environmentName')]",
      "location": "[parameters('location')]",
      "properties": {
        "displayName": "[parameters('displayName')]",
        "description": "Production environment",
        "environmentSku": "Production"
      }
    }
  ]
}
```

{
  "isExact": true,
  "rules": [
    {
      "entityName": "Account",
      "columnMatch": "City",
      "columnMatchValue": "Seattle"
    }
  ]
}

{
  "value": "rubbish bin",
  "type": "AppFeedback",
  "data": [
    {
      "sentiment": "negative"
    }
  ]
}

{
  "flows": [
    {
      "name": "Flow1",
      "triggers": ["When an item is created"],
      "actions": ["Send an email", "Update item"]
    },
    {
      "name": "Flow2",
      "triggers": ["When an email arrives"],
      "actions": ["Create item", "Send approval"]
    }
  ]
}

{
  "connector": "Azure SQL Database",
  "authenticationType": "ServicePrincipal",
  "connectionParameters": {
    "server": "myserver.database.windows.net",
    "database": "SalesDB",
    "tenantId": "contoso.onmicrosoft.com",
    "clientId": "12345678-1234-1234-1234-123456789abc"
  }
}

{
  "type": "Microsoft.PowerApps/apps",
  "apiVersion": "2023-06-01",
  "properties": {
    "appComponents": [
      {
        "type": "CanvasApp",
        "name": "InventoryApp",
        "appVersion": "1.0.0.0",
        "lifecycleId": "production"
      }
    ],
    "environment": {
      "id": "/providers/Microsoft.PowerApps/environments/Environment1"
    }
  }
}

SalesByRegion = SUMMARIZE(Sales, Sales[Region], "TotalSales", SUM(Sales[Amount]))

{
  "connections": [
    {
      "name": "shared_office365",
      "id": "/providers/Microsoft.PowerApps/apis/shared_office365"
    },
    {
      "name": "shared_sql",
      "id": "/providers/Microsoft.PowerApps/apis/shared_sql"
    }
  ],
  "environment": {
    "name": "Production",
    "type": "Production",
    "region": "eastus"
  }
}

{
  "triggers": [
    {
      "type": "Schedule",
      "recurrence": {
        "frequency": "Hour",
        "interval": 1
      }
    }
  ],
  "actions": [
    {
      "type": "ApiConnection",
      "inputs": {
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataservice"
        },
        "parameters": {
          "tableName": "accounts",
          "filterQuery": "createdon ge @{addHours(utcNow(), -1)}"
        }
      }
    }
  ]
}

{
  "type": "Microsoft.PowerApps/apps",
  "properties": {
    "appVersion": "1.0.0",
    "createdBy": {
      "displayName": "John Doe"
    },
    "lastModifiedBy": {
      "displayName": "Jane Smith"
    },
    "connections": [
      {
        "name": "shared_commondataservice",
        "id": "/providers/Microsoft.PowerApps/apis/shared_commondataservice"
      }
    ]
  }
}

Refer to the exhibit.

{
  "name": "Data Loss Prevention Policy",
  "properties": {
    "blockedConnectors": [
      "Microsoft 365 Outlook",
      "SharePoint",
      "OneDrive for Business"
    ],
    "allowedConnectors": [
      "Dataverse",
      "SQL Server",
      "Salesforce"
    ]
  }
}

Refer to the exhibit.

```kusto
SalesSummary
| summarize TotalSales = sum(SalesAmount) by Region, ProductCategory
| where Region == "North America"
| order by TotalSales desc
```

Refer to the exhibit.

```json
{
  "scope": "environment",
  "action": "restrict",
  "subject": "*"
}```

Refer to the exhibit.

{
  "flows": [
    {
      "name": "Send approval email",
      "trigger": "When an item is created",
      "actions": [
        {
          "type": "Send an email (V2)",
          "inputs": {
            "to": "manager@contoso.com",
            "subject": "Approval needed",
            "body": "Please approve the new item."
          }
        },
        {
          "type": "Condition",
          "expression": "@equals(triggerOutputs()?['body/status'], 'Approved')",
          "actions": {
            "true": [
              {
                "type": "Update item",
                "inputs": {
                  "status": "Approved"
                }
              }
            ]
          }
        }
      ]
    }
  ]
}