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

learn more… | top users | synonyms

0
votes
1answer
439 views

Return value of the dropdown list rather than text when creating an item

I'm following this example: http://www.martinhatch.com/2013/08/jslink-and-display-templates-part-3-creating-a-custom-editing-interface.html I have a dropdown on the create new item page (external ...
1
vote
1answer
464 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 ...
0
votes
1answer
505 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 ...
0
votes
0answers
21 views

JS Link on External list views (BCS)

How can I apply SharePoint Client Side rendering (JSLink) on an external List?
1
vote
1answer
517 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" ...
0
votes
1answer
1k views

Access denied by Business Data Connectivity error for anonymous users when accesing external list

I have created an external content type which displays the data from the SQL table. And the external list's data I am displaying the web part. The site is to be made available to the anonymous users. ...
0
votes
0answers
7 views

WCF based External List Columns Type in Sharepoint 2010

In my Sharepoint 2010 I've created External List that uses WCF service as data source. This is my data type that is exposed by the service: [DataContract] public class Item { [DataMember] ...
0
votes
0answers
12 views

SP Designer 2010 external content type - database moved

I must be overlooking something really simple. I have custom forms in Sharepoint 2010, built on an external list that's tied to an ECT created in Designer 2010. The SQL Server database that contains ...
0
votes
0answers
5 views

Display some data collected from external sources to external customers?

we're looking the way how to display some data collected from external sources in SP to external customers. We have the list of projects handled in SQL. Every project has own number, name and status ...
0
votes
0answers
210 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 ...
0
votes
0answers
38 views

BCS OData navigation properties are not shown in SharePoint Hosted App external list

I have created a WCF Data Service that is hosted on Azure. I use this service as the data source for my SharePoint Hosted App's external lists. I noticed I was missing all navigation properties from ...
1
vote
1answer
129 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 ...
1
vote
1answer
38 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, ...
0
votes
0answers
42 views

“Connect to Outlook” button disabled on an External List based on “Contact”

I'm using SharePoint's Business Data Connectivity to connect to external source with contacts information. I created a .NET Assembly connector (BDC Model project in VS) with ReadItem and ReadList ...
0
votes
0answers
17 views

Business Data Connectivity Model based on Contact

I'm trying to create a .NET assembly connector for BDC. I'm creating the Business Data Connectivity Model and I'd like my entity to behave in SharePoint as a contact - so that I could use "Connect to ...
0
votes
0answers
36 views

Copy a list using a workflow

I have an external list that pulls in info from an SQL database, I would like to create a workflow to copy the contents of the external list into a custom list How would I do this? I can only see ...
0
votes
1answer
21 views

change the order of fields in the forms of external lists

I have an external list and forms contain fields which are ordered alphabetically. I would like to customize the order of fields in all the forms. I thought of using jquery, but that is giving me some ...
0
votes
1answer
120 views

Cancel button click event in the new form

I have created an external list and in the new form I have a few input controls. Some of them are required fields but are not indicated as such on page. So I am trying to check if the input is empty ...
0
votes
1answer
37 views

External Data Editing and Modification

Can data in a SQL database be modified (new, delete, edit) through a SharePoint out-of-the-box feature or custom built feature?
0
votes
0answers
40 views

Calendar view for external content type

I have created a new external content type / external list that pulls information from an SQL database, the list has a start date column and end date column so what I wanted to do is create a calendar ...
0
votes
2answers
69 views

Filtering by QueryString doesn't work in SPD 2013

I have an external list, I have setup and use querystring to filter list in SharePoint Designer 2013 like this posted: ...
0
votes
0answers
110 views

How to retrieve BDC Identity from External List programmatically?

I need to do a lookup on an External List (in SharePoint Online - Office 365) to retrieve the value of the BDC Identity. BCS is talking to an OData web service. (I'm not a Visual Studio guy), so ...
1
vote
0answers
191 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 ...
0
votes
1answer
61 views

GUID field from data base table in external list

I created an external list based on table from data base. But one field in my table has type "uniqueidentifier" for GUID values and does not display in external list. Is there any way to solve this ...
1
vote
2answers
206 views

Can't get JSLink to work on external list

We have an external list surfacing data from a homegrown data source and I need to modify some of the values using JSLink (formatting dates, color-coding based on values, etc.) I have a web part ...
0
votes
1answer
718 views

How to create an external list from an ECT using powershell

I have an External Content Type in my Metadata store and I want to create an external list using that ECT, using Powershell script. I tried to use $Web.Lists.Add() with SiteTemplate = "External ...
0
votes
0answers
73 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
1answer
164 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 ...
1
vote
1answer
24 views

How to handle DeleteItem in external list

We have an external list bound to data source by the WCF service. It displays a metadata of "tasks", and for every "tasks" we have in another document Library a special folder. When user selects ...
0
votes
0answers
54 views

External List filter by Current User

How to field Current user on External Content make from the View. I have got a View with one field with the user name and Surname. How to Filter a External Content to see only the records wchich the ...
0
votes
1answer
31 views

Show external List data to only logged user

How to show only elements from an External List, where login or names is the same as for the currently logged in user?
2
votes
1answer
118 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 ...
1
vote
0answers
88 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 ...
0
votes
1answer
55 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is ...
0
votes
0answers
18 views

Actions listed in “Navigate Association” section of a External List Profile Page

I have two external content types. One called clients and the second called Client Guidelines. I created an association from Client Guidelines to clients. I also created a profile action for clients ...
0
votes
0answers
63 views

Warning when opening an InfoPath form with data sources linked to external lists

I am replacing a colleague for the support of a SharePoint 2010 intranet. A library contains InfoPath 2010 forms. The form template contains data sources linked to external lists. Each external list ...
0
votes
1answer
767 views

How to have integer fields in an external list display without thousands separators on the display form?

I am using the Business Connectivity Services in SharePoint 2010 to display the content of a database table in an External List on my site. One of the fields in the database table is of int type and ...
0
votes
0answers
55 views

How to get security to work with Secure Store Service?

I have an External List/content type in SharePoint 2010 using Secure Store Service. It is for an MSSQL DB access with an SQL user for a group of users. I set up Secure Store Service with Target ...
0
votes
0answers
15 views

External List based on authentication

I have an External list with so many items.I want to restrict some items in the list to some user based on custom property.How should I do it
0
votes
1answer
46 views

Customizing details page link in BCS list or custom details page redirection with SarePoint 2013

I'm having fun with Sharepoint 2013 and studio 2013, just started dev few months ago -) I have some external lists pointing to external content type, I would like to redirect to a custom detail page ...
0
votes
0answers
35 views

How can I combine two external list in SharePoint 2013?

I have 2 external lists: - SQL - Oracle Both have the same columns, but in diferent server (SharePoint, SQL and Oracle). I need to combine the lists in one. How can I do that?
0
votes
1answer
332 views

lookup external list

I have two tables: Documents Project task What I am looking for is the following: I have a page with project tasks in a hierarchy list (done) Clicking on a task will open an edit screen (done) ...
0
votes
1answer
113 views

How do I populate the VALUEs in one column with the FIELD NAMES of another list?

I'm trying to create a 'request update form' where the user selects an entry which is incorrect and then which field is incorrect and writes a comment and that form will get submitted via workflow to ...
0
votes
0answers
96 views

External List “fail” on create item

So I have an external list with all the read list / read item / create item operations set up. When I creates an item on the list webpage, SharePoint gives me this error: Operation ...
0
votes
0answers
160 views

Connecting external list webpart to filter values

I have an external list in SharePoint 2013 on premise which gets data from SQL server. I created another list (regular custom list) in SP where I want to store items which are related to the SQL ...
0
votes
1answer
80 views

external content type

We are a tennant in a larger sharepoint setup. I have tennant admin rights. As a test I would like to create a list that originates from a sql table. I followed this guide: ...
0
votes
1answer
50 views

custom value in external list

I currently have a external list with a column valued either 0, 1 or -1. I want to display different pictures for each value (like a status indicator). Is it possible to do so in SharePoint? I'm ...
1
vote
0answers
52 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 ...
0
votes
0answers
57 views

External list - When configure BDC returns error and cannot access Managed Accounts settings

With SP2013. I want to create a list that use external data (sql ones). So I create my external list, everything's ok. When I open it in my browser, bring me the error : access denied by BDC This ...
0
votes
1answer
247 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.