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).

81 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
377 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
0answers
553 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
2answers
337 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
328 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
818 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
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
105 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
200 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
345 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
506 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
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
332 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
0answers
1k views

Sharepoint external list problem

I'm taking my first crack at creating an External list in SharePoint 2010. I've taken 3 training classes in SharePoint 2010, and am now trying to transfer my knowledge to my own development ...
1
vote
1answer
222 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 ...
1
vote
0answers
298 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 ...
1
vote
0answers
56 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 ...
1
vote
0answers
115 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 ...
1
vote
0answers
77 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 ...
1
vote
0answers
220 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 ...
1
vote
0answers
44 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, ...
1
vote
1answer
263 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 ...
1
vote
0answers
1k views

How to get the data from external SQL Server database in SharePoint 2013 site

What I want to do is retrieve the data from external SQL server database and bring it on the SharePoint 2013 site and show the graphs accordingly. So the data might be from different database tables. ...
1
vote
1answer
192 views

Not able to create External Content Type in SharePoint Designer 2013 using Stored Procedure

I want to create the external content type using stored procedure but it is giving me error such that, when I right click on routines in Data Source Explorer and then select New Read Item Operation ...
1
vote
0answers
48 views

Displaying items from an External List in Sharepoint 2013

I was hoping that someone might be able to help me with this little problem. We currently have a SharePoint site set up for our Intranet and want to display an error message (i.e. a particular ...
1
vote
0answers
77 views

Display SQL Server data in Sharepoint with the ability to Drill Down

Metadata External List Users need to see & update metadata information about user databases via sharepoint. Users open a Sharepoint site and look for metadata Information Data being pulled from ...
1
vote
0answers
99 views

Sharepoint 2013 accessing external list in workflows

I have created an external list using WCF connections. I have in that list all the information that I need. Now I need to access that data from another list workflow(sharepoint 2013 platform workflow)....
1
vote
1answer
275 views

bulk update the external list sharepoint 2010

I try to provide bulk editing and updating for external lists. I heard that the datasheet view is a convenient tool, but it is not enabled for external lists. Is there any way to get an easy, user-...
1
vote
0answers
543 views

Display Search box on an external list

I have an external list on a sharepoint site, from a BDC connector on sharepoint 2013. I want an inline Search box so that a search can be done on that list only. When i go into the web part and ...
1
vote
0answers
87 views

Can I get beyond SharePoint Throttling on External List without altering the threshold?

The SharePoint throttle for External Lists has been met in my most recent attempt to connect securely to an external SQL Database with approximately 5000 records. Of course, I get the correlation ...
1
vote
1answer
740 views

Is it possible to Copy External List item Directly to Custom list

I want to know whether I can copy External List items directly into Custom list in SharePoint 2013. also I want to know whether I can convert Text Field from External List to Person or Group field.
1
vote
0answers
572 views

Handling identity column when managing SQL database table using external content type \ external list

I have a SQL table (with a primary key identity column) which I want to perform CRUD operations on using a SharePoint external list as a front end. I have setup stored procedures to perform the CRUD ...
1
vote
0answers
61 views

Are third party solutions really that superior to BCS?

Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business ...
1
vote
1answer
507 views

Read items from External list in Sandbox Solution

Can we read an external content type using a sandbox solution for share point online? If anyone has faced this issue then please share how is it possible. Thanks
1
vote
0answers
581 views

Sharepoint 2013 - External List view/edit item in modal dialog

I have an External List, reading from a WCF. When I open an item (view item), I want it to open in a modal dialog. The External Data Source has 'read item' and 'read list' set up from WCF services. ...
1
vote
0answers
408 views

Custom List Form works fine in Infopath but gets stuck when deployed

I have a custom list form for whenever I add a new item to a custom list. This form connects to an external sharepoint list that has 3000 records. When you type a client ID it will connect to the ...
1
vote
1answer
459 views

Copy data from external List Item to New Form

I have an external list that I want to add action to copy list item to NewForm. or any othwer way to take data from external list item to a new form. From display form, edit form any way will be ...
1
vote
0answers
118 views

External lists: Field GUIDs always empty?

I want to turn an external list into a DataTable using the ID/GUID values of external list's Fields as the DataTable column names; however, I've noticed for the external list I'm using, all of the ...
1
vote
0answers
153 views

Bulk-Edit in external lists (Sharepoint 2010)

I try to provide bulk editing for external lists. I heard that the datasheet view is a convenient tool, but it is not enabled for external lists. Is there any way to get an easy, user-friendly bulk ...
1
vote
0answers
288 views

user lookup field for external lists

Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
1
vote
1answer
265 views

Associated ECT only displays ID (not title) in external list

I have created two ECTs, let's call them country and city for clarity. I have also created an association with city as the child and country as the parent. When I create an external list for city, ...
1
vote
0answers
194 views

SPFieldUrl does not work

I have an external list, items in that list have a field that contains an url. I want to show this url as a link in sharepoint form. I found this example and defined in my Creator and Updater methods ...
1
vote
0answers
46 views

How add personal list for all users

I want to integrate Sharepoint with my external system. Sharepoint should load tasks from my system and show them in the list on user personal page. Integration should be done using Sharepoint client-...
1
vote
0answers
118 views

Run custom javascript when external list table loaded

Is there any way to run custom javascript after table with external custom list is loaded on page? The external list table is loaded on page with some delay and I would like to modify its content ...
1
vote
1answer
51 views

Parameterized External Content Types?

Suppose I have multiple instances of some line of business app in my environment. Is there a way to create a single External Content Type that can be parametrized and reused? If I have 5 instances, is ...