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


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (18,670)