How to Refresh a Dataflow Using Power Automate

How to Refresh a Dataflow Using Power Automate
Hey Everyone,
In this video I'll cover how you can automatically refresh a dataflow when a change has occurred in the data source.
For example, I'll demo how to automagically keep the Dataverse table in-sync with the SharePoint list using Power Automate. I.e. when a change has occurred in the SharePoint list, the Dataflow will automatically kick-off. In addition, I'll also show how can we send an email notification to show the status of the refresh.
I highly recommend that you watch my 'Introduction to Dataflows in Power Apps' video first because this video builds on top of it.
Table of contents
Introduction 0:00
Quick review 1:04
Building the flow 1:50
Add the trigger 2:15
Add the Refresh a dataflow action 2:55
Add the When a dataflow refresh completes trigger as an action 4:30
Condition and email notification 5:55
Test 8:00
Conclusion 9:48
Helpful links
-docs.microsoft...
-docs.microsoft...
-docs.microsoft...
#PowerApps #PowerAutomate #Dataflows #RefreshDataflows #SharePoint #Dataverse

[@kimgaskins5537]

Great Daniel! I always learn from your series; you are among the favorites of my team here at the office!

[@DanielChristian19]

Wow, thanks for the compliment Kim!

[@aaron6516]

OMG... I was seriously just looking at how to do this and this popped up... how cool is that!!! Thank you so much this is super sweet!!!

[@DanielChristian19]

You are so welcome!

[@yeraldo05]

Really great both videos Daniel, there´s something new to learn every day! Note: I posted the first comment!!! Maybe because I live in Madrid and over there in America everyone is sleeping. Keep it up Daniel!!

[@DanielChristian19]

Thanks Yeriel, for the compliment.

[@louise1282]

Thank you Daniel, this is very helpful!!

[@DanielChristian19]

Glad it was helpful!

[@jessontvarghese327]

Awesome, sir. Thank you so much.

[@DanielChristian19]

Your welcome.

[@suhaimiabdazais]

Tqvm Daniel.. Cool.. I'm try now to refresh my sharepoint list till my dashboard

[@DanielChristian19]

Glad to help

[@samstuntteam]

Great video.... Keeping going...

[@DanielChristian19]

Thank you! Will do!

[@thiagofraletti4220]

Daniel, even with Pro licenses, it allow us to refresh 48 times a day for dataflows? I tested for datasets and 8 was the limit for me.

[@DanielChristian19]

You will need the Power Apps Per User license for this.

[@MizanNet]

Love the new dataflow series. Is there a SQL dataflow connector for dataverse for Teams?

[@DanielChristian19]

Glad you like them. Yes, there is a SQL connector for dataflow.

[@sundrapillay6668]

Thanks Daniel

[@DanielChristian19]

Thanks Sundra!

[@hamzachraibi4679]

Hi Daniel, I loved this automation until i get this error : The backend request failed with error code '400' Any Tips for fixing that ?

[@DanielChristian19]

Hi Hamza, 400 refers to an authentication related error. Check your connectors and see if they are active. You can also review this post in the community for some ideas community.powerbi.com/t5/Issues/dataflow-refresh-using-api-failed-400-bad-request/idi-p/628235

[@maxnomicon]

Hi Daniel, this works for Dataverse/Dataflow for Teams?

[@DanielChristian19]

Eventually. Currently it is in Preview. docs.microsoft.com/en-us/power-query/dataflows/dataflows-teams

[@nayeem3905]

Will this work for Power BI dataflow?

[@DanielChristian19]

It should. I have tested a few scenarios with SharePoint and SQL as the data sources.

[@vaibhavsharma8012]

thanks

[@DanielChristian19]

Welcome