nishantrana

[nishantrana]

When Do We Use the ActivityParty.AddressUsed Property for Emails in Power Automate (Dataverse)

When we automate emails in Dataverse using Power Automate, we deal with something called Activity Party. It manages the participants of an email—whether they are To, CC, BCC, or the Sender. Normally, we use the partyid field to point to a Dataverse record like a Contact, Lead, User, or Queue. Every participant in an email is stored as a row in the Activity Party table. Key fields…

[nishantrana]

How to - Find Every Cloud Flow That References a Specific Column / Field (Dataverse/ Dynamics 365)

Sometimes we need to find all the flows where a specific Dataverse field is used — maybe before renaming it, removing it, or just checking its usage. Manually opening each flow is slow, but we can do it in seconds with SQL 4 CDS. For e.g. we want to search for flows that use the field: custom_mysamplefield For this we can make use of the below query, run it in SQL 4 CDS (XrmToolBox). SELECT…

[nishantrana]

Fixing Date Shift Issue After Changing DateOnly Field from Time Zone Independent to User Local – Dataverse / Dynamics 365

In our Dataverse environment, we had a field named custom_sampledate configured as a DateOnly type with User Local behavior. At some point, we changed its behavior to Time Zone Independent, assuming it would prevent confusion across time zones. At first glance, everything seemed fine. But over time, users in time zones like New Zealand (NZ) started reporting an issue: for older records created…

[nishantrana]

Workflow must be in Published state while deleting the Bookings / Work Orders (Dynamics 365 Field Service)Workflow must be in Published state

Recently we were cleaning some of the work orders and related records in one of our environments. However when trying to delete the bookable resource booking record, we were getting the below error. Deleting booking records is required if we want to delete the associated work order record. We verified all the processes – workflows, SLA, and also checked the system’s plugin code, but could not…

[nishantrana]

Fix - The FnO Integration solution install failed. HCMScheduling and HCMSchedulingAnchor solutions must be installed. See Field Service documentation for details (Dynamics 365 Field Service)

While trying to install Finance and Operations from Field Service Settings, we might encounter the following error. “The FnO Integration solution install failed. Please contact your system administrator. HCMScheduling and HCMSchedulingAnchor solutions must be installed. See Field Service documentation for details.” To fix it, we need to install the “Dynamics 365 Human Resources integration to…

[nishantrana]

Fixed - The following solution cannot be imported: Dynamics365SupplyChainExtended. Some dependencies are missing – HCM Common (Dynamics 365)

While trying to install the Dual Write Supply Chain Extended Solution, we got the following error. We had below apps already installed before installing the Supply Chain Extended Solution. Dual-Write Application Core Solutions Dual-write core Solution Dual-write Dynamics 365 Human Resources Dual-write Finance and Extended Solutions Upon going through the documentation, we realized we were…

[nishantrana]

Resolve - This environment can't be copied because your org (tenant) is over capacity. Request an extension (Dataverse / Dynamics 365)

When trying to overwrite another environment with a copy of Prod, the system prevented the operation due to exceeding tenant capacity limits. This copy operation is subject to environment and storage capacity constraints. We raised a Microsoft Support Ticket and learned that we can resolve this issue by either purchasing additional storage or requesting free temporary storage to complete the…

[nishantrana]

Using Form fill Assist Toolbar to streamline data entry in Power Apps

We tried the AI Form Filling Assistance feature in model-driven Power Apps and found it very helpful. One part that we liked the most was the toolbar and file (preview). This makes it much easier to fill forms using information from uploaded documents. To enable this feature, go to: Environment → Settings → Features → Form fill assist toolbar (AI Form Fill Assistance) Once enabled, we can…

[nishantrana]

Favorite your Actions and Connectors for quick retrieval in Cloud Flows (Power Automate)

With this new update in Power Automate, it’s now easier for us to find and use the actions and connectors we need. We can also quickly access tools and AI features while building flows. This helps save time and makes the flow-building experience smoother. Here is a screenshot of the new connector and action pane in Power Automate, below we have added Dataverse connector and some of its action as…

[nishantrana]

How We Reclaimed Storage from the WebResourceBase Table in Dataverse

While reviewing our Dataverse environment’s storage usage, we noticed something surprising—over 13 GB of our file capacity was being consumed by the WebResourceBase table alone. This table typically stores JavaScript files, HTML web resources, images, and other files tied to customizations in Dynamics 365. However, the volume was unexpectedly high, prompting us to investigate further. We started…

[nishantrana]

Step-by-Step: Deleting Work Orders (Dynamics 365 Field Service)

When working with historical or test data in Dynamics 365 Field Service, we often come across the need to clean up old Work Orders and their related records. While it might seem straightforward to just delete the Work Order, there are quite a few interdependent entities and plugin validations that can make this task tricky. We wanted to delete all msdyn_workorder records created before a certain…

[nishantrana]

Handling Unexpected Lookup Auto-Population in Quick Create Forms (Dynamics 365)

Recently, we had a requirement to track the Current and Previous contracts for a Contact in our Dataverse environment. To achieve this, we created two separate N:1 relationships between the Contact and Contract tables custom_currentcontractid → Contact’s Current Contract custom_previouscontractid → Contact’s Previous Contract So far, so good. Soon after, we noticed a strange issue: “When…

[nishantrana]

Compare Plugin Steps and Images Across Environments in Dynamics 365

Recently, while testing in UAT, we ran into a plugin-related issue that wasn’t reproducible in Dev. After investigating, we discovered the root cause: one of the plugin step images was missing an attribute in UAT. This wasn’t immediately obvious and not something we’d catch in a standard deployment check. Manually inspecting each plugin step image across environments would be tedious and…

[nishantrana]

Update Business Process Flow Stage using Excel Import with Power Automate – Dataverse / Dynamics 365

In some business scenarios, we might need to update the Business Process Flow (BPF) stage of a record during an Excel import — especially during data migration or bulk record manipulation. In this blog post, we’ll walk through how to set a desired BPF stage (based on the stage name) and automatically move the record to that stage using Power Automate. We’re working with a custom Dataverse table…

[nishantrana]

Fixed - The Default Unit is not a member of the specified Unit Group error in Dynamics 365 / Dataverse

Recently while trying to import the product records in our Dynamics 365 Sales, we got the below error – “The Default Unit is not a member of the specified Unit Group” We were providing the correct UoM Group and Default UoM in our Excel file to be imported. After some troubleshooting, we realized that we had 2 units with the same name “Primary Unit”, because of which the system was not able to…

[nishantrana]

Failed to delete View (View Name). Object dependencies exist, please review before deleting error in Dataverse

While trying to delete a custom public view (Test View) in Dataverse, we encountered the following error: “The SavedQuery(<GUID>) component cannot be deleted because it is referenced by 1 other component. For a list of referenced components, use the RetrieveDependenciesForDeleteRequest.” This usually means that the view we’re trying to delete is still being referenced somewhere else in our…

[nishantrana]

Fixed - Field Service Time Entry functionality is not available. The installed version of Project Service Automation is not compatible with the installed version of Field Service. Please upgrade Project Service Automation to use Field Service Time Entry functionality.

Recently while trying to set Bookable Resource Booking record’s status as completed or trying to change Settings >> General >> Field Service Settings >> Time Entry, we were getting below error We can see the Dynamics 365 Project Service Installation Failed and on retrying the installation it was giving below error. The fix that worked here was to install the Project Operations. Hope it helps..