Category: Power Automate / Flow

How to Authenticate and Use the Power BI API inside Power Automate

The Power BI API contains several useful pieces of functionality if you need to do interact with Power BI at a lower API level. Power Automate provides great automation features, and it’s only natural we would want to use the two together. Power Automate does have a Power BI connector, but we can get right to the Power BI API to unlock more features as well. Let’s look at how … Continue reading How to Authenticate and Use the Power BI API inside Power Automate

Refresh a Power BI Dataset with a Button Using the Power Automate Mobile App

In this post, we will look at how to refresh a Power BI dataset using the Power Automate (Flow) mobile app. We previously looked at how to refresh a Power BI Dataset using a Power Apps Canvas App. When using Power Automate, it’s even easier. First, log into Power Automate at https://flow.microsoft.com/. Create a new Instant – from blank Flow: Give the flow a name, e.g. Manually Refresh Power BI Dataset. … Continue reading Refresh a Power BI Dataset with a Button Using the Power Automate Mobile App

Deploying Microsoft Power Automate Flows from One Environment to Another

In this post, we will look at how to deploy Microsoft Automate Flows from one environment to another. Let’s say we have a Flow we have created in our Development environment and we want to deploy it to our Production environment. In our Development environment, we have a flow called “Power Virtual Agent Flow Template”, which we happened to create from a Power Virtual Agent bot. This flow is in … Continue reading Deploying Microsoft Power Automate Flows from One Environment to Another

Microsoft Flow becomes Power Automate and other Cool Features from Microsoft Ignite 2019

As announced in at the Microsoft Ignite 2019 conference in Orlando, FL, Microsoft Flow will now be known as Power Automate. The rebranding moves the product in line with the Microsoft Power Platform, which consists of PowerApps, Power BI and now (formerly Flow) Power Automate. Microsoft has been describing the Power Platform as a way to “analyze, act, and automate” data and processes, so it’s not a huge surprise that … Continue reading Microsoft Flow becomes Power Automate and other Cool Features from Microsoft Ignite 2019

Calling a Microsoft Flow from Dynamics 365 and PowerApps using JavaScript

In our previous post, we send a POST request to a Microsoft Flow. We showed how to do this using the Postman application. Let’s now run this from Dynamics 365 / PowerApps. On our Account page, we have a field called Partner Ranking. We see the ranking for the current account is set to 7: Now let’s say we want to post a message to a Microsoft Teams channel when … Continue reading Calling a Microsoft Flow from Dynamics 365 and PowerApps using JavaScript

Triggering a Microsoft Flow POST Request from Postman

In a previous post, we looked at how to trigger a Microsoft Flow using a GET request. In this post, we will show how to trigger a request using POST. We will do this using the Postman application to simulate our POST. We will use the same example as with the GET, where we post to a Microsoft Teams chat when the request comes in. Additionally, in our POST we … Continue reading Triggering a Microsoft Flow POST Request from Postman

Triggering a Microsoft Flow using a Webpage or HTTP GET Request

There are several use cases where you may want to run a Microsoft Flow from a web page or sending an HTTP GET request. Let’s do this. We will create a flow that runs when a user accesses a web address and performs the action of posting to a Microsoft Teams chat. First, let’s create an Instant Microsoft Flow by going to https://flow.microsoft.com and selecting New->Instant – From Blank: We … Continue reading Triggering a Microsoft Flow using a Webpage or HTTP GET Request

Installing Microsoft Flow Addin for Excel and Selected Row Email Demo

In this post, we will look at how to install and use the Microsoft Flow Add-In for Excel. First, open Excel and go to Office Add-Ins, then select Microsoft Flow for Excel (Preview). Click Add: You will see: The Add-in is now ready to use. Let’s create a new spreadsheet, Customers, with a column for the Customers, and we will make this selection a table by highlighting then selecting Table … Continue reading Installing Microsoft Flow Addin for Excel and Selected Row Email Demo

Using Microsoft Flow to Create Recurring Tasks in Dynamics 365

Microsoft Flow can be used to create recurring tasks in Dynamics 365. Let’s go through an example. Let’s say we want to send create a task that reminds a salesperson to call their customers every morning. Sign in to https://flow.microsoft.com. Select My Flows, then New: Pick Scheduled – From Blank: Set a date, time and frequency. The flow can run every Month, Week, Day, Hour, Minute and Second: Click Create. … Continue reading Using Microsoft Flow to Create Recurring Tasks in Dynamics 365

Dynamics 365 Conditional Branching in Business Process Flows

In this post, we will look at how conditional branching works with Business Process Flows in Dynamics 365. Let’s create a new BPF: We will call it Account Conditional Flow, and run it on the account entity: Let’s create a new Stage. Rename it to Stage1: And we will create add a new condition by clickind Add Condition, then selecting the + sign next to the Stage: We see our … Continue reading Dynamics 365 Conditional Branching in Business Process Flows