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...)

Below I write a powershell script to get the author and date of creation of SharePoint List. Today I have suddenly found out the new list. I was very surprised to see it and wanted to know who and when created it.

(read more...)

In this post I write some examples of C# coding for SharePoint list items. These methods are rather fast and it's very actual for SharePoint. (read more...)

PowerShell script to add column to SharePoint list. It' useful when you want to make changes in your SharePoint list in test area and then to repeat in productive one. (read more...)

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...)

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...)

Unfortunately, there’s no equivalent for "Truncate" in SharePoint Lists. It’s not very good. If your list has more than 1000 items and you need to load only new data to list, you need to remove all existing items and to add new ones. This task is easy to code but not very fast to execute. (read more...)

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...)

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...)

Today while coding a Sharepoint timer job I needed to clean my SPList.

I tried common ways of deleting using "foreach" and "for i++ ..." but I got the error. I couldn't delete list and create it again in timer job because of custom views. As usually for SharePoint solution is not ordinary 🙂 (read more...)