web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / BC CE integration Auto...
Small and medium business | Business Central, N...
Suggested answer

BC CE integration Automatic synchronization of Custom integration

(2) ShareShare
ReportReport
Posted on by Henki 8
Hi all,
 
I've created an integration with custom tables and am now looking at a way to automatically synchronize the integration when a new record is added in Dataverse. From what I understand I need to:

1. Create a Job Queue to run the synchronization per table
2. Create a Power Automate to create trigger the Job Queue
 
I cannot figure out however how to configure the Job Queue. What Codeunit should be running? Should I create a new Codeunit for the custom table that i created? 
I've looked everywhere on blogs and videos (yzhums was a big help but still doesn't explain what Codeunit to run), but I still don't understand. 
 
Hopefully some of you can help me:)
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 437 on at
    BC CE integration Automatic synchronization of Custom integration
    Namaste Henki  ,
     
     
    This Microsoft link will help what is job and how to scedhule it 
     
    This Microsoft link helps about the synchoronization done for Standard Tables with Dataverse . Only Coupled Records will be synced bothways . 
     
    This Microsoft Link helps how power automate is configured for syncrhonizing datverse and BCE 
     
    1) If you have used custom entity then create Codeunit , write procedure  and assign it in Job queue 
    Job queue . Below MS link will help you .
     
     
    2) if you are good hands-on power automate then create flow as explained in above link . Power automate has size limitations 
     
    I would prefer Option 1 . 
     
    If you feel it was helpful , please verify the answer 
     
    Regards 
    Pallavi
     
     
  • Suggested answer
    Chavda Dharmendra Profile Picture
    Chavda Dharmendra 853 on at
    BC CE integration Automatic synchronization of Custom integration
  • Suggested answer
    Nimsara Jayathilaka. Profile Picture
    Nimsara Jayathilaka. 1,076 on at
    BC CE integration Automatic synchronization of Custom integration
    Hi Henki
     
    When implementing automatic synchronization for custom tables in Business Central triggered by new records in Dataverse, the Job Queue plays a crucial role. The Job Queue in Business Central is designed to run specific tasks, typically encapsulated within Codeunits. For a custom table integration, you will need to create a new Codeunit that includes the synchronization logic tailored to your table's data and business rules. This Codeunit should define the OnRun() trigger which handles the actual sync process. Once the Codeunit is ready and published, you create a Job Queue entry configured to run this custom Codeunit. This setup ensures that each time the Job Queue runs, it executes your synchronization logic automatically.
     
    To trigger this process from Dataverse, you then create a Power Automate flow that acts as the event trigger — when a new record is created in Dataverse, the flow triggers the Job Queue in Business Central. This two-step approach leverages Power Automate’s ability to respond to Dataverse events and Business Central's Job Queue capability to execute the scheduled code. Without a custom Codeunit, the Job Queue cannot run your specific synchronization logic for the custom table, so it is essential to build and deploy such a Codeunit yourself. This pattern is widely used to automate integration workflows, providing scalability and reliability when processing new or updated records from external systems like Dataverse.
     
    Thanks
    Nimsara

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 2,856

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,681 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,342 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans