Dynamics 365 Tech Blogs: Dynamics 365

Showing posts with label Dynamics 365. Show all posts

Implementing Dynamic Subgrid Filtering in Power Apps Model-Driven Forms Introduction

In the Rental Smart MVP project, we often need to display filtered data in subgrids on forms like the Property form. This helps property managers quickly view owner expenses without clutter. Here's a simple JavaScript function to dynamically filter the Owner Expense History subgrid for Bills that are historical (Paid or Void), linked to the property owner, and not unit-specific. It uses setFilterXml for UCI compatibility and assumes the subgrid is set up as a related entity grid for Charges.

Dataverse Date & Time columns: a practical guide

The two settings that matter

Format: Date only or Date and time.
Behavior: User Local, Date Only, or Time zone independent.

These decide storage, conversion, and what users see.

From Zero to Working Demo: Power Automate → Azure Service Bus → Azure Durable Functions → Clio API

This guide walks a junior developer from a blank Azure subscription to a running integration that accepts a message, runs a Durable Function, and creates a contact in Clio via OAuth. It includes the Azure setup, the required environment variables, the project structure, and the end-to-end flow.

Assigning (or Un-assigning) a Contact’s Web Role with a Classic D365 Workflow

Portal web-roles drive what a portal user (contact) can see and do. If you only need a straightforward set-it-and-forget-it rule—no complex branching or API calls—a classic background workflow is still the quickest tool in the box.

1 · Scenario

Problem statement ↴
Records previously flagged as Ineligible (statecode = Inactive) are later re-activated by users. Their associated Business Process Flow rows remain inactive and stuck on an early stage.

Edit related table records directly from another table’s main form

Reference: 1

There are multiple ways that you can work with related table records on a table form within Power Apps. For example, you can include related tables in read-only mode with a quick view form and create or edit a record using a main form in a dialog.

Another way you can work with related table records is by adding a form component control to another table's main form. The form component control lets users edit information of a related table record directly from another table’s form.

How to Check Whether Any Dataverse Record Is in a Particular Business-Process-Flow (BPF) Stage

Knowing the current stage of a Business Process Flow (BPF) lets you lock fields, hide buttons, or trigger downstream logic. Below are two generic patterns that work in every online environment—no proprietary entity names, no deprecated APIs, and no plug-ins.

Call Dataverse actions directly in Power Fx

Reference: 1

As a part of the Power Fx language, authors can now directly invoke a Dataverse action within a formula. Both unbound and bound actions are supported. Authors can add a Power Fx Environment language object to their app and access Dataverse actions.

Fixing "Access is Denied" When Creating a Strong Name Key (.snk) File in Visual Studio

If you're trying to create a .snk file for signing your Dynamics 365 plugin assembly and encounter the error: "The operation could not be completed. Access is denied."

How to Get All Outlook Calendar Events (Including Recurring Events) in Power Automate

When working with Outlook calendar data in Power Automate, it's important to understand the difference between the “Get events” and “Get calendar view of events” actions—especially if your flow needs to handle recurring events.

Understanding Dataverse Storage: From Business Basic to Power Apps Licenses

When I started exploring Microsoft Power Platform with just a Microsoft 365 Business Basic license (primarily for business email via Outlook), I noticed some limitations when trying to create environments for Power Apps development.

FW: Change the rollup field update frequency in Dataverse or Dynamics 365

By default, each attribute is updated hourly. When a rollup attribute is created or updated a Mass Calculated Rollup Fields job is scheduled to run in 12 hours But you can change it. Follow below steps to change the frequency.

How to Create a Web API Integration for Dataverse Using Azure Portal

This guide walks you through creating a secure Web API integration between Microsoft Dataverse (used by Dynamics 365) and an external system using Azure Active Directory (Azure AD) authentication.

How to Retrieve Environment Variable Current Value in JavaScript for Dynamics 365

In Dynamics 365, Environment Variables let you externalize configurable values such as URLs, keys, or feature toggles without changing the solution code.

How to Format a Date Field as "Month Year" in a Dataverse Formula Type Column

In Dataverse, you may need to display a Date and Time column in a readable "Month Year" format — like May 2025. This is especially useful for calculated or formula-type columns where formatting options are limited.

User Guide: Managing Export to PDF Settings

This guide explains how to Refresh, Add, Update, and Delete tables for Export to PDF.

Download latest solution package

How to Calculate Account Engagement Score in Dynamics 365

In sales and CRM, measuring account engagement is crucial to identifying customer interactions and potential sales opportunities. In this guide, we will walk through how to calculate the engagement score for an account in Microsoft Dynamics 365 using activities such as emails, phone calls, and appointments.

Deploy and install Dynamics 365 App for Outlook

This topic covers how to set up and deploy Dynamics 365 App for Outlook.

Diagnosing SQL Arithmetic Overflow Errors in Dynamics 365 Calculated Columns

In Dynamics 365, calculated columns are processed by SQL, and complex expressions can sometimes lead to unexpected errors. One reported error is:

SQL error: A SQL arithmetic overflow error occurred
CRM ErrorCode: -2147217098
SQL ErrorCode: -2146232060
SQL Number: 8115

How to Calculate Quarters from Dates in Dynamics 365 and Power BI

When working with date fields in Dynamics 365 or Power BI, you might need to categorize transactions or activities by quarters. A simple formula can help you determine which quarter a given date falls into.