New Functionality In Microsoft Power Automate 2024 Wave 1: Connect to Other Environments from the Microsoft Dataverse Connector

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

The 5th 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
Early Access: –
General Availability: Apr 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

In order to judge this enhancement, I need to get more up to speed on the Dataverse and specifically how it interacts with Business Central, as most of my work is with that ERP and the flows I create interact with it in some way.

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

New Functionality In Microsoft Power Automate 2024 Wave 1
Use Generative AI to Achieve a Process in AI Flows
Receive Intelligent License Recommendations for Admins
Be More Productive with Power Automate and Excel Desktop
View a Power Automate Visual in a Power BI Report
Monitor Performance for Cloud and Desktop Flow Activities
Connect to Other Environments from the Microsoft Dataverse Connector
Push Cloud Flow Execution Data into Application Insights
Use Your Own Encryption Key for Encrypting Data At-Rest for Existing Environments
Create Power Automate Flows in Excel
View Two Action Properties Panes Simultaneously
Use Undo and Redo While You Build Cloud Flows in the Designer
Use Copy-Paste for Container Actions Like Scope, Condition, and Apply to Each
Use a Simplified OData Editor in Actions like Get Items and Get Files
Manage Unpublished Solution-Aware Cloud Flows Using Admin APIs
Cancel all Flow Runs for a Version of a Flow
Create a Flow on a File in Teams
Cloud Flows are Automatically Defined in Dataverse Solutions
Use Workflows on Calendar Events in Teams and Outlook
Create AI Flows in Power Automate
Use Copilot with French Language
Recommendations to Reassign Orphaned Cloud Flows
Generate Descriptions for Cloud Flows using AI
Use Flows with Connections from Users in Copilot Studio
Use Process Mining Microsoft 365 Personal Recommendations
Create and Edit Expressions with Copilot
Get Quick Insights and Recommendations in Copilot for Process Mining
Troubleshoot with Copilot for Cloud Flows Execution
Automate With Ease Using the AI Recorder
Enter into a Conversation-first Copilot Experience to Build Flows
Transform Scripting Using AI-driven Natural Language
Maximize Your Productivity with Generative Answers
Streamline Workflow Creation with the Next Best Action
Generate Flow Description Using AI
Use Natural Language to Create a Flow in Teams
Leverage Desktop Automation with the Power Automate Plugin for Windows Copilot
Set Up Fallback UI Automation Mechanism
Power Fx Integration with Power Automate for Desktop
Use Power Platform Connectors in Power Automate for Desktop Actions
Use CyberArk Credentials in Desktop Flow Connections
Use Azure Key Vault Credentials in Flow Connections
Connect Your Own Virtual Network with Hosted Machine Group
View Attended Desktop Flow Runs Using Picture-in-Picture Execution Mode
Self-heal UI and Browser Automation Actions at Execution with AI
Use the Run Power Fx Expression
Use Python v3 in Power Automate for Desktop
Use Machine to Credential Mapping in Desktop Flow Connections
Create a Reusable Collection of UI Elements
Use Customer-managed Encryption Key for Hosted RPA
Automation Center to Monitor and Manage All Your Automations and Related Assets
Trigger Attended Desktop Flows in Picture-in-Picture
Use Copilot in Automation Center to Analyze Cloud Flow Runs
Trigger Attended Desktop Flows in Picture-in-Picture Mode Through the Power Automate Console
Use Copilot in Automation Center to Analyze Desktop Flow Runs
Use Copilot in Automation Center to Analyze Work Queue Data
Use Copilot in Automation Center to Ask Power Automate Product Questions
Use New Data Table Actions
Use New Excel Actions in Power Automate for Desktop
Use the New Desktop Flow Running Timeout Property
Ingest Process Data from Customers' Data Lake
Scale Faster with Power Automate Process Mining Thin Client App

New Functionality In Microsoft Power Automate 2024 Wave 1: Monitor Performance for Cloud and Desktop Flow Activities

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

The 4th of the new functionality in the Cloud Flows section is monitor performance for cloud and desktop flow activities.

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: May 2024
Early Access: –
General Availability: –

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.

My Opinion

This looks to be a good enhancement to monitoring which will allow you to see if any flows are problematic.

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

New Functionality In Microsoft Power Automate 2024 Wave 1
Use Generative AI to Achieve a Process in AI Flows
Receive Intelligent License Recommendations for Admins
Be More Productive with Power Automate and Excel Desktop
View a Power Automate Visual in a Power BI Report
Monitor Performance for Cloud and Desktop Flow Activities
Connect to Other Environments from the Microsoft Dataverse Connector
Push Cloud Flow Execution Data into Application Insights
Use Your Own Encryption Key for Encrypting Data At-Rest for Existing Environments
Create Power Automate Flows in Excel
View Two Action Properties Panes Simultaneously
Use Undo and Redo While You Build Cloud Flows in the Designer
Use Copy-Paste for Container Actions Like Scope, Condition, and Apply to Each
Use a Simplified OData Editor in Actions like Get Items and Get Files
Manage Unpublished Solution-Aware Cloud Flows Using Admin APIs
Cancel all Flow Runs for a Version of a Flow
Create a Flow on a File in Teams
Cloud Flows are Automatically Defined in Dataverse Solutions
Use Workflows on Calendar Events in Teams and Outlook
Create AI Flows in Power Automate
Use Copilot with French Language
Recommendations to Reassign Orphaned Cloud Flows
Generate Descriptions for Cloud Flows using AI
Use Flows with Connections from Users in Copilot Studio
Use Process Mining Microsoft 365 Personal Recommendations
Create and Edit Expressions with Copilot
Get Quick Insights and Recommendations in Copilot for Process Mining
Troubleshoot with Copilot for Cloud Flows Execution
Automate With Ease Using the AI Recorder
Enter into a Conversation-first Copilot Experience to Build Flows
Transform Scripting Using AI-driven Natural Language
Maximize Your Productivity with Generative Answers
Streamline Workflow Creation with the Next Best Action
Generate Flow Description Using AI
Use Natural Language to Create a Flow in Teams
Leverage Desktop Automation with the Power Automate Plugin for Windows Copilot
Set Up Fallback UI Automation Mechanism
Power Fx Integration with Power Automate for Desktop
Use Power Platform Connectors in Power Automate for Desktop Actions
Use CyberArk Credentials in Desktop Flow Connections
Use Azure Key Vault Credentials in Flow Connections
Connect Your Own Virtual Network with Hosted Machine Group
View Attended Desktop Flow Runs Using Picture-in-Picture Execution Mode
Self-heal UI and Browser Automation Actions at Execution with AI
Use the Run Power Fx Expression
Use Python v3 in Power Automate for Desktop
Use Machine to Credential Mapping in Desktop Flow Connections
Create a Reusable Collection of UI Elements
Use Customer-managed Encryption Key for Hosted RPA
Automation Center to Monitor and Manage All Your Automations and Related Assets
Trigger Attended Desktop Flows in Picture-in-Picture
Use Copilot in Automation Center to Analyze Cloud Flow Runs
Trigger Attended Desktop Flows in Picture-in-Picture Mode Through the Power Automate Console
Use Copilot in Automation Center to Analyze Desktop Flow Runs
Use Copilot in Automation Center to Analyze Work Queue Data
Use Copilot in Automation Center to Ask Power Automate Product Questions
Use New Data Table Actions
Use New Excel Actions in Power Automate for Desktop
Use the New Desktop Flow Running Timeout Property
Ingest Process Data from Customers' Data Lake
Scale Faster with Power Automate Process Mining Thin Client App

Working with Power Automate Child Flows: Error Encountered Saving a Flow Which Calls a Child Flow

Power AutomateThis article is part of the Working with Power Automate Child Flows series and of the larger 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.

If you create a child flow and call it from a parent, you may receive this error:

Child Flow Error

However, you will only be receiving the error if you have missed a step when creating the child flow; you need to change the run-only users setting, which I covered in this article.

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

MADIC dynamics Knowledge Hub Webinars: Extending Business Central with Power Automate

MADIC dynamicsIn our most recent webinar here at MADIC dynamics, we took a look at Extending Business Central with Power Automate.

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

What is Power Automate? ^

Power Automate is part of the Power Platform from Microsoft.

Power Platform is a collection of services which allow organisations to build their own solutions through low- or no-code services, such as Power BI (reporting), Power Apps (custom apps), Power Pages (websites) and Power Automate (automation). The idea is that they are low- or no-code and therefore do not require a developer to build the solution, and also allow for more rapid building than traditional applications, websites or other extensions.

We looked specifically at Power Automate in this webinar; Power Automate lets users create automated workflows between applications and services, allowing for repetitive business processes such as communications and approvals, to be automated.

As a relevant aside, I am currently writing two series of articles on Power Automate; the first is Working with Power Automate and the second is In Microsoft Dynamics 365 Business Central (Power Automate), how do I…. There is a large overlap between articles in those two series and this webinar, so I will be linking to the series where possible.

Types of Cloud Flow ^

There are four types of cloud flow available with Power Automate in combination with Business Central.

In the Microsoft documentation, they only show three types of cloud flow, but I always include the fourth, approvals, as this constitutes a large segment of the flows used by clients on Business Central, for users who have decided that the standard workflows don’t provide the flexibility required.

Icons for cloud flow types

Continue reading “MADIC dynamics Knowledge Hub Webinars: Extending Business Central with Power Automate”

Working with Power Automate Child Flows: Test the Parent/Child Flow Examples

Power AutomateThis article is part of the Working with Power Automate Child Flows series and of the larger 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.

With the child and parent flow examples created, they can now be tested. As the example parent flow, is an instant flow, to run the flow, go to the My flows page, select the parent flow in the list and click the button:

My flows page with the example parent flow button selected

Continue reading “Working with Power Automate Child Flows: Test the Parent/Child Flow Examples”

Working with Power Automate Child Flows: Add a Child Flow To a Parent Flow

Power AutomateThis article is part of the Working with Power Automate Child Flows series and of the larger 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.

With the child flow created and the run-only users setting changed, we can add the child flow to parent flows. In this article, I am going to create an example flow which prompts the user for a message which is passed into the child flow and then receives back and emails an output message from the child flow.

The parent calling a child flow, can be any type of flow, but for this example, I am creating an instant cloud flow. Do this by opening your solution and clicking New » Automation » Cloud flow » Instant:

Solution page with the new flow menu open

Continue reading “Working with Power Automate Child Flows: Add a Child Flow To a Parent Flow”

Working with Power Automate Child Flows: Change Run Only Users For Child Flow

Power AutomateThis article is part of the Working with Power Automate Child Flows series and of the larger 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.

After creating a child flow, there is one setting in the flow which needs to be set. This is to change the Run only users setting. Do this, by opening the flow to see the details and clicking the Edit button in the Run only users box in the lower right corner of the page:

Child flow detail page with Run only users section ringed

Continue reading “Working with Power Automate Child Flows: Change Run Only Users For Child Flow”

Working with Power Automate Child Flows: Create a Child Flow

Power AutomateThis article is part of the Working with Power Automate Child Flows series and of the larger 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.

Child flows in Power Automate are quite easy to create and there is actually very little difference between creating a child flow and a normal flow; the main difference is actually in the final step of the child flow. In this example, I’m going to create a simple child flow, including a step to send an email, just to show a complete flow.

Child flows are created as instant cloud flows. To create a child flow, open your solution and click New » Automation » Cloud flow » Instant:

Power Automate Solution page with the menu open to create a new Instant cloud flow

Continue reading “Working with Power Automate Child Flows: Create a Child Flow”

MADIC dynamics Knowledge Hub Webinar on Tuesday 19th March 2024: Extending Business Central with Power Automate

MADIC dynamicsHere at MADIC dynamics we will be presenting a Knowledge Hub Webinar at 1400 UK time on Tuesday.

Learn how Business Central can be extended with Power Automate, from approvals to process automation to document distribution and more.

The webinar is open to everyone who wants to sign up and join:

No march-2024 events found.

Working with Power Automate Child Flows: What are Child Flows?

Power AutomateThis article is part of the Working with Power Automate Child Flows series and of the larger 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.

As I mentioned in the article on managing large flows in Power Automate, there are two ways of managing large flows by breaking them down; the first is using scopes which allow you to segment a large flow into different sections, but this approach keeps the flow as one large flow and does retain some of the problems inherent in doing this.

The second approach is to break the large flow up into a number of child flows. This method forms part of a typical approach to ALM (application lifecycle management). As well as allowing you to break a flow down into multiple smaller flows, making them easier to understand and maintain, the child flowa approach means these smaller child flows become reusable, so you can use them again and again within different flows without needing to create the same set of steps within every flow. This can be very useful when creating a set of flows with similar purpose, such as a suite of approval workflows, where you need to check the users automatic reply settings on their mailbox to see if a delegation is required.

This re-usability is a key reason why child flows should be used wherever a set of steps would otherwise need to be replicated; by creating and calling the child flow each time, instead of replicating the steps, it is easier to maintain if changes are required in future, but also means there can be no variance in the logic which is applied to this set of repeatable steps.

There are some potential issues around using child flows, which it is probably worth mentioning:

  • Child flows are only available within a solution (technically there is a way to use them outside of a solution, but all your flows should be within a solution anyway as part of ALM and deployment to production via a managed solution.
  • Child flows are only accessible from within the solution they were created, so you can;t deploy two solutions and have them access the child flow.
  • Related to the above point, if you want to use the same child flow in a second solution, you need to manually recreate it as a new child flow within the second solution, as it likely won’t work correctly if you import it (the same is true of the parent flow calling the child).
  • Input variables can be passed from the parent flow to the child flow; if you need a lot of parameters passing in, then creating them as an array

As with much else around Power Automate flows, proper planning and design is required before you start building the flows.

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