Olena's Dynamics Blog (post-AI)

As you know I am a very big fan of Dataflows. The biggest ask from me was always the ability to trigger the Dataflow refresh on demand from a Power App.

Initially, Dataflows you could only run from the maker portal. You need all sort of “powerful” security roles and permissions to do so.

As a user I want an ability to trigger a bulk import with Dataflows from Power Apps UI.

As an admin I want my users with the restricted security roles to be able to successfully run Dataflows from Power Apps.

Previously, we used a very resource consuming workaround to make this happened for our users.

Last month we’ve got proper tools for this with the new Power Automated trigger and action.

This how you could implement the bulk import trigger from Power Apps for Dataflows via Power Automate.

Step 1. Add a custom ribbon button to initialise the import.

You could do it with a traditional Ribbon Workbench way or a new and fancy way:

https://www.develop1.net/public/post/2021/07/25/commandingv2

Your button will look very similar to mine:

Step 2. Call a JavaScript from the ribbon

Your button will trigger a JavaScript function. My function looks like this code below:

 this.StartChargesImport = function (formContext) {
        'use strict';
        Xrm.Utility.confirmDialog('Are you sure you want to schedule bills and meters import for this batch? It will take aprox. 15 min for files to load. Please check your notifications and review the Process record for the updates.',
            function () {              

                //populate start charges import date to trigger flow
                var startChargesImportDate = formContext.data.entity.attributes.getByName("tm_importchargesstartdate");

                if (startChargesImportDate == null) return;

                var currentDate = new Date();
                startChargesImportDate.setValue(currentDate);

                formContext.getAttribute("tm_chargesrecordcount").setValue(0);
                formContext.getAttribute("tm_chargesloadedrecordcount").setValue(0);
                formContext.getAttribute("tm_chargesstatus").setValue(801090001);              

                formContext.ui.tabs.get("LoadData").setFocus();

                formContext.data.entity.save();
            });
    }

It updates the import start date and the status on the process header, also resets load records counts. THe record gets saved the next step will be…

Step 3. Dataverse connector -> When a record is created, updated or deleted Power Automate

Set one of the fields you updated from the JavaScript above as a column filter on your trigger. I set it to the Import Charges Start Date field.

Do whatever you need to do in your Power Automate flow then call the following action:

We use environmental variables for Group and Dataflow name.

Your Dataflow refresh settings has to be set to manual:

Step 4. When a Dataflow refresh completes trigger for Power Automate.

It’s an example of the refresh complete. No environmental variables here. We do it differently in our production system at the moment. But here you could check if the refresh was successful then update your record counts and statuses or send error messages to the Team channel if the run has failed.

This completes the whole ‘magic button” story to me.

Please comment or message me if you want to talk about Dataflows or Power Platform.