New Functionality In Microsoft Power Automate 2024 Wave 2: Maximize Your Productivity With Generative Answers

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 Copilot for Power Automate section is maximize your productivity with generative answers.

Copilot provides you with the ability to ask product related questions using natural language and receive prompt, precise answers, eliminating the need for time-consuming searches and waiting for support responses. This feature increases your productivity and allows you to have uninterrupted focus while developing your flows.

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

Feature Details

With Copilot’s generative answers functionality, you can easily find the information you need to create and manage your flows and any other aspect of Power Automate for desktop. The generative answers are integrated into the Power Automate for desktop UI in both the console and the designer, making it easy to access and use. Just type your question in natural language, and Copilot provides you with the most relevant information from our documentation. To use it, select the copilot icon in the console or designer UI and start getting answers to your questions.

Geographic areas

This feature will be released into the following Microsoft Azure geographic areas:

  • Germany
  • Norway
  • Singapore
  • South Africa
  • Switzerland
  • United Arab Emirates
  • US GCC
  • US GCC High
  • United States
  • Europe
  • Asia Pacific
  • United Kingdom
  • Australia
  • Brazil
  • Canada
  • India
  • Japan
  • France
  • Korea

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: Transform Scripting Using AI-Driven Natural Language

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 Copilot for Power Automate section is transform scripting using AI-driven natural language.

You can enhance efficiency and save valuable time and resources by using natural language and AI to generate the code in the scripting actions in Power Automate for desktop. This added capability allows you to describe your desired scripts and have AI automatically generate the necessary code for you. By doing so, you can streamline your flows automation and reduce the time and the effort required to write code for simple tasks, such as running PowerShell, VB, CMD scripts or executing SQL statements.

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

Feature Details

Natural language to Code is a new AI capability that we are adding in Power Automate for desktop that allows you to quickly generate code that is used in the scripting actions by just describing it. This feature is available in the “Run PowerShell,” “Run VBScript,” “Run DOS command,” “Run Python,” and “Run JavaScript” actions. You can simply describe what you want to achieve, and the tool will generate the script for you. This feature makes it easy for users who are not familiar with scripting languages to automate their tasks.

Geographic areas

This feature will be released into the following Microsoft Azure geographic areas:

  • Germany
  • Norway
  • Singapore
  • South Africa
  • Switzerland
  • United Arab Emirates
  • US GCC
  • US GCC High
  • United States
  • Europe
  • Asia Pacific
  • United Kingdom
  • Australia
  • Brazil
  • Canada
  • India
  • Japan
  • France
  • Korea

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: Automate With Ease Using The AI Recorder

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 3rd of the new functionality in the Copilot for Power Automate section is automate with ease using the AI Recorder.

The AI Recorder in Power Automate for desktop revolutionizes task automation by allowing users to simply record and explain their tasks using their voice and showing a task. This intuitive feature not only saves time but also leads to improved productivity and streamlined operations for businesses.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  Sep 2, 2024
General Availability: Mar 2025

Feature Details

The AI Recorder leverages cutting-edge Generative AI to interpret voice, mouse movements, and screen sharing to create a desktop flow. It’s like having a digital assistant that understands your process and automates it for you, making it an invaluable tool for any user looking to build automations.

Geographic areas

This feature will be released into the following Microsoft Azure geographic areas:

  • Germany
  • Norway
  • Singapore
  • South Africa
  • Switzerland
  • United Arab Emirates
  • US GCC
  • US GCC High
  • United States
  • Europe
  • Asia Pacific
  • United Kingdom
  • Australia
  • Brazil
  • Canada
  • India
  • Japan
  • France
  • Korea

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 an Image, File or Document 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 11th action which is available is the Get an image, file or document (V3) one which allows you to extract an mage, file or document from Business Central. This could be useful for things like extracting PDFs of invoices to OneDrive or SharePoint.

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 an Image, File or Document V3” Action”

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”