Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Sharepoint and CDS

I have seen how to create a CDS entity from sharepoint but can an entity remain synchronized to a sharepoint list?

Power Apps
Power Apps



Thanks for posting - we have work underway at the moment to keep this syncronized. There is a preview coming out shortly that includes this functionality, if you're interested in being involved please send me a message.


I would like to help.  Let me know how.

I've yet to find any documentation or tutorials displaying or describing this functionality


You have two options - if you're using SharePoint as your datasource, and that is where you would like it to stay, you can build a Canvas app that connects directly to SharePoint without having to use CDS to store your data.


If you'd like to bring your data into CDS and build your apps from there, you can use PowerQuery to move that data from SharePoint into CDS - however this isnt a two way sync, so your data will only move from SharePoint to CDS. If you need your SharePoint list to be the master and be kept up to date, then connecting directly to your SharePoint list is probably your best option. 


You can read about creating an app directly against SharePoint here. You can also read about getting data from your SharePoint list into an entity from here.



I have several Sharepoint Lists to create, in multiple sites, that will have some duplicated fields. 

Is it possible to put the common data in the CDS and use Lookups to display the data in each of the Sharepoint Lists?

Thanks in advance

Not applicable

adding @CWesener back in to assist with the latest question in the thread.



I am having an error trying to load data from sp list there is any way to identify which is the error the message just says there is an error and an execution id

Any help will be appreciated

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,739)