Dynamics Business Central / NAV Developer Digest - Vol. 457
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes adding table fields to pages without code extensions, performance improvements in Business Central for large data export to Excel with Microsoft Graph, and using AL namespaces in BC.
The Dynamics 365 Business Central community comprises professionals devoted to advancing the success of their customers. Developers, project managers, and consultants collaborate to share helpful information across blogs, forums, and social media sites. From discovering new solutions to finding answers to complex issues, these dedicated individuals are constantly sharing their knowledge with others. At ArcherPoint, we recognize and appreciate this highly engaged community’s creativity, hard work, and collective intelligence. To ensure all users can benefit from their expertise, we want to share their wealth of information with everyone.
Add table fields to pages without code extensions
A new feature in Business Central lets administrators, department owners, and partner consultants add table fields to their pages without requiring code extensions. This feature helps cut implementation costs and frees developers to focus on more strategic projects. Administrators can set permissions to determine who can add the table fields to pages. In addition, developers can protect sensitive table trees by excluding them from UI customization.
Find out more by visiting Mohana’s blog, Unlock Efficiency: Enhance Your Pages by Adding Existing Table Fields.
Performance improvements in BC for large data export to Excel with Microsoft Graph
A typical scenario in Dynamics 365 Business Central is exporting Business Central data to an Excel file and then saving the file to OneDrive or SharePoint. The simple, perhaps too obvious, solution is solving the problem with a Power Automate flow. This solution is easy and requires very little coding. The downside is that the Excel connector for Power Automate has actions to process records by rows, which can result in a performance hit when handling hundreds of thousands of records.
Stefano Demiliani addresses these performance issues using Micorosft Graph.
Find out more by reading his blog, Dynamics 365 Business Central and large data export to Excel via Power Automate: use Graph API.
Using AL namespaces in Business Central
Namespaces is a new feature in AL coming in BC 2023 release wave 2. Namespaces lets you organize code into logical groups to help prevent naming conflicts when libraries are combined, so you can reuse names when applied in different contexts. AL enforces two compiler rules when naming objects using namespaces:
- You can only have one object of a kind with the same name in a module
- You can only have one object of a kind with the same name in a namespace
Erik Hougaard explains namespaces and how they are used in his video, Finally we got namespaces in AL and Business Central, let’s try it out!
Interested in Dynamics NAV and Business Central development? Be sure to see our collection of NAV/BC Development Blogs.
Read “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.