Working with Power Automate: What is a Scope?

Power AutomateThis article is part of the Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC.

I briefly introduced scopes in the last article of this series and thought I’d give a bit more detail on what scopes are and how they’re used.

Scopes in Power Automate are a type of action, but one which doesn’t do anything by itself.

Instead scopes are used to organise a flow, allowing you to group together related actions. As actions can be expanded and contracted, a scope allows you to control which scopes are expanded and the steps visible or not, making the view smaller when you close the scopes you’re not working on.

Scopes, like all actions, can be renamed so that they have a name which makes it clean what that action does; in terms of a scope, the scope name should clearly describe what the actions in the scope collectively do. For example, you might have a scope renamed to “Scope | Handle customer document on OneDrive”.

In addition, scopes can also be used to improve error handling (a topic I haven’t yet covered).Each action can have error handling attached to it for the result of that step, or, in the case of a scope, error handling for all the actions within the scope.

Working with Power Automate

Working with Power Automate
What is Power Automate?
What Type of Flow Are Available?
What Type of Cloud Flows Are Available?
Power Automate with Business Central
Working with Power Automate Solutions: What Are Solutions?
Working with Power Automate Solutions: What Types of Solution Are There?
Working with Power Automate Solutions: What is a Solution Publisher?
Working with Power Automate Solutions: Create a Solution Publisher
Working with Power Automate Solutions: Create a Solution
Working with Power Automate Solutions: Publish a Solution
Working with Power Automate Solutions: Version Numbering for Solutions
Working with Power Automate Solutions: Exporting An Unmanaged Solution
Working with Power Automate Solutions: Importing An Unmanaged Solution
Working with Power Automate Solutions: Exporting A Managed Solution
Working with Power Automate Solutions: Importing A Managed Solution
Working with Power Automate Solutions: Change the Managed Properties of a Solution Component
Create a Visio Diagram of a Flow
What Are Environment Variables and Why Should They be Used?
Create an Environment Variable
Create a New Cloud Flow From a Template
Managing Large Flows
What is a Scope?
Example of How to Use a Scope
Best Practice For Using Scopes
Working with Power Automate Child Flows: What are Child Flows?
Working with Power Automate Child Flows: Create a Child Flow
Working with Power Automate Child Flows: Change Run Only Users For Child Flow
Working with Power Automate Child Flows: Add a Child Flow To a Parent Flow
Working with Power Automate Child Flows: Test the Parent/Child Flow Examples
Working with Power Automate Child Flows: Error Encountered Saving a Flow Which Calls a Child Flow
Working with Power Automate Child Flows: Error Encountered With Surprise Extra Parameters for a Child Flow
Calculate 30 Days Ago

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Discover Report and Data Analysis Content Easily

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 1st of the new functionality in the Reporting and data analysis section is discover report and data analysis content easily.

End users can now discover report and data analysis content, including queries, reports, and Power BI pages, by using navigational search (Tell Me) or the new report explorer page. This feature minimizes the effort it takes to find report and data analysis content, making it more accessible and user-friendly.

Enabled for: Users by admins, makers, or analysts
Public Preview: Apr 2024
General Availability: Apr 2024

Feature Details

Business Central comes with many options for reporting, business intelligence (BI) dashboards, and data analysis. This release makes this content much easier to discover through search and a new report explorer page.

In the search experience, Microsoft include the title and description from teaching tips (if defined by the developer), so that users can better decide whether the report, page, or query is what they’re looking for to solve their analytics need.

The role explorer has explanations on all entries, so that when you hover over a report, page, or query, you’ll find:

  • The title and description from the teaching tip (if defined).
  • You can open the report, page, or query in a new browser tab without closing the explorer view.
  • An icon that helps you decide whether this is a report that delivers Excel or PDF files, whether the page is a Power BI report, or whether the query supports data analysis.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Achieve Sustainable Compliance with Business Central

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 3rd of the new functionality in the Legislation section is achieve sustainable compliance with Business Central.

This feature enables you to collect and report on your sustainability activities. The solution is the foundation that will be used for compliance with the European Union’s Corporate Sustainability Reporting Directive (CSRD) and other ESG standards..

Enabled for: Users, automatically
Public Preview: Apr 2024
General Availability: May 2024

Feature Details

Microsoft are introducing a groundbreaking feature focused on sustainability reporting. This new, easily extendable functionality lets you record and report on a wide spectrum of sustainability information, encompassing both qualitative and quantitative aspects, and forward-looking and retrospective data. You can also leverage the feature to actively reduce emissions, making it a valuable tool for small and midsized organizations seeking to comprehensively report on sustainability initiatives.

This feature ensures compliance with the European Union’s CSRD, which requires companies to report on the sustainability of their activities. The CSRD introduces a heightened requirement for reporting, impacting approximately 50,000 companies in the European Union—more than four times the number covered by the previous Non-Financial Reporting Directive (NFRD), which the CSRD supersedes. However, the solution will be built to ensure that ESG compliance aligns with other standards.

Continue reading “New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Achieve Sustainable Compliance with Business Central”

Error on Fixed Asset List Report when Filtering on Responsible Employee in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business CentralI was working on a project with a client recently which included implementing the Fixed Asset Management module of Microsoft Dynamics 365 Business Central. The module was configured, data imported and asset take-on posted and everything looked good.

When delivering training to the key users, I was showing a couple of the reports when I was asked about reporting on only assets held by an individual. This should not have been a problem, as we had configured the Responsible Employee field on the asset cards, so the assets were assigned. However, when I tried to show the Fixed Asset List report we encountered an error.

I added the field as a filter and just typed the name of the user into the box, but when clicking the Preview button, this error appeared:

GUID error on Fixed Asset List report

Continue reading “Error on Fixed Asset List Report when Filtering on Responsible Employee in Microsoft Dynamics 365 Business Central”

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 2nd of the new functionality in the Legislation section is automate country of origin listed for item tracking code in Intrastat reporting.

This feature enables users to include the country of origin in item tracking. This enhancement is poised to increase productivity by automatically inheriting the country of origin for items in sales documents from corresponding purchases, eliminating the need for manual intervention. This information will later be used in Intrastat reporting.

Enabled for: Users, automatically
Public Preview: May 2024
General Availability: Jun 2024

Feature Details

Intrastat currently uses Country of Origin from the Item Card. However, it’s common that users are buying the same item from different countries. The new Intrastat solution in Dynamics 365 Business Central improves the usage of country of origin by allowing users to set up a Country of Origin on an Item Tracking Code. With this new approach, the Country of Origin for Items in sales documents automatically inherits values from corresponding purchase documents based on the Item Tracking Code setup, such as lot number or serial number. This eliminates the need for manual intervention and potential mistakes. With this information, Intrastat reporting will be faster and more accurate.

My Opinion

This sounds like a useful bit of automation which should help to reduce errors in Intrastat reporting.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See VAT Date in Posting Previews

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 1st of the new functionality in the Legislation section is see VAT date in posting previews.

This feature provides better overviews, compliant accounting and reporting, and increased productivity related to VAT details.

Enabled for: Users, automatically
Public Preview: May 2024
General Availability: Jun 2024

Feature Details

With this feature, you can view the VAT Date when you post previews in documents and journals. When a document is posted, the VAT Date field is visible in VAT entries and in G/L entries. Now, you can see the VAT Date before you post, when you run the Posting Preview action. This feature is a continuation of the VAT improvements based on user and partner feedback.

My Opinion

Again, a feature I am surprised in missing, but good to see that it is being added.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

Working with Power Automate: Managing Large Flows

Power AutomateThis article is part of the Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC.

While you can build a flow with as many steps as required, they will, in my experience, become more and more unwieldy the larger they become. This means the flow is both hard to navigate and difficult to maintain as you need to do a lot of scrolling and hold the structure in your mind.

There are two ways that you can make flows easier to understand and manage.

The first is through using scopes, which allows you to group steps together into logical groupings.

However, this does have it’s limitations as the steps within the workflow are still contained within the same flow, meaning you still have the same number of steps within the flow.

The second approach, and the one which I’d say forms part of the ALM (application lifecycle management) is child flows. As well as allowing you to break a flow down into multiple smaller flows, making them easier to understand and maintain, the individual child flows also become reusable so you can use them again and again without needing to create the same set of steps within every flow.

Over the next few articles of this series, I’ll run through scopes and child flows with some further explanation and examples.

Working with Power Automate

Working with Power Automate
What is Power Automate?
What Type of Flow Are Available?
What Type of Cloud Flows Are Available?
Power Automate with Business Central
Working with Power Automate Solutions: What Are Solutions?
Working with Power Automate Solutions: What Types of Solution Are There?
Working with Power Automate Solutions: What is a Solution Publisher?
Working with Power Automate Solutions: Create a Solution Publisher
Working with Power Automate Solutions: Create a Solution
Working with Power Automate Solutions: Publish a Solution
Working with Power Automate Solutions: Version Numbering for Solutions
Working with Power Automate Solutions: Exporting An Unmanaged Solution
Working with Power Automate Solutions: Importing An Unmanaged Solution
Working with Power Automate Solutions: Exporting A Managed Solution
Working with Power Automate Solutions: Importing A Managed Solution
Working with Power Automate Solutions: Change the Managed Properties of a Solution Component
Create a Visio Diagram of a Flow
What Are Environment Variables and Why Should They be Used?
Create an Environment Variable
Create a New Cloud Flow From a Template
Managing Large Flows
What is a Scope?
Example of How to Use a Scope
Best Practice For Using Scopes
Working with Power Automate Child Flows: What are Child Flows?
Working with Power Automate Child Flows: Create a Child Flow
Working with Power Automate Child Flows: Change Run Only Users For Child Flow
Working with Power Automate Child Flows: Add a Child Flow To a Parent Flow
Working with Power Automate Child Flows: Test the Parent/Child Flow Examples
Working with Power Automate Child Flows: Error Encountered Saving a Flow Which Calls a Child Flow
Working with Power Automate Child Flows: Error Encountered With Surprise Extra Parameters for a Child Flow
Calculate 30 Days Ago

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Link Business Central Environments to Power Platform Environments

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 5th of the new functionality in the Governance and administration section is link Business Central environments to Power Platform environments.

Link your Business Central to a Power Platform environment from the admin center to provide a default target environment for integrations and apply Power Platform environment settings to your Business Central environment. This simplifies the integration process and reduces the need to specify the target environment for each integration.

Enabled for: Users by admins, makers, or analysts
Public Preview: –
General Availability: May 2024

Feature Details

Business Central integrates with many different Power Platform and Dynamics 365 products in various ways. In 2024 release wave 1, Business Central administrators are able to link a Business Central environment to a Power Platform environment from the Business Central admin center.

This capability provides the following benefits:

  • The Business Central environment will inherit settings that are enabled on the linked Power Platform environment in the Power Platform admin center, such as customer-managed encryption keys.
  • The linked Power Platform environment will provide a default target environment for any integrations set up between Business Central and other Dynamics 365 and Power Platform products, such as Dynamics 365 Sales and Power Automate.

Business Central environments can only be linked to Power Platform environments that are in the same Azure geography and are of the same type (production or sandbox). Linking environments isn’t a permanent operation, meaning it’s possible to unlink and relink environments. Environment lifecycle operations, such as updating or deleting an environment, on each of the linked environments is administered separately.

My Opinion

This was something I’d found odd when working with Power Automate, that there was no way of linking a Power Automate environment with a Business Central one. After all, I would want my development environment in Power Automate linked with my development one in Business Central, and the same for QA, UAT and production environments in both.

It’s good to see that this feature is being added; I think it will go quite some way to avoiding problems with a Power Automate environment being inadvertently linked with the wrong Business Central one.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Encrypt Data At-Rest with Customer-Managed Encryption Key

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.

The 3rd of the new functionality in the Governance and administration section is encrypt data at-rest with customer-managed encryption key.

This capability will allow customers to meet their data and privacy policy according to the standard privacy guidelines.

Enabled for: Users by admins, makers, or analysts
Public Preview: –
General Availability: May 2024

Feature Details

With Dynamics 365 Business Central 2024 release wave 1, customers will gain the ability to encrypt their environment database using their own encryption key. This feature, also known as customer-managed key (CMK), provides enhanced data protection and compliance for your business data. With CMK, you can use your own Azure Key Vault key to protect and control access to the key that encrypts your environment database. This gives you more flexibility and control over your encryption keys, such as the ability to rotate, revoke, or restore them.

This feature will be administered in the Power Platform admin center, and will require the Business Central environment to be linked to a Power Platform environment. Enabling CMK on a Power Platform environment linked to a Business Central environment will apply the same CMK policy on the Power Platform and Business Central environments.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1
Use Virtual Tables to Expose More Business Central Data in Dataverse
Improve Approval Processes via Power Automate
Add Table and Field Mappings for Existing Integration Tables
Find a Matching Record in a Power Automate Flow
Archive Projects
Usability Improves for Service and Projects
Use Deferral Codes in Purchase and Sales Journals
Define a Service Invoice Posting Policy for Various Users
Define Default Location for Project or Project Phase
Block Item, Item Variant or Service Item from Use in Service Management transactions
Connect Business Central With Shopify B2B
Set Up Financial Consolidation Runs More Efficiently
Simpler Shopify Connection
Use General Ledger Account Revaluation for More Accurate Financial Statements
Get More Productive While Entering Time Sheets
Create Projects That You Can Invoice to Multiple Customers
Assemble to Project
Invoice a Customer for Multiple Projects
Use New Excel Layouts for 35 Selected Reports
Use Standard Terminology for Project Management
Use Currencies When Posting Employee Transactions
Manage Work Orders in Field Service, Invoice Them in Business Central
Manage Document Attachments in Service Items and Documents
Export and Import Multiline Text Using Configuration Packages
Correct Errors in Service Invoices
Prevent Editing Number Series on Service Documents and Cards
Be More Productive When Approving Time Sheets
Inventory Package Numbers Work Like Item Tracking Dimensions
Assign Salesperson to Customer Ship-to Addresses
View Incoming Documents in Archived Quotes and Orders
Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
Allow Lines with Amounts of Zero on Recurring General Journals
Automate the Reminders Process in Collections
See Improved Usability for Warehouse and Inventory
Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
Use a New Role Center for Collection Management
Manage Subscription Billing and Revenue and Expense Recognition
Enable Sustainability Features for Integrations with APIs
Install Field Service Integration with Business Central from AppSource
Introduce Power Automate Copilot Integration with Business Central
Map e-Documents to Purchase Order Lines with Copilot
Create Sales Lines Easily with Copilot
Extend Copilot Using Richer Development Tools
Get to Insights Faster with Copilot-Generated Analysis Tabs
Complete Bank Account Reconciliation Faster With Copilot
Create Product Information Faster with Copilot
Learn More About Fields with Copilot
Chat with Copilot
Simplify collections with Copilot for Finance and Business Central
Automate Tests for your Copilot Extensions with the Business Central Test Toolkit
Automate IRS 1099 Form Submission in US
Enable Additional Countries and Regions
Install UK Localization as an App
Process Czech Bank Statements, Payment Orders More Productively
Improvement of Czech Localization Reports
Report Explorer has Additional Outputs in the Czech Version
Improved Updates of ARES Data in the Czech Version
Allow More Extendability of Advance Payments in the Czech Version
Print QR Codes on Sales Invoices in the Czech Version
Use Excel Layouts for Czech Reports
Handle Multiple File Uploads and File Drop Zones
Debug the System Application
Remove Friction When Working with External App Dependencies
Use In-client Page Scripting Tool for Acceptance Testing
Use AL-controlled Barcode Scanning For All Scenarios
Write flexible and performant code with NumberSequences
Use the OData V4 IN Operator in Web Service Queries
Define Extension Objects in Same App as Their Base Object
Use Cookies in HTTP Calls From Business Central
Define Tooltips on Table Fields
Use Linked Environment in Dataverse Integration
Audit Business Central Operations in Microsoft Purview
Encrypt Data At-Rest with Customer-Managed Encryption Key
Allow Customers to Consent to Microsoft Support Accessing Their Data
Link Business Central Environments to Power Platform Environments
Copy Companies with Dataverse Integration Safely
View and Filter Users With Additional User Details
Control partner access per environment
Analyze Telemetry Events Across Browser and Server for a Session or User
Use Premium License to Sign In to Environment with Essentials Licenses
Experience the New Embedded AppSource Marketplace Page
Migrate Record Links and Notes with Cloud Migration Tooling
See VAT Date in Posting Previews
Automate Country of Origin Listed for Item Tracking Code in Intrastat Reporting
Achieve Sustainable Compliance with Business Central
Discover Report and Data Analysis Content Easily
Use Drag and Drop to Attach Multiple Files
Use Actions to Navigate and Highlight or Fix Platform-Generated Errors
Share Error Details to Get Help from Another User
Access Worksheet Pages from Mobile Phones
Boost Productivity With the Modern Action Bar
Enhancements to the User Experience

In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Flow for Business Central From a Template

Microsoft Dynamics 365 Business CentralThis post is part of the In Microsoft Dynamics 365 Business Central (Power Automate), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

In the last article of the Working with Power Automate series, I showed how a flow could be created from a template; the example I used was a Business Central purchase order approval flow. However, while I showed the flow being created from the template in the Power Auto,ate portal, they can also be created from a template within Business Central itself.

The process is actually very similar to manually creating a flow from within Business Central; on a page, click the Automate » Power Automate » Create approval flow action:

Purchase Order page showing the Automate » Power Automate action menu expanded

Continue reading “In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Flow for Business Central From a Template”