From the Microsoft Dynamics 365 Business Central blogs: ExcelLayoutMultipleDataSheets; Azure Function SQL trigger; Managing scrap in manufacturing; String function

In this review of the Microsoft Dynamics 365 Business Central blogs:

• Introducing ExcelLayoutMultipleDataSheets in Business Central 2025 wave 1
• Azure Function SQL trigger: how to use it (and why it can be useful in your Business Central projects)
• Managing scrap effectively in manufacturing with Microsoft Dynamics 365 Business Central
• IncStr() now includes a new overloaded method—use it wisely

Introducing ExcelLayoutMultipleDataSheets in Business Central 2025 wave 1

Writing on his blog, Ammolh Saallvi stated that with the launch of Dynamics 365 Business Central 2025 wave 1, Microsoft introduced a new feature called ExcelLayoutMultipleDataSheets, aimed at improving reporting and data analysis for both developers and users. 

Saallvi noted that this feature resolves a common issue by allowing multiple datasets to be exported to separate sheets within a single Excel file.

He wrote that ExcelLayoutMultipleDataSheets is a new property for report objects that use Excel layouts, which lets developers link multiple data items or datasets to different sheets in an Excel file (.xlsx). He noted that this makes reports more organized and easier to navigate when they're exported.

And he stated that instead of cramming all data into one sheet, this feature allows you to create separate sheets for different datasets. He added that developers can now name data items and map them to specific sheet names, giving them more control and eliminating the need for complex workarounds.

In his blog post, Saallvi explained how to use ExcelLayoutMultipleDataSheets.

Azure Function SQL trigger: how to use it (and why it can be useful in your Business Central projects)

Writing on his blog, Stefano Demiliani stated that recently he held a training session on "serverless integrations for Dynamics 365 Business Central" at the Microsoft House in Milan.