[Tool Showcase – PowerMakerAI] Talk to Your CRM Like a Teammate — Meet PowerMakerAI’s Context-Aware Chatbot


You’ve probably used ChatGPT or Gemini to generate code, write emails, or even debug errors. But what if you could do the same for your Dynamics 365 CRM?

No plugins. No clicking around. No SDK calls.

Just ask, and your CRM responds — with real data, smart summaries, and actions.

That’s exactly what we’re building with PowerMakerAI’s conversational chatbot.


🧠 What It Actually Does

This isn’t just a chatbot bolted on top of CRM. It’s deeply CRM-aware — meaning it knows your metadata, understands your entities and attributes, and can use that to:

  • Create new records (like leads, contacts, opportunities)
  • Update or delete existing data
  • Fetch filtered lists
  • Analyze plugin trace logs in conversation
  • Help troubleshoot issues based on real CRM behavior
  • Explain how your CRM is set up — from relationships to field types

In short: it’s like having a junior CRM dev who already knows your schema and listens carefully.


🛠 How It Works

Here’s a basic example.

You say:

“Show me all open opportunities from last week, owned by users in the Mumbai region.”

The bot:

  • Understands “opportunity” as an entity
  • Reads your metadata to confirm which fields match “open,” “last week,” and “region”
  • Constructs a real CRM query
  • Returns the results in a nice summary or even a table
  • Can export the results or help you take action — like closing them or assigning to someone else

A screenshot of a chat
AI-generated content may be incorrect.

Another example:

You say:

“Why is my lead conversion plugin failing for some records?”

The bot:

  • Checks for recent failures in your PluginTraceLog
  • Analyzes the logs using the same logic as our trace log analyzer
  • Gives you a plain-language explanation of what’s breaking
  • Suggests what you might fix in the plugin or data

🔁 It’s Not Static — It Talks Back

What makes this chatbot different is that it keeps asking the right follow-up questions:

“Do you want to filter this by owner?” “Should I show top 10 records or all?” “Would you like to update these now?”

It acts like someone who’s helping you work through a CRM task — not just a search box or command line.


🔍 Why This Matters

Most CRM tools still assume you:

  • Know the schema
  • Can build FetchXML queries or use Advanced Find
  • Understand what each plugin step is doing
  • Have time to jump between forms, logs, and docs

But most people just want to get something done or figure out what’s broken. That’s where natural language makes a real difference.


🧪 Use Cases We’re Seeing Already

  • Functional consultants using it to prepare data before demos
  • Junior devs using it to troubleshoot without writing code
  • Support teams asking why a record didn’t update
  • Architects mapping entity relationships without opening the solution

🎯 What It’s Doing Under the Hood

  • Reads your CRM metadata in real time (entities, fields, option sets, etc.)
  • Converts your prompt into a structured CRM operation
  • Performs the operation via Web API or analysis logic
  • Returns results + lets the LLM generate summaries or explanations

You don’t need to write any code or handle tokens — it does the heavy lifting quietly.


🔐 In Beta — and Free for Now

Right now, the chatbot is available to all beta users. It’s evolving fast, and we’re adding support for:

  • Multi-turn conversations that lead to actual CRM changes
  • Configurable actions (e.g. “always ask before saving”)
  • Metadata validation with real-time error checks
  • Relationship-aware queries

👉 [Try the Chatbot Now]

You can explore PowerMakerAI yourself here: https://powermakerai.com


We’re excited about this one. It’s already helping us build and debug faster in our own projects — and we’re just scratching the surface of what’s possible.

Let us know how you’d use this. Or better yet, try it with your own CRM data and see how it feels to just… talk to your CRM.

You could share the feedback at – powermakerai@gmail.com

Action ‘Update_a_record’ failed: An error has occurred. No resources were found when selecting for update – Fixing Cross-Company Update Issues in Finance & Operations Using Dataverse Virtual Entities (Power Automate)


Recently, while trying to update the Projects table in Finance & Operations using the Fin & Ops Apps actions in Power Automate, we ran into below error:

An error has occurred. No resources were found when selecting for update.

A screenshot of a computer

AI-generated content may be incorrect.

A screenshot of a computer

AI-generated content may be incorrect.

After digging deeper, we realised the issue had nothing to do with the payload or field mappings. The root cause was that the default company of the connection user in Finance & Operations was different from the company of the record we were trying to update. The Fin & Ops connector always operates in the context of the user’s default legal entity, and unlike the “List items present in table” action, it does not offer any “Cross Company” option for update operations. The result is that Power Automate looks for the record in the wrong company and, naturally, F&O returns a “record not found” error.

A screenshot of a computer

AI-generated content may be incorrect.

In our scenario, we had dual-write and virtual entities enabled. When this is the case, Finance & Operations exposes many of its data entities as Dataverse Virtual Tables. These tables are essentially real-time proxies: Dataverse reads and writes directly into F&O while automatically handling the underlying company and key structure. So instead of updating the F&O Projects table directly, we switched our Power Automate logic to update the corresponding virtual entity in Dataverse. That simple change immediately resolved the issue. The update worked flawlessly across companies, and we didn’t have to worry about the user’s default company or any cross-company flags.

A screenshot of a computer

AI-generated content may be incorrect.

This completed without errors, even for multi-company data.

A screenshot of a computer

AI-generated content may be incorrect.

There are other approaches as well, depending on how your environment is set up. We could bypass the connector entirely and make raw OData PATCH calls to F&O, as long as we manually specify the full composite keys, including the DataAreaId. Another option is to build a small custom API or X++ service that accepts a legal entity parameter, executes a changeCompany call in F&O, and safely performs the update on the server side. Both approaches work, but they require more configuration, authentication handling, and careful error management. For most day-to-day automation scenarios, the virtual entity route remains the simplest and most reliable.

In our case, switching to the Dataverse Projects (mserp) virtual table solved the issue immediately. The update completed without errors, even for multi-company data, and the flow became much cleaner.

A detailed explanation of this limitation can be found here, and was very helpful in troubleshooting:

Multiple legal entities issue with the Fin & Ops Apps connector in Power Automate

Hope it helps..

Advertisements

Fixing the “Only 1 of 2 keys provided for lookup, provide keys for dataAreaId, ProjectID / Not found” Error in Power Automate (Fin & Ops Apps)


Recently, while working with the Projects table from a Finance & Operations (F&O) environment, we ran into an error while using the Get a record action in Power Automate. (BTW this was the first we were using the Fin & Ops connector)

The flow kept failing with the following message:

Only 1 of 2 keys provided for lookup, provide keys for dataAreaId, ProjectID.

This error appears when we try to fetch a record from an F&O using only the ProjectID. But unlike normal Dataverse tables, F&O tables often come with composite keys.

Instead of passing just the ProjectID, we must pass the full composite key in the format:

dataAreaId,ProjectID

In our case, the correct value was:

AUST P-REP-34

Below, we can see it working properly

A screenshot of a computer

AI-generated content may be incorrect.

At one point, even after passing the correct composite key, we started getting a NotFound error:

Action ‘Get_a_record’ failed – NotFound

A screen shot of a computer error

AI-generated content may be incorrect.

Nothing had changed in the inputs — it was just not working. The fix was surprisingly simple..

We deleted the Get a record step, re-added it, provided the same inputs again, and the error disappeared. It could be related to the connection reference not being updated properly in the background.

Hope it helps..

Advertisements

Fixed – Error occurred while loading document template / Error occurred while loading preview error in Dynamics 365


Recently, one of the users reported the following error while trying to generate a PDF for a Quote record in Dynamics 365:

Initially, the Export to PDF option was showing a blank list of templates.

A screenshot of a computer

AI-generated content may be incorrect.

This happened because the user was missing a few essential privileges on the Document Template tables.

To fix the blank template list, we updated the user’s custom security role with the appropriate privileges on the following tables:

  • Document Template
  • Personal Document Template
A screenshot of a computer

AI-generated content may be incorrect.

After adding these, the templates started appearing in the “Export to PDF” dialog.

Even though the templates were now visible, the user still got the following error while trying to preview or export:

A screenshot of a computer

AI-generated content may be incorrect.

This was due to one missing privilege in the Customization area of the security role.

We added: DocumentGeneration privilege

A screenshot of a computer

AI-generated content may be incorrect.

Once this privilege was granted, the preview and PDF generation started working as expected.

If we are unsure which privilege might be missing in similar situations, a quick way to find out is by using Developer Tools (F12) and monitoring the Network tab while reproducing the error. The failed request, such as ExportPdfDocument, usually reveals the missing privilege directly in its Response section (for example, missing prvDocumentGeneration privilege). This saves time and avoids trial and error when troubleshooting permission issues.

Hope it helps..

Advertisements

Understanding “Block Deletion of Out-of-the-box Attribute Maps” in Dataverse / Dynamics 365


In Dynamics 365, attribute maps define how data flows from one record to another when creating related records. For example, when creating a Contact from an Account, fields like Address, Phone Number, and Website are copied automatically through predefined mappings. These mappings are part of standard Microsoft solutions like Sales, Customer Service, and Marketing.

If we try deleting these out-of-the-box (OOB) mappings, we will encounter an error — the platform restricts the deletion of system mappings to protect standard data flow and solution integrity.

A screenshot of a computer error

AI-generated content may be incorrect.
A screenshot of a computer

AI-generated content may be incorrect.

Using the Block Deletion of Out-of-the-box Attribute Maps feature setting, we can govern this behavior. Navigate to Environment → Settings → Features to locate this option.

A screenshot of a computer

AI-generated content may be incorrect.

When we disable this setting, the platform allows the deletion of OOB mappings.

A screenshot of a computer

AI-generated content may be incorrect.

A screenshot of a computer

AI-generated content may be incorrect.

In some scenarios, it could be applicable, like during lead conversion, where we may want to remove OOB mappings (like Address, Job Title, or Description) to populate these fields using external data. Some organizations use a custom quoting process instead of the OOB Opportunity → Quote flow. They remove the standard attribute maps that automatically copy data into Quote fields to prevent conflicts with their own automation.

However, even if these mappings are deleted, they can reappear when Microsoft pushes future solution updates. The recommendation is to only disable this setting if there is a specific and controlled use case, typically in a non-production environment, and with a backup plan in place. Keeping this setting enabled ensures consistency and prevents loss of important system logic that underpins Dynamics 365’s standard data flow.

Hope it helps..

Advertisements

Flows getting triggered multiple times / missing callbackregistration record – Power Automate / Dataverse


Recently, we observed that one of our flows was getting triggered multiple times in our UAT environment; however, the flow was working properly in our Development environment.

A screenshot of a computer

AI-generated content may be incorrect.

On comparing the flows trigger, we didn’t find any differences.

A screenshot of a computer

AI-generated content may be incorrect.

However, when checking for the callbackregistration record, we observed that for the Dev env, we had the callbackregistration record available.

A screenshot of a computer

AI-generated content may be incorrect.

However, it was missing for our UAT environment.

A screenshot of a computer

AI-generated content may be incorrect.

Turning the flow on and off didn’t create the corresponding callbackregistration record.

https://nishantrana.me/2025/09/02/fixed-flow-not-getting-triggered-incorrect-callback-registration-record-power-automate-dataverse/

Eventually, we deleted the trigger and recreated it in the UAT.

A screenshot of a computer

AI-generated content may be incorrect.

After recreating the trigger, we could see our flow getting triggered only once as expected.

A screenshot of a computer

AI-generated content may be incorrect.

However, we also noticed that the name of the callbackregistration record was not just the GUID, but it also had MTA suffixed to it in our UAT.

daf9fae3-a405-ee11-8f6e-00224817f864:MTA

A screenshot of a computer

AI-generated content may be incorrect.

So may this record was already existing and had an incorrect filter expression, which got fixed when we deleted and created a new trigger.

We also deleted this callbackregistration record, and turned our flow on and off. This created a new callbackregistration record with the same MTA suffixed to it.

A screenshot of a computer

AI-generated content may be incorrect.

So the solution here could be to find the callbackregistration record either with a GUID or with MTA suffixed to it, delete the record found, and turn the flow on and off.

Hope it helps..

Advertisements