Тёмный

How to Refresh a Dataflow Using Power Automate 

Daniel Christian
Подписаться 27 тыс.
Просмотров 12 тыс.
50% 1

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.com/en-us/powe...
-docs.microsoft.com/en-us/powe...
-docs.microsoft.com/en-us/powe...
#PowerApps #PowerAutomate #Dataflows #RefreshDataflows #SharePoint #Dataverse

Наука

Опубликовано:

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 28   
@kimgaskins5537
@kimgaskins5537 2 года назад
Great Daniel! I always learn from your series; you are among the favorites of my team here at the office!
@DanielChristian19
@DanielChristian19 2 года назад
Wow, thanks for the compliment Kim!
@aaron6516
@aaron6516 2 года назад
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
@DanielChristian19 2 года назад
You are so welcome!
@yeraldo05
@yeraldo05 2 года назад
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
@DanielChristian19 2 года назад
Thanks Yeriel, for the compliment.
@louise1282
@louise1282 Год назад
Thank you Daniel, this is very helpful!!
@DanielChristian19
@DanielChristian19 Год назад
Glad it was helpful!
@jessontvarghese327
@jessontvarghese327 Год назад
Awesome, sir. Thank you so much.
@DanielChristian19
@DanielChristian19 Год назад
Your welcome.
@suhaimiabdazais
@suhaimiabdazais 2 года назад
Tqvm Daniel.. Cool.. I'm try now to refresh my sharepoint list till my dashboard
@DanielChristian19
@DanielChristian19 2 года назад
Glad to help
@samstuntteam
@samstuntteam 2 года назад
Great video.... Keeping going...
@DanielChristian19
@DanielChristian19 2 года назад
Thank you! Will do!
@MizanNet
@MizanNet 2 года назад
Love the new dataflow series. Is there a SQL dataflow connector for dataverse for Teams?
@DanielChristian19
@DanielChristian19 2 года назад
Glad you like them. Yes, there is a SQL connector for dataflow.
@sundrapillay6668
@sundrapillay6668 2 года назад
Thanks Daniel
@DanielChristian19
@DanielChristian19 2 года назад
Thanks Sundra!
@thiagofraletti4220
@thiagofraletti4220 2 года назад
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
@DanielChristian19 2 года назад
You will need the Power Apps Per User license for this.
@vaibhavsharma8012
@vaibhavsharma8012 2 года назад
thanks
@DanielChristian19
@DanielChristian19 2 года назад
Welcome
@hamzachraibi4679
@hamzachraibi4679 2 года назад
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
@DanielChristian19 2 года назад
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
@maxnomicon 2 года назад
Hi Daniel, this works for Dataverse/Dataflow for Teams?
@DanielChristian19
@DanielChristian19 2 года назад
Eventually. Currently it is in Preview. docs.microsoft.com/en-us/power-query/dataflows/dataflows-teams
@nayeem3905
@nayeem3905 2 года назад
Will this work for Power BI dataflow?
@DanielChristian19
@DanielChristian19 2 года назад
It should. I have tested a few scenarios with SharePoint and SQL as the data sources.
Далее
How To Import Excel to Dataverse using Dataflow
17:04
Introduction to Dataflows in Power Apps
21:23
Просмотров 23 тыс.
ПОЮ НАРОДНЫЕ ПЕСНИ🪗
3:19:41
Просмотров 1,9 млн
Amazing weight loss transformation !! 😱😱
00:24
شربت كل الماء؟ 🤣
00:31
Просмотров 12 млн
Dataverse Dataflows as a sync mechanism
15:33
Просмотров 10 тыс.
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
18:40