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

Power automate to loop through GL entries to identify new combinations

(6) Share

Report

Posted on by Curator

164

I am hoping to build a power automate flow in BC that will loop through the GL entries on a monthly basis to identify any new combinations of GL account, Dimension1, Dimension2 that have been posted. The aim will be to have these combinations recorded in a table in either sharepoint or a custom table. We'll then be using this to update some financial reports.

If I use the list records action in the flow, will the flow not be too slow in retrieving the records first (potentially up to 10,000 records a month)? After that we'll want to filter out those that are already in the combination table.

Is there a more efficient way to do this?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

Why you want to use Power automate. Dimension correction should be able solve your problem and also it has option schedule job queue to run in background

https://learn.microsoft.com/en-ca/dynamics365/business-central/finance-troubleshooting-correcting-dimensions

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (1)

Report

Unique combination anyway you can figure out from Dimension Set ID?

Is this not helping?

Was this reply helpful? Yes No
Curator 164 on at

Like (1)

Report

I also need to include the gl account number; the dimension set id on its own is insufficient. The aim is to automatically update a financial report that has combination of Gl account numbers and the 2 dimensions.

Not too sure where the other person who replied about dimension corrections is coming from.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, I personally don't recommend using Power Automate either.
Create a code unit to review your data monthly and then save it to SharePoint using the Graph API. This is much more efficient.

Hope the following can give you some hints.

Dynamics 365 Business Central Blog Series: Integrate Business Central with SharePoint

https://yzhums.com/63735/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (1)

Report

You don’t need to loop thousands of records in Power Automate. In Business Central you can handle this more efficiently with Dimension Correction and a simple report/query that lists new G/L + Dimension combinations. That way you avoid the performance hit, keep everything in BC, and still feed the results to SharePoint/Power BI if needed.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No