Showing results for 
Search instead for 
Did you mean: 
New Member

Updating CDS with data from SharePoint LIst





We are going to need more details on what issues you are encountering in order to help you out here. What issues are you encountering? What errors are you getting? Please expand this.








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

Thank you Alex for your response.

I have a SharePoint list which contains record and I am trying to get records from the Sharepoint list to my CDS. So I created an entity in the CDS and use the get data which connect to Sharepoint online using power query to get the data from my Sharepoint list to my Entities. During the settings for the refresh I choose automatic refresh and apply settings of every 3mins. In my share point list I have 425records, so after applying for settings I got 425records in my entities which is fine. I notice that on the first automatic refresh after 3mins it loads thesame 425 records to my entities again making the data in my entities to be 850 records on second refresh after 3mins it records in my entity increase to 1275 records. Please how do I resolve this issue to avoid duplicated record on my entities and also to allow only record that has been modified or newly created  in my SharePoint list load into my entity.


Thank you 


Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (29,468)