Learn DYNAMICS-POWER-PLATFORM with Real Code Examples

Updated Nov 27, 2025

Introduction & Fundamentals Setup & Configuration Architecture & Deep Internals Performance & Security Development Workflow Learning & Career Growth Business & Strategy Examples

Code Sample Descriptions

Simple Canvas App Counter

Set(varCounter, 0);

// Button OnSelect
Set(varCounter, varCounter + 1);
UpdateContext({displayCounter: varCounter})

// Label Text
Text = displayCounter

Increment a counter and display it on a Canvas App screen using a button.

Let’s Try →

Patch Record to Dataverse Table

Patch(Accounts, LookUp(Accounts, AccountName="Contoso"), {Revenue: 1000000, Status: "Active"});

Update a specific record in a Dataverse table using the Patch function.

Let’s Try →

Filter Gallery by Text Input

Filter(Contacts, StartsWith(FullName, TextInput_Search.Text))

Filter a gallery dynamically based on user input in a TextInput control.

Let’s Try →

Send Email Using Power Automate Flow

PowerAutomateFlow.Run({To: "user@example.com", Subject: "Hello", Body: "Automated email from Power Platform."});

Trigger a flow to send an email when a button is clicked in Canvas App.

Let’s Try →

Create Record in Dataverse

Patch(Accounts, Defaults(Accounts), {AccountName: "New Account", Revenue: 50000, Status: "Prospect"});

Add a new account record to a Dataverse table using Patch.

Let’s Try →

Update Multiple Records

ForAll(Filter(Accounts, Status="Prospect"), Patch(Accounts, ThisRecord, {Status: "Active"}));

Update all accounts with a specific status.

Let’s Try →

Conditional Visibility of Controls

Button.Visible = Toggle_Show.Value

Show or hide a button based on a toggle switch.

Let’s Try →

Compute Total from Gallery Items

Sum(Gallery1.AllItems, Quantity * Price)

Sum a numeric column from a gallery's datasource.

Let’s Try →

Trigger Approval Flow

ApprovalFlow.Run({Requester: User().Email, Amount: TextInput_Amount.Text, Description: TextInput_Desc.Text});

Invoke an approval process using Power Automate flow from a Canvas App.

Let’s Try →

Patch with Lookup Value

Patch(Contacts, LookUp(Contacts, FullName="Alice"), {ParentAccount: LookUp(Accounts, AccountName="Contoso")});

Update a record with a lookup field value in Dataverse.

Let’s Try →

Code Sample Descriptions

Simple Canvas App Counter

Set(varCounter, 0);

// Button OnSelect
Set(varCounter, varCounter + 1);
UpdateContext({displayCounter: varCounter})

// Label Text
Text = displayCounter

Increment a counter and display it on a Canvas App screen using a button.

Let’s Try →

Patch Record to Dataverse Table

Patch(Accounts, LookUp(Accounts, AccountName="Contoso"), {Revenue: 1000000, Status: "Active"});

Update a specific record in a Dataverse table using the Patch function.

Let’s Try →

Filter Gallery by Text Input

Filter(Contacts, StartsWith(FullName, TextInput_Search.Text))

Filter a gallery dynamically based on user input in a TextInput control.

Let’s Try →

Send Email Using Power Automate Flow

PowerAutomateFlow.Run({To: "user@example.com", Subject: "Hello", Body: "Automated email from Power Platform."});

Trigger a flow to send an email when a button is clicked in Canvas App.

Let’s Try →

Create Record in Dataverse

Patch(Accounts, Defaults(Accounts), {AccountName: "New Account", Revenue: 50000, Status: "Prospect"});

Add a new account record to a Dataverse table using Patch.

Let’s Try →

Update Multiple Records

ForAll(Filter(Accounts, Status="Prospect"), Patch(Accounts, ThisRecord, {Status: "Active"}));

Update all accounts with a specific status.

Let’s Try →

Conditional Visibility of Controls

Button.Visible = Toggle_Show.Value

Show or hide a button based on a toggle switch.

Let’s Try →

Compute Total from Gallery Items

Sum(Gallery1.AllItems, Quantity * Price)

Sum a numeric column from a gallery's datasource.

Let’s Try →

Trigger Approval Flow

ApprovalFlow.Run({Requester: User().Email, Amount: TextInput_Amount.Text, Description: TextInput_Desc.Text});

Invoke an approval process using Power Automate flow from a Canvas App.

Let’s Try →

Patch with Lookup Value

Patch(Contacts, LookUp(Contacts, FullName="Alice"), {ParentAccount: LookUp(Accounts, AccountName="Contoso")});

Update a record with a lookup field value in Dataverse.

Let’s Try →