Introduction to Dataflows in Power Apps

Подписаться 26 тыс.

Просмотров 23 тыс.

50% 1

Introduction to Dataflows in Power Apps
Hey Everyone,
In this video I'll walk you through step-by-step how to sync a SharePoint list to a Dataverse table using Dataflows. I'll also show you some of the sync settings which can give you the option to either keep the two data sources in sync or allow copies in the dataverse tables.
Table of contents
Introduction 0:00
What is Dataflows? 0:48
SharePoint list 2:53
Dataverse Table 3:13
Get data 3:20
SharePoint connector 3:58
Power Query 6:38
Dataflows 10:55
Rename the dataflow 11:30
Checkbox to delete rows that no longer exist 13:57
Show refresh history 18:15
Dataverse for Teams 19:42
Conclusion 20:21
Helpful Links:
- docs.microsoft.com/en-us/powe...
- docs.microsoft.com/en-us/powe...
- powerapps.microsoft.com/en-us...
- powerbi.microsoft.com/en-us/b...
#Dataflows #PowerApps #Dataverse #PowerQuery

Наука

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

8 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 49

@RezaDorrani 2 года назад

Awesome explanation & walkthrough on Dataflows 👏

@DanielChristian19 2 года назад

Thanks Bro!

@rachelpang8311 2 года назад

Daniel, you are the best! Not only about the information you are sharing with the community, but also your branding and PR as a technical professional.. so much to learn from you.

@DanielChristian19 2 года назад

Thanks Rachel, I appreciate that!

@FranciscoCamacho_fjcamachoj 2 года назад

Thanks Daniel. Great video!!! This also is very useful as a complement of your video for importing SQL Server data to SharePoint list!!!! Transform your data before importing!!!

@DanielChristian19 2 года назад

Exactly! Thanks for the compliment.

@analyticsadda6080 10 месяцев назад

Daniel your best. This is the video I am searching from the last two days.

@DanielChristian19 10 месяцев назад

Glad it was helpful!

@vinayayinapurapu 2 года назад

Awsome video Dan. I love your presentation and how you take care of all the visual things (like background and lightning effects) it just adds flavor to your session. You need to teach who to make affective videos :). Nice introduction of Dataflows and how it can be leveraged in common use cases. Can't wait to play with Dataflows for DVTs. Excellent work !!!

@DanielChristian19 2 года назад

Thanks for the compliment, Vinay.

@AudrieGordon 2 года назад

Excellent 'how to' and 'why do' video! Added to my favs!

@DanielChristian19 2 года назад

Hey Audrie, WOW! What an honor to have you visit my channel and comment on my videos. Glad you enjoy them.!

@JonDoesFlow Год назад

Excellent clear and concise video, thank you Daniel !

@DanielChristian19 Год назад

Glad it was helpful!

@samsiva2004 2 года назад

Beautiful. Thanks Daniel.

@DanielChristian19 2 года назад

Thank you too!

@365g 2 года назад

Hi Daniel - Thanks, great video on Data flows with 💠 crystal clear explanation of the process.

@DanielChristian19 2 года назад

Hey Gerard, Always a pleasure reading a compliment from you. Glad you found this vlog helpful!

@ArohShukla 2 года назад

Wow...this is so fantastic .. thanks for sharing Dan!!

@DanielChristian19 2 года назад

My pleasure!

@BLobregat 2 года назад

Thank you!! Amazing explanation

@DanielChristian19 2 года назад

You're very welcome!

@shaiksamad1562 2 года назад

Daniel.. You are just amazing.. Please keep sharing the valuable info and Thanks for your efforts. Just want to say the video background very nice and creative.

@DanielChristian19 2 года назад

Thanks Shaik, for the compliment!

@sundrapillay6668 2 года назад

Thanks Daniel

@DanielChristian19 2 года назад

You are most welcome, Sundra

@tMub365 2 года назад

That was awesome! ☺️

@DanielChristian19 2 года назад

Glad you liked it!!

@ajaychoudhary5596 2 года назад

Awesome Dan 👌👌👌🙏🙏🙏

@DanielChristian19 2 года назад

Thanks for the compliment, Ajay.

@julien8979 2 года назад

Thank you Daniel for the walkthrough on Dataflows, looking forward to advanced scenarios that can be covered in dataflows. I have a question if we have data of contact's information mobile numbers that are formatted in different ways in an excel sheet will it be possible to apply consistent format for all the mobile numbers and ignore the duplicates before the import process?

@DanielChristian19 2 года назад

Hi Julien, Yes, but it will be a multiple step process using Power Automate.

@danielzajac6921 2 года назад

Hello Daniel. You are the best teacher in youtobe. I have a question. I want creation request for user to select area of work. Quantity of area is 20. User should select area and flow should know area connection to person to approval. How can I setup this. User select area, muliple value also and how connet in approval?

@DanielChristian19 2 года назад

Hi Daniel, Thanks for the compliment. For the approval, you can use Power Automate to 1st get the user's manager and then the approval action. For the selection of area you build a simple canvas app.

@zafarahmadbhatti 2 года назад

Hi Daniel, great job, keep it coming . I have although a question related to data import. Are dataflows worth to import millions of records from 3rd party systems? Also if the data is huge, would the refresh mechanism ( Upsert ) still be efficient? Thanks in advance.

@DanielChristian19 2 года назад

Hey Zafar, That is legitimate question. I did a POC recently with an App maker and we pulled 2500 items successfully. I haven't tested millions of records ☺. However, my educated guess is that it will work since this is the same Power Query that Power BI users. Now, keep in mind, the more Power Query actions you add, the slower it will get.

@veerleswartebroekx6816 2 года назад

Thanks Daniel! One question, when an existing record gets updated in SharePoint, does it get removed and recreated at the next refresh? Just wondering because if that's the case I think we can't use it to import data that's used as a lookup by another table or can we?

@DanielChristian19 2 года назад

Your welcome Veerle. From what I'm seeing, the record in dataverse table gets updated and not recreated from scratch.

@geralddahl9159 2 года назад

Thank you for explaining this. Question: Does the sync work in both directions? If I change a Dataverse field, will that edit overwrite the connected source as part of the next sync process?

@DanielChristian19 2 года назад

You are welcome, Gerald. No, the sync only works one-way. Changes made to the SharePoint list will update the Dataverse table.

@geralddahl9159 2 года назад

@@DanielChristian19 Thank you.

@debasishroy4173 2 года назад

Hi Daniel, Great Video. Is there any way to trigger the refresh without having to click on the refresh button? example - whenever a row changes or added in SP List...etc.

@DanielChristian19 2 года назад

Hi Debasish, Yes you can using Power Automate flow. The trigger will be the SP list item change and the connector is Refresh a Dataflow.

@FranciscoCamacho_fjcamachoj 2 года назад

Thanks Daniel, great video!!! What about the storage limitations? It can be costly if you have a great amount of data. What is the best solution if you need a 5GB DB, more per user capacity?

@DanielChristian19 2 года назад

Hey Francisco, Good question! So I have seen a few companies prefer to purchase the Power Apps Per User License instead of paying for the additional storage capacity. This is a win-win because more users get the license and you get additional storage.

@nelsonvea4930 2 года назад

Hi Daniel, nice topic, I just have question regarding the records inserted, how you can reassign the ownership of the records created? Thanks, Nelson

@DanielChristian19 2 года назад

Hi Nelson, You can't make changes to the default columns created in the tables. If you plan to make changes then create a separate owners column which you can modify.