Small and medium business | Business Central, N...

Generate automated access report for business central

(5) Share

Report

Posted on by AmritaSengupta

Hello,

We have a requirement to provide an automated report from Business Central with the permission of all the users.

Has anyone done this before?

In Power Automate, I do not see any corresponding actions.

Many thanks!

Amrita

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi @AmritaSengupta,

As per my knowledge, the standard Power Automate connector cannot access user permissions. One of the solution is to create a custom API.
Custom API
1. In Business Central (Developer Task):
    Developer can create a simple API page in AL code. This page will expose a list of users and their assigned permission sets.
2. In Power Automate (Your Task):
       Trigger: Use a `Recurrence` trigger to run the Flow on a schedule.
       Action: Use the standard Business Central `Find records` action to call the new custom API   endpoint.
       Report: Format the data using `Create HTML Table` or `Create CSV Table`.
       Deliver: Use the Outlook connector's `Send an email` action to send the report.
Official Microsoft Links
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-custom-api

Please verify it in case it helps.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

The standard Power Automate only supports outputting data or attachments and cannot automatically generate a report.

The simplest solution is to customize a small codeunit, set it to the Job Queue, and send it regularly.

Hope the following can give you some hints.

https://businesscentralgeek.com/5-ways-to-send-an-email-in-business-central

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

You can access the data in Power Automate only using the API, and we don't have a standard API for users or permission sets. If you need a file or Excel document, you can create it in AL instead of using Power Automate. Create a report or codeunit, export the Users and their permission sets, and then add the code to send an email or export to a file. Schedule this using Job Queue.

Was this reply helpful? Yes No
AmritaSengupta 70 on at

Like (2)

Report
Copy link

Link copied!

Thank you @Suresh Kulla, @YUN ZHU, @Sumit Singh.

I am taking a look, but I don't see a table/entity holding the user base of the tenant.

Which is what we want to retrieve in the report - Users + corresponding permissions + assigned licenses.

Does BC exposes this table/entity for API development?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

As far as I know, the standard does not expose this information. You need to create a custom API to display this content before you can get it in Power Automate.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Chavda Dharmendra 1,000 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Hello Amrita,

You require to create custom report and API in business central.

Once you created report then call API from Power automate to capture data.

Sample code for retrieved Report into API with base64.

[ServiceEnabled]

[Scope('Cloud')]

procedure Exportreport(): Text

var

SalesInvoiceReport: Report "Sales Invoice Report";

TempBlob: Codeunit "Temp Blob";

Base64Convert: Codeunit "Base64 Convert";

FileText: Text;

MyOutStream: OutStream;

MyInStream: InStream;

begin

//SetTableView and SetReqFilter if required

TempBlob.CreateOutStream(MyOutStream);

SalesInvoiceReport.SetTableView(Rec);

SalesInvoiceReport.UseRequestPage(false);

SalesInvoiceReport.SaveAs('', ReportFormat::Pdf, MyOutStream);

TempBlob.CreateInStream(MyInStream);

FileText := Base64Convert.ToBase64(MyInStream);

exit(FileText);

end;

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Namaste Amrita ,

RCA

Since Permission Sets and Users are system base tables (not company-specific), they cannot be exposed directly as APIs.

Solution

You need to create a script that pushes this data into custom tables, which can then be published as APIs and consumed as required.

Whenever a new user, permission, or permission set is added, the script should capture and update it in the custom tables.

If this approach works for you, you can proceed with the implementation, and in case you face any challenges with the scripting, please let us know

If you find this helpful , please verify the answer

Regards

Pallavi Phade

1 people found this reply helpful.

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

Like (2)

Report
Copy link

Link copied!

Hi

You could look into other solutions like PowerbI by accessing OData or APIs, or a native report by accessing the corresponding tables.

Best

GR

Was this reply helpful? Yes No
Suggested answer

Sahan Hasitha 2,683 on at

Like (2)

Report
Copy link

Link copied!

Use Power BI (Optional)

If you prefer dashboards, you can:

Create a Power BI report based on the User and User Permission tables.

Schedule refreshes to provide up-to-date permission information.( 8 time )

1 people found this reply helpful.

Was this reply helpful? Yes No