Millington Offices (10).png

Edit your data directly from Power BI using PowerApps Part 2 - Building an approval workflow


First part of this post:

Edit your data directly from Power BI using PowerApps (datapears.com)



In last week's post, we talked about how you can use PowerApps to edit data directly from your Power BI report. But what if you want that data to be verified before it is actually written back to your data source?


Well, in that case, you probably need to think about how you can build an approval workflow, so that your data is only written back to your data source after someone approves it.


Having this, today we are going to add an extra step to our solution, building an approval workflow using Power Automate. Here is a very simple architecture of our solution:


So, as you can see from the image above, our Power BI report gets it's data from an Azure SQL database. On the other end, our PowerApp will read the data coming from Power BI, but also from SQL, as we want to be able to write back to our data source.


Once the PowerApp form is submitted, a Power Automate Flow will be triggered. This flow will send an approval request email, which the user needs to reject or approve. Once this request is approved (and only when it's approved!), your new value will be written back to the database.


Curious? Let's get to work!!


Reminder from last post: the data we are using is from a SQL Server table called Auto Trader, that has data about used cars (Brand, Model, Price etc).




1) Go to Power Automate and create a new Instant Flow:

> Click on Create

> Choose Instant Flow

> Name your flow

> Select the PowerApps trigger

> Click on Create




2) Now we are going to add a new step that will allows us to retrieve the data from our original data source in Azure SQL: