SharePoint lookup column error:
“Value does not fall within the expected range”.
This lookup column error is very generic and can be very frustrating too especially when you have taken care to ensure that everything is right. I have often encountered this error when working with SPListItem values for lookup columns, people pickers and choice columns.
SharePoint
This is where I log all things SharePoint. I have worked on various versions of SharePoint. So, each post will usually specify what version I'm talking about (some times, the post will apply to pretty much all versions). Beyond SharePoint, this section may also hold content pertaining to other related Microsoft technologies like Office 365, Azure, C# (C Sharp), PowerShell, etc.
Repackage A SharePoint WSP
You may someday need to hack into, edit and repackage a SharePoint WSP file. This article explains how.
InfoPath Case Conversion Rules
Three handy InfoPath case conversion rules. They are applied to the data in the current field (as indicated by the dot “.” character). But hopefully, you’ll not need these anymore since InfoPath has pretty much died (and a very welcome death as well).
PowerShell script to delete SharePoint orphaned users
Orphaned users in SharePoint are users that have been disabled or completely deleted from active directory but are still referenced in list items and sites, and especially in the SharePoint people picker control. This article explains how to remove them using PowerShell.
Error opening InfoPath document containing BCS data in Office 2013
Windows desktop and Windows server fix for error when opening InfoPath document: “The current operation requires Business Connectivity Services client components. Install Business Connectivity Services client components and try again.”
Edit SharePoint Quick Launch Programmatically
I have done quite a bit of programmatic manipulation on the SharePoint quick launch bar in C# so I decided to write this article that logs some of the tips and tricks I have used. Here you will find how to add and delete items, update links and text in parent and children nodes, add headings (items without links), add links that open in new window, and handle audience targeting for specific quick launch links.