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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,473)