Category: Power Automate / Flow

Embedding a Dataverse Power Automate Flow Inside Power BI

Power Automate Flows can now be embedded inside Power BI reports, which opens many possibilities for performing functions within a Power BI report. In this post, we will look at this cool new feature. In a previous post, we showed how to embed a canvas app inside Power BI. Let’s take a look at embedding a flow. Note this functionality will reach General Availability in April 2024 and is part … Continue reading Embedding a Dataverse Power Automate Flow Inside Power BI

Power Automate Natural Language and Approval Flows

In this post, we will look at a new preview feature in Power Automate, the ability to use natural language to create Power Automate flows, and also the ability to build approvals with Dataverse using Power Automate. The technology behind the natural language flow creation is OpenAI, a descendant of GPT-3, which also powers GitHub Co-Pilot and Power Apps Ideas. First, let’s go to Power Automate and click on Create, … Continue reading Power Automate Natural Language and Approval Flows

Power Virtual Agents Sending Question Parameters to Dataverse

In a previous post, we showed how a Power Virtual Agent can look up dataverse data and return it to the person chatting to the bot. In this post, we will look at how the bot can ask a person questions, send the person’s answer as a parameter to the dataverse, and return data to the person. Specifically, we will look at the example where a customer asks about a … Continue reading Power Virtual Agents Sending Question Parameters to Dataverse

Power Virtual Agents Calling Dataverse to Answer Questions

In this post, we will look at how a Power Virtual Agent can lookup data in the Dataverse and answer questions intelligently to the person it is chatting with. We will go through a simple example where we display account data to the bot’s chatter. First, let’s create a new virtual agent in the Dataverse environment we want to look up data. Go to https://web.powerva.microsoft.com/environments/ to access your bot. Then go … Continue reading Power Virtual Agents Calling Dataverse to Answer Questions

Calling an APIM App Service from Power Automate

In this post, we will look at how to call an Azure App Service through an API Management endpoint from Power Automate. The service will require a subscription and also require the Bearer token to be passed through. First, we will create a new Power Automate flow, and add a new HTTP operation: Next, let’s configure it to get the bearer token: Now, run this and grab the resulting JSON … Continue reading Calling an APIM App Service from Power Automate

Power Automate Dataverse Adding Scope for Field Changes

In this post, we will look at using the Power Automate Dataverse connector to run only when specified fields change. In Power Automate, add a new Dataverse connector for Add, Modified, or Deleted. We see the Select Columns: Now, let’s say we only want this to run when some account fields change, specifically the Number of Employees and the Annual Revenue: We will add these fields to the select fields: … Continue reading Power Automate Dataverse Adding Scope for Field Changes

Installing and Using Power Apps in PowerShell for Admins and Creators

PowerShell can be used to manage Power Apps. Let’s look at how to use this, and some of the functions available for both Administrators and Creators of Power Apps. To install, open a PowerShell Command Prompt as Administrator and run the command: Install-Module -Name Microsoft.PowerApps.Administration.PowerShell Install-Module -Name Microsoft.PowerApps.PowerShell -AllowClobber Press Y or A to install: Note you can visit the Power Shell Gallery at https://www.powershellgallery.com/packages/Microsoft.PowerApps.Administration.PowerShell/: To see the many functions available: … Continue reading Installing and Using Power Apps in PowerShell for Admins and Creators

Creating an HTTP Listener with Power Automate

In this post, we will use Power Automate to create an HTTP Listener. This can be useful when subscribing to webhooks. Go to https://powerautomate.microsoft.com and select New Flow, then Automated Cloud Flow: Skip here: Select Request: And: We see: At this point, we can do anything with the flow, such as sending an email, integrating with 3rd party systems, etc. Let’s do something very simple. We will send an email. … Continue reading Creating an HTTP Listener with Power Automate