Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
6
votes
4answers
5k views

Working with large external lists using BCS

I have a database that I want to display the content in SharePoint 2010. I am not displaying the content in a list but am using a custom WebPart. The database is not updated any more as it is ...
5
votes
3answers
3k views

Integrating an external database into Sharepoint

One of my current projects involves integrating a client's database into an overall CRM system design. Part of the process was updating their legacy database and porting it over to SQL Server. That'...
5
votes
0answers
378 views

How to set selected value of external item picker

I have developed a custom edit form with an external item picker as application page in visual studio. The picker is populated with data using the following method. private ItemPickerExtendedData ...
4
votes
1answer
913 views

Adding a non WCF SOAP wsdl as external content type in sharepoint manager

This is location to my wsdl, it is WSDL created by Spring WS: http://foo.bar/local/rpc/file.wsdl I am trying to add the connection to external data source from sharepoint designer. In the selection ...
4
votes
1answer
1k views

Secondary lookup columns for external content types not displaying data in list after refreshing from primary

I have created a SharePoint list that has a lookup column to an external list. I also have instructed SharePoint to display several secondary columns that are related to that primary external lookup ...
4
votes
1answer
3k views

Permissions to write to External List from Workflow

I'm attempting to create a SharePoint workflow that creates a new item in an external list using the "Create item in [External List Name]" action available in SharePoint Designer. Currently, I keep ...
4
votes
0answers
555 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
3
votes
4answers
340 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. ...
3
votes
2answers
1k 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 ...
3
votes
2answers
5k views

External lists do not display data though data are available

I have external lists connected to a sql server database. Since the last day, some of the lists do not display data; the lists are empty, only headers are shown. (Some lists still display data, though....
3
votes
2answers
2k views

Create External List on SharePoint online

Does anyone knows if it's possible to create an external list from another external list? Is it possible to create an external list on SharePoint Online from an existing external list on SharePoint ...
3
votes
1answer
989 views

Paging and sorting with BCS - Is it really possible?

I'm trying to add paging on an external list and so far it does not work 100%. The best references I could find (that actually... kinda... work) are these: Paging and sorting with BCS Paging and ...
3
votes
2answers
795 views

Is it possible to programmatically invoke a workflow on external list items?

Is it possible to invoke a workflow on an external list programmatically and pass parameters into the workflow? Is there an example using SharePoint 2010?
3
votes
1answer
466 views

How can we use multiple fields from an external list in a survey?

We are trying to build a survey, that uses data from an external list. It works fine for a single field. But what we would like to do is to bring about 10 fields back from the external system and ...
3
votes
2answers
341 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 ...
3
votes
0answers
330 views

Event receiver on external list

Recently I am working on a project to set event receiver on external list. Below list what we have done Create trigger to capture data change in database and log them into data table Implement ...
3
votes
0answers
628 views

Why can't i get data from External List within my workflow?

Im trying to load a value (string) into my SPD 2010 workflow from an external list. I want to save that value in a workflow variable, so I lookup for that external list and set up my filter's ...
3
votes
0answers
192 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
3
votes
1answer
819 views

Custom form template with external list does not work

I have following .ascx file <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register TagPrefix="SharePoint" Namespace="...
2
votes
3answers
8k views

How can I get external content crawled into SharePoint online index

I have SharePoint online and I want to add external content to the index. So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
2
votes
1answer
71 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?
2
votes
1answer
68 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 ...
2
votes
1answer
5k 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 ...
2
votes
2answers
7k views

How to read items in a BCS external list with PowerShell?

Is there a way that you get information from an external list (created from SPD for a specific ECT) differently than you do from a "normal" SharePoint list when using PowerShell? I did the following: ...
2
votes
3answers
3k views

How to authenticate BDC to the external system?

I'm using the following tutorial to define a workflow on a SharePoint list to create an element in and external List. When the workflow action tries to create the item in the external list, it fails ...
2
votes
3answers
7k views

How do I associate Workflows to SharePoint 2010 External Lists?

I've read that you can't associate workflows to SharePoint 2010 external lists but that there are workarounds for doing it. What do those workarounds involve? Can I do all of it in the Sharepoint ...
2
votes
1answer
56 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 ...
2
votes
1answer
318 views

Sharepoint 2010 External List Image column

I have a SQL table with 5 columns in it (EmployeeName, StartDt, EndDt, Location, PictureUrl). I want to display this data in a Sharepoint List. I want the image to be displayed in my sharepoint list's ...
2
votes
2answers
6k views

How to get the current custom view name of my SharePoint List

I am using the following JQuery to get the current name of the View for External SharePoint list. var ctx = GetCurrentCtx(); var listName =ctx.ListTitle; var currentView = $('[id*=\'...
2
votes
1answer
422 views

[Today]-15 filter not working on external list

I have an external list which is getting data from SQL Server. The table structure is as follows: Name InsertDate Where InsertDate is the date when record was inserted. I am trying to show only ...
2
votes
2answers
2k views

Custom forms for external lists guidance

I need guidance/suggestions developing an app which will be hosted in SharePoint using external content types. So far I have a BDC model which works fine for reading the data und displaying it in an ...
2
votes
1answer
3k views

External List from External Content Type: missing and/or error

I've created an ECT w/ Read List and Read Item operations using SharePoint Designer, saved it, and given myself permissions. The ECT's external data source is a WCF service. When I try to create an ...
2
votes
2answers
685 views

Additional datasource in infopath

Is there any way to add additional datasources to an infopath form when using an external list? Infopath always complains about the form not being valid, because of the addinal datasource.
2
votes
1answer
411 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 ...
2
votes
1answer
843 views

namespace on external content type

I have noticed that when moving BCS lists/external content types from my development computer to our production server, it keeps the namespace of my development computer. For example, all the ...
2
votes
0answers
18 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 ...
2
votes
0answers
107 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 ...
2
votes
0answers
201 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. ...
2
votes
1answer
40 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.
2
votes
1answer
347 views

Link Sharepoint Survey to External list

I am trying to go around the limitation of not being able to associate workflows to external lists. I am wondering if it is possible to create some form of association with a SharePoint survey. My ...
2
votes
0answers
507 views

Updating External List after Updating BCS: SharePoint 2013

I am using SharePoint 2013 and SQL Server 2012, both Enterprise Editions. Earlier I had created an External Content Type and created its External List. I have no problem performing various options ...
2
votes
1answer
2k views

How to create list item in an external list using SharePoint workflow?

Environment: SharePoint 2013 SP1 I have an External List displaying data exposed through a WCF service. Creating, Reading, Updating and Deleting (CRUD) items in the external list works fine in the ...
2
votes
0answers
2k views

Getting External Data from Oracle to O365?

We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365. The requirement is that ...
2
votes
0answers
1k views

Alerts on SharePoint 2013 External List

I have created an external list using an external content type reading from a database server on our network that is not on the same machine as our SharePoint database server. I am also sysadmin on ...
2
votes
1answer
669 views

External List - change a column to dropdown (Sharepoint 2013)

I'm on Sharepoint foundation 2013. I have a external list (based on a WCF) For the new and edit form, I'd like to have some columns to be a dropdown (list of selections to be populated from another ...
2
votes
1answer
335 views

How do I manipulate an external list view's columns with javascript?

I want to manipulate the columns of an external list view (XsltListViewWebPart), however, as the data loads asynchronously I must wait for the data to load and the table to be generated before my code ...
2
votes
0answers
178 views

Send email after creating New Item in External List

I am using SP 2013 and I have an external list. But when I created a new item, I want to send e-mail to the specific people. Workflow is disabled for external lists. So can we create a new method in ...
2
votes
0answers
336 views

How do I change SQL connection from one server to another on an an External list

I have an external list that points to SQL Server A. Server A is being de-commission and the database is moving to SQL Server B. I need to change my connection for my lists. I created a new ...
2
votes
0answers
144 views

BCS and External List: Validations and Business Logic

I have been able to define an External List through a WCF Service. This works well, but I am now moving onto more advanced scenarios - I would like my Create, Update and Delete methods to implement ...
2
votes
1answer
806 views

Have External Lists And / Or Event Receivers?

I am fairly new to Sharepoint. I am in the early stages of developing a SP2010 LOB app that will finally have like 50 lists which are quite interrelated with each other. I am asking for your help ...