Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Common Data Service and SharePoint List

Can I connect a SharePoint List to a Common Data Service Entity (ala BDC)? 


I have some app solutions to build, CDS is a great place for the data due to complexity, but some of the data should be exposed via a SharePoint list. 


Am I missing something obvious?


Community Support
Community Support

Hi @philsspokas,


Yes, there is a way to connect Common Data Service with SharePoint List, take a look at the following article:

Load data from external data sources to the Common Data Service using Power Query





Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


The article discusses how to load data *into* CDS, but, not how to get data *out* of CDS.


I'm familar with using Power Query to load data, Power Apps to view data, Excel to "export" which is really a live connect.


What I'd like to see is the ability to connect a SharePoint List to CDS similar to what you can do with Business Data Connectivity to a SQL Server.





Hi, any updates on this? I know about the link you provided already. I'm looking to expose CDS data in SharePoint via a list.

Hi @philsspokas,


Thanks for following up - @v-micsh-msft any thoughts on @philsspokas's question of "[Is there an] ability to connect a SharePoint List to CDS similar to what you can do with Business Data Connectivity to a SQL Server?"




Not applicable

Is there any update regarding this question? 


I'm faced with exactly the same challange. If I could use information from entities from the common data modell to Tag Documents in SharePoint, this would help me managing MaterData fundamentally.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Kudoed Authors
Users online (2,338)