Common Data Service Dataflows for Import from SharePoint and bulk Edit with Excel

In this video, we continue our journey of learning CDS together. To make learning easier I think importing data from somewhere you know, like SharePoint or SQL is the way to go. So I show you how to do so with Dataflows. Then because data always needs cleaned up we talk about the Excel add in that allows you to directly edit CDS data. So much fun!

[zaidkashour]

CDS is way better than Share Point online lists. I use more than 10 entities connected to each other with lookup fields. In Power Apps canvas apps, I stopped using filters in each gallery, I just change the entity source and data loads very quickly.
The hard thing to do is making complex operations in Model Driven apps the same way we do in canvas apps!
Thanks Shane for bringing more CDS topics to the channel :)

[brwoodlands]

Your intro rocks. I never get bored with it. Honestly watch the whole video because of your intro.

[jimfitch]

What great tools! Thanks for the clear explanation & usage tips!

[benjaminmillar]

Great videos Shane! Just caught up on a load of them in one go really easy to understand and honest. Great work.

[ewolthaus]

Great work again, Shane. Love your work and effort to create these videos. Thank you!

[brtp]

You are the man Shane!! thanks for sharing !!

[paulhaley]

Those two tips at the end - using the GUID in Edit in Excel and don't touch the keyboard when refreshing Power Query - are worth their weight in gold. If I had known those weeks ago I could have saved hours of frustration - you have probably saved my I would encourage people to use Solutions if they are creating Entities, Apps and Flows otherwise it can all get very messy. I still have some problems where lookup fields can't be found by the child entity; and Option Sets will sometimes take a text value but other times ask for an integer.

[adamwheeler]

You are definitely smart enough to teach Power Query especially as it relates to Data Flows. I am really struggling with how to take a Person column in SP and move that to User DataVerse lookup column via DataFlow. Why do they make this so

[richardclowes]

"Tells time like my wife" - man, you live dangerously!

[AssassinUK]

Excellent .. needed a video about the excel add-in as I never really got this to work.
Plus 1st comment smugness :-)

[JarrodMast]

Great video thanks Shane, perfect timing! But I do think there are signs you may be spending too much time talking to yourself in front of a camera 😁

[stoffer]

Love the videos Shane! One question. At the end of the video you mention that on several occations the refresh caused duplicates of all your values. This happens for me and I can't for the life of me figure out why and how to deal with it. Have you figured it out yet? Best regards!

[ksowjanya]

This video is great and helpful. Thank you for this video. I have a doubt.I am importing a csv file from sharepoint to dataverse using dataflow in dataverse. After I select Binary of required table, my flow stops at navigation step. I could not see the table.can you please tell what might be the reason?

[studiovolantis]

Wish this was available in the Teams Power Apps environment .

[myboyzdad]

I have a SharePoint List that I’d like to move to CDS. With this videos, I should be able to accomplish this task. Thank you. The big question: I have a PowerrApp that is connected to the SharePoint list, once I have the list in CDS, will the connection from my PowerApp to that source be seemless? Just connect to the new Entity, and change the source in PoweraApp? Easy peezy?

[pradipta]

Good one ...if i delete or add or modify in powerapps does it update SharePoint? Or only update CDS

[ewolthaus]

Please note: as far as I know, having the data sync from SharePoint (or any other source) to the CDS, it will override your changes to the data. Good to know if you plan to sync on a regular basis but also will edit the data in the CDS.

[ashokpershad]

Thanks a lot Shane...liked your video though CDS is something not comes free to account I use. It always ask for some special access level.

[mammifero]

Great video! one question: in a real world scenario you mantain both Sharepoint List and CDS Entities aligned or you choose only one enviroment to develop your application ?

[earllinealcide]

Hi Shane, was there a reason for you choosing 'Remove Columns' and not using 'Choose Columns' when you were in Power Query?