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

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 :)

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

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

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

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

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

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 marriage..... 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.

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

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 difficult?????

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!

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 😁

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?

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.

Wish this was available in the Teams Power Apps environment .

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?

Very helpful video Shane!! Thank you so much!! While exporting data from SharePoint to Dataverse I found couple of columns called Attachment and Attachments! How are they different?

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

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 ?

HI Shane Excellent video!! I learn a lot about power apps following your series. I have a question about the amount of data that could go into CDS in a plan 1 licence. I saw in the Microsoft site that says 50MB and I think that couldn't be right. Could you help to better understand that storage management question? Thank you in advance :)

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

Excellent! Have you tried connecting to an API or a website? I´m trying to create an app that includes countries and cities as well as addresses and I was looking to have address completion for US addresses and other countries if possible.

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

Does moving to and using data in CDS eliminate the delegation issues inherent with SharePoint? BTW... your videos have been most helpful in learning to use Power Apps, thank you.

Hey Shane thanks for the video , but i have a query i followed the same steps to get the data from SP List but when i tried it only got the Primary Column data rest other columns were not brought to Dataverse nor the columns or the Data's present in them

I'm getting an error while finishing creating the new table: "We encountered an unexpected error. Mashup text". Does anyone have the same issue?

I was playing with power query previously, but don't remember is it possible to skip rows if some data corrupted? For example if you are importing data from excel to sharepoint list.

Hi Shane, this is totally unrelated with the current video, but I wanted to ask if you could do a tutorial on the Google sheet flow connector. I tried to use it with the Twitter connector to insert a rows in the google sheet file I created everytime I get mentioned in I tweet, but it just wasn't working.

Hi Shane, thanks for the great video. Regarding the data update, if we get data updated in SharePoint, we can have it refreshed in CDS, but not the reversed way (ie, data updated in CDS will not be reflected or updated in Sharepoint). Is my understanding correct? thanks

Great video Shane. Just one thing, if I delete something in sharepoint List, and refresh to CDS, this item is going to be deleted/modified in CDS?

Please which license/subcription do I need to be able to do this?

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.

Nice

At 8:30 your're setting a primary name field. Why title? Couldn't you have two with the same title? Or isn't a unique ID field? Or should I just watch the last video?

May i know about any way to get data updated from CDS entity dataflow to SharePoint..vice versa

how to get data from excel in common data service?

Hi Shane ... I have excel which is not in table format which I want to import in Powerapps .. I haven't kept in table format because excel is in shared mode .. if it's in shared mode table format is not possible .. please help