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
658 views

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

I'm following this example. I have a dropdown on the create new item page (external list). And I'd like to get the value of the selected item rather than the text. Please see my code below, at the ...
0
votes
1answer
950 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
11 views

Create ECT using Nested SQL Store Procedure

I'm creating ECT in SharePoint O365 using SP Designer. I'm defining the operations using Store Procedure. My Read List Store Procedure some thing like below: CREATE PROCEDURE [dbo].[...
2
votes
1answer
786 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 ...
3
votes
1answer
659 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="...
1
vote
1answer
1k 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 ...
2
votes
0answers
24 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 ...
0
votes
1answer
225 views

external content type

We are a tenant in a larger SharePoint setup. I have tenant admin rights. As a test I would like to create a list that originates from a SQL table. I followed this guide: http://www.sharepoint....
2
votes
0answers
29 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. ...
0
votes
0answers
7 views

Workaround limitations of custom forms for external list in InfoPath 2013

I need customize "new" and "edit" form for external list in SharePoint 2013. I use some secondary Data Connections to implements user-friendly interface with ability to lookup data storing in Database....
0
votes
0answers
10 views

SharePoint External List editing

I create a page with 2 web parts. one displays the external list and 2nd web part displays the data of selected item. I would like to be able to make this 2nd web part as editable. is it possible? ...
0
votes
2answers
4k views

Error with External Content Type List: “Unable to display this web part”

I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
0
votes
1answer
64 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". ...
2
votes
1answer
23 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.
0
votes
0answers
25 views

Associate workflow on External list in Sharepoint 2013

I am able to get data from SQL 2012 to SharePoint 2013 external list. I wish to associate or attach workflow on this list. I am aware that workflows cannot be associated on external lists, but is ...
3
votes
2answers
778 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?
0
votes
3answers
239 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 ...
0
votes
0answers
22 views

External List Without BDS

I am developing a Sharepoint site mostly as a document management solution for reports and invoices generated in the billing department. I have two tables in SQL that I would like to have access to in ...
1
vote
1answer
28 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 ...
0
votes
0answers
40 views

Web Part connection on external list form

I added an External Content Type (from WCF service) with Read List and Read Item operations defined. I created an External List based on this Content Type. I would like to display a Web Part on the ...
0
votes
1answer
78 views

use external liste error :Oracle database TNS The value's length for key 'data source' exceeds it's limit of '128'

I have created xml model for external list using bcs this is the code example for my BDCM model: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <Model xmlns="http://schemas....
3
votes
4answers
182 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. ...
0
votes
1answer
152 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 ...
0
votes
2answers
39 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 ...
0
votes
0answers
20 views

How to define datasource filters a dataview for an external list

How to define datasource filters in a dataview for an external list As of now, it displays: "There are no items to show in this view" The default external list view does return some rows..so i am ...
2
votes
1answer
38 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 ...
0
votes
0answers
12 views

How do you connect a SP2013 External Content Type to an Exchange Mailbox data source?

We have a requirement where a business unit wishes to expose Exchange mailbox data through an external list in SharePoint. What are the steps to create a SharePoint External Content Type (ultimately ...
0
votes
0answers
41 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
1answer
50 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
239 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
43 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 ...
3
votes
0answers
56 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
1answer
126 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
26 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
31 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
26 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
27 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
20 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
158 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
42 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
158 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.
1
vote
2answers
3k 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
45 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
190 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() { ...
0
votes
1answer
111 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 ...
1
vote
0answers
59 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
768 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
127 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 Designer,...
0
votes
0answers
52 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
2answers
328 views

Configure “Check if item exists” in external item picker

I work on the edit form of an external list. I can pick items from an associated content type with a picker. There is the option to "Check if item exists", but currently it only accepts IDs. Can I ...