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
0
votes
1answer
713 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 ...
1
vote
1answer
739 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.
0
votes
1answer
618 views

How SP generates ID for each list item

When you click open an item in an external list, you have a url like this: DispForm.aspx?ID=__ck8100530003000300030013008300g40000300&Source=http%3A%2F%2Fswsudc07%3A9200%2FLists%2FQuote%2FQuote%...
0
votes
2answers
824 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
1k views

Creating External Content Type under BCS model by connecting to an Oracle Database

I want to create an External content type by connecting to an Oracle database using VS or SP designer,to show data in an external list? I am a bit new to BCS model so a little background will be ...
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 ...
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="...
0
votes
1answer
645 views

BCS External List CRUD operation using REST API on SharePoint 2013

Can we have CRUD operation on SharePoint External List Based on SQL Server using Rest API with Jquery on SharePoint 2013 On Premise. This link says it possible. But need more advice on this
0
votes
1answer
21 views

Unknown error has occurred. The form template has been published to the server but it can only be opened in InfoPath Filler

I have gotten this error before and to fix it, I created a new external list and new form. But when going back in and editing the new form, it doesn't even publish and keeps giving me this error. I ...
0
votes
0answers
13 views

How to only show specific columns in external list picker

How would one use an external list containing several columns to map each column in the external list to a drop-down control in a SharePoint List item? In the picture attached, how does one take each ...
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 ...
0
votes
1answer
609 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.
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 ...
0
votes
1answer
2k views

What are the BCS/External List Limitations for ECMA CSOM?

I cannot seem to find any documentation on this topic. Are there any limitations for what I can or cannot do with the JavaScript CSOM in SharePoint Server Standard 2010 External Lists as compared to ...
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 ...
0
votes
0answers
18 views

External List - datetime fields UTC adjusted

In SP 2013, we are able to pull in data from sql server to an external list (via an External Content Type) - unfortunately the datetime fields in SharePoint do not match what's in the database. The SP ...
4
votes
1answer
910 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 ...
0
votes
2answers
144 views

SharePoint migration - External List

I am doing a migration (mostly content) from SharePoint 2010 to SharePoint Online. There are a couple of External lists spread across the site collections. Any ideas/recommendations on how I should ...
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 ...
0
votes
1answer
42 views

Workflow will not create an external list item

I have an external list in Sharepoint Online that is connected to SQL server (Azure) via BCS and secure store. I can manually add/edit items and it they immediately show up in the DB. I built and ...
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 ...
0
votes
1answer
156 views

Very slow external list based on SQL Server

I am using SharePoint 2016 on premises. This is a new farm with installation done just now. I created BDC to fetch data from SQL Server view. That view contain less than 8000 records. Then I created ...
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
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 ...
0
votes
1answer
166 views

Sharing Sharepoint News with Digital Signage Screens

We have an intranet site where we carry employee news, announcements and vacancies. We also have screens for our front line staff running ScreenCloud. I was hoping to output RSS feeds from our lists ...
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 ...
0
votes
1answer
135 views

External Content Type - Large List (5k or more)

I setup a external content type for a list that has ~ 6k rows (SalesPerson). I have setup the list threshold to be 50k in central admin so I can test this. I am not able to return any data when I try ...
1
vote
2answers
228 views

Search External List Web Part

I have a SharePoint 2010 on-prem site with 2 external lists and I want to add web parts of those lists on a landing page with search boxes for each list that displays the results in the web part. How ...
0
votes
1answer
84 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 unavailable/...
2
votes
1answer
70 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?
1
vote
0answers
297 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
4answers
275 views

Alternative to BCS in SharePoint 2013

My requirements is to consume external data in SharePoint 2013. One of the option I know is SSIS, this is a lot of work. I wanted to know if you've achieved something similar using other methods. ...
1
vote
1answer
427 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....
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
151 views

External List shows only BDC Identity

I have created an external list called Employees. When I go to site contents, I see Employees and when I click it, I see the exact contents I expect. When I create a new page for my site and insert ...
0
votes
1answer
466 views

How to fill External Item picker using jquery?

Set value of a SharePoint 2013 BDC External Item Picker field using JQuery I want to fill customer name using jquery. How can fill this when page load?
1
vote
1answer
777 views

How to identify data source for external list?

I'm a SharePoint noob, using SharePoint Designer 2010. There's an External List that is pulling data from a MS SQL server. How can I find out what database and table it's querying?
0
votes
1answer
114 views

External list from SQL database with more than 2000 rows

I created external list in SP2013 which has more than 2000 rows but I still cannnot read it all, error is: Database Connector limited response. The response from the database contains more than 2000 ...
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 ...
0
votes
3answers
259 views

Still getting Odata Service Connector Throttle Error - Already tried Set-SPBusinessDataCatalogThrottleConfig

I've already tried powershell to reset the throttle value as well as disabled it completely: This disables a throttling rule. Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Enforced:$false ...
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 ...
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 ...
2
votes
1answer
407 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 ...
0
votes
1answer
56 views

Sharepoint 2013 BDC IEnumerable<T> VS List<T>

When I follow this walkthrough for External Content type I am not able to register the ECT in SPD with the following error This operation is based on a method with complex data types in its ...
0
votes
1answer
120 views

Create list view with unlimited items

We have a requirement in SharePoint Online to create list view that can view more than 100,000 items. We have a custom list synchronization with email, and there are more than 16,000 item creates ...
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 ...
0
votes
1answer
136 views

How to create a Sharepoint 2013 form to update a Sharepoint SQL database

I have a SQL database, I have created an External Content Type and an External List for the Table. I can see the list in SharePoint. I would like to be able to change the form to add a new instance ...
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 ...