shelf 3195135 1920

Filtering for SharePoint items with CAML Queries

Most of our times, we just need just a bunch of items, to export them or to change their values. This post should help you to show, how to handle filtering for SharePoint items. Besides filtering for SharePoint items with Where-Object, you can also make use of CAML (Collaborative Application Markup Language), which lets you […]


Determine internal name of SharePoint Columns with GUI

You have to determine the internal name of SharePoint columns, when you want to get the values of the items programatically or develop some apps with PowerApps. If you make use of display names of columns, you might not get the values of the columns, that’s why you should use the internal name of the […]

code preview image

Getting FieldValues of Items

Getting all values of all items If you want to retrieve all fieldvalues of an item, you can use following steps. I am getting the opportunities of the sales department Connect to SharePoint Online with PNP. If you don’t know how to, check the post. I am connecting with the sales site Connect-PnPOnline -Url “” […]

PowerShell code

PNP.PowerShell: How to connect to SharePoint Online with PowerShell

This article describes how to connect to SharePoint Online by using the PowerShell Module PNP.PowerShell Prerequisites An global admin approval for the enterprise app PNP.PowerShell Internet access Installation PNP.PowerShell I recommend using the latest PNP.PowerShell Module to connect to SharePoint Online. PNP stands for Patterns and Practices You can find it here: PnP PowerShell | […]