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

Data not showing in External list of SharePoint 2013 site

I have created external content type using stored procedure. Also created read list operation, as well as read item operation. But the problem is that the stored procedure that I have created is ...
1
vote
0answers
47 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
34 views

Put external List data into a Drop Down

I am developing an app for my site. I have an external list that displays all the data i need fine. I need to somehow get that data in Visual Studio 2013 so i can loop through the data and create a ...
1
vote
1answer
42 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 ...
3
votes
0answers
42 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 ...
0
votes
0answers
19 views

Doing some actions into multiple Item of External list

I have an external list of Microsoft CRM 2011 Accounts in SharePoint 2013 (By BDCS Service). In SharePoint 2013 environment I want to select some items in this External List and apply an action to the ...
1
vote
0answers
23 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 ...
0
votes
0answers
19 views

Create external content type with sql server

I need to have an external list in SharePoint 2013, i found a lot of tutorial but. I need that my external content type has a unique authentification to my sql tablE. i don't want connection to the ...
1
vote
0answers
21 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 ...
0
votes
1answer
16 views

Use the data of Apps list in the collection site

I created a list (external content type) with Visual Studio in an app within in site collection under Office 365 SharePoint. However, this list is not visible in the site collection, (the app is in ...
0
votes
0answers
78 views

Populate multiple fields based on external data source item Sharepoint 2010

I am building a function booking form. I have 2 custom lists. List 1 (Main data source) contains regular information like Name, function date, number of people, etc. List 2 (Secondary data source) ...
0
votes
1answer
41 views

Disabled finder button - SharePoint Designer

I have an external list available in SharePoint Designer. Now I try to edit my list. I can't figure out why finder button (refer below screen shot) is still disabled. I'm sure that button should be ...
0
votes
1answer
75 views

External list with hyperlinks sharepoint 2013

How do I make a column (content) a hyperlink with an external list in SharePoint 2013? I have the url in the database and need to turn it into a hyperlink.
0
votes
1answer
69 views

SharePoint Data Source Filter REST / View

I have an external list with one wildcard filter named taskname. When I edit the filter directy in the view I get all the information i want to get. The problem is when I try to set the filter for ...
0
votes
0answers
41 views

External Content Type based on SQL View allow insert/update/delete

I have two tables in SQL, one of them is read only (it is the "master"). The other is a detail table. They are joined on column 'VNO'. It is constructed with a left join on the master table, so ...
0
votes
1answer
108 views

Getting error from display multiple selected external list item javascript

So here's the javascript I use to display item name of selected item from an external list: <script type="text/javascript"> var targetListItem; function ShowSelectedItems() { ...
1
vote
0answers
53 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 ...
0
votes
1answer
229 views

Could not save the list changes to the server

I have an External List in SharePoint 2013. I am trying to create a new Edit Form in SharePoint Designer but unfortunately it is throwing Could not save the list changes to the server error instead of ...
0
votes
1answer
64 views

ReadOnly columns in External List: SharePoint 2013.

I want to make some fields ReadOnly in External List in SharePoint 2013. I have tried JavaScript and SPUtility approaches as guided in this blog, but unfortunately did not work. In SharePoint ...
0
votes
0answers
36 views

SharePoint Designer not creating NewForm or EditForm for Stored Proc

I have created an external list using an external content type which uses stored procs for create, update, and delete operations. When I try adding a new item to that list using a Web Part, I'm ...
0
votes
0answers
62 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 ...
0
votes
1answer
61 views

Dynamically creating SharePoint 2013 external content type

Background: There is requirement of calling external list from SQL to SharePoint 2013. We have done it using BCS, external content Type and SecureStore. There are also some modification done using ...
0
votes
1answer
38 views

Is it possible to get items from External List using Lists Web Service

I am trying to get items from an external list, but I always get 'Microsoft.SharePoint.SoapServer.SoapServerException'. I am very new to SharePoint and have used similar approach in gettings items ...
0
votes
2answers
109 views

What is the best way to CRUD data in SQL database into SharePoint?

In Sharepoint site, I have a list, it will display data from the table in SQL database. When user insert, update or delete item in this list, the SQL database will be changed too. The change is one ...
0
votes
1answer
49 views

Custom link from External List

I've got an external List that consists of Names and ID numbers. What I'd like to do is to somehow make clicking this List take the user to another page (within our SP environment) based on which ...
0
votes
0answers
110 views

JS Link on External list views (BCS)

How can I apply SharePoint Client Side rendering (JSLink) on an external List?
0
votes
0answers
22 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
24 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
1answer
675 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 ...
1
vote
1answer
99 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

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
67 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
293 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
46 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
177 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 ...
0
votes
2answers
98 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: ...
1
vote
2answers
404 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
123 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 ...
2
votes
0answers
170 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 ...
1
vote
1answer
33 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
1answer
42 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
173 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
171 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
66 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 ...
1
vote
2answers
2k 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
1answer
166 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
1answer
187 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
56 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
72 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
1answer
385 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.