Few handy SQL Queries (SQL4CDS) – Dataverse / Dynamics 365
Sharing some the queries we had used in our projects recently- 1) Get the list of table with audit enabled – 2) Get the list of fields per table with audit enabled…
Nishant Rana
1,323
Posts
217,496
Views
Fixed – Workflow must be in Published state (Dynamics 365 Field Service)
Recently, we got the following error while booking a resource in our schedule board. We earlier got the same error while trying to delete bookable resource booking records. We could not figure…
Using AI to Build Tables and Fields in Dynamics 365 with PowerMakerAI’s AI Entity Builder & Visualizer (Tool Showcase)
Recently, I came across a very interesting tool called PowerMakerAI, developed by a fellow community member. I felt it’s worth sharing here because it directly helps us in one of the most…
Understanding Date and Time Field Behavior in Dataverse
When working with Date and Time fields in Dataverse, one of the most confusing parts is how values are stored in the backend vs. how they are displayed to users in different…
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,…
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…
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…
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…
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…
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. Upon going through…