Power Up - Upskill Yourself...
❌

Reading view

Explore Dataverse Tools: FetchXML Formatter Online by Arun Potti – Usage

In my previous article, I had explained about Arun Potti’s FetchXML Formatter and in this article, will explain about how to use this Tool.

Requirement: Get all the Active Contacts created in the last 1 hour using JS, C# and Web API.

Solution:

Follow the below steps,

Step 1: Click on the below link to open the Arun Potti’s FetchXML formatter.

Arun Potti’s FetchXML Formatter

Step 2: Open the Advanced Find and Select the conditions as mentioned below.

Look for: Contacts

Conditions:

Created On – Last X Hours – 1
Status Equals Active

Step 3: Click on Download Fetch XML.

Step 4: Click on Open file.

Step 5: Select and copy the downloaded FetchXML.

FetchXML Code:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="contact">
<attribute name="fullname"/>
<attribute name="address1_composite"/>
<attribute name="mobilephone"/>
<attribute name="birthdate"/>
<attribute name="contactid"/>
<order attribute="fullname" descending="false"/>
<filter type="and">
<condition attribute="createdon" operator="last-x-hours" value="1"/>
<condition attribute="statecode" operator="eq" value="0"/>
</filter>
</entity>
</fetch>

Step 6: Paste the copied FetchXML in the FetchXML Input in the Arun Potti’s FetchXML formatter mentioned in the Step 1.

After the FetchXML input is provided, the tool automatically produces fully formatted JavaScript, C#, and Web API code snippets in the Generated Code section for the direct implementation.

Hope you have successfully downloaded the required FetchXML, provided the Input and saw all the outputs.

In the next article, will explain how to use them in real code JS, C# and Web API and get the desired results.

Please like and share your valuable feedback on this article. Also, follow my blog to get my articles to your Inbox.

Graphic promoting a YouTube channel with the text 'Has my blog post helped you?' and buttons for 'WATCH', 'LEARN', and 'SUBSCRIBE'.

Below are my earlier articles that you can have a look.

Streamline FetchXML with Online Formatter for Dataverse Tools

Fixing Postman Connection Issues: A Step-by-Step Guide

Explore Microsoft AB-Series Certification: Skills for AI Roles

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Usage)

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Installation)

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Overview)

Limited Time Offer: 50% Off Microsoft Certification Vouchers

How to send an automated email in Dataverse using Power Automate?

Understanding Activity Party Types in Dynamics 365 CE

How to configure donotreply email using Shared mailboxes in Dynamics 365 CE?

Microsoft Power Pages: The authentication key for your portal will expire

Microsoft Azure: You’re not eligible for an Azure free account

How to create Microsoft Azure 30 days trial?

Edit in Visual Studio Code for the Web in Power Apps Portals

Error: The object cannot be updated because it is read-only in Microsoft Power Apps

Resolved: Fix connections issue in Power Automate Flow

Clear all objects feature in Power Apps Solutions

Power Automate Error: The ‘inputs.parameters’ of workflow operation of type ‘OpenApiConnection’ is not valid.

Power Automate Error: To use FilteringAttributes, your trigger must include an Update event on Dataverse Trigger

Dynamics 365 CE Solution Import Failed in Azure DevOps Pipelines

Power Automate Error: Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600

Error while opening a Tool in XRMToolBox

The Power Automate Cloud Flows Best Practices Whitepaper is now LIVE!

Error in Power Automate: There’s a problem that needs to be fixed to trigger this flow. To see more details, open Flow checker.

How to get the Dataverse Table’s first row from List Rows in Power Automate?

Microsoft Dataverse Accelerator – Part 2 – Installation

Microsoft Dataverse Accelerator – Part 1 – Introduction

How to get the Database Version of the Dataverse?

API playground feature not available in Dataverse Accelerator App?

How to Explore and test Dataverse in the Web API playground (preview)?

Web resource method does not exist in Dynamics 365 CE

How to get Environment Variable Value in Dynamics 365 CE using JavaScript?

Model-driven Apps – openAlertDialog – JavaScript – Code Snippet

Power Automate – Flow is not running on Trigger condition

Power Automate – Input field Delete option is disabled

Recipient of type ‘Contact’ with ID is marked as non-emailable

Preferred Solution | New feature | Microsoft Dataverse

New and Retired Microsoft Dynamics 365 Certifications

Environment settings behavior (Preview) feature in Model-driven Apps

Error while connecting to Dataverse environment in XrmToolBox

Power Fx Formula Columns in Microsoft Power Apps

How to Enable 2024 Release Wave 1 Updates in the Microsoft Dynamics 365 CE Environment?

Delete and Restore records (Preview) feature in Microsoft Dataverse

Microsoft Power App Environments Retention Period

How to Override the Model-driven app header colors?

Timeline Highlights (New feature) in Microsoft Power Apps

Model-driven App – Cannot “See associate records” option in the sub grid (arunpotti.com)

Bookmark the Important Dynamics 365 URLs

How to Enable Tenant-level analytics for Power Automate and Power Apps?

Microsoft Power Automate Copy and Paste Action in New DesignerHow to Setup Multi-Factor Authentication for your Microsoft Power Apps environment?

Microsoft Power Apps | Modern Themes | Preview feature

How to Download and Install the .NET Framework?

How to Create a SharePoint Site Online?

How to add and use Copilot answer control (Preview) in Microsoft Power Apps?

Dark Mode in Microsoft Power Apps

How to create Microsoft 365 E3 Trial for 30 days?

Refreshed look of solution dependencies in Dataverse Solutions

Microsoft Power Automate | Version History | Restore | New Feature

MICROSOFT LEARN – Artificial Intelligence Skills Challenge​ 2024!!!

Resolved – ‘InvokerConnectionOverrideFailed’ Error When a Power App Custom Page call a Power Automate Flow

How to Create Microsoft Power Apps Trial 30 days?

Not able to Create Power Automate Flow in Custom Page in Model-Driven App?

How to Enable Inline Actions feature in Microsoft Canvas Apps?

How to use /mention in Outlook web client for Dataverse records?

Associate Activities Multiple Related Records (Preview) feature in Microsoft Dynamics 365 CE

How to Enable Aggregation (preview) feature in Microsoft Power Apps?

Power Apps – Some components of this app require you to sign in. If you don’t sign in, part of the app may not work.

How to Enable the SQL Server stored procedures (preview) feature in the Power Apps?

How to get the Client Version of the Model Driven Apps?

How to get Microsoft 365 E3 Trial for 30 days?

How to Enable Copilot for Model-Driven apps feature in Dynamics 365 CE Environment?

[Resolved] Web resource method does not exist in Dynamics 365 CE JavaScript Error

How to Enable Blocking unmanaged customizations (Preview) feature in Dynamics 365 CE?

How to create Microsoft Power Apps Developer Plan Environment?

Microsoft Power Apps Developer Plan vs Power Apps Trial 30 days

What is Microsoft Power Apps Developer Plan?

[Resolved] PCF Field Control not showing anything in the PCF Test Environment?

[Issue Resolved] ReferenceError: Web resource method does not exist in Dynamics 365 CE Javascript Error

[Issue Resolved] Subcomponent cannot be added to the solution because the root component Template is missing in Dataverse

How to Turn Off the Modern Look in the Model Driven Apps?

How to Turn on the New modern, refreshed look for the Model-Driven apps?

Microsoft Power Apps – Apps filter feature

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Microsoft Power Apps – Solutions filter Preview feature

How to Show the Power Automate complete Expressions?

Dataverse Error: Cannot start the requested operation [EntityCustomization] because there is another [PublishAll] running at this moment.

Power Automate Error: You should specify a contact or account.

How to get the Choice Text and Value in the Dataverse using JavaScript?

Microsoft Dataverse Low Code No Code Plugins

How to convert the Number String to Number Array?

How to Integrate Instant Plugins in the Power Automate Flow?

Power Apps – ‘actionname’ is an unknown or unsupported function in namespace ‘Environment’

Dataverse Browser V1.1.0.1 is available for Dataverse Plugin Debugging

How to Integrate Instant Plugins in the Canvas App?

How to Enable Access to Microsoft Dataverse Actions (Preview feature) in the Power Apps?

How to Create an Instant Plugin in the Dataverse Environment?

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

What is Microsoft Dataverse Accelerator?

How to get the Logged in User Information in the Power Apps?

How to Install Power Platform Tools in Visual Studio Code?

How to Install the Apps from the Microsoft AppSource to your Dataverse Environment?

Microsoft Power Apps Maker Portal has a new look

Microsoft Power Apps Emulator (New Feature)

How to Enable the Dataverse Offline (Experimental Feature) in the Canvas Apps?

How to set the Authoring Version in the Canvas App?

New version of Dataverse Browser is available for Dataverse Plugin Debugging

Latest Free Practice Assessments for Microsoft Certifications

Download CRM 365 V9.X Tools using PowerShell

How to set the Refresh cadence for a Power Platform Environment?

Update forms and views (Preview feature) in Dataverse

How to connect to Microsoft Dataverse in Power Automate Flow using Service principal?

How to Enable Copilot (Preview) feature in Canvas Apps?

How to Debug a Dataverse Plugin without Installing the Profiler in the Plugin Registration Tool?

How to Enable the Licenses (Preview) feature for a Power Platform Environment?

How to Enable Maker Welcome Content (preview) in Power Apps Maker Portal?

How to Enable Managed Environments for a Dataverse Environment?

How to Enable the Modern Controls (Preview feature) in the Canvas Apps?

How to Enable 2023 Release Wave 1 updates in the Dataverse Environment?

How to Deploy Enterprise Applications in the new Dataverse Environment?

What is Preview, Experimental and Retired features in Canvas Apps?

How to Enable the New Power Fx Formula Bar in Power Apps Studio?

Writing Power Fx formulas with natural language

Power Fx Formula Columns in Dataverse

Generating Power Fx formulas from examples

How to Create Dynamics 365 Marketing 30 Days Trial Version Online?

How to disable Multi-Factor Authentication (MFA) on Dynamics 365 Login?

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Explore Dataverse Tools: FetchXML Formatter Online by Arun Potti

Logo of Dataverse featuring a green circular design with the text 'Dataverse' in a modern font.

Working with FetchXML can sometimes get messy – especially when dealing with long, nested queries. To make this easier, I’ve created a new Online FetchXML Formatter. This tool automatically beautifies and structures your FetchXML, making it more readable and developer‑friendly.

This is a lightweight web tool for Dataverse / Dynamics 365 CE developers. It helps them format FetchXML and instantly generate ready-to-use JavaScript, C#, and Web API snippets. All of this is possible from a single FetchXML input.

Click on the below link to open the Tool.

Arun Potti’s FetchXML Formatter

Features:

Clear separation between input and the three outputs.

🔹 Single FetchXML input

Paste FetchXML in standard XRM / Dataverse format

Basic XML validation (parse + root <fetch> check)

🔹 Automatic formatting

Auto-beautifies FetchXML on input/change

Fixes indentation and line breaks for readability

🔹 Code generation

JavaScript snippet for Xrm.WebApi.retrieveMultipleRecords or Web API calls

C# verbatim string snippet for plugins, custom workflow activities, or console apps

Web API URL parameter (fetchXml) with URL-encoded FetchXML

🔹 Copy to clipboard

One-click Copy for:

  • JavaScript output
  • C# output
  • Web API output
  • Formatted FetchXML

🔹 Sample FetchXML

Insert a sample FetchXML query with one click to test the tool

🔹 Clean, responsive UI

Modern layout that works on desktop and mobile

In the next post, I’ll walk you through what the tool does. I will explain how it works.

Please like and share your valuable feedback on this article. Also, follow my blog to get my articles to your Inbox.

Graphic promoting a YouTube channel with the text 'Has my blog post helped you?' and buttons for 'WATCH', 'LEARN', and 'SUBSCRIBE'.

Below are my earlier articles that you can have a look.

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Usage)

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Installation)

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Overview)

Limited Time Offer: 50% Off Microsoft Certification Vouchers

How to send an automated email in Dataverse using Power Automate?

Understanding Activity Party Types in Dynamics 365 CE

How to configure donotreply email using Shared mailboxes in Dynamics 365 CE?

Microsoft Power Pages: The authentication key for your portal will expire

Microsoft Azure: You’re not eligible for an Azure free account

How to create Microsoft Azure 30 days trial?

Edit in Visual Studio Code for the Web in Power Apps Portals

Error: The object cannot be updated because it is read-only in Microsoft Power Apps

Resolved: Fix connections issue in Power Automate Flow

Clear all objects feature in Power Apps Solutions

Power Automate Error: The ‘inputs.parameters’ of workflow operation of type ‘OpenApiConnection’ is not valid.

Power Automate Error: To use FilteringAttributes, your trigger must include an Update event on Dataverse Trigger

Dynamics 365 CE Solution Import Failed in Azure DevOps Pipelines

Power Automate Error: Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600

Error while opening a Tool in XRMToolBox

The Power Automate Cloud Flows Best Practices Whitepaper is now LIVE!

Error in Power Automate: There’s a problem that needs to be fixed to trigger this flow. To see more details, open Flow checker.

How to get the Dataverse Table’s first row from List Rows in Power Automate?

Microsoft Dataverse Accelerator – Part 2 – Installation

Microsoft Dataverse Accelerator – Part 1 – Introduction

How to get the Database Version of the Dataverse?

API playground feature not available in Dataverse Accelerator App?

How to Explore and test Dataverse in the Web API playground (preview)?

Web resource method does not exist in Dynamics 365 CE

How to get Environment Variable Value in Dynamics 365 CE using JavaScript?

Model-driven Apps – openAlertDialog – JavaScript – Code Snippet

Power Automate – Flow is not running on Trigger condition

Power Automate – Input field Delete option is disabled

Recipient of type ‘Contact’ with ID is marked as non-emailable

Preferred Solution | New feature | Microsoft Dataverse

New and Retired Microsoft Dynamics 365 Certifications

Environment settings behavior (Preview) feature in Model-driven Apps

Error while connecting to Dataverse environment in XrmToolBox

Power Fx Formula Columns in Microsoft Power Apps

How to Enable 2024 Release Wave 1 Updates in the Microsoft Dynamics 365 CE Environment?

Delete and Restore records (Preview) feature in Microsoft Dataverse

Microsoft Power App Environments Retention Period

How to Override the Model-driven app header colors?

Timeline Highlights (New feature) in Microsoft Power Apps

Model-driven App – Cannot “See associate records” option in the sub grid (arunpotti.com)

Bookmark the Important Dynamics 365 URLs

How to Enable Tenant-level analytics for Power Automate and Power Apps?

Microsoft Power Automate Copy and Paste Action in New DesignerHow to Setup Multi-Factor Authentication for your Microsoft Power Apps environment?

Microsoft Power Apps | Modern Themes | Preview feature

How to Download and Install the .NET Framework?

How to Create a SharePoint Site Online?

How to add and use Copilot answer control (Preview) in Microsoft Power Apps?

Dark Mode in Microsoft Power Apps

How to create Microsoft 365 E3 Trial for 30 days?

Refreshed look of solution dependencies in Dataverse Solutions

Microsoft Power Automate | Version History | Restore | New Feature

MICROSOFT LEARN – Artificial Intelligence Skills Challenge​ 2024!!!

Resolved – ‘InvokerConnectionOverrideFailed’ Error When a Power App Custom Page call a Power Automate Flow

How to Create Microsoft Power Apps Trial 30 days?

Not able to Create Power Automate Flow in Custom Page in Model-Driven App?

How to Enable Inline Actions feature in Microsoft Canvas Apps?

How to use /mention in Outlook web client for Dataverse records?

Associate Activities Multiple Related Records (Preview) feature in Microsoft Dynamics 365 CE

How to Enable Aggregation (preview) feature in Microsoft Power Apps?

Power Apps – Some components of this app require you to sign in. If you don’t sign in, part of the app may not work.

How to Enable the SQL Server stored procedures (preview) feature in the Power Apps?

How to get the Client Version of the Model Driven Apps?

How to get Microsoft 365 E3 Trial for 30 days?

How to Enable Copilot for Model-Driven apps feature in Dynamics 365 CE Environment?

[Resolved] Web resource method does not exist in Dynamics 365 CE JavaScript Error

How to Enable Blocking unmanaged customizations (Preview) feature in Dynamics 365 CE?

How to create Microsoft Power Apps Developer Plan Environment?

Microsoft Power Apps Developer Plan vs Power Apps Trial 30 days

What is Microsoft Power Apps Developer Plan?

[Resolved] PCF Field Control not showing anything in the PCF Test Environment?

[Issue Resolved] ReferenceError: Web resource method does not exist in Dynamics 365 CE Javascript Error

[Issue Resolved] Subcomponent cannot be added to the solution because the root component Template is missing in Dataverse

How to Turn Off the Modern Look in the Model Driven Apps?

How to Turn on the New modern, refreshed look for the Model-Driven apps?

Microsoft Power Apps – Apps filter feature

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Microsoft Power Apps – Solutions filter Preview feature

How to Show the Power Automate complete Expressions?

Dataverse Error: Cannot start the requested operation [EntityCustomization] because there is another [PublishAll] running at this moment.

Power Automate Error: You should specify a contact or account.

How to get the Choice Text and Value in the Dataverse using JavaScript?

Microsoft Dataverse Low Code No Code Plugins

How to convert the Number String to Number Array?

How to Integrate Instant Plugins in the Power Automate Flow?

Power Apps – ‘actionname’ is an unknown or unsupported function in namespace ‘Environment’

Dataverse Browser V1.1.0.1 is available for Dataverse Plugin Debugging

How to Integrate Instant Plugins in the Canvas App?

How to Enable Access to Microsoft Dataverse Actions (Preview feature) in the Power Apps?

How to Create an Instant Plugin in the Dataverse Environment?

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

What is Microsoft Dataverse Accelerator?

How to get the Logged in User Information in the Power Apps?

How to Install Power Platform Tools in Visual Studio Code?

How to Install the Apps from the Microsoft AppSource to your Dataverse Environment?

Microsoft Power Apps Maker Portal has a new look

Microsoft Power Apps Emulator (New Feature)

How to Enable the Dataverse Offline (Experimental Feature) in the Canvas Apps?

How to set the Authoring Version in the Canvas App?

New version of Dataverse Browser is available for Dataverse Plugin Debugging

Latest Free Practice Assessments for Microsoft Certifications

Download CRM 365 V9.X Tools using PowerShell

How to set the Refresh cadence for a Power Platform Environment?

Update forms and views (Preview feature) in Dataverse

How to connect to Microsoft Dataverse in Power Automate Flow using Service principal?

How to Enable Copilot (Preview) feature in Canvas Apps?

How to Debug a Dataverse Plugin without Installing the Profiler in the Plugin Registration Tool?

How to Enable the Licenses (Preview) feature for a Power Platform Environment?

How to Enable Maker Welcome Content (preview) in Power Apps Maker Portal?

How to Enable Managed Environments for a Dataverse Environment?

How to Enable the Modern Controls (Preview feature) in the Canvas Apps?

How to Enable 2023 Release Wave 1 updates in the Dataverse Environment?

How to Deploy Enterprise Applications in the new Dataverse Environment?

What is Preview, Experimental and Retired features in Canvas Apps?

How to Enable the New Power Fx Formula Bar in Power Apps Studio?

Writing Power Fx formulas with natural language

Power Fx Formula Columns in Dataverse

Generating Power Fx formulas from examples

How to Create Dynamics 365 Marketing 30 Days Trial Version Online?

How to disable Multi-Factor Authentication (MFA) on Dynamics 365 Login?

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

How to restrict Unwanted Power Automate flow execution

Power Automate

In Microsoft Dataverse, Power Automate flows are commonly used to execute business logic when records are created, updated, or deleted. They work well for most user-driven and real-time business operations.

However, in certain scenarios such as integrations, background jobs, bulk data operations, or system maintenance tasks running these flows is not always required and can negatively impact performance or cause unintended automation triggers.

To address this, Microsoft provides a way to bypass Power Automate flow execution when performing operations through the Dataverse SDK. This allows developers to update or delete records without triggering associated flows, giving greater control over when automation should or should not run.

In this blog, we’ll explore when and why bypassing Power Automate flows makes sense, how it works at a technical level, and what to keep in mind before using it in production environments.

Why Bypass Power Automate Flows?

Bypassing flows is useful when the operation is system-driven and the flow logic is not needed.

Some common reasons include:

  • Avoiding unnecessary flow execution during background operations
  • Improving performance during bulk updates or migrations
  • Preventing flows from triggering repeatedly or causing loops
  • Keeping business automation separate from technical or maintenance logic

This approach ensures that Power Automate flows run only when they genuinely add business value, rather than during behind-the-scenes system updates.

Steps to Perform

For demonstration purposes, the logic is implemented using a desktop application. The objective is to clearly compare a standard update operation with one that bypasses Power Automate flow execution.

In both scenarios:

  • The same account record is updated
  • The only difference is whether the bypass flag is applied during the update request

Update Event Without Bypass

In this scenario, the record is updated using the standard SDK request without any bypass flag.

/// <summary>

/// Update the record Account record

/// </summary>

/// <param name="service"></param>

private static void UpdateRecord(CrmServiceClient service, string accountName, Guid accountId)

{

try

{

//Step 1: Get Record to update

Entity ent = new Entity("account", accountId);

#region Create Account name

ent["name"] = accountName;

#endregion

// Step 2: Update

service.Update(ent);

Console.WriteLine($"Record updated successfully. {DateTime.Now}");

}

catch (Exception ex)

{

SampleHelpers.HandleException(ex);

}
}

Restrict Unwanted Power Automate flow execution

Restrict Unwanted Power Automate flow execution

Observed behavior:

  • The update operation succeeds
  • The associated Power Automate flow is triggered
  • Any downstream logic defined in the flow executes as expected (for example, SharePoint operations, notifications, or validations)

This is the default and expected behavior when performing update operations through the SDK.

Update Event with Power Automate Flow Bypass

In this scenario, the same update operation is executed, but the request includes the bypass flag to skip Power Automate flow execution.

/// <summary>

/// Update the record Account record with bypass logic

/// </summary>

/// <param name="service"></param>

private static void UpdateRecordWithBypass(CrmServiceClient service, string accountName, Guid accountId)

{

try

{

//Step 1: Get Record to update

Entity ent = new Entity("account", accountId);

#region Create entity record object

ent["name"] = accountName;

#endregion

// Step 2: Create delete request

var updateRequest = new UpdateRequest

{

Target = ent

};

// Step 3: Bypass Power Automate flows

updateRequest.Parameters.Add("SuppressCallbackRegistrationExpanderJob", true);

// Step 4: Execute

service.Execute(updateRequest);

Console.WriteLine($"Record updated with bypass successfully. {DateTime.Now}");

}

catch (Exception ex)

{

SampleHelpers.HandleException(ex);

}
}

Restrict Unwanted Power Automate flow execution

Restrict Unwanted Power Automate flow execution

Observed behavior:

  • The record is updated successfully.
  • Power Automate flow does not execute.
  • No SharePoint or automation logic tied to the flow is triggered.

This allows the system to perform controlled updates without affecting existing automation logic.

Conclusion

Bypassing Power Automate flows in Microsoft Dataverse is a powerful capability designed for advanced scenarios, such as:

  • System integrations
  • Maintenance or cleanup jobs
  • Bulk updates and data migrations

When used appropriately, it helps improve performance, avoid unnecessary automation, and maintain clean separation between business logic and technical processes.

However, this feature should be applied carefully and intentionally. Overusing it can lead to missed automation or inconsistent system behavior. When used in the right context, it results in cleaner implementations and more predictable outcomes.

The post How to restrict Unwanted Power Automate flow execution first appeared on Microsoft Dynamics 365 CRM Tips and Tricks.

Building Standalone Apps with Power Apps Code Apps: Using Dataverse and Office 365 Users Connectors (Part 1)

Power Apps

In the Dynamics 365 and Power Apps ecosystem, we have several options for building applications, each one is for a specific type of requirement. Model-driven Apps works well when we need a structured UI with standard components, while we use Canvas Apps to create custom, mobile-friendly interfaces with a low-code approach. Recently, Microsoft introduced another application type called Code Apps, which offers a completely different way to build applications using pro code approach.

With the introduction of  Power Apps Code Apps, things have changed. Code Apps let us build standalone single page applications using modern web frameworks. These are independent applications that cannot be integrated with Canvas Apps or Model-driven Apps.

The best part is that we get direct access to more than 1,500 standard and premium connectors through the Power Apps SDK. We do not have to write any authentication code, no OAuth flows, no custom APIs, no middleware. We just have to connect and use.

In this article, we’ll walk you through creating a Code App from scratch. We’ll build Personal Dashboard, a simple application that pulls assigned cases and leads from Dataverse and shows current logged in user details using the Office 365 Users and Dataverse connectors.

What Makes Code Apps Different?

We can build a UI of our own choice and connect to a wide range of data sources using more than 1,500 standard and premium connectors provided by the Power Platform. All connections are secure because the Power Apps SDK handles authentication, and each connector enforces user-level permissions. This means the app can only access data that the signed-in user is allowed to see, so there’s no need to write custom authentication code.

Code Apps provide a balanced approach with several key advantages:

  • A standalone application that runs directly within Power Platform
  • Full development with modern web frameworks such as React, Vue, or Angular, with support for  your preferred libraries
  • Direct access to connectors through the Power Apps SDK without custom authentication code
  • Streamlined deployment through a single command to your environment

The connector integration is particularly valuable. Whether the need is to query Dataverse, access current user profile details, or use other services, the connector can be called directly. There’s no need to configure service principals, manage app registrations, or implement token management. The integration works seamlessly within the platform.

Prerequisites

Before getting started, we have to make sure the following prerequisites are in place:

  • Power Apps Premium license with Code Apps enabled environment
  • Visual Studio Code installed
  • Node.js LTS version
  • Power Platform Tools for VS Code extension

Step 1: Setting Up the Code App

Let’s create the app. Open VS Code, launch a PowerShell terminal, and run the following command:

npm create vite@latest PersonalDashboard — –template react-ts

For this application, we are using React as the framework and TypeScript as the variant. After that, navigate to the project folder and install the dependencies:

npm install

Install the node type definitions:

npm i –save-dev @types/node

After executing these commands, the project structure will appear as shown in the image below.

PowerAppsCode

According to the official Microsoft documentation, the Power Apps SDK currently requires the port to be 3000 in the default configuration. To configure this, open vite.config.ts and replace the content with the following code:

import { defineConfig } from 'vite'

import react from '@vitejs/plugin-react'

import * as path from 'path'

 

// https://vite.dev/config/

export default defineConfig({

base: "./",

server: {

host: "::",

port: 3000,

},

plugins: [react()],

resolve: {

alias: {

"@": path.resolve(__dirname, "./src"),

},

},

});

Note for Mac users: It may be necessary to modify the package.json scripts section.

Change from:

"scripts":  {

"dev": "start vite && start pac code run",

"build": "tsc -b && vite build",

"lint": "eslint .",

"preview": "vite preview"

}

to this

"scripts": {
"dev": "vite && pac code run",
"build": "tsc -b && vite build",
"lint": "eslint .",
"preview": "vite preview"
}

Save the file and run the Code App locally by executing:

npm run dev

Browse to http://localhost:3000. If the application loads successfully, press Ctrl+C to stop the server.

Step 2: Initialize the Code App

First authenticate to Power Platform:

pac auth create

After that, sign in with the credentials and select the environment:

pac env select -env <environment-url>

Initialize the Code App:

pac code init –displayName “Personal Dashboard”

This will create a power.config.json file in the project as shown in the image below.

PowerAppsCode

Now install the Power Apps SDK. This package provides APIs that allow the application to interact directly with Power Platform services and includes built-in logic to manage connections automatically as they are added or removed.

npm install –save-dev “@microsoft/power-apps

Update package.json to run both Vite and the Power Apps SDK server:

"scripts": {
"dev": "start pac code run && vite",
"build": "tsc -b && vite build",
"lint": "eslint .",
"preview": "vite preview"
}

Step 3: Configure Power Provider

 

Create PowerProvider.tsx under src and add the Power SDK context provider code given below.

 

import { initialize } from "@microsoft/power-apps/app";

import { useEffect, type ReactNode } from "react";

interface PowerProviderProps {

children: ReactNode;

}

export default function PowerProvider({ children }: PowerProviderProps) {

useEffect(() => {

const initApp = async () => {

try {

await initialize();

console.log('Power Platform SDK initialized successfully');

} catch (error) {

console.error('Failed to initialize Power Platform SDK:', error);

}

};

initApp();

}, []);

return <>{children}</>;

}

Update the main.tsx and add this line in the imports section:

import PowerProvider from './PowerProvider.tsx'

and change this code snippet

<StrictMode>
<App />
</StrictMode>,

to this

<StrictMode>

<PowerProvider>

<App />

</PowerProvider>

</StrictMode>,

Run the app by executing :

npm run dev

Open the URL provided by the Power SDK Server in the same browser profile as that of power platform tenant.

Step 4: Adding Dataverse Connector

Now comes the part where we will add the data source to our application. In this step, we’ll use the Dataverse connector to fetch assigned cases and leads for the logged-in user.

For that First, we need to create a connection:

1. Go to Power Apps and open Connections.

2. Click New Connection and select Dataverse.

Follow the instruction properly to create the connection, as shown in the

PowerAppsCode

Once the connection is ready, we have to open the terminal. For Dataverse, we have to add the tables required for the application. For this example, we’ll add the Leads and Incident (Cases) tables using the following commands:

pac code add-data-source -a dataverse -t lead

pac code add-data-source -a dataverse -t incident

PowerAppsCode

After running these commands, we can see that some files and folders are added to the project. Inside the generated folder, there are services and models folders. These contain the files for Leads, Incidents, and other tables, which can be used in the code. For example:

import { AccountsService } from './generated/services/AccountsService';

Import type { Accounts } from './generated/models/AccountsModel';

CRUD operations can be performed on Dataverse using the app. Before accessing any data, we have to initialize the Power Apps SDK to avoid errors. An async function or state check can ensure the SDK is ready before making API calls. For example:

useEffect(() => {

// Define a function of asynchronous type to properly initialize the Power Apps SDK to avoid any error during runtime

 

const init = async () => {

try {

await initialize(); // Wait for SDK initialization

setIsInitialized(true); // Mark the app as ready for data operations

} catch (err) {

setError('Failed to initialize Power Apps SDK'); // Handle initialization errors

setLoading(false); // Stop any loading indicators

}

};

 

init(); // Call the initialization function when the component mounts

}, []);

 

useEffect(() => {

If (!isInitialized) return;

 

// Place your data reading logic here

}, []);


 

Step 5: Adding Office 365 Users Connector

Similar to Dataverse, we need to create a connection for Office 365 Users by following the same steps. Once the connection is ready, we need to add it to the application. First, list all available connections to get the connection ID using command:

pac connection list

It will list all the connections available in the selected environment. We need to Copy the connection ID for Office 365 Users from the list, then add it to the project using:

pac code add-data-source -a “shared_office365users” -c “<connection-id>”

After running this command, the Office 365 Users connector will be available to use in the application, allowing access to user profiles, and other Office 365 user data.


Step 6: Building the UI

There are two ways to build a good UI. The first is the traditional coding approach where we write the complete code manually. The second is by using GitHub Copilot integrated in VS Code with the help of prompts.

Using GitHub Copilot:

We can generate the UI by writing a detailed prompt in GitHub Copilot. Here’s an example prompt:

Create a Personal Dashboard UI component in React with TypeScript that displays:

  1. A header section showing the current logged-in user’s profile information (name, email, job title, and profile photo) fetched from Office 365 Users connector
  2. Two main sections side by side:

– Left section: Display a list of assigned Cases (Incidents) from Dataverse

* Show case title, case number, priority, status, and created date

* Use card layout for each case

* Add loading state and error handling

– Right section: Display a list of assigned Leads from Dataverse

* Show lead name, company, topic, status, and created date

* Use card layout for each lead

* Add loading state and error handling

  1. Use modern, clean UI design with:

– Responsive layout (works on desktop and mobile)

– Tailwind CSS for styling

– Professional color scheme (blues and grays)

– Proper spacing and typography

– Loading spinners while data is fetching

– Error messages if data fails to load

After providing this prompt to GitHub Copilot, it will generate the complete component code. We can then review the generated code, make any necessary adjustments, and integrate it into our application.

Step 7: Deploy Your Code App

Once the code is complete and the app is running locally, the next step is to deploy the application. For Code Apps, deployment is straightforward. First, build the application by running:

npm run build

After a successful build, execute the following command to push the application to Power Apps:

pac code push

This command will deploy the application to Power Apps. To verify the deployment, go to the Power Apps portal and open the Apps section. The newly deployed Code App will be visible in the list as shown in the image below.

PowerAppsCode

To run the app, click the play button. On the first launch, the application will prompt for permission to access the connected data sources. After allowing the permissions, the application will use those connection references for all subsequent operations.

PowerAppsCode

 

PowerAppsCode

Conclusion

With Power Apps Code Apps, we can now build standalone applications. The real advantage here is the direct access to over 1,500 connectors through the Power Apps SDK. We can connect to Dataverse, Office 365 Users, and other services without writing any authentication code. The Power Apps SDK handles all the security, and each connector respects user level permissions automatically.

We also get complete freedom to design our own UI using any libraries we prefer. The deployment process is simple. Just run the build command and push it to Power Platform with a single command.

In this article, we built a Personal Dashboard that pulls data from Dataverse and Office 365 Users. The same approach works for any application that needs to connect with Power Platform services. The setup is straightforward, and once the project is initialized, adding new data sources is just a matter of running a few commands.

Code Apps provide a practical way to build custom applications within the Power Platform ecosystem while maintaining secure connections and proper access control.

Frequently Asked Questions (FAQs)

What are Power Apps Code Apps?

Power Apps Code Apps are a new application type in Microsoft Power Platform that allow developers to build standalone single-page applications using modern web frameworks such as React, Angular, or Vue. They provide direct access to Power Platform connectors through the Power Apps SDK without requiring custom authentication code.

How are Code Apps different from Canvas Apps and Model-Driven Apps?

Unlike Canvas Apps and Model-Driven Apps, Code Apps:

  • Are fully standalone applications
  • Use a pro-code development approach
  • Allow complete control over UI and application architecture
  • Cannot be embedded into Canvas or Model-Driven Apps
  • Use modern frontend frameworks instead of low-code designers

Do Power Apps Code Apps require authentication setup?

No. Authentication is handled automatically by the Power Apps SDK. Developers do not need to implement OAuth flows, manage tokens, or configure app registrations. All connectors enforce user-level permissions by default.

Can Power Apps Code Apps connect to Dataverse?

Yes. Power Apps Code Apps can connect directly to Dataverse using the Dataverse connector. Developers can perform CRUD operations on Dataverse tables, such as Leads and Incidents once the SDK is initialized.

How do Code Apps access Office 365 user information?

Code Apps use the Office 365 Users connector to retrieve profile details such as name, email, job title, and profile photo. The connector respects the signed-in user’s permissions automatically.

The post Building Standalone Apps with Power Apps Code Apps: Using Dataverse and Office 365 Users Connectors (Part 1) first appeared on Microsoft Dynamics 365 CRM Tips and Tricks.

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles

Logos featuring a stylized letter 'D' in blue and a wrench icon next to a blue and red graphic element.

I recently released my first XRMToolBox plugin, “Dataverse Users, Security Roles, Teams and Teams Security Roles,” designed to help administrators, developers, and auditors easily explore detailed user access data within Microsoft Dataverse environments.

You can check the below articles in order for more details.

Hope you liked my new XrmToolBox tool “Dataverse Users, Security roles, Teams and Teams security roles“.

Please like and share your valuable feedback on this article. Also, follow my blog to get my articles to your Inbox.

Click on the below image to navigate to my YouTube Channel.

Graphic promoting a YouTube channel with the text 'Has my blog post helped you?' and buttons for 'WATCH', 'LEARN', and 'SUBSCRIBE'.

Below are my earlier articles that you can have a look.

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Usage)

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Installation)

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Overview)

Limited Time Offer: 50% Off Microsoft Certification Vouchers

How to send an automated email in Dataverse using Power Automate?

Understanding Activity Party Types in Dynamics 365 CE

How to configure donotreply email using Shared mailboxes in Dynamics 365 CE?

Microsoft Power Pages: The authentication key for your portal will expire

Microsoft Azure: You’re not eligible for an Azure free account

How to create Microsoft Azure 30 days trial?

Edit in Visual Studio Code for the Web in Power Apps Portals

Error: The object cannot be updated because it is read-only in Microsoft Power Apps

Resolved: Fix connections issue in Power Automate Flow

Clear all objects feature in Power Apps Solutions

Power Automate Error: The ‘inputs.parameters’ of workflow operation of type ‘OpenApiConnection’ is not valid.

Power Automate Error: To use FilteringAttributes, your trigger must include an Update event on Dataverse Trigger

Dynamics 365 CE Solution Import Failed in Azure DevOps Pipelines

Power Automate Error: Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600

Error while opening a Tool in XRMToolBox

The Power Automate Cloud Flows Best Practices Whitepaper is now LIVE!

Error in Power Automate: There’s a problem that needs to be fixed to trigger this flow. To see more details, open Flow checker.

How to get the Dataverse Table’s first row from List Rows in Power Automate?

Microsoft Dataverse Accelerator – Part 2 – Installation

Microsoft Dataverse Accelerator – Part 1 – Introduction

How to get the Database Version of the Dataverse?

API playground feature not available in Dataverse Accelerator App?

How to Explore and test Dataverse in the Web API playground (preview)?

Web resource method does not exist in Dynamics 365 CE

How to get Environment Variable Value in Dynamics 365 CE using JavaScript?

Model-driven Apps – openAlertDialog – JavaScript – Code Snippet

Power Automate – Flow is not running on Trigger condition

Power Automate – Input field Delete option is disabled

Recipient of type ‘Contact’ with ID is marked as non-emailable

Preferred Solution | New feature | Microsoft Dataverse

New and Retired Microsoft Dynamics 365 Certifications

Environment settings behavior (Preview) feature in Model-driven Apps

Error while connecting to Dataverse environment in XrmToolBox

Power Fx Formula Columns in Microsoft Power Apps

How to Enable 2024 Release Wave 1 Updates in the Microsoft Dynamics 365 CE Environment?

Delete and Restore records (Preview) feature in Microsoft Dataverse

Microsoft Power App Environments Retention Period

How to Override the Model-driven app header colors?

Timeline Highlights (New feature) in Microsoft Power Apps

Model-driven App – Cannot “See associate records” option in the sub grid (arunpotti.com)

Bookmark the Important Dynamics 365 URLs

How to Enable Tenant-level analytics for Power Automate and Power Apps?

Microsoft Power Automate Copy and Paste Action in New DesignerHow to Setup Multi-Factor Authentication for your Microsoft Power Apps environment?

Microsoft Power Apps | Modern Themes | Preview feature

How to Download and Install the .NET Framework?

How to Create a SharePoint Site Online?

How to add and use Copilot answer control (Preview) in Microsoft Power Apps?

Dark Mode in Microsoft Power Apps

How to create Microsoft 365 E3 Trial for 30 days?

Refreshed look of solution dependencies in Dataverse Solutions

Microsoft Power Automate | Version History | Restore | New Feature

MICROSOFT LEARN – Artificial Intelligence Skills Challenge​ 2024!!!

Resolved – ‘InvokerConnectionOverrideFailed’ Error When a Power App Custom Page call a Power Automate Flow

How to Create Microsoft Power Apps Trial 30 days?

Not able to Create Power Automate Flow in Custom Page in Model-Driven App?

How to Enable Inline Actions feature in Microsoft Canvas Apps?

How to use /mention in Outlook web client for Dataverse records?

Associate Activities Multiple Related Records (Preview) feature in Microsoft Dynamics 365 CE

How to Enable Aggregation (preview) feature in Microsoft Power Apps?

Power Apps – Some components of this app require you to sign in. If you don’t sign in, part of the app may not work.

How to Enable the SQL Server stored procedures (preview) feature in the Power Apps?

How to get the Client Version of the Model Driven Apps?

How to get Microsoft 365 E3 Trial for 30 days?

How to Enable Copilot for Model-Driven apps feature in Dynamics 365 CE Environment?

[Resolved] Web resource method does not exist in Dynamics 365 CE JavaScript Error

How to Enable Blocking unmanaged customizations (Preview) feature in Dynamics 365 CE?

How to create Microsoft Power Apps Developer Plan Environment?

Microsoft Power Apps Developer Plan vs Power Apps Trial 30 days

What is Microsoft Power Apps Developer Plan?

[Resolved] PCF Field Control not showing anything in the PCF Test Environment?

[Issue Resolved] ReferenceError: Web resource method does not exist in Dynamics 365 CE Javascript Error

[Issue Resolved] Subcomponent cannot be added to the solution because the root component Template is missing in Dataverse

How to Turn Off the Modern Look in the Model Driven Apps?

How to Turn on the New modern, refreshed look for the Model-Driven apps?

Microsoft Power Apps – Apps filter feature

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Microsoft Power Apps – Solutions filter Preview feature

How to Show the Power Automate complete Expressions?

Dataverse Error: Cannot start the requested operation [EntityCustomization] because there is another [PublishAll] running at this moment.

Power Automate Error: You should specify a contact or account.

How to get the Choice Text and Value in the Dataverse using JavaScript?

Microsoft Dataverse Low Code No Code Plugins

How to convert the Number String to Number Array?

How to Integrate Instant Plugins in the Power Automate Flow?

Power Apps – ‘actionname’ is an unknown or unsupported function in namespace ‘Environment’

Dataverse Browser V1.1.0.1 is available for Dataverse Plugin Debugging

How to Integrate Instant Plugins in the Canvas App?

How to Enable Access to Microsoft Dataverse Actions (Preview feature) in the Power Apps?

How to Create an Instant Plugin in the Dataverse Environment?

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

What is Microsoft Dataverse Accelerator?

How to get the Logged in User Information in the Power Apps?

How to Install Power Platform Tools in Visual Studio Code?

How to Install the Apps from the Microsoft AppSource to your Dataverse Environment?

Microsoft Power Apps Maker Portal has a new look

Microsoft Power Apps Emulator (New Feature)

How to Enable the Dataverse Offline (Experimental Feature) in the Canvas Apps?

How to set the Authoring Version in the Canvas App?

New version of Dataverse Browser is available for Dataverse Plugin Debugging

Latest Free Practice Assessments for Microsoft Certifications

Download CRM 365 V9.X Tools using PowerShell

How to set the Refresh cadence for a Power Platform Environment?

Update forms and views (Preview feature) in Dataverse

How to connect to Microsoft Dataverse in Power Automate Flow using Service principal?

How to Enable Copilot (Preview) feature in Canvas Apps?

How to Debug a Dataverse Plugin without Installing the Profiler in the Plugin Registration Tool?

How to Enable the Licenses (Preview) feature for a Power Platform Environment?

How to Enable Maker Welcome Content (preview) in Power Apps Maker Portal?

How to Enable Managed Environments for a Dataverse Environment?

How to Enable the Modern Controls (Preview feature) in the Canvas Apps?

How to Enable 2023 Release Wave 1 updates in the Dataverse Environment?

How to Deploy Enterprise Applications in the new Dataverse Environment?

What is Preview, Experimental and Retired features in Canvas Apps?

How to Enable the New Power Fx Formula Bar in Power Apps Studio?

Writing Power Fx formulas with natural language

Power Fx Formula Columns in Dataverse

Generating Power Fx formulas from examples

How to Create Dynamics 365 Marketing 30 Days Trial Version Online?

How to disable Multi-Factor Authentication (MFA) on Dynamics 365 Login?

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Usage)

Logos of two software tools: a blue and purple graphic featuring a stylized 'D' and a red, white, and blue logo with a wrench symbol.

In my previous articles, I introduced my plugin tool, “Dataverse Users, Security Roles, Teams, and Team Security Roles“ and explained how to install it using XrmToolBox. In this article, I’ll Walk you through how to use the tool effectively.

Follow the below steps.

Step 1: Open XrmToolBox and search for “Dataverse Users, Security roles, Teams and Teams security roles” in Tools tab.

Click on it.

Screenshot of XrmToolBox interface showing the search bar and the plugin tool 'Dataverse Users, Security roles, Teams and Teams security roles'.

Step 2: Click on Yes to connect to an organization.

Screenshot of the XrmToolBox interface displaying the tool 'Dataverse Users, Security roles, Teams and Teams security roles' with an option to connect to an organization.

Step 3: Select the required connection and click on OK.

Screenshot of the XrmToolBox interface showing the 'Dataverse Users, Security roles, Teams and Teams security roles' tool with a dialog box for selecting connections.

Tool has been opened successfully.

Screenshot of XrmToolBox interface showing the 'Dataverse Users, Security roles' tool with a gray background and zero users retrieved.

Step 4: Click on Load Data.

Screenshot of the XrmToolBox interface showcasing the 'Dataverse Users, Security Roles, Teams' tool, with options to close, load data, and search, displaying zero users retrieved.

Tool will start retrieving all the System user details, Security roles (separated by semicolon ;), Teams (separated by semicolon 😉 and Team Security Roles (separated by semicolon ;).

XrmToolBox interface displaying the Dataverse Users, Security Roles tool, with a loading message indicating retrieval of system user details.

Once, the Tool retrieves the data, you can see the data in the grid and also can see the number of users retrieved.

Screenshot of XrmToolBox displaying user details and security roles for a Dataverse connector, showing fields such as Azure AD Object ID, Full Name, User Status, and User Security Roles.

Step 5: Search for some text to filter the data.

As an example, I have entered the text “System Administrator“, and you can see the grid filtered with the entered text and can see the updated count as well.

Screenshot of the XrmToolBox displaying user data, including user details, security roles, and teams, with a total of 85 users retrieved.

If you want to sort, click on any column in the grid to sort ascending or descending.

As an example, I have clicked on Full Name to sort in Ascending order.

Screenshot of the XrmToolBox displaying a grid of user details including User ID, Application ID, Azure AD Object ID, Domain Name, Business Unit Name, Primary Email, User Status, Access Mode, User Security Roles, and User Teams.

Step 6: Click on Export to export the data in CSV format.

Note: Data will be exported to the CSV format only on the filtered data, which you can see on this grid.

Screenshot of XrmToolBox showing a grid with user details, including User ID, Application ID, Full Name, and Security Roles. Option buttons for Load Data and Export are visible at the top.

Step 7: Choose the required path and Provide the File name.

Click on Save.

User interface showing the file save dialog for exporting data to CSV in XrmToolBox.

Step 8: Once the data is exported successfully, you can see the Information message and the alert dialog with the Path, the file is downloaded.

Click on OK.

Screenshot showing a data export success message in XrmToolBox, indicating the export of user data to a specific file path with a grid of user information displayed.

Step 9: Go to the Downloads folder and open the file to see the data.

Screenshot of an Excel spreadsheet showing exported user and security role data, including columns for User ID, Full Name, and User Status.

Hope you liked my new XrmToolBox tool “Dataverse Users, Security roles, Teams and Teams security roles“.

Please like and share your valuable feedback on this article. Also, follow my blog to get my articles to your Inbox.

Click on the below image to navigate to my YouTube Channel.

Graphic promoting a YouTube channel with the text 'Has my blog post helped you?' and buttons for 'WATCH', 'LEARN', and 'SUBSCRIBE'.

Below are my earlier articles that you can have a look.

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Installation)

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Overview)

Limited Time Offer: 50% Off Microsoft Certification Vouchers

How to send an automated email in Dataverse using Power Automate?

Understanding Activity Party Types in Dynamics 365 CE

How to configure donotreply email using Shared mailboxes in Dynamics 365 CE?

Microsoft Power Pages: The authentication key for your portal will expire

Microsoft Azure: You’re not eligible for an Azure free account

How to create Microsoft Azure 30 days trial?

Edit in Visual Studio Code for the Web in Power Apps Portals

Error: The object cannot be updated because it is read-only in Microsoft Power Apps

Resolved: Fix connections issue in Power Automate Flow

Clear all objects feature in Power Apps Solutions

Power Automate Error: The ‘inputs.parameters’ of workflow operation of type ‘OpenApiConnection’ is not valid.

Power Automate Error: To use FilteringAttributes, your trigger must include an Update event on Dataverse Trigger

Dynamics 365 CE Solution Import Failed in Azure DevOps Pipelines

Power Automate Error: Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600

Error while opening a Tool in XRMToolBox

The Power Automate Cloud Flows Best Practices Whitepaper is now LIVE!

Error in Power Automate: There’s a problem that needs to be fixed to trigger this flow. To see more details, open Flow checker.

How to get the Dataverse Table’s first row from List Rows in Power Automate?

Microsoft Dataverse Accelerator – Part 2 – Installation

Microsoft Dataverse Accelerator – Part 1 – Introduction

How to get the Database Version of the Dataverse?

API playground feature not available in Dataverse Accelerator App?

How to Explore and test Dataverse in the Web API playground (preview)?

Web resource method does not exist in Dynamics 365 CE

How to get Environment Variable Value in Dynamics 365 CE using JavaScript?

Model-driven Apps – openAlertDialog – JavaScript – Code Snippet

Power Automate – Flow is not running on Trigger condition

Power Automate – Input field Delete option is disabled

Recipient of type ‘Contact’ with ID is marked as non-emailable

Preferred Solution | New feature | Microsoft Dataverse

New and Retired Microsoft Dynamics 365 Certifications

Environment settings behavior (Preview) feature in Model-driven Apps

Error while connecting to Dataverse environment in XrmToolBox

Power Fx Formula Columns in Microsoft Power Apps

How to Enable 2024 Release Wave 1 Updates in the Microsoft Dynamics 365 CE Environment?

Delete and Restore records (Preview) feature in Microsoft Dataverse

Microsoft Power App Environments Retention Period

How to Override the Model-driven app header colors?

Timeline Highlights (New feature) in Microsoft Power Apps

Model-driven App – Cannot “See associate records” option in the sub grid (arunpotti.com)

Bookmark the Important Dynamics 365 URLs

How to Enable Tenant-level analytics for Power Automate and Power Apps?

Microsoft Power Automate Copy and Paste Action in New DesignerHow to Setup Multi-Factor Authentication for your Microsoft Power Apps environment?

Microsoft Power Apps | Modern Themes | Preview feature

How to Download and Install the .NET Framework?

How to Create a SharePoint Site Online?

How to add and use Copilot answer control (Preview) in Microsoft Power Apps?

Dark Mode in Microsoft Power Apps

How to create Microsoft 365 E3 Trial for 30 days?

Refreshed look of solution dependencies in Dataverse Solutions

Microsoft Power Automate | Version History | Restore | New Feature

MICROSOFT LEARN – Artificial Intelligence Skills Challenge​ 2024!!!

Resolved – ‘InvokerConnectionOverrideFailed’ Error When a Power App Custom Page call a Power Automate Flow

How to Create Microsoft Power Apps Trial 30 days?

Not able to Create Power Automate Flow in Custom Page in Model-Driven App?

How to Enable Inline Actions feature in Microsoft Canvas Apps?

How to use /mention in Outlook web client for Dataverse records?

Associate Activities Multiple Related Records (Preview) feature in Microsoft Dynamics 365 CE

How to Enable Aggregation (preview) feature in Microsoft Power Apps?

Power Apps – Some components of this app require you to sign in. If you don’t sign in, part of the app may not work.

How to Enable the SQL Server stored procedures (preview) feature in the Power Apps?

How to get the Client Version of the Model Driven Apps?

How to get Microsoft 365 E3 Trial for 30 days?

How to Enable Copilot for Model-Driven apps feature in Dynamics 365 CE Environment?

[Resolved] Web resource method does not exist in Dynamics 365 CE JavaScript Error

How to Enable Blocking unmanaged customizations (Preview) feature in Dynamics 365 CE?

How to create Microsoft Power Apps Developer Plan Environment?

Microsoft Power Apps Developer Plan vs Power Apps Trial 30 days

What is Microsoft Power Apps Developer Plan?

[Resolved] PCF Field Control not showing anything in the PCF Test Environment?

[Issue Resolved] ReferenceError: Web resource method does not exist in Dynamics 365 CE Javascript Error

[Issue Resolved] Subcomponent cannot be added to the solution because the root component Template is missing in Dataverse

How to Turn Off the Modern Look in the Model Driven Apps?

How to Turn on the New modern, refreshed look for the Model-Driven apps?

Microsoft Power Apps – Apps filter feature

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Microsoft Power Apps – Solutions filter Preview feature

How to Show the Power Automate complete Expressions?

Dataverse Error: Cannot start the requested operation [EntityCustomization] because there is another [PublishAll] running at this moment.

Power Automate Error: You should specify a contact or account.

How to get the Choice Text and Value in the Dataverse using JavaScript?

Microsoft Dataverse Low Code No Code Plugins

How to convert the Number String to Number Array?

How to Integrate Instant Plugins in the Power Automate Flow?

Power Apps – ‘actionname’ is an unknown or unsupported function in namespace ‘Environment’

Dataverse Browser V1.1.0.1 is available for Dataverse Plugin Debugging

How to Integrate Instant Plugins in the Canvas App?

How to Enable Access to Microsoft Dataverse Actions (Preview feature) in the Power Apps?

How to Create an Instant Plugin in the Dataverse Environment?

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

What is Microsoft Dataverse Accelerator?

How to get the Logged in User Information in the Power Apps?

How to Install Power Platform Tools in Visual Studio Code?

How to Install the Apps from the Microsoft AppSource to your Dataverse Environment?

Microsoft Power Apps Maker Portal has a new look

Microsoft Power Apps Emulator (New Feature)

How to Enable the Dataverse Offline (Experimental Feature) in the Canvas Apps?

How to set the Authoring Version in the Canvas App?

New version of Dataverse Browser is available for Dataverse Plugin Debugging

Latest Free Practice Assessments for Microsoft Certifications

Download CRM 365 V9.X Tools using PowerShell

How to set the Refresh cadence for a Power Platform Environment?

Update forms and views (Preview feature) in Dataverse

How to connect to Microsoft Dataverse in Power Automate Flow using Service principal?

How to Enable Copilot (Preview) feature in Canvas Apps?

How to Debug a Dataverse Plugin without Installing the Profiler in the Plugin Registration Tool?

How to Enable the Licenses (Preview) feature for a Power Platform Environment?

How to Enable Maker Welcome Content (preview) in Power Apps Maker Portal?

How to Enable Managed Environments for a Dataverse Environment?

How to Enable the Modern Controls (Preview feature) in the Canvas Apps?

How to Enable 2023 Release Wave 1 updates in the Dataverse Environment?

How to Deploy Enterprise Applications in the new Dataverse Environment?

What is Preview, Experimental and Retired features in Canvas Apps?

How to Enable the New Power Fx Formula Bar in Power Apps Studio?

Writing Power Fx formulas with natural language

Power Fx Formula Columns in Dataverse

Generating Power Fx formulas from examples

How to Create Dynamics 365 Marketing 30 Days Trial Version Online?

How to disable Multi-Factor Authentication (MFA) on Dynamics 365 Login?

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Installation)

Logo of a software application with a stylized letter 'D' in blue tones, accompanied by a wrench icon and another logo featuring geometric shapes in blue and red.

In my last article, I had explained about my new Plugin “Dataverse Users, Security roles, Teams and Teams security roles” overview and in this article, will explain about its installation.

Follow the below steps for installing this plugin in XrmToolBox.

Step 1: Click on the link to open XrmToolBox website.

Screenshot of the XrmToolBox website, displaying the header 'XrmToolBox: The Ultimate Set of Tools for Microsoft Dataverse' and a download button for the latest version.

Step 2: Click on the Download latest version.

Screenshot of the XrmToolBox homepage showcasing the download button for the latest version of the software.

Step 3: Click on Folder icon in Downloads.

The XrmToolBox website interface displaying a download notification for 'XrmToolbox.zip' with an arrow indicating the 'Open file' option.

Step 4: Right click on the folder and click on Extract All.

Screenshot of a computer screen showing the Downloads folder with an open context menu displaying options including 'Extract All' for a zip file named 'XrmToolbox.zip'.

Step 5: Click on Extract.

Screenshot of the 'Extract Compressed (Zipped) Folders' window, showing the destination folder path and the 'Extract' button.

Step 6: Once the file is extracted, click on it to open the folder.

Screenshot of the Windows Downloads folder showing the 'XrmToolbox.zip' file and the extracted 'XrmToolbox' folder.

Step 7: Click on the XrmToolBox.exe to open the XrmToolBox executable file.

Screenshot of the XrmToolBox folder in a Windows file explorer, showing various files and their details such as size and date modified.

XrmToolBox is opening…

XrmToolBox loading screen displaying the logo and tagline for Microsoft Dataverse and Microsoft Dynamics 365 tools.

Step 8: Click on Open Tool Library from Quick actions.

Or

Click on Configuration -> Tool Library.

XrmToolBox tool library menu showing options including 'Open Tool Library', 'Manage Connections', 'Settings', and 'Help'.

Step 9: Search for “Dataverse Users, Security roles, Teams and Teams security roles“.

XrmToolBox interface showing the search functionality for 'Dataverse Users, Security roles, Teams and Teams security roles' plugin.

Step 10: Select the Tool and Click on Install.

Screenshot of the XrmToolBox interface displaying the Tool Library, with the Dataverse Users, Security roles, Teams and Teams security roles plugin highlighted.

Step 11: Click on Yes to install this tool.

XrmToolBox interface showing the Dataverse Users, Security roles, Teams and Teams security roles plugin with a confirmation dialog asking if the user is sure they want to install the tool.

Step 12: Once the Installation is done successfully, you can see the below.

Click on Close.

XrmToolBox interface showing the installation process for the Dataverse Users, Security roles, Teams and Teams security roles plugin, with progress indicators for downloading and installing.

Step 13: Click on Tools tab.

Screenshot of the XrmToolBox interface highlighting the 'Tools' tab at the top.

Step 14: Search for “Dataverse Users, Security roles, Teams and Teams security roles“.

You can see my tool, which has been successfully installed.

Screenshot of XrmToolBox showing the tool 'Dataverse Users, Security roles, Teams and Teams security roles' with details including its version number and author.

In the next article, will explain about how to use this tool.

Hope you had successfully Installed “Dataverse Users, Security roles, Teams and Teams security roles” plugin in XrmToolBox.

Please like and share your valuable feedback on this article. Also, follow my blog to get my articles to your Inbox.

Click on the below image to navigate to my YouTube Channel.

Graphic promoting a YouTube channel with the text 'Has my blog post helped you?' and buttons for 'WATCH', 'LEARN', and 'SUBSCRIBE'.

Below are my earlier articles that you can have a look.

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Overview)

Limited Time Offer: 50% Off Microsoft Certification Vouchers

How to send an automated email in Dataverse using Power Automate?

Understanding Activity Party Types in Dynamics 365 CE

How to configure donotreply email using Shared mailboxes in Dynamics 365 CE?

Microsoft Power Pages: The authentication key for your portal will expire

Microsoft Azure: You’re not eligible for an Azure free account

How to create Microsoft Azure 30 days trial?

Edit in Visual Studio Code for the Web in Power Apps Portals

Error: The object cannot be updated because it is read-only in Microsoft Power Apps

Resolved: Fix connections issue in Power Automate Flow

Clear all objects feature in Power Apps Solutions

Power Automate Error: The ‘inputs.parameters’ of workflow operation of type ‘OpenApiConnection’ is not valid.

Power Automate Error: To use FilteringAttributes, your trigger must include an Update event on Dataverse Trigger

Dynamics 365 CE Solution Import Failed in Azure DevOps Pipelines

Power Automate Error: Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600

Error while opening a Tool in XRMToolBox

The Power Automate Cloud Flows Best Practices Whitepaper is now LIVE!

Error in Power Automate: There’s a problem that needs to be fixed to trigger this flow. To see more details, open Flow checker.

How to get the Dataverse Table’s first row from List Rows in Power Automate?

Microsoft Dataverse Accelerator – Part 2 – Installation

Microsoft Dataverse Accelerator – Part 1 – Introduction

How to get the Database Version of the Dataverse?

API playground feature not available in Dataverse Accelerator App?

How to Explore and test Dataverse in the Web API playground (preview)?

Web resource method does not exist in Dynamics 365 CE

How to get Environment Variable Value in Dynamics 365 CE using JavaScript?

Model-driven Apps – openAlertDialog – JavaScript – Code Snippet

Power Automate – Flow is not running on Trigger condition

Power Automate – Input field Delete option is disabled

Recipient of type ‘Contact’ with ID is marked as non-emailable

Preferred Solution | New feature | Microsoft Dataverse

New and Retired Microsoft Dynamics 365 Certifications

Environment settings behavior (Preview) feature in Model-driven Apps

Error while connecting to Dataverse environment in XrmToolBox

Power Fx Formula Columns in Microsoft Power Apps

How to Enable 2024 Release Wave 1 Updates in the Microsoft Dynamics 365 CE Environment?

Delete and Restore records (Preview) feature in Microsoft Dataverse

Microsoft Power App Environments Retention Period

How to Override the Model-driven app header colors?

Timeline Highlights (New feature) in Microsoft Power Apps

Model-driven App – Cannot “See associate records” option in the sub grid (arunpotti.com)

Bookmark the Important Dynamics 365 URLs

How to Enable Tenant-level analytics for Power Automate and Power Apps?

Microsoft Power Automate Copy and Paste Action in New DesignerHow to Setup Multi-Factor Authentication for your Microsoft Power Apps environment?

Microsoft Power Apps | Modern Themes | Preview feature

How to Download and Install the .NET Framework?

How to Create a SharePoint Site Online?

How to add and use Copilot answer control (Preview) in Microsoft Power Apps?

Dark Mode in Microsoft Power Apps

How to create Microsoft 365 E3 Trial for 30 days?

Refreshed look of solution dependencies in Dataverse Solutions

Microsoft Power Automate | Version History | Restore | New Feature

MICROSOFT LEARN – Artificial Intelligence Skills Challenge​ 2024!!!

Resolved – ‘InvokerConnectionOverrideFailed’ Error When a Power App Custom Page call a Power Automate Flow

How to Create Microsoft Power Apps Trial 30 days?

Not able to Create Power Automate Flow in Custom Page in Model-Driven App?

How to Enable Inline Actions feature in Microsoft Canvas Apps?

How to use /mention in Outlook web client for Dataverse records?

Associate Activities Multiple Related Records (Preview) feature in Microsoft Dynamics 365 CE

How to Enable Aggregation (preview) feature in Microsoft Power Apps?

Power Apps – Some components of this app require you to sign in. If you don’t sign in, part of the app may not work.

How to Enable the SQL Server stored procedures (preview) feature in the Power Apps?

How to get the Client Version of the Model Driven Apps?

How to get Microsoft 365 E3 Trial for 30 days?

How to Enable Copilot for Model-Driven apps feature in Dynamics 365 CE Environment?

[Resolved] Web resource method does not exist in Dynamics 365 CE JavaScript Error

How to Enable Blocking unmanaged customizations (Preview) feature in Dynamics 365 CE?

How to create Microsoft Power Apps Developer Plan Environment?

Microsoft Power Apps Developer Plan vs Power Apps Trial 30 days

What is Microsoft Power Apps Developer Plan?

[Resolved] PCF Field Control not showing anything in the PCF Test Environment?

[Issue Resolved] ReferenceError: Web resource method does not exist in Dynamics 365 CE Javascript Error

[Issue Resolved] Subcomponent cannot be added to the solution because the root component Template is missing in Dataverse

How to Turn Off the Modern Look in the Model Driven Apps?

How to Turn on the New modern, refreshed look for the Model-Driven apps?

Microsoft Power Apps – Apps filter feature

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Microsoft Power Apps – Solutions filter Preview feature

How to Show the Power Automate complete Expressions?

Dataverse Error: Cannot start the requested operation [EntityCustomization] because there is another [PublishAll] running at this moment.

Power Automate Error: You should specify a contact or account.

How to get the Choice Text and Value in the Dataverse using JavaScript?

Microsoft Dataverse Low Code No Code Plugins

How to convert the Number String to Number Array?

How to Integrate Instant Plugins in the Power Automate Flow?

Power Apps – ‘actionname’ is an unknown or unsupported function in namespace ‘Environment’

Dataverse Browser V1.1.0.1 is available for Dataverse Plugin Debugging

How to Integrate Instant Plugins in the Canvas App?

How to Enable Access to Microsoft Dataverse Actions (Preview feature) in the Power Apps?

How to Create an Instant Plugin in the Dataverse Environment?

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

What is Microsoft Dataverse Accelerator?

How to get the Logged in User Information in the Power Apps?

How to Install Power Platform Tools in Visual Studio Code?

How to Install the Apps from the Microsoft AppSource to your Dataverse Environment?

Microsoft Power Apps Maker Portal has a new look

Microsoft Power Apps Emulator (New Feature)

How to Enable the Dataverse Offline (Experimental Feature) in the Canvas Apps?

How to set the Authoring Version in the Canvas App?

New version of Dataverse Browser is available for Dataverse Plugin Debugging

Latest Free Practice Assessments for Microsoft Certifications

Download CRM 365 V9.X Tools using PowerShell

How to set the Refresh cadence for a Power Platform Environment?

Update forms and views (Preview feature) in Dataverse

How to connect to Microsoft Dataverse in Power Automate Flow using Service principal?

How to Enable Copilot (Preview) feature in Canvas Apps?

How to Debug a Dataverse Plugin without Installing the Profiler in the Plugin Registration Tool?

How to Enable the Licenses (Preview) feature for a Power Platform Environment?

How to Enable Maker Welcome Content (preview) in Power Apps Maker Portal?

How to Enable Managed Environments for a Dataverse Environment?

How to Enable the Modern Controls (Preview feature) in the Canvas Apps?

How to Enable 2023 Release Wave 1 updates in the Dataverse Environment?

How to Deploy Enterprise Applications in the new Dataverse Environment?

What is Preview, Experimental and Retired features in Canvas Apps?

How to Enable the New Power Fx Formula Bar in Power Apps Studio?

Writing Power Fx formulas with natural language

Power Fx Formula Columns in Dataverse

Generating Power Fx formulas from examples

How to Create Dynamics 365 Marketing 30 Days Trial Version Online?

How to disable Multi-Factor Authentication (MFA) on Dynamics 365 Login?

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

My first XRMToolBox Plugin: Dataverse Users, Security roles, Teams and Teams security roles (Overview)

Logos featuring a stylized letter 'D' in blue and a wrench icon next to a blue and red graphic element.

I have recently published my first XRMToolBox Plugin “Dataverse Users, Security roles, Teams and Teams security roles” related to Dataverse Security, which helps administrators, developers, and auditors retrieve and explore detailed user access information from Microsoft Dataverse environments.

You can check the below for the Overview, Key Features, Use Cases and Data Export of my Plugin.

📦 Overview

This plugin provides a comprehensive view of Dataverse users and their access configurations, including:

  • 👤 User Details: UserId, ApplicationId, Full Name, Email, User Status, Business Unit, Azure AD Object ID etc.
  • 🛡 User Security Roles (Separated by semicolon 😉
  • 👥 User Teams (Separated by semicolon 😉
  • 🛡 Team Security Roles (Separated by semicolon 😉

🧰 Key Features

  • 🔎 Global Search: Use a single search box to find any text across all retrieved user fields
  • ↕ Column Sorting: Sort by any field for easier navigation and analysis
  • 📤 CSV Export: Export all data or filtered search results to a .csv file with a custom filename
  • 📊 Detailed Metadata: View additional fields like domain name, business unit ID, and application ID
  • ⚡ Fast Performance: Optimized for large datasets with responsive UI
  • 🧭 User-Friendly Interface: Intuitive layout with minimal setup required
  • 🔄 Refresh Capability: Reload data without restarting the plugin with a single click
  • 📁 Offline Analysis: Exported data can be used for reporting, auditing, or compliance reviews

📋 Use Cases

  • 🔐 Security Audits: Identify users with elevated or missing roles
  • 🧾 Compliance Reporting: Export user-role mappings for documentation
  • 👥 Team Management: Understand team memberships and inherited roles
  • 🧹 Environment Cleanup: Detect inactive users or redundant access
  • 📈 Access Reviews: Analyze user metadata for governance and policy enforcement

📤 Data Export

  • Click the Export button to download data as a .csv file
  • Choose your own filename
  • Export either full dataset or filtered results based on search

Hope you liked my new plugin in the XrmToolBox.

In the next article, will explain about how to install this plugin in the XrmToolBox.

Please like and share your valuable feedback on this article. Also, follow my blog to get my articles to your Inbox.

Click on the below image to navigate to my YouTube Channel.

Graphic promoting a YouTube channel with the text 'Has my blog post helped you?' and buttons for 'WATCH', 'LEARN', and 'SUBSCRIBE'.

Below are my earlier articles that you can have a look.

Limited Time Offer: 50% Off Microsoft Certification Vouchers

How to send an automated email in Dataverse using Power Automate?

Understanding Activity Party Types in Dynamics 365 CE

How to configure donotreply email using Shared mailboxes in Dynamics 365 CE?

Microsoft Power Pages: The authentication key for your portal will expire

Microsoft Azure: You’re not eligible for an Azure free account

How to create Microsoft Azure 30 days trial?

Edit in Visual Studio Code for the Web in Power Apps Portals

Error: The object cannot be updated because it is read-only in Microsoft Power Apps

Resolved: Fix connections issue in Power Automate Flow

Clear all objects feature in Power Apps Solutions

Power Automate Error: The ‘inputs.parameters’ of workflow operation of type ‘OpenApiConnection’ is not valid.

Power Automate Error: To use FilteringAttributes, your trigger must include an Update event on Dataverse Trigger

Dynamics 365 CE Solution Import Failed in Azure DevOps Pipelines

Power Automate Error: Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600

Error while opening a Tool in XRMToolBox

The Power Automate Cloud Flows Best Practices Whitepaper is now LIVE!

Error in Power Automate: There’s a problem that needs to be fixed to trigger this flow. To see more details, open Flow checker.

How to get the Dataverse Table’s first row from List Rows in Power Automate?

Microsoft Dataverse Accelerator – Part 2 – Installation

Microsoft Dataverse Accelerator – Part 1 – Introduction

How to get the Database Version of the Dataverse?

API playground feature not available in Dataverse Accelerator App?

How to Explore and test Dataverse in the Web API playground (preview)?

Web resource method does not exist in Dynamics 365 CE

How to get Environment Variable Value in Dynamics 365 CE using JavaScript?

Model-driven Apps – openAlertDialog – JavaScript – Code Snippet

Power Automate – Flow is not running on Trigger condition

Power Automate – Input field Delete option is disabled

Recipient of type ‘Contact’ with ID is marked as non-emailable

Preferred Solution | New feature | Microsoft Dataverse

New and Retired Microsoft Dynamics 365 Certifications

Environment settings behavior (Preview) feature in Model-driven Apps

Error while connecting to Dataverse environment in XrmToolBox

Power Fx Formula Columns in Microsoft Power Apps

How to Enable 2024 Release Wave 1 Updates in the Microsoft Dynamics 365 CE Environment?

Delete and Restore records (Preview) feature in Microsoft Dataverse

Microsoft Power App Environments Retention Period

How to Override the Model-driven app header colors?

Timeline Highlights (New feature) in Microsoft Power Apps

Model-driven App – Cannot “See associate records” option in the sub grid (arunpotti.com)

Bookmark the Important Dynamics 365 URLs

How to Enable Tenant-level analytics for Power Automate and Power Apps?

Microsoft Power Automate Copy and Paste Action in New DesignerHow to Setup Multi-Factor Authentication for your Microsoft Power Apps environment?

Microsoft Power Apps | Modern Themes | Preview feature

How to Download and Install the .NET Framework?

How to Create a SharePoint Site Online?

How to add and use Copilot answer control (Preview) in Microsoft Power Apps?

Dark Mode in Microsoft Power Apps

How to create Microsoft 365 E3 Trial for 30 days?

Refreshed look of solution dependencies in Dataverse Solutions

Microsoft Power Automate | Version History | Restore | New Feature

MICROSOFT LEARN – Artificial Intelligence Skills Challenge​ 2024!!!

Resolved – ‘InvokerConnectionOverrideFailed’ Error When a Power App Custom Page call a Power Automate Flow

How to Create Microsoft Power Apps Trial 30 days?

Not able to Create Power Automate Flow in Custom Page in Model-Driven App?

How to Enable Inline Actions feature in Microsoft Canvas Apps?

How to use /mention in Outlook web client for Dataverse records?

Associate Activities Multiple Related Records (Preview) feature in Microsoft Dynamics 365 CE

How to Enable Aggregation (preview) feature in Microsoft Power Apps?

Power Apps – Some components of this app require you to sign in. If you don’t sign in, part of the app may not work.

How to Enable the SQL Server stored procedures (preview) feature in the Power Apps?

How to get the Client Version of the Model Driven Apps?

How to get Microsoft 365 E3 Trial for 30 days?

How to Enable Copilot for Model-Driven apps feature in Dynamics 365 CE Environment?

[Resolved] Web resource method does not exist in Dynamics 365 CE JavaScript Error

How to Enable Blocking unmanaged customizations (Preview) feature in Dynamics 365 CE?

How to create Microsoft Power Apps Developer Plan Environment?

Microsoft Power Apps Developer Plan vs Power Apps Trial 30 days

What is Microsoft Power Apps Developer Plan?

[Resolved] PCF Field Control not showing anything in the PCF Test Environment?

[Issue Resolved] ReferenceError: Web resource method does not exist in Dynamics 365 CE Javascript Error

[Issue Resolved] Subcomponent cannot be added to the solution because the root component Template is missing in Dataverse

How to Turn Off the Modern Look in the Model Driven Apps?

How to Turn on the New modern, refreshed look for the Model-Driven apps?

Microsoft Power Apps – Apps filter feature

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Microsoft Power Apps – Solutions filter Preview feature

How to Show the Power Automate complete Expressions?

Dataverse Error: Cannot start the requested operation [EntityCustomization] because there is another [PublishAll] running at this moment.

Power Automate Error: You should specify a contact or account.

How to get the Choice Text and Value in the Dataverse using JavaScript?

Microsoft Dataverse Low Code No Code Plugins

How to convert the Number String to Number Array?

How to Integrate Instant Plugins in the Power Automate Flow?

Power Apps – ‘actionname’ is an unknown or unsupported function in namespace ‘Environment’

Dataverse Browser V1.1.0.1 is available for Dataverse Plugin Debugging

How to Integrate Instant Plugins in the Canvas App?

How to Enable Access to Microsoft Dataverse Actions (Preview feature) in the Power Apps?

How to Create an Instant Plugin in the Dataverse Environment?

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

What is Microsoft Dataverse Accelerator?

How to get the Logged in User Information in the Power Apps?

How to Install Power Platform Tools in Visual Studio Code?

How to Install the Apps from the Microsoft AppSource to your Dataverse Environment?

Microsoft Power Apps Maker Portal has a new look

Microsoft Power Apps Emulator (New Feature)

How to Enable the Dataverse Offline (Experimental Feature) in the Canvas Apps?

How to set the Authoring Version in the Canvas App?

New version of Dataverse Browser is available for Dataverse Plugin Debugging

Latest Free Practice Assessments for Microsoft Certifications

Download CRM 365 V9.X Tools using PowerShell

How to set the Refresh cadence for a Power Platform Environment?

Update forms and views (Preview feature) in Dataverse

How to connect to Microsoft Dataverse in Power Automate Flow using Service principal?

How to Enable Copilot (Preview) feature in Canvas Apps?

How to Debug a Dataverse Plugin without Installing the Profiler in the Plugin Registration Tool?

How to Enable the Licenses (Preview) feature for a Power Platform Environment?

How to Enable Maker Welcome Content (preview) in Power Apps Maker Portal?

How to Enable Managed Environments for a Dataverse Environment?

How to Enable the Modern Controls (Preview feature) in the Canvas Apps?

How to Enable 2023 Release Wave 1 updates in the Dataverse Environment?

How to Deploy Enterprise Applications in the new Dataverse Environment?

What is Preview, Experimental and Retired features in Canvas Apps?

How to Enable the New Power Fx Formula Bar in Power Apps Studio?

Writing Power Fx formulas with natural language

Power Fx Formula Columns in Dataverse

Generating Power Fx formulas from examples

How to Create Dynamics 365 Marketing 30 Days Trial Version Online?

How to disable Multi-Factor Authentication (MFA) on Dynamics 365 Login?

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Step-by-Step Guide: Implementing the Power Pages Summary Component with Dataverse Tables

Power Pages Summary Component with Dataverse Tables

Overview

Microsoft Power Pages continues to evolve as a powerful platform for building secure, low-code, data-driven websites. One of its latest additions, the Summary Component, brings the power of AI summarization directly into portals.

The Summary Component allows developers and makers to automatically generate short, readable summaries from Dataverse data using the Power Pages Web API. This feature helps users quickly understand patterns, trends, and key details without navigating through individual records.

This blog explains the implementation of the Summary Component for the Lead table in the Power Pages portal to summarize key fields such as Full Name, Creation Date, Annual Revenue, Subject, Company Name, Email, and Telephone Number.

Business Use Case

The goal of this implementation is to provide sales managers and team members with a quick overview of lead information directly from the portal without requiring them to open each record.

Traditionally, reviewing leads involves scanning through a detailed list of entries, which can be time-consuming. The new Summary Component solves this by generating a concise, AI-based paragraph summarizing all relevant leads.

Example: Instead of reading a table with multiple columns, the component can generate a statement like:

“In the last month, five new leads were created, including John Carter from Contoso Ltd. and Priya Mehta from Bluewave Technologies, both showing strong revenue potential.”

This not only saves time but also provides instant insight into the business pipeline.

Step-by-Step Implementation of Summary Component

The following steps outline the implementation of Power Pages Design Studio:

Step 1: Open Power Pages Design Studio

Open the Power Pages Design Studio and navigate to the page where the summary needs to appear.

Step 2: Add the Summary Component

In the selected section, click + More Options → Components → Connected to data → Summary.

Power Pages Summary Component with Dataverse Tables

Step 3: Configure the Component

In the configuration panel, fill in the details as follows:

  • Title: Lead Summary Overview
  • Summarization API: leads?$select=fullname,subject,companyname,emailaddress1,telephone1,createdon,revenue
  • Additional Instructions:
    “Provide a clear and concise summary highlighting the lead’s name, company, contact details, and the purpose or topic of the lead. Identify any patterns, urgency indicators, or follow-up requirements based on the creation date.”
  • Keep Summary Expanded: Enabled (This will keep the summary expandable by default when the user visits the portal)

Power Pages Summary Component with Dataverse Tables

This configuration connects the component to the Lead table via the Power Pages Web API and instructs it to summarize the specified fields.

Configuration Settings

Before the Summary Component can retrieve data, permissions and secure access must be configured through the portal.

  1. Enable Web API for the Lead Table

Go to Power Pages Management → Site Settings → + New, and add the following key-value pairs:

  • Name: Webapi/lead/enabled
    Value:
    true
  • Name: Webapi/lead/fields
    Value:
    * (to allow access to all fields) or specify individual fields as fieldlogicalname1, fieldlogicalname2, …

This explicitly grants Web API access for the Lead table in the Power Pages portal.

Additionally, verify that the setting Summarization/Data/Enable is set to true.
If this setting does not exist, create a new record with that name and set its value to true.

Power Pages Summary Component with Dataverse Tables

2. Create Table Permissions

In Power Pages → Security → Table Permissions:

  • Create a new permission record with:
    • Name: All Leads or Lead Read Permission
    • Table: Lead
    • Access Type: Global access
    • Permission: Read
  • Assign this permission to the Authenticated Users web role.

Power Pages Summary Component with Dataverse Tables

Without this, data access via the Web API will fail with an error message:

“Something went wrong, please try again later.” error.

Working

Once the configuration is complete, publish the site and test the component.

The Summary Component will automatically connect to Dataverse, retrieve lead data, and generate a short summary paragraph that dynamically updates as new records are created or modified.

Power Pages Summary Component with Dataverse Tables

The output proved that the Web API connection and summarization logic were functioning correctly. The results dynamically update as new leads are added or existing records change in Dataverse.

Styling the Summary Component

The appearance of the Summary Component can be customized to align with the Power Pages portal theme. Styles such as borders, background colors, shadows, and other visual effects can be applied to ensure seamless integration with the overall site design.

Power Pages Summary Component with Dataverse Tables

FAQs

  1. What is the Summary Component in Power Pages?
    The Summary Component is an AI-powered feature in Microsoft Power Pages that uses natural language generation to summarize data from Dataverse tables, helping users understand key insights quickly.
  2. Can I use the Summary Component for any Dataverse table?
    Yes. It can be connected to any table with Web API access enabled. Just update the summarization API query and permissions accordingly.
  3. Do I need to enable any specific settings before using the Summary Component?
    Yes. Web API access must be enabled for the target table (e.g., Lead) and ensure the Summarization/Data/Enable site setting is set to true. Also, create the appropriate Table Permissions for the portal users.
  4. Does the Summary Component automatically refresh when data changes in Dataverse?
    Yes. Once configured, the summary updates dynamically whenever the underlying Dataverse records are modified or new data is added.
  5. Can I style or customize the Summary Component UI?
    Absolutely. The component’s appearance can be adjusted using custom CSS to align it with their Power Pages theme for a consistent visual experience.

Conclusion

The Summary Component in Power Pages is a game-changer for presenting Dataverse data in a meaningful, AI-driven format. By implementing it for the Lead table, sales teams gain quick, automated insights which resulted in saving time, improving decision-making, and enhancing user experience.

With minimal configuration enabling Web API, creating table permissions, and defining a summarization query the component delivers a seamless experience that transforms raw data into concise insights.

 

The post Step-by-Step Guide: Implementing the Power Pages Summary Component with Dataverse Tables first appeared on Microsoft Dynamics 365 CRM Tips and Tricks.

❌