New Functionality In Microsoft Power Automate 2024 Wave 2: Create And Edit Expressions With Copilot

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 8th of the new functionality in the Cloud flows section is create and edit expressions with Copilot.

Makers can create, edit, and fix their Power Automate expressions by expressing their expression requirement in natural language. They can save a lot of time building expressions manually by invoking Copilot through this feature.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Oct 2024
General Availability: Nov 2024

Feature Details

Prior to this feature, makers needed to write complex expressions in their cloud flows in Power Automate to process data, or do conversions, manipulation, comparison, and others. With this feature, makers can create complex expressions or edit their existing expressions simply through submitting natural language prompts submitted to Copilot in Power Automate.

You need Copilot access in your tenant to use this feature, and turning off copilot turns off this feature too.

Natural Language is in the top box and Copilot generates an expression in the bottom box.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

New Functionality In Microsoft Power Automate 2024 Wave 2: Create A Flow On a File In Teams

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 7th of the new functionality in the Cloud flows section is create a flow on a file in Teams.

This feature allows you to create a flow on a file in Teams using one of the templates that are available to be done to a file. You can also use AI to create your flow from scratch.

Enabled for: Users, automatically
Public Preview: –
General Availability: Oct 2024

Feature Details

This feature allows you to set up and use workflows in Teams on files. You can create a flow on a file in the overflow menu of the Workflows app. Improve your productivity by using one of the templates that are available to be done to a file, or by using AI to create your flow from scratch.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

New Functionality In Microsoft Power Automate 2024 Wave 2: Connect To Other Environments From The Microsoft Dataverse Connector

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 6th of the new functionality in the Cloud flows section is connect to other environments from the Microsoft Dataverse connector.

Users can create flows that combine data and perform operations across different Microsoft Dataverse databases.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  Nov 12, 2023
General Availability: Nov 2024

Feature Details

Currently, you must use the Microsoft Dataverse (legacy) connector to connect to environments outside of the current environment. With this feature, you can connect to other environments from the Microsoft Dataverse connector’s actions and triggers.

My Opinion

It is not unusual for Microsoft Dynamics 365 Business Central clients to have more than one production environment, so this looks like it could be very useful.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

MADIC dynamics Knowledge Hub Webinars: How to Create a Multi-company Report in Jet Reports

MADIC dynamicsIn our most recent webinar here at MADIC dynamics, we took a look at how to create a multi-company report in Jet Reports. This is a webinar which I presented.

If you want to catch up on this webinar, you can do so here.

  1. Introduction
  2. Multi-company data in reports
  3. Multi-company by columns
  4. Multi-company by sheets
  5. Consolidation sheet using INDIRECT function
  6. Conclusion

Introduction ^

Jet Reports is a third-party add-on for Microsoft Dynamics 365 Business Central which is widely used along side Business Central. It is popular because it is very flexible, allowing reports to be created against any table in Business Central, whether from a standard or third-party table. It can be used to create both financial and operational reports.

Many of the clients I work with have multiple companies in Business Central and therefore a need for multi-company reporting.

In this webinar I took a look at the way that the Jet functions can be used to pull data from multiple companies into a single report. The webinar focused primarily on doing so using the GL function, but the same can be done with the NL function.

Multi-company data in reports ^

When you build or run a Jet Report the data, if you do nothing to override it, will come from the default company specified in the company selection on the Excel action bar:

Excel action bar showing the Settings tab of Jet Reports

Continue reading “MADIC dynamics Knowledge Hub Webinars: How to Create a Multi-company Report in Jet Reports”

New Functionality In Microsoft Power Automate 2024 Wave 2: Monitor Performance For Cloud and Desktop Flow Activities In Automation Center

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 5th of the new functionality in the Cloud flows section is monitor performance for cloud and desktop flow activities in Automation Center.

You can use a central consolidated view to monitor and understand the executions across cloud and desktop flows.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  Jun 5, 2024
General Availability: Nov 2024

Feature Details

With this feature, you have a single consolidated view to understand the automation performance across your cloud and desktop flows. This feature enables you to:

  • Understand the top trends across all of your automation assets (for example, success and failure) across different time periods.
  • Understand top errors and their trends.
  • Understand top flows with specific errors.
  • Seamlessly switch between cloud and desktop flows activity.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “Get Adaptive Card V3” Action

Microsoft Dynamics 365 Business CentralThis article is part of the In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… series, a sub-series 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.

There are a number of actions available in Power Automate for Business Central which allow specific actions against the data of Business Central to be performed from within Power Automate.

The 10th action which is available is the Get adaptive card (V3) one which allows you to create an adaptive card which you can use in Teams or elsewhere. This is a new action, introduced in the 2-23 Wave 1 release.

Within a flow, click the add action button; search for Business Central and select the Business Central icon (make sure you select the SaaS one, which is a dark colour instead of the on-premises one which is mainly white):

Choose an action dialog with Business Central in the search results

Continue reading “In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “Get Adaptive Card V3” Action”

New Functionality In Microsoft Power Automate 2024 Wave 2: Use Workflows On Calendar Events In Teams and Outlook

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 4th of the new functionality in the Cloud flows section is use workflows on calendar events in Teams and Outlook.

You can boost productivity with calendar-related templates to get ideas for scenarios you might be interested in.

Enabled for: Users, automatically
Public Preview: –
General Availability: Oct 2024

Feature Details

This feature allows you to create flows on existing and new calendar events. For example, you can configure a flow that is triggered to run at the start or end of a meeting.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “Run Action V3” Action

Microsoft Dynamics 365 Business CentralThis article is part of the In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… series, a sub-series 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.

There are a number of actions available in Power Automate for Business Central which allow specific actions against the data of Business Central to be performed from within Power Automate.

The 9th action which is available is the Run action (V3) one which allows you to run actions against records in Business Central, including posting journals, receiving and invoicing purchase orders, posting sales invoices and more.

Within a flow, click the add action button; search for Business Central and select the Business Central icon (make sure you select the SaaS one, which is a dark colour instead of the on-premises one which is mainly white):

Choose an action dialog with Business Central in the search results

Continue reading “In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “Run Action V3” Action”

End of Life for Microsoft Dynamics GP Announced

Microsoft Dynamics GPIn an announcement which cannot be a surprise to anyone, Microsoft have announced that Microsoft Dynamics GP is coming to the end of it’s life.

Today, we’re announcing we will end product support and updates for Dynamics GP on the 30th of September 2029 (with security patches ending on the 30th of April 2031). We want to take a moment to express our heartfelt gratitude to our loyal GP customers. Your trust and collaboration have been essential to building an incredibly strong GP community!…

I was a part of that community for nineteen years before I decided the writing on the wall was getting too large to ignore and made the switch across to Microsoft Dynamics 365 Business Central. That swith has seemed increasingly a good choice as I had come to expect an announcement like yesterdays.

The Dynamics GP roadmap has been updated to reflect this announcement:

Roadmap for Dynamics GP showing end of life and end of support

The Dynamics Communities site is hosting an interview with Microsoft’s Mike Morton, VP of Dynamics 365 BC and SMB, where he discusses the timeline for ending support for Dynamics GP.

Microsoft had already announced the end of Microsoft Dynamics GP On-Premises Licenses in 2025 and Subscription Licenses in 2026 which again was a huge red flag in terms of the future life of Dynamics GP; the new key dates to bear in mind for users of Dynamics GP is 30th September 2029 when there will be an end to produce support, product enhancements and regulatory updates and 30th April 2030 when there will the end of security updates.

What does this mean for users of Dynamics GP? Well, first thing is don’t panic!
Continue reading “End of Life for Microsoft Dynamics GP Announced”

In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “List Companies V3” Action

Microsoft Dynamics 365 Business CentralThis article is part of the In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… series, a sub-series 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.

There are a number of actions available in Power Automate for Business Central which allow specific actions against the data of Business Central to be performed from within Power Automate.

The 8th action which is available is the List companies (V3) one which was only made available in the 2023 Wave 2 release and allows you to get all companies in a given environment.

Within a flow, click the add action button; search for Business Central and select the Business Central icon (make sure you select the SaaS one, which is a dark colour instead of the on-premises one which is mainly white):

Choose an action dialog with Business Central in the search results

Continue reading “In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the “List Companies V3” Action”