cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
robertopolo
Advocate I
Advocate I

Sharepoint list connector does not work

I want to start by saying that I don't know English. So any mistakes, please excuse me.

I am trying to get data for CDS from a sharepoint list. When I use the connector it doesn't show me any list. I do a test using the OData connector by adding _vti_bin / ListData.svc to the end of the link and if I can access the lists. I must note that the language of the site, tenant and environment is Spanish.

1 ACCEPTED SOLUTION

Accepted Solutions
renatoromao
Super User
Super User

Hi @robertopolo ,

 

Yes, when we are using SharePoint connector to import data to CDS entities, we got some problems sometimes.

 

Regarding your question, I recommend to use OData connector and follow these steps:

1- Connect to OData connector

2- Insert https://yourtenant.sharepoint.com/sites/yoursitecollection/_api/Web/Lists/GetByTitle('List title')/Items  in the URL field

3- Connect with your Office 365 account

4- Next step

5- Select your list

6- Next step

7- After finish all common steps, your list has been imported! 🙂

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Renato Romão
https://www.linkedin.com/in/renatoromao/

 


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

View solution in original post

2 REPLIES 2
renatoromao
Super User
Super User

Hi @robertopolo ,

 

Yes, when we are using SharePoint connector to import data to CDS entities, we got some problems sometimes.

 

Regarding your question, I recommend to use OData connector and follow these steps:

1- Connect to OData connector

2- Insert https://yourtenant.sharepoint.com/sites/yoursitecollection/_api/Web/Lists/GetByTitle('List title')/Items  in the URL field

3- Connect with your Office 365 account

4- Next step

5- Select your list

6- Next step

7- After finish all common steps, your list has been imported! 🙂

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Renato Romão
https://www.linkedin.com/in/renatoromao/

 


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

View solution in original post

EricRegnier
Super User
Super User

Hi @robertopolo,

I suggest using Dataflows with SharePoint list. It's an out-of-the-box data source made specifically for this. The advantage of a Dataflows it's a no code solution, you have a replication of the list inside CDS which you can built additional functionality on top and you can schedule the sychronization.

2020-04-17_12-47-08.png

More info on Dataflows: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-and-use-dataflows

Hope this helps!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,145)