How to Customize the Opportunity Close Dialog and Auto-Populate Actual Revenue in Dynamics 365

 When closing an Opportunity in Microsoft Dynamics 365, you may need to customize the Opportunity Close dialog and ensure that the Actual Revenue field is correctly populated. By default, the Actual Revenue might be set to 0 due to out-of-the-box (OOB) processes. This guide will show you how to enable customization for the Opportunity Close form and use JavaScript to auto-populate the Actual Revenue field.

PreOperation vs PostOperation for Action Plugin Registration in Dynamics 365

When developing a plugin for a custom action in Dynamics 365, choosing the correct plugin registration stage is crucial. This article explains the differences between PreOperation and PostOperation, highlights a real failure case, and provides best practices for plugin registration.

Resolving SQL Arithmetic Overflow Errors in Dynamics 365 Workflows

 Issue Overview

Users may encounter the following error message when executing workflows or other operations in Dynamics 365:

Integrating Dynamics 365 Workflows, Actions, and Power Automate Flows

 In Dynamics 365, workflows, actions, and Power Automate flows can be seamlessly integrated to create robust and automated business processes. Understanding how these components interact helps leverage their full potential and simplifies complex automation scenarios.

Using sessionStorage to Pass Values Between HTML Web Resource and D365 Form

 In Dynamics 365, you often embed HTML web resources within forms to capture or display additional data. Sometimes, you need to pass values between these web resources and the main form. For example, Amy’s scenario involved preserving the active tab on a booking record after the signature capture form refreshes the parent form.

Dynamically Retrieving a View ID by View Name and Table Name in Dynamics 365

 This article demonstrates how to dynamically retrieve the ID of a custom view based on its name and the target table (entity) in Dynamics 365. This technique is useful when you need to apply a custom view for lookups or other scenarios where a filtered set of records is required.

Replacing the "Add Existing" Button with a Filtered Lookup in Dynamics 365

 This article demonstrates how to replace the standard "Add Existing" button in Dynamics 365 with a custom solution that opens a filtered lookup dialog. The solution leverages the Dynamics 365 Web API and FetchXML to dynamically retrieve a custom view's ID and use it to filter lookup results. Although the example associates system users with a Driver Group via an N:N relationship, the approach is flexible and can be adapted for other entities and scenarios.

Understanding the Microsoft Dynamics 365 Plugin Execution Pipeline

 In Microsoft Dynamics 365, plugins are executed within a pipeline that consists of multiple stages. The three primary stages—PreValidation, PreOperation, and PostOperation—determine when your custom code runs relative to the core data operation. Each stage has its own characteristics, benefits, and use cases. This article explains the differences between these stages.

Filtering the Owner Lookup in Dynamics 365 Forms

 This article explains how to customize your Dynamics 365 form by filtering the ownerid lookup field. The goal is to display only system users where the custom boolean field dsl_driver is set to true. This ensures that only qualified users are selectable in the lookup, enhancing data integrity and user experience.

How to Change the Default Calendar View to Month

Follow these simple steps to personalize your calendar settings:

How to Display a Subgrid in Calendar View

Subgrid displayed in calendar view allows users to see records in a more intuitive, time-based format.

Adding a Custom Calendar Filtered by ID from Page URL in Power Pages

Integrating a calendar into a Power Pages portal can enhance the user experience by displaying scheduled events dynamically. This article guides you through adding a FullCalendar instance to Power Pages, retrieving events via Web API, and filtering them by an ID retrieved from the page URL.

How to Utilize Web API in Power Pages: A Comprehensive Guide

 Power Pages Web API empowers you to create rich, interactive web experiences by enabling seamless communication between your web pages and backend data. This article will guide you through the process of setting up and utilizing the Web API in Power Pages, drawing insights from official Microsoft tutorials and a helpful YouTube video.

Disabling a Ribbon Button Based on the Current Table and Form in Dynamics 365

 In Dynamics 365, ribbon (or command bar) buttons can be enabled or disabled using enable rules. The enable rule functions should return true if the button should be enabled and false if the button should be disabled. In this example, we want to disable a button when the current record belongs to a specified entity (table) and is displayed on a specified form.

Opening a Specified Related Entity Form with Pre-Populated Parameters in Dynamics 365

 In Dynamics 365 customizations, you may encounter scenarios where you need to open a related entity form with pre-populated fields. This is common when you want to create a record in a related entity and carry over some data from the current record. In this article, we will walk through two JavaScript functions that help you achieve this by:

How To Retrieve the ObjectTypeCode by Table Name in Dynamics 365

 In Dynamics 365 (Dataverse), each entity is assigned a unique numerical identifier known as the ObjectTypeCode. This code is used internally for various purposes, such as filtering system forms and working with metadata. While some approaches may attempt to query metadata directly via unsupported endpoints (like EntityDefinitions), the recommended and supported method is to use the Xrm.Utility.getEntityMetadata function.

How to Dynamically Switch Forms in Dynamics 365 Based on Field Values Using JavaScript

 In Dynamics 365, the user interface can be dynamically adjusted to enhance user experience and streamline data entry processes. One way to achieve this is by switching forms based on the value of a specific field. This article provides a detailed guide on how to implement this functionality using JavaScript.

How to Redirect Users to a Home Page or Custom Page After They Sign In

 If you’re using Power Apps portals (now Power Pages) or a similar setup with Azure Active Directory (AD) / Azure B2C logins, you may want users to land on a home page—or different pages depending on how they signed in—rather than the default profile page. Below are the core steps to achieve this, along with examples of handling custom query parameters.

Understanding SQL Joins: A Comprehensive Guide

 SQL joins are a fundamental concept in relational database management systems. They enable you to combine data from multiple tables based on relationships between those tables. This article provides an in-depth look at the different types of joins, their use cases, and examples to help you understand when and how to use them effectively.

Unlock the Power of XrmToolBox: Tips for Using Web Resources Manager, ReportSync, and Script Finder

 

As a Dynamics 365 developer or functional consultant, you’ve likely encountered scenarios where managing resources and tracking dependencies can feel like a daunting task. Luckily, XrmToolBox provides a range of tools that simplify these processes, helping you save time and effort. Let’s explore three key tools and some tips to get the most out of them.

Resolving Metadata Setting Attribute Value Failures in Power Pages

 Introduction

When integrating Power Pages with Dynamics 365, you might encounter an issue where changes to field attributes through Power Pages metadata settings do not reflect due to Dynamics 365 fields being set to read-only. This article provides a straightforward explanation and solution to this common problem.

How to Get the User's Current Location in Dynamics 365 Using JavaScript

 In Dynamics 365, you can use JavaScript to retrieve the user's current geographical location and store it in custom fields on the form. This guide explains how to implement a function that utilizes the browser's geolocation API.

Using JavaScript to Navigate to Google Maps in Dynamics 365

 This guide demonstrates how to use JavaScript in Dynamics 365 to enable navigation buttons that open Google Maps with predefined locations.

How to Limit the Maximum Number of Records in a D365 View (Top N) Using a Plugin

 Requirement

We need to limit how many records a Dynamics 365 (D365) view returns. Since there’s no out-of-box (OOB) way to do this, we introduced a custom column dsl_topn. This column holds the “Top N” value we want. A plugin then intercepts the FetchXML query and injects the <fetch top="N"/> attribute, removing any conflicting paging attributes in the process.

Merging Word Documents in Dynamics 365 Using Only Built-In Features

 Below is a straightforward approach to merge two Word documents in Dynamics 365—without resorting to third-party paid connectors or extensions. By leveraging a custom Action, a Power Automate flow, and a plugin with OpenXML (embedded via ILRepack), you can seamlessly combine Word files and store the merged result, all in one out-of-the-box solution.

How To Operate Microsoft Dataverse From An HTML Web Resource In Dynamics 365

Working with HTML web resources in Dynamics 365 is a common way to extend forms, capture user input, and interact directly with Microsoft Dataverse data. In this tutorial, we will show how to retrieve a record ID from URL parameters  and then use OData calls to fetch(Read) and Create / Update / Delete records.

Workaround for Multiple Columns in Quick View Forms

 Dynamics 365 Quick View forms only support a single column. 

Two Approaches to Make a Lookup Column Read-Only While Retaining Programmatic Updates In Power Pages (Powerapps Portal)

 In certain scenarios, you may want to present a lookup field on a form as if it were read-only, while still allowing scripts to programmatically set or update its value behind the scenes. Here are two methods to achieve this without disabling the field entirely, thus preserving your ability to set its value via code:

How to Remove Hyperlinks from the First Column of an Entity List in Power Pages

 Background

In Power Pages (formerly known as Power Apps portals), Entity Lists often present clickable hyperlinks on the first column. While this is convenient for navigation to detailed records, sometimes you might want to display this information as plain text instead. For example, you may have a “Case Number” or “Grievance Number” column that you want visible, but not clickable.