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

SharePoint 2013 List Connection

Hi, 

 

I cannot connect to a SharePoint 2013 List via the SharePoint List option due to the following error:

Capture.PNG

Note all the other lists available from that root URL are able to connect via the SharePoint List option.

Is this due to calculations and lookups in the list? How can I get the Input String into the right format?

 

It is possible to connect it via the Web Connection but when connecting up more than one site, the servers constantly time out.

So I made a view in the SharePoint list that doesn't contain the lookups but this didn't help.

 

POL Capture.PNG

I've also increased the timeout from 100 seconds to 5 minutes but this hasn't change the situation. 

 

2 problems in essense! 

Any ideas where to look? Are the issues stemming from the SharePoint list?

 

Thank you in advance,

J

2 REPLIES 2
Community Support
Community Support

Re: SharePoint 2013 List Connection

Hi Jowill,

Your error is 500  server error, so you could check whether there is something wrong on your server, you coould try to connect to other sharepoint list to see whether it work or not. In addition, you also could try to delete calculated column or other column like (lookup ) to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Jowill
Frequent Visitor

Re: SharePoint 2013 List Connection

Hi Zoe, 

 

thanks for your reply. Other SharePoint lists connect without an issue. 

Would you suggest then that it's likely because of the calculated columns in the list?

I only ask because the other lists that connect without an issue also have calculated columns. Seems odd.

 

thanks, 

J

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors