Rows of items containing columns of information.

learn more… | top users | synonyms (1)

3
votes
3answers
14k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
3
votes
2answers
2k views

Is it possible to limit the visibility of list items to not only just me (the author), but anyone from my company too?

I have a custom list on a SharePoint 2010 extranet site which users from various external companies can add items to. The list's Permission Settings page allows you to make all items visible to all ...
3
votes
4answers
3k views

Error - while exporting a Sharepoint List (Export to Excel)

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues. Note: He is ...
3
votes
2answers
920 views

How to modify a list's template?

I have a list that was created from a Custom List template. Most users have been interacting with it through a calendar view that was created. Now, some users would like to connect this list to their ...
3
votes
2answers
763 views

Creating email subscription service via SP 2010

Is it possible to create an email subscription service in SharePoint 2010? We have an ASP.NET app where users sign up to receive a bi-weekly newsletter. Our SharePoint installation is currently ...
3
votes
2answers
773 views

How many workflows can a SharePoint 2007 Library / List contain?

What is the maximum workflow can a Library & List in SharePoint 2007 can have? Information in http://technet.microsoft.com/en-us/library/cc262787.aspx mention that SharePoint 2010 can have 15 ...
3
votes
2answers
1k views

Can I access the service definition for the web service for a specific SharePoint list?

I have a problem accessing the web service ?wsdl for SharePoint lists, although I can see the list of operations. For example, for the following URLS: http://team/sites/test/_vti_bin/Lists.asmx - ...
3
votes
4answers
19k views

Is setting permissions on views now possible?

In the previous SharePoint version of SharePoint you couldn't have permissions on list views. Is this now possible on SharePoint Foundation 2010? So for example I have a list and 2 views but I want ...
3
votes
1answer
49 views

how to iterate through all folders inside subfolders of root level folders

below is the code to iterate through root level folders which downloads folder starts with "a" and download sub folders from it starting with any letter. I want to download all the folder levels and ...
3
votes
1answer
54 views

Identify List Template (stp) from SPList Object

I have custom list templates (stp) based on Generic List template. I have created several lists using stp files. How can I identify from which list template (STP file) the List was created. The ...
3
votes
1answer
104 views

Is it possible to programmatically enable ratings for a list in SharePoint 2013?

I would like to programmatically enable "Likes" (ratings) for a list in a SharePoint 2013 solution (object model or CSOM), but have not found any public methods available that support enabling ratings ...
3
votes
1answer
2k views

SP2010 Javascript REST API: updating list item using MERGE and POST

I am trying to use REST API approach in javascript to update a sharepoint list item where I have an id. So I use GET and POST to create records, but per MSDN article it looks like the way to do this ...
3
votes
2answers
861 views

SP 2010 - Client object model (javascript) - How to use get_listItemCollectionPosition for paging?

This is my code: When I call the function to get the items, it fails (doesn't go to the fail function, it goes into the success function but crashes when I try to get the position object), and I get ...
3
votes
1answer
142 views

Apply formatting logic before rendering field in SP list

I am relatively new to SP development; I am trying to do the following in SP 2010: I have a list field containing e-mail addresses separated by semicolons. I would like to insert a newline character ...
3
votes
1answer
80 views

Creating a view in SharePoint 2010

I have a ticketlist which has ticket_id for 2 different locations, tickd1,tickd2,tickd3,tickd4 for Dallas ticka1,ticka2,ticka3,ticka4 for Atlanta Now I am trying to create 2 views, one for ...
3
votes
2answers
592 views

Create list using a Workflow

I have a list of projects called "Project Reference." I want to create a new project list (for project tracking) called "[Project Name] Tracking" when someone adds a new project to Project Reference. ...
3
votes
2answers
1k views

Web Service UpdateListItems User Permissions

I'm trying to do an AJAX SOAP call to the Lists web service, specifically UpdateListItems. The query isn't malformed, and is working appropriately when using a user with full permissions. When a ...
3
votes
2answers
199 views

How to dump and XML file from a Workflow

I would like to dump an XML file to a specific location based on a workflow. Whenever someone creates an element on my list I want to create an XML file and save it to a disk location. Any good ideas ...
3
votes
2answers
3k views

Updating a List Instance

I have a List Instance in Visual Studio. However, every time I deploy the solution, Visual Studio says there is already a list instance with the same URL on the site collection and it needs to delete ...
3
votes
1answer
466 views

SharePoint 2010 - Modified Calender View

I want to filter the Calender in my SharePoint 2010. All Items with a Enddate older than 7 days must be hidden. I found no way to modified the Calender View to filter the elements because the field ...
3
votes
2answers
3k views

Silverlight unhandled exception on AddGallery.aspx

I try to create a new list in SharePoint 2010 with AddGallery.aspx and the Silverlight app gives me An unhandled exception occurred in the Silverlight Application right when I click the "Create" ...
3
votes
4answers
1k views

Content deployment - synchronizing lists in two environments

I'm working on a project with a typical scenario where authors are maintaining content on internal network (let's call it InAuthoring) and uses "content deployment" feature to flush the content to ...
3
votes
2answers
235 views

How do I programatically change the default value of, or remove from default view, title column using javascript?

Using the JSOM in SharePoint 2010, if I am creating lists programmatically using something like: this.myField= oList.get_fields().addFieldAsXml('<Field DisplayName=\'Key\' Type=\'Text\' />', ...
3
votes
2answers
509 views

How to move/copy items from one custom list to another custom list without Designer?

I'm a guest to the site and after seeing the great quality of Q&A's believe it's worthwhile to 'put this out there' in the event anyone may be able to assist. Brief background: I have ...
3
votes
1answer
3k views

Programmatically find lists by template ID

I am looking for an efficient way to programmatically find all SharePoint lists with a given template / type in the current site collection from within a sandbox solution. NB: I'm obviously aware ...
3
votes
2answers
99 views

How can I identify columns independent from language?

I've got a webpart which reads several values from a list, while developing local I've got a column "Due Date", but when I upload my webpart to SharePoint online (Office 365) we have a German version ...
3
votes
5answers
7k views

How to remove default columns from a custom list?

Is there any option to remove default columns(eg: Created By, Modified By) from a custom list? I do not want to hide the columns for a view, but I need to entirely remove/modify the default columns. ...
3
votes
1answer
166 views

Tracking User Activity for badges

I'm creating a QA site similar to Stack Overflow on SharePoint. I'd like to be able to integrate some badges into the System. I've thought of a few ideas, but I'd love some divergent thinking on ...
3
votes
2answers
63 views

Architecture: How do you store single pieces of information?

I am building a solution in which each Site Collection represents a single contained unit. The members of that unit will be using SharePoint to track information that describes their unit at the root ...
3
votes
2answers
2k views

error activate feature list template/instance in site definition

i've created a SiteDefiniton project and a Sharepoint ListDefinition project. In the SiteDefinition I created a listinstance of my template, but in deployment the activation of the ListInstanceFeture ...
3
votes
1answer
240 views

How to pull the total # of items from one sharepoint list as a column in another list?

The site has a list (List A) that links to multiple comments lists. For each item in List A, a unique list exists to capture comments related to that item. Users want to know how many comments have ...
3
votes
2answers
1k views

Drag and Drop SharePoint List by row for change items order

I have problem in one of my project. Requirement is it be able to drag and drop items in list to change their order. I try with HTML5 http://msdn.microsoft.com/en-us/magazine/hh852596.aspx but i did't ...
3
votes
2answers
692 views

Document Library Permissions being bypassed when using “Open with Windows Explorer”

SharePoint 2007 Document Library has permissions set for user A to "Read". User A is able to go to Actions -> Open in Windows Explorer and delete files. This seems like a very large security loop ...
3
votes
2answers
1k views

Show Modified and Created columns with Date only

I'm looking for the best way (if there is one) to show the Modified and Created columns in a list/library with the date only, so without the time. For example, instead of 1/12/2011 8:37 PM it should ...
3
votes
1answer
287 views

Trigger a workflow when user added to permission group

I'm not sure if this is even possible so here goes: I have a calendar list. After creation of the list I will add a choice field to the list in an event receiver where the choices will be the email ...
3
votes
1answer
5k views

How to filter items in a list that have a specific date that falls in last, this or next month?

I want to show only items with a specific date that falls in last, this or next month? For example: If today is the 7/13/2010 it should show only the items between the 1st of June and the 31st of ...
3
votes
4answers
581 views

CQWP Link to List Item

I cant seem to get my custom CQWP to link to a list item. If i look at everything exposed in the CQWP (using the showxml trick) the only thing close is the LinkURL which takes the format ...
3
votes
2answers
791 views

CAML OrderBy and managed metadata

I have something like this: SPQuery query = new SPQuery(); query.Query = "<OrderBy><FieldRef name=\"MyTerm\" /></OrderBy>"; myList.GetItems(query); I can sort on normal fields, ...
3
votes
1answer
26 views

How to Update “Created By” column through workflow?

I am trying to make the Blog comments and discussion replies to be Anonymous. The only way to do this (a simple way) is through hiding the created by column in the view. Is it possible to update the ...
3
votes
3answers
79 views

Get difference in Minutes for DateTime format column

I have a formula for calculated column which gets the date difference in hh:mm format. =TEXT([COLUMN2]-[COLUMN1],"h:mm") But I want to get the difference in just minutes. I created very complex ...
3
votes
1answer
280 views

SharePoint 2010 List Grouping Expand/Collapse Sequence Bug

I've run into a bug with a List web part that has me stumped. Bug description: Using the web part and XSL specified below, expanding groups may result in items from the wrong group being shown. ...
3
votes
3answers
628 views

How to check membership from current user and set readonly of some fields when override ListFieldIterator?

I have created a custom ListForm template and overide the ListFieldIterator. I have for example 10 fields in my content type. 5 of these 10 fields must be shown for the creator of the item. The ...
3
votes
1answer
1k views

Use one filter for multiple sharepoint lists

Can I define one list filter, and connect it to two lists on one web part page? I have two seperate lists on a page, both containing the 'author' column. Now, I want to add a filter to de page, so you ...
3
votes
1answer
577 views

Declarative OnQuickLaunch property not working in SharePoint 2013

I have a question about the OnQuickLaunch property in SharePoint 2013. I've created a new SharePoint 2013 project in Visual Studio with a document library List instance in it. All I have is an ...
3
votes
2answers
2k views

Filter People and Group column using [Me]

Our list has a people and group column (called Users) which we want to filter using [Me]. It works when the field only contains individual users, but when the field contains a group (either SP group ...
3
votes
1answer
644 views

Missing fields / columns on NewForm.aspx

I have a list in SharePoint 2010 in which the fields are not shown when clicking "New Item" and opening the NewForm.aspx. The list is not using a custom content type. I can edit existing list items in ...
3
votes
2answers
2k views

All versions of one item in list

Is it possible to see all versions for one item in SP list a different way than through version history? We have one extensively used list with 100, 130, 150... with a lot of (multi-line and rich ...
3
votes
1answer
1k views

How to remove duplicates from a sharepoint view?

I have a sharepoint views containing different items but according to the columns displayed in my view, those items are the same: A B C D A B C D A B C D A B C E That I would like to display like: ...
3
votes
3answers
698 views

Add default data in declarative xml list instances for Taxonomy fields

Can somebody tell me, how to add default data for taxonomy fields in xml... currently i am doing this is a basic way, but not working... <Data> <Rows> <Row> <Field ...
3
votes
1answer
571 views

Notify user when question is answered

I have a list for frequently asked questions that anybody can submit an item to. There already is a workflow set up to notify the approvers when an item is submitted so they can approve it. But, they ...