Unanswered

How do I connect my Dataverse to Business Central?

(1) Share

Report

Posted on by SP-06021121-0

Hi All, could someone help me with my problem? I'm trying to connect my Dataverse(Mercury D365) to Business Central. The objective of this flow is to connect the client table/view in my Dataverse with the customer's table in Business Central. The outcome I'm looking for is that when I update a client within the Dataverse, it will simultaneously update the client/customer in Business Central.

So far, I've added "When a row is added, modified or deleted" within my database as my trigger. I've selected Modified as my change type, Clients as the table name, and Organisation for scope. I then added an "update record" to Business Central. I selected my environment and company.

I believe I'm missing something in the following steps: When selecting the API category, Table name, row ID, and Row, I selected Client name, Customers, Client Name, and Client ID.

I've looked at Microsoft Learn and YouTube videos but have found no solution. Some websites suggest doing a data integration on Business Central before using Power Automate, but I do not know if this is necessary.
Any help would be appreciated, even if it's just a link to some more reading material.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,369 Super User 2025 Season 2 on at

Like (1)

Report

Hi

So couple things

1. I dont actually see any specific details on the problem

2. Please make sure to share your flows, not just sorta a paragraph on them as that makes it hard to help and you 'll get skipped instead of helped most of the time.

What you are trying to do though should be very straight forward. I dont know if you want bidirectional (as you only talked about from Dataverse to BC.

So happy to help but please attach images and please make sure if there are errors to have those and my eyes are bad, so please make the images big enough for my old self to read and I'll happily help

Thank you

Was this reply helpful? Yes No
SP-06021121-0 2 on at

Like (0)

Report

Hi

Thank you for responding so quickly! Apologies, this was my first posting; I've attached the screenshots of my flow. I do not need the connection to be bidirectional. The outcome I'm looking for is when I modify a client record in my database. It will update the corresponding record within Business Central. For example, if I had Apple as a client within my database and I changed the name from Apple to Apple Inc. I want my client/customer record within Business Central to do the same.

Power automate ac...

Power automate Tr...

Was this reply helpful? Yes No