SPListItem

Get list items from SharePoint 2010 using Client Object model

Simple console application, which get data from SharePoint list and displays it. It’s very good solution if SharePoint is used as a storage of rates, catalogs, libraries etc. To use SharePoint Client model you should add references to Microsoft.SharePoint.Client.dll and Microsoft.SharePoint.Client.Runtime.dll in your solution. Read more»

.Net & C#

Concatenate SharePoint list items values

Most of all I use PowerShell for administration of SharePoint portal. But also I use it when I need to make some actions with SharePoint lists – get items, update items, remove items (link how to remove items) or to make report based on lists on SharePoint. Read more»

SharePoint

Remove Items from SharePoint Recycle filtered by URL

If you removed a number of SharePoint list items (moved to Recycle Bin), I think you want to clean the Recycle from them. Of course you can remove them manually but it’s not a good idea if you have deleted 10000 records or more (Remove a lot of elements from very large SharePoint Lists). Read more»

SharePoint

Remove a lot of elements from very large SharePoint Lists

Lists in SharePoint is only look like database tables but not they are. For some things they are even better than databases – for common users for example, but for developers and administrators they are often not so good and friendly. Read more»

SharePoint

How to create fake users in SharePoint with real names

While migration system and its data to SharePoint application there was a task to save logs of change from old system data. Some authors of changes have already retired – some of them are disabled in Active Directory, others – deleted at all. Read more»

SharePoint

CAML: Select SharePoint List Items with not empty column values

Once I needed a CAML query for selecting elements with non-empty column. I wanted to select all the users with name detected (filled) and with OS “Windows”. First I decided to use <Neq> construction and <Value Type=’Text’></Value>. I thought it’s an analog for var != “”. But the result was wrong. Read more»

SharePoint

Get available SharePoint list field options in a field type (Multi)Choice from codebehind

In a list with a field type “Choice” you can know available options of this field from codebehind without reading all list values and not making them unique with Distinct(). Especially, you can’t just read and make Distinct() list values if your field allows multiple choice or if you don’t have all options. Read more»

SharePoint

Working with lookup values in SharePoint Lists

Working with SharePoint lists I often use lookup values. But when I write C# solutions for lists I have some difficulties with LookUp Values. Trying to get LookUp Value as string it looks like “213;#lookup value”. Read more»

SharePoint

Popular Posts