Questions tagged [external-list]

An external list is a list published outside of the scope of SharePoint usually with the tool Business Connectivity Services (BCS).

Filter by
Sorted by
Tagged with
0 votes
1 answer
943 views

Can we connect SharePoint online to ODBC data

Can we connect SharePoint online to ODBC data? to read the ODBC data and update a sharepoint custom list? Thanks
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
58 views

BCS: get notified when data is changed in sql server?

We were using a sharepoint 2019 list as logging list and we moved that to SQL server. Then using BCS we are only reading the data from SQL and displaying in sharepoint using External Content Type and ...
user20377051's user avatar
1 vote
0 answers
25 views

External Content Profile Pages in Sharepoint Online

My institution is migrating to SharePoint online from an on-prem 2016 environment. One thing we currently rely on heavily is getting an ECT into the existing 2016 site and having a profile page for ...
MigrationNewbie's user avatar
0 votes
1 answer
63 views

Unable to access data from external list by REST API

I'm trying to retrieve items from external list by REST API. The external list displays data from SQL Server view. Unfortunately I always get error saying that the list does not exist. This happens ...
n0e's user avatar
  • 307
0 votes
2 answers
82 views

Pass parameters to external list on SP2019 Standard

I have an external list that is displaying data from a SQL Server view. Now, I want to add filtering. The problem is that I'm working on Standard version of Sharepoint, so no Enterprise webparts are ...
n0e's user avatar
  • 307
0 votes
1 answer
124 views

To add a new column in the external list

I have created external list to retrieve SQL data into my SharePoint via External Content Type (ECT). Everything working fine till here but the problem is when ever i want to add a new column to the ...
kiran kumar's user avatar
1 vote
0 answers
26 views

Hyperlink in External List webpart isn't working

So I was able to add <a> <xsl:attribute name="href">....</xsl:attribute>View</a> in my xslt code for modifying my external list. It works when I view the list ...
Rox's user avatar
  • 11
0 votes
1 answer
44 views

External access from Vendors

How can I grant access to external users? The idea is the external user can: Access some of my SharePoint list so I can collect information from them (We temporary hire some vendors), this list will ...
Luthius's user avatar
0 votes
1 answer
314 views

Unknown error has occurred. The form template has been published to the server but it can only be opened in InfoPath Filler

I have gotten this error before and to fix it, I created a new external list and new form. But when going back in and editing the new form, it doesn't even publish and keeps giving me this error. I ...
Kateland R.'s user avatar
2 votes
0 answers
30 views

Create, read, and update from SQL table to on-prem SharePoint 2016?

Ultimately I would like to create an external list that can be customized (i.e., partly columns from a SQL table and partly native SharePoint columns). BCS isn't an option because it would not let me ...
almostsp's user avatar
0 votes
2 answers
392 views

SharePoint migration - External List

I am doing a migration (mostly content) from SharePoint 2010 to SharePoint Online. There are a couple of External lists spread across the site collections. Any ideas/recommendations on how I should ...
Murilo Santana's user avatar
0 votes
1 answer
130 views

Workflow will not create an external list item

I have an external list in Sharepoint Online that is connected to SQL server (Azure) via BCS and secure store. I can manually add/edit items and it they immediately show up in the DB. I built and ...
AFerrary's user avatar
0 votes
1 answer
1k views

BCS External List CRUD operation using REST API on SharePoint 2013

Can we have CRUD operation on SharePoint External List Based on SQL Server using Rest API with Jquery on SharePoint 2013 On Premise. This link says it possible. But need more advice on this
Vikas Sharma's user avatar
0 votes
1 answer
374 views

Very slow external list based on SQL Server

I am using SharePoint 2016 on premises. This is a new farm with installation done just now. I created BDC to fetch data from SQL Server view. That view contain less than 8000 records. Then I created ...
Frank Martin's user avatar
  • 3,668
1 vote
1 answer
434 views

Bind dynamic DropDownList in new form (external lists involved)

Short version of the question: I am dynamically building the option list of a DropDownList based on a selection from another DropDownList with jQuery. How do I bind the new option list so that it will ...
KR169387's user avatar
0 votes
1 answer
420 views

Sharing Sharepoint News with Digital Signage Screens

We have an intranet site where we carry employee news, announcements and vacancies. We also have screens for our front line staff running ScreenCloud. I was hoping to output RSS feeds from our lists ...
Chris Wiseman's user avatar
4 votes
2 answers
646 views

2 ways Communication required from SAP to SharePoint

I need to to get the data from SAP to SharePoint, and on performing CRUD operations via Lists from SharePoint. The updated data should also get effected in SAP. Can anyone help me in knowing how I ...
MSA's user avatar
  • 1,155
0 votes
1 answer
185 views

External Content Type - Large List (5k or more)

I setup a external content type for a list that has ~ 6k rows (SalesPerson). I have setup the list threshold to be 50k in central admin so I can test this. I am not able to return any data when I try ...
David Tully's user avatar
2 votes
1 answer
75 views

Display a standard grid for a external list connected through BCS

Environment Sharepoint 2016. Visual Studio 2017. Sharepoint Add-In in a hosted environment. Requirements Display an external list connected through BCS in a standard grid view with possibility of ...
Mark Twain's user avatar
4 votes
2 answers
3k views

Problem with limit of Items in External list

My Web part consumes a list that presents this error: The Database Connector limited the response. The database response contains more than '2000' rows. The maximum number of rows that can be read ...
Xablau Developer's user avatar
1 vote
2 answers
522 views

Search External List Web Part

I have a SharePoint 2010 on-prem site with 2 external lists and I want to add web parts of those lists on a landing page with search boxes for each list that displays the results in the web part. How ...
Andrea Pasutti's user avatar
2 votes
1 answer
88 views

"Export to Excel" - Database Connections Data - SP2010

We have few "Database Connections" created in SP Designer 2010 and I used the "Data view" web part to display the database connections' data. Is it possible to export this data to an excel?
George's user avatar
  • 1,512
1 vote
0 answers
519 views

Sharepoint DataFormWebPart and ListFormWebPart validation SP2016

I'd like to add some custom validation to custom NewForm for external list. The default new item form has in the ZoneTemplate ListFormWebPart but if i add a new form in SPD2013 there is ...
peter jasan's user avatar
1 vote
4 answers
408 views

Alternative to BCS in SharePoint 2013

My requirements is to consume external data in SharePoint 2013. One of the option I know is SSIS, this is a lot of work. I wanted to know if you've achieved something similar using other methods. ...
vikbehal's user avatar
  • 240
1 vote
1 answer
306 views

External List shows only BDC Identity

I have created an external list called Employees. When I go to site contents, I see Employees and when I click it, I see the exact contents I expect. When I create a new page for my site and insert ...
Ira D's user avatar
  • 167
2 votes
1 answer
2k views

How to identify data source for external list?

I'm a SharePoint noob, using SharePoint Designer 2010. There's an External List that is pulling data from a MS SQL server. How can I find out what database and table it's querying?
TheAmigo's user avatar
  • 123
0 votes
1 answer
351 views

External list from SQL database with more than 2000 rows

I created external list in SP2013 which has more than 2000 rows but I still cannnot read it all, error is: Database Connector limited response. The response from the database contains more than 2000 ...
Zbyna's user avatar
  • 149
1 vote
0 answers
60 views

Get foreign key in external content type to show up in list view using Visual Studio

How can I setup external content types in such a way that when in the list view of these external content types, I can jump between and possible lookup values to that other type? Note: No 3rd party ...
SPUser's user avatar
  • 152
0 votes
3 answers
386 views

Still getting Odata Service Connector Throttle Error - Already tried Set-SPBusinessDataCatalogThrottleConfig

I've already tried powershell to reset the throttle value as well as disabled it completely: This disables a throttling rule. Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Enforced:$false ...
user5579208's user avatar
1 vote
0 answers
127 views

External Content Type : How to display label on lookup columns (without unable edit / new form)?

I have a SQL Server Table A with a foreign key with reference to B : id_A [int auto_increment PK] name [varchar()] ref_B [int FK_ref_to_B] I try to display A in an External List based on External ...
Marsso's user avatar
  • 11
1 vote
0 answers
98 views

Can not retrieve sql server routine return parameter schema information

I am trying to create an external content type on Sql stored procedure in sharepoint 2013 and getting the following error: Invalid Object Name '#...' .Can not retrieve sql server routine return ...
Misha's user avatar
  • 83
2 votes
1 answer
643 views

Failed to create list item for external list using REST API POST

I've AN OData API, which I'm consuming in SharePoint via BCS and External List. I already have the Get and Update functionality working using REST API to external list. But when I try to add an item ...
user5579208's user avatar
0 votes
1 answer
598 views

How to fill External Item picker using jquery?

Set value of a SharePoint 2013 BDC External Item Picker field using JQuery I want to fill customer name using jquery. How can fill this when page load?
Admin's user avatar
  • 900
0 votes
1 answer
83 views

Sharepoint 2013 BDC IEnumerable<T> VS List<T>

When I follow this walkthrough for External Content type I am not able to register the ECT in SPD with the following error This operation is based on a method with complex data types in its ...
LR2007_ITA94's user avatar
0 votes
1 answer
1k views

Creating External Content Type under BCS model by connecting to an Oracle Database

I want to create an External content type by connecting to an Oracle database using VS or SP designer,to show data in an external list? I am a bit new to BCS model so a little background will be ...
Ahmed's user avatar
  • 31
0 votes
1 answer
196 views

Create list view with unlimited items

We have a requirement in SharePoint Online to create list view that can view more than 100,000 items. We have a custom list synchronization with email, and there are more than 16,000 item creates ...
taher mohammad's user avatar
1 vote
0 answers
237 views

Read External List (BCS) Data in SharePoint Hosted App

I have this SharePoint hosted app on SharePoint Online. In this app, I am able to read the data from any SharePoint List/Library using the REST calls. However, when I try to fetch the items from a ...
Piyush's user avatar
  • 215
0 votes
1 answer
286 views

How to create a Sharepoint 2013 form to update a Sharepoint SQL database

I have a SQL database, I have created an External Content Type and an External List for the Table. I can see the list in SharePoint. I would like to be able to change the form to add a new instance ...
meck2003's user avatar
2 votes
1 answer
79 views

Creating External List [closed]

I have been asked to research External Lists. After exploration I came to know that in order to use data which isn't there on SharePoint we make use of External List. Now can anyone tell me a real ...
Anand's user avatar
  • 1,745
0 votes
0 answers
35 views

Share external list with external users in office 365

can we share external list with external user in Office 365.
Trimantra Software Solution's user avatar
1 vote
0 answers
51 views

Query BCS Connection to Update a SP 2013 Library

I have a requirement to update a SP 2013 Library (let's call this Test Library) The requirements are detailed below: Update all items with a Status = Created If Status = Created update: Name, ...
Nina G's user avatar
  • 935
3 votes
1 answer
7k views

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ in BCS

I have already configured BSC service in SharePoint 2013, I created an external content type in SharePoint Designer, everything is ok. But unfortunately, When I tried to browse an external list from ...
Mohamed El-Qassas MVP's user avatar
2 votes
0 answers
177 views

Reading data from a external list using a 2010 workflow

I work with SharePoint 2013, and need to read information from a external list that I have created. The list can display information correctly when using it through the browser. I need to create a ...
garfield185's user avatar
3 votes
0 answers
215 views

Display additional fields on forms (External lists)

I have a external list where I have employee information. I am trying to do a lookup where I can select the employee and display it's corresponding department with the additional columns possibility. ...
garfield185's user avatar
0 votes
1 answer
696 views

Show filter choices error on external list in SharePoint 2013

I have an external list on SharePoint 2013 migrated from SharePoint 2010. There are about 1500 items in the list. When I click to filter a text column it gives me the option to "Show Filter Choices". ...
LetMeSP's user avatar
2 votes
1 answer
44 views

What happens to External List created using BCS from SQL query once the server goes offline?

If the database gets deleted or somehow goes offline, will the list keep the existing data or will it all be gone due to failed synchronization.
Jake's user avatar
  • 23
1 vote
3 answers
5k views

Query String Parameter pass to Data Source Filters in External List (BDC)

Can you please guide me how to pass the Query String Parameters to Data source Fiters in external list? I have created external list based on external content type. External content type has three ...
Dikesh Gandhi's user avatar
1 vote
1 answer
317 views

SharePoint 2010 bcs item limit

I have an on premise SharePoint 2010 implementation. I need to implement a custom form with 65 fields which has rich text, drop downs and some complex filtering logic on the form. I want to load the ...
user1339913's user avatar
3 votes
4 answers
365 views

Approaching to have a third part web application inside SharePoint 2013

I am working on SharePoint enterprise server 2013, and I am trying to find the best approach I can follow to achieve this requirement:- Our customer has a web page which list their employees info. ...
John John's user avatar
1 vote
1 answer
1k views

SPServices GetListItems from External List causes HTTP 500 Internal Server Error

My function only works when I'm using my SP_ADMIN user. But when I'm using another user I receive the following error message from the console: 500 (Internal Server Error) What's wrong with this ...
user avatar

1
2 3 4 5