Can I run Business Central Reports from Power Automate?

(2) Share

Report

Posted on by SO-14020048-0

I have a Power Automate flow, and I would like to run a specific report from the Customers I have queried in my flow.

I am trying to use the "Run action (V3)" action for Business Central to try running the flow, but the "Name of the OData procedure" doesn't have anything relevant to my report.

I am new to Business Central, so I don't understand how to run this report.

After running the report, I would like to attach it to an email.

Categories:

Dynamics 365 general

Power Platform integration

I have the same question (0)

All responses (2)

Answers (0)

ArchitectMadhan 458 on at

Like (0)

Report

Can I run Business Central Reports from Power Automate?

Hi,

I think that provision is already there in Dynamics 365 Business Central, to send auto reports as email based on schedule.

https://community.dynamics.com/forums/thread/details/?threadid=b903b8c5-3e33-4410-bbd9-efdfce45fb1e

or try with below approach using Power BI & Power Automate (in this case your D365 BC data should be made available for Power BI report)

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export

If you find this solution useful, please like it and accept it as answer.
-ArchitectMadhan

Was this reply helpful? Yes No
JP-21101044-0 2 on at

Like (0)

Report

Can I run Business Central Reports from Power Automate?

Would it be possible to "scale" this built-in function to run and retrieve multiple reports (60+)?

Every month after month close, I have to download a lot of reports, which as you can imagine can be quite time-consuming.

But they all have the same template (data and layout), file type (csv), and date (last day of previous month).

Could this process not be automated through either BC or Power Automate? I'm happy to trigger it myself and change the date, but I think that the rest could be done automatically (there is one filter applied, which does change, happy to do a bit of leg-work and set that up initially to save time in the long run).

Hopefully this is something relatively straight-forward, as I think this could be of benefit to a lot of people.

Was this reply helpful? Yes No