No video

Introduction to Dataflows in Power Apps

  Рет қаралды 23,859

Daniel Christian

Daniel Christian

Күн бұрын

Пікірлер: 49
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Awesome explanation & walkthrough on Dataflows 👏
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Thanks Bro!
@rachelpang8311
@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
@DanielChristian19 2 жыл бұрын
Thanks Rachel, I appreciate that!
@analyticsadda6080
@analyticsadda6080 11 ай бұрын
Daniel your best. This is the video I am searching from the last two days.
@DanielChristian19
@DanielChristian19 11 ай бұрын
Glad it was helpful!
@vinayayinapurapu
@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
@DanielChristian19 2 жыл бұрын
Thanks for the compliment, Vinay.
@AudrieGordon
@AudrieGordon 2 жыл бұрын
Excellent 'how to' and 'why do' video! Added to my favs!
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Hey Audrie, WOW! What an honor to have you visit my channel and comment on my videos. Glad you enjoy them.!
@FranciscoCamacho_fjcamachoj
@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
@DanielChristian19 2 жыл бұрын
Exactly! Thanks for the compliment.
@365g
@365g 2 жыл бұрын
Hi Daniel - Thanks, great video on Data flows with 💠 crystal clear explanation of the process.
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Hey Gerard, Always a pleasure reading a compliment from you. Glad you found this vlog helpful!
@JonDoesFlow
@JonDoesFlow Жыл бұрын
Excellent clear and concise video, thank you Daniel !
@DanielChristian19
@DanielChristian19 Жыл бұрын
Glad it was helpful!
@ArohShukla
@ArohShukla 2 жыл бұрын
Wow...this is so fantastic .. thanks for sharing Dan!!
@DanielChristian19
@DanielChristian19 2 жыл бұрын
My pleasure!
@shaiksamad1562
@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
@DanielChristian19 2 жыл бұрын
Thanks Shaik, for the compliment!
@samsiva2004
@samsiva2004 2 жыл бұрын
Beautiful. Thanks Daniel.
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Thank you too!
@danielzajac6921
@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
@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.
@BLobregat
@BLobregat 2 жыл бұрын
Thank you!! Amazing explanation
@DanielChristian19
@DanielChristian19 2 жыл бұрын
You're very welcome!
@ajaychoudhary5596
@ajaychoudhary5596 2 жыл бұрын
Awesome Dan 👌👌👌🙏🙏🙏
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Thanks for the compliment, Ajay.
@julien8979
@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
@DanielChristian19 2 жыл бұрын
Hi Julien, Yes, but it will be a multiple step process using Power Automate.
@tMub365
@tMub365 2 жыл бұрын
That was awesome! ☺️
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Glad you liked it!!
@zafarahmadbhatti
@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
@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.
@FranciscoCamacho_fjcamachoj
@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
@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.
@geralddahl9159
@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
@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
@geralddahl9159 2 жыл бұрын
@@DanielChristian19 Thank you.
@debasishroy4173
@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
@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.
@sundrapillay6668
@sundrapillay6668 2 жыл бұрын
Thanks Daniel
@DanielChristian19
@DanielChristian19 2 жыл бұрын
You are most welcome, Sundra
@nelsonvea4930
@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
@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.
@veerleswartebroekx6816
@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
@DanielChristian19 2 жыл бұрын
Your welcome Veerle. From what I'm seeing, the record in dataverse table gets updated and not recreated from scratch.
@julijazas
@julijazas 2 жыл бұрын
Is it possible to sync spo list with data source sql on premise?
@DanielChristian19
@DanielChristian19 2 жыл бұрын
Hi Julius, Yes, but you will have to use Power Automate for that. Dataflows are used only to sync with Dataverse.
How to Refresh a Dataflow Using Power Automate
10:31
Daniel Christian
Рет қаралды 12 М.
How To Import Excel to Dataverse using Dataflow
17:04
Daniel Christian
Рет қаралды 23 М.
Underwater Challenge 😱
00:37
Topper Guild
Рет қаралды 41 МЛН
Before VS during the CONCERT 🔥 "Aliby" | Andra Gogan
00:13
Andra Gogan
Рет қаралды 10 МЛН
Кадр сыртындағы қызықтар | Келінжан
00:16
Microsoft Dataverse Intro in 20 Minutes #Dataverse
19:46
April Dunnam
Рет қаралды 171 М.
Dataverse Dataflows as a sync mechanism
15:33
Microsoft Community Learning
Рет қаралды 11 М.
Process CSV files easily with Power Automate and Dataflows
20:25
Microsoft Power Platform
Рет қаралды 60 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 98 М.
Dataverse + Power BI: What you didn't even know you needed!
12:45
Guy in a Cube
Рет қаралды 60 М.
How to Turn Your Excel Spreadsheets into Power Apps
32:45
Lisa Crosbie
Рет қаралды 255 М.
Learn Power Apps from Scratch for Free: Beginner's Course Available Now
47:50
Technoobie Tutorials
Рет қаралды 73 М.
Underwater Challenge 😱
00:37
Topper Guild
Рет қаралды 41 МЛН