Tagged Questions

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

1
vote
2answers
63 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
2answers
21 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 ...
0
votes
0answers
18 views

SharePoint list has different permissions that site

I shared a site with an external user. The user has been able to access the site. The site has a list. The user cannot access items on the list, though they can edit and add them. (They can't open ...
0
votes
0answers
30 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
16 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
23 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
24 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
56 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 ...
0
votes
0answers
41 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
0answers
10 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
42 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
0answers
43 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
14 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
32 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
1answer
130 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
21 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
52 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
87 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
0answers
57 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
1answer
36 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
40 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
42 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
37 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
133 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
88 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 ...
0
votes
0answers
397 views

External list - Access denied by Business Data Connectivity - Cannot add permissions

I created an external list, and got the "Access denied by Business Data Connectivity" error. So I tried to fix it by adding permissions on BDC Service, according to google, this is exactly what I have ...
1
vote
1answer
145 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
0answers
77 views

Sharepoint 2013 BDC : How to set Yes/No (Boolean)

I have struggled to set a Yes/No column to Yes by simply assign true on the TypeDescriptor, but it allways turns out be set to 'No". I am using Sharepoint 2013, BDC Explorer and Visual Studio 2013. ...
0
votes
0answers
124 views

How to create dashboard through CSOM to show workflow from external lists

We have following requirement. SharePoint 2013 standard edition environment is installed. SO no BI site template is possible. Development has to be through CSOM only. Vendor data is stored ...
0
votes
0answers
25 views

external list linked to different external list

I created an external content type and then a list from that. It shows the departments of the organization along with the phone and fax number. So when I click on the Department Name, it ...
0
votes
0answers
40 views

top level external list used in subsites?

We have SharePoint Foundation. I created an external content type along with a list in my main site collection. I created a bunch of different views (one for each department of the organization). I ...
1
vote
0answers
37 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 ...
0
votes
1answer
39 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
84 views

Remove “Actions Menu” from list view with external data columns

I have a list which contains two external data columns. The view for the list displays an "Actions Menu" next to each of the external columns. This "Actions Menu" appears like little box and down ...
3
votes
1answer
127 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
1answer
29 views

Case of an external list being inaccessible

I have an external list that I created with a bdc, but it might happen that the external source is not available is there any way that the sharepoint saves a last access? if not what is the best ...
1
vote
1answer
225 views

External List (List view) change layout to multiple columns

I'm using Sharepoint 2013. I have an external list. In the list view, I want to add 3 web parts horizontally. (side by side) That means I need to change the page layout. But couldn't find where to ...
2
votes
0answers
201 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 ...
1
vote
0answers
74 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
237 views

External List : XsltListViewWebPart not loading view (Team Site)

Scenario: I have external list and I want to show specific view on team sites homepage. I add XsltListViewWebPart with featurereceiver because I can init specific settings and view to it when creating ...
1
vote
2answers
911 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 ...
1
vote
1answer
226 views

The query against the database caused an error

I have two farms. I restored a custom SQL Server database from farm1 to farm2. After this when I try to access my external list which fetches data from one of the tables, it is showing error: The ...
2
votes
0answers
311 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 ...
0
votes
1answer
376 views

Create external content type with impersonated custom identity

I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a ...
2
votes
1answer
200 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 ...
0
votes
1answer
89 views

XSLT not displaying data from Arabic column external list

I have an external list named "users". It is coming from SQL Server and has following two columns: English_Name varchar(300) Arabic_Name nvarchar(300) Notice the Arabic_Name field has data ...
0
votes
1answer
342 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 ...
0
votes
1answer
219 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: ...
0
votes
1answer
358 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 ...
1
vote
2answers
1k views

How to get the current custom view name of my SharePoint List

I am using the following JQuery to get the current name of the View for External SharePoint list. var ctx = GetCurrentCtx(); var listName =ctx.ListTitle; var currentView = ...