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.
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 !!!
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!!!
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.
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?
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.
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?
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?
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.
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.
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?
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.
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?
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.
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.
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.
Thanks Rachel, I appreciate that!
Awesome explanation & walkthrough on Dataflows 👏
Thanks Bro!
Daniel your best. This is the video I am searching from the last two days.
Glad it was helpful!
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 !!!
Thanks for the compliment, Vinay.
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!!!
Exactly!
Thanks for the compliment.
Excellent 'how to' and 'why do' video! Added to my favs!
Hey Audrie,
WOW! What an honor to have you visit my channel and comment on my videos. Glad you enjoy them.!
Excellent clear and concise video, thank you Daniel !
Glad it was helpful!
Wow...this is so fantastic .. thanks for sharing Dan!!
My pleasure!
Hi Daniel - Thanks, great video on Data flows with 💠 crystal clear explanation of the process.
Hey Gerard,
Always a pleasure reading a compliment from you. Glad you found this vlog helpful!
Beautiful. Thanks Daniel.
Thank you too!
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.
Thanks Shaik, for the compliment!
Thank you!! Amazing explanation
You're very welcome!
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?
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.
Awesome Dan 👌👌👌🙏🙏🙏
Thanks for the compliment, Ajay.
That was awesome! ☺️
Glad you liked it!!
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?
Hi Julien,
Yes, but it will be a multiple step process using Power Automate.
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?
You are welcome, Gerald.
No, the sync only works one-way. Changes made to the SharePoint list will update the Dataverse table.
@@DanielChristian19 Thank you.
Thanks Daniel
You are most welcome, Sundra
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.
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.
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?
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.
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?
Your welcome Veerle.
From what I'm seeing, the record in dataverse table gets updated and not recreated from scratch.
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.
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.
Hi Daniel, nice topic, I just have question regarding the records inserted, how you can reassign the ownership of the records created?
Thanks,
Nelson
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.
Is it possible to sync spo list with data source sql on premise?
Hi Julius,
Yes, but you will have to use Power Automate for that. Dataflows are used only to sync with Dataverse.