Codeunits or Power Automate

(1) Share

Report

Posted on by Pragya752

234

Hello everyone,

Which is a better way to integrate an external system with Business Central if you have its APIs. Power Autoamte or Business Central codeunits using HTTPclient and run them via job queue? Power automate does not rollback the changes in case of error while job queue does revert. Also, we have to sync data real time so which one would be better.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Powerautomate will give you the facitlity with low code or No code, while in Business central side you have to build your logic and job queue will run it at minium 1 minute, if you want it real time, I would suggest go with Powerautomate and assign the particular trigger.

for the BC codeunit you can create an API and with procedures inbuilt and call it from Powerautomate.

Thanks

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,230 Most Valuable Professional on at

Like (1)

Report

Hi

You could review business events with power automate

Dynamics 365 Business Central and Power Automate Connector: create, modify, delete triggers things to know. – Stefano Demiliani

Dynamics 365 Business Central: Power Automate and multiple record changes limitation – Stefano Demiliani

Best

GR

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

If you want real-time, I doubt Power Automate will meet your needs, depending on the amount of data you have. This may require you to purchase additional licenses for Power Automate

If data interaction is very frequent, I vote for job queue.
If the frequency is once a day, both are fine.
Maybe Job Queue is easier to maintain, because if there is a problem, you have to check Power Automate.

Hope this can give you some hints.

Thanks

ZHU

Was this reply helpful? Yes No
Pragya752 234 on at

Like (1)

Report

" Power automate does not rollback the changes in case of error while job queue does revert. Also, we have to sync data real time so which one would be better." and what about this part?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

then you should go with Job queues.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

If you insert rows individually via the API, this is indeed not possible to rollback.

But, if you run code through API, for example [ServiceEnabled] procedure in Power Automate, I think this can be rolled back. This is the same as inserting data in the code. If there is no commit, it will rollback if an error occurs.

For example,

https://yzhums.com/20111/

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No