cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Super User
Super User

Re: Sharepoint list connector does not work

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,

Power Virtual Agents Course: https://udemy.com/pva-beginners

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Sharepoint list connector does not work

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,

Power Virtual Agents Course: https://udemy.com/pva-beginners

View solution in original post

Highlighted
Solution Sage
Solution Sage

Re: Sharepoint list connector does not work

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Users online (7,450)