Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

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
0 answers
14 views

SharePoint External list is throwing error after adding trigger to the SQL table

With out trigger my external list is working fine. But once I added trigger on the SQL table, when I am saving item from new form, I can see the record added into the SQL table but not getting success ...
user avatar
1 vote
0 answers
17 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 ...
user avatar
0 votes
1 answer
42 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 ...
user avatar
  • 297
0 votes
2 answers
43 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 ...
user avatar
  • 297
0 votes
1 answer
47 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 ...
user avatar
1 vote
0 answers
24 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 ...
user avatar
  • 11
0 votes
1 answer
41 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 ...
user avatar
0 votes
1 answer
177 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 ...
user avatar
2 votes
0 answers
27 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 ...
user avatar
0 votes
2 answers
334 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 ...
user avatar
0 votes
1 answer
100 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 ...
user avatar
0 votes
1 answer
967 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
user avatar
0 votes
1 answer
338 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 ...
user avatar
  • 3,614
1 vote
1 answer
415 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 ...
user avatar
0 votes
1 answer
341 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 ...
user avatar
4 votes
2 answers
587 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 ...
user avatar
  • 1,155
0 votes
1 answer
182 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 ...
user avatar
2 votes
1 answer
67 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 ...
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 ...
user avatar
1 vote
2 answers
460 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 ...
user avatar
2 votes
1 answer
83 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?
user avatar
  • 1,450
1 vote
0 answers
457 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 ...
user avatar
1 vote
4 answers
381 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. ...
user avatar
  • 240
1 vote
1 answer
265 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 ...
user avatar
  • 167
1 vote
1 answer
1k 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?
user avatar
  • 113
0 votes
1 answer
321 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 ...
user avatar
  • 147
1 vote
0 answers
57 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 ...
user avatar
  • 152
0 votes
3 answers
343 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 ...
user avatar
1 vote
0 answers
123 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 ...
user avatar
  • 11
1 vote
0 answers
93 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 ...
user avatar
  • 83
2 votes
1 answer
612 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 ...
user avatar
0 votes
1 answer
562 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?
user avatar
  • 900
0 votes
1 answer
79 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 ...
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 ...
user avatar
  • 31
0 votes
1 answer
163 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 ...
user avatar
1 vote
0 answers
234 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 ...
user avatar
  • 215
0 votes
1 answer
277 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 ...
user avatar
2 votes
1 answer
77 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 ...
user avatar
  • 1,735
0 votes
0 answers
32 views

Share external list with external users in office 365

can we share external list with external user in Office 365.
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, ...
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 ...
user avatar
2 votes
0 answers
169 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 ...
user avatar
3 votes
0 answers
213 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. ...
user avatar
0 votes
1 answer
645 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". ...
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.
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 ...
user avatar
1 vote
1 answer
296 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 ...
user avatar
3 votes
4 answers
359 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. ...
user avatar
  • 2,234
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
0 votes
2 answers
171 views

List where only some columns are confidential

I have created an external list which is drawing data from a single table in an Azure SQL Database (SAAS). Two external content type operations: List & Read Item. This is a generic list ...
user avatar
  • 163

1
2 3 4 5