Sharepoint online list cmdlets

Sharepoint online is way better than hosting Sharepoint yourself, unless you like torture. However, I’ve found the availability of Powershell cmdlets for Sharepoint Online, specifically for searching and adding to lists.

There were a few community-provided solutions, but I found the performance of them to be poor with large lists. With some advanced Google-fu and a few hours of browsing TechNet pages, I was able to come up with something better.

Simple Sharepoint List Cmdlets

Now basic list tasks are as simple as this:

Import-Module "C:\Path\To\SharepointCmdlets.psm1"
$c = New-SPContext -URL "https://mytenant.sharepoint.com/mysite" -UserID "MyUser@MyTenant.com" -Password $SecurePassword
$myList = Get-SPList -Context $c -ListName "My List"
$myArray = Get-SPListItems -Context $c -List $myList -Fields "ID","Title","Description","Notes"

More advanced documentation is at the GitHub link above, as well as in comments in the code itself. Hopefully this helps someone else!

My problem with open-source in a nutshell

Don’t get me wrong, I love me some OSS. However, I find that there are often times where a project is 90%-95% complete, but is missing one or two key features that would really make it a commercial software killer.

Case in point: The OpenOffice Writer ruler.

 

This beast right here looks almost identical to what we’re used to in MS Word, but there is one key difference. In Word, your tabs and margins will snap-to-grid, allowing you to align various sections of your document nicely. In OOo, all items move “fluidly”, meaning you have to line up stops in different parts of your document to the pixel. I can only imagine how mind-numbingly frustrating this must be on a Retina display.

From what I gather, this issue was first entered into the OOo bug tracker back in early 2004. Yes, that’s over 10 years ago as of the writing of this post.

https://issues.apache.org/ooo/show_bug.cgi?id=24070

To save you the time of reading this entire bugtracker log, the general response from the dev team has been “This is not a priority”, and one going as far as saying “I never use the mouse”. Great, so you never use your mouse. That means that every other person who uses your application doesn’t either, right? Who cares about the “average” user, they’re not as smart therefore they don’t matter, right? Doing a quick Google search shows the same types sentiments in forums and duplicate issue tracks all over the place.

Community-driven open source projects have been lifesavers in my experience. They have also proven that they have the power to shape the technology market. But, this elitist attitude has GOT to go.