Tag: Scripting

How to use LINQ in PowerShell to compare arrays
LINQ stands for Language Integrated Query and if you use LINQ in PowerShell it might boost the performance of your scripts. In this article, I’ll show you how to use LINQ in PowerShell for comparing arrays.

In this article, I will show you except and intersect of LINQ. There are many more methods. If you are interested in other methods, check out the official documentation of Microsoft.

Concept of using LINQ in PowerShell

We have three amounts red, orange and yellow. The aim is to only get a specific amount e.g. only the red portion.
```
$Red = @( "A", "B", "C")
$Yellow = @("C","D","E")
```
We also can do this for integer values.
```
$Red = @( 1..5)
$Yellow = @(4..10)
```
Using LINQ for Strings in arrays

I will show you how to use LINQ for string in this chapter. We will cover the methods except and intersect.

String – Get the red amount

In order to get the red amount, you have to do following:
```
$Red = @( "A", "B", "C")
$Yellow = @("C","D","E")

$Left  = [string[]]$Red
$Right = [string[]]$Yellow

[string[]][Linq.Enumerable]::Except($Left, $Right)
```
By doing this, you’ll get only A and B:

String – Get the yellow amount

In order to get the red amount, you have to change Right and Left in the LINQ cmdlet:
```
$Red = @( "A", "B", "C")
$Yellow = @("C","D","E")

$Left  = [string[]]$Red
$Right = [string[]]$Yellow

[string[]][Linq.Enumerable]::Except($Right, $Left)
```
By doing this, you’ll get only D and E:

String – Get the orange amount

If we want to get the orange amount, we have to make use of intersect
```
$Red = @( "A", "B", "C")
$Yellow = @("C","D","E")

$Left  = [string[]]$Red
$Right = [string[]]$Yellow

[string[]][Linq.Enumerable]::Intersect($Left, $Right)
```
String – Get everything except orange
```
$Red = @( "A", "B", "C")
$Yellow = @("C","D","E")

$Left  = [string[]]$Red
$Right = [string[]]$Yellow

[string[]]([Linq.Enumerable]::Except($Left, $Right) + [Linq.Enumerable]::Except($Right, $Left))
```
By doing this, you’ll everything but not C:

Using LINQ for integers in arrays

I will show you how to use LINQ for integers in this chapter. We will cover the methods except and intersect.

Integer – Get the red amount

In order to get the red amount, you have to do following:
```
$Red = @( 1..5)
$Yellow = @(4..10)

$Left  = [int[]]$Red
$Right = [int[]]$Yellow

[int[]][Linq.Enumerable]::Except($Left, $Right)
```
By doing this, you’ll get only 1, 2, 3:

Integer – Get the yellow amount

In order to get the red amount, you have to change Right and Left in the LINQ cmdlet:
```
$Red = @( 1..5)
$Yellow = @(4..10)

$Left  = [int[]]$Red
$Right = [int[]]$Yellow

[int[]][Linq.Enumerable]::Except($Right, $Left)
```
By doing this, you’ll get only 6, 7, 8, 9, 10:

Integer – Get the orange amount

If we want to get the orange amount, we have to make use of intersect
```
$Red = @( 1..5)
$Yellow = @(4..10)

$Left  = [int[]]$Red
$Right = [int[]]$Yellow

[int[]][Linq.Enumerable]::Intersect($Right, $Left)
```
Integer – Get everything except orange
```
$Red = @( 1..5)
$Yellow = @(4..10)

$Left  = [int[]]$Red
$Right = [int[]]$Yellow

[int[]]([Linq.Enumerable]::Except($Left, $Right) + [Linq.Enumerable]::Except($Right, $Left))
```
By doing this, you’ll everything but not 5:

Read more
July 8, 2021

Dealing with existing SharePoint connections

We all can Imagine the scenario. You create sites in sharepoint and now you want to edit multiple sites afterwards with PowerShell. In order to be safe, we have to check, wether an connection exists and if yes to disconnect the current connection to have a clean processing of the sites. In this article I want to show you how can achieve dealing with existing SharePoint connections. If you don’t know how to connect to SharePoint Online, check the article.

Symptoms – How I tried it first

I tried to check the connection by a normal if query, but as you can see it throws everytime an error, so the script will be halted under normal circumstances. Changing the ErroActionPreference is something you could do for sure, but I would not recommend it, if you want to handle other upcomming potential errors of the API. So as you can see dealing with existing SharePoint connections in terms of checking, wether an connection exists, is not that easy.

if ((Get-PnPConnection) )
{
    Write-Host "Connection found"
}
Get-PnPConnection : The current connection holds no SharePoint context. Please use one of the Connect-PnPOnline commands which uses the -Url argument to connect.
In Zeile:2 Zeichen:6
+ if ((Get-PnPConnection) )
+      ~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Get-PnPConnection], InvalidOperationException
    + FullyQualifiedErrorId : System.InvalidOperationException,PnP.PowerShell.Commands.Base.GetPnPConnection
PS H:>> 
if ((Get-PnPConnection) -ne $Null )
{
    Write-Host "Connection found"
}
Get-PnPConnection : The current connection holds no SharePoint context. Please use one of the Connect-PnPOnline commands which uses the -Url argument to connect.
In Zeile:2 Zeichen:6
+ if ((Get-PnPConnection) -ne $Null )
+      ~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Get-PnPConnection], InvalidOperationException
    + FullyQualifiedErrorId : System.InvalidOperationException,PnP.PowerShell.Commands.Base.GetPnPConnection
PS H:>> 
if ((Get-PnPConnection|out-null) -ne $Null )
{
    Write-Host "Connection found"
}
Get-PnPConnection : The current connection holds no SharePoint context. Please use one of the Connect-PnPOnline commands which uses the -Url argument to connect.
In Zeile:2 Zeichen:6
+ if ((Get-PnPConnection|out-null) -ne $Null )
+      ~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Get-PnPConnection], InvalidOperationException
    + FullyQualifiedErrorId : System.InvalidOperationException,PnP.PowerShell.Commands.Base.GetPnPConnection
PS H:>> 
if ((Get-PnPConnection -ErrorAction SilentlyContinue) -ne $Null )
{
    Write-Host "Connection found"
}
Get-PnPConnection : The current connection holds no SharePoint context. Please use one of the Connect-PnPOnline commands which uses the -Url argument to connect.
In Zeile:2 Zeichen:6
+ if ((Get-PnPConnection -ErrorAction SilentlyContinue) -ne $Null )
+      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Get-PnPConnection], InvalidOperationException
    + FullyQualifiedErrorId : System.InvalidOperationException,PnP.PowerShell.Commands.Base.GetPnPConnection

Solutions

Try Catch Solution

In order to handle this situation, you have to catchup the error.

The snippet tries to check wether there is an connection and if there is one, it will proceed and disconnect it. After disconnecting it I have set the variable $connection to $null, so I can process it later on.

try 
{
    Get-PnPConnection -ErrorAction Stop
    Disconnect-PnPOnline
    $Connection = $null
}
catch 
{
    $Connection = $null
}

BONUS 1: Invoke-PNPConnection with Credential object (No MFA enforcement)

A function which handles the whole procedure of cutting of the connection and reconnecting, makes the handling easier. In this case I have added an additional check of the contents of lists, because sometimes you do connect, but experience that the webserver is not ready yet – basically you get an 403 FORBIDDEN message in PowerShell.

NOTE: This will only work If your user has no MFA enforcement. If you have MFA enabled, I have another function for you.

Function Invoke-PNPConnection ($Url, $Cred)
{
    try 
    {
        Get-PnPConnection -ErrorAction Stop
        Disconnect-PnPOnline
        $Connection  = $null
    }
    catch
    {
        $Connection  = $null
    }
    $i = 1
    while ($null -eq $Connection -and $i -le 6 -and $null -eq $Lists)
    {
        Write-Verbose "Trying to connect to $Url for the $i time" 
        $Lists = $null
        Connect-PnPOnline -Url $Url -Credentials $Cred
        $Lists = Get-PnPList -ErrorAction SilentlyContinue
        $i++
        if ($i -ne 1 -and $null -eq $Lists)
        {
            Start-Sleep -Seconds 30
            Write-Verbose "Wait 30 Seconds"
        }
    }
    Write-Verbose "Connection to $Url established"
}

You can call the function like this

$Cred = get-credential
$Url = "https://contoso.sharepoint.com/sites/Sales"
Invoke-PNPConnection -Url $Url -Cred $Cred

Bonus 2: Invoke-PNPConnection interactively (MFA enforced)

So if you use the scripts interactively (with MFA enforced users), you can make use of this function

Function Invoke-PNPConnection ($Url)
{
    try 
    {
        Get-PnPConnection -ErrorAction Stop
        Disconnect-PnPOnline
        $Connection  = $null
    }
    catch
    {
        $Connection  = $null
    }
    $i = 1
    while ($null -eq $Connection -and $i -le 6 -and $null -eq $Lists)
    {
        Write-Verbose"Trying to connect to $Url for the $i time" 
        $Lists = $null
        Connect-PnPOnline -Url $Url -Interactive
        $Lists = Get-PnPList -ErrorAction SilentlyContinue
        $i++
        if ($i -ne 1 -and $null -eq $Lists)
        {
            Start-Sleep -Seconds 30
            Write-Verbose "Wait 30 Seconds"
        }
    }
    Write-Verbose "Connection to $Url established"
}

Start the function like this

$Url = "https://contoso.sharepoint.com/sites/Sales"
Invoke-PNPConnection -Url $Url

Conclusio

There are ways to deal with the connections, you just have to think a bit OOTB 🙂

You might find intersting

If you are not familiar with connecting to SharePoint, check out this Post: Connect to SharePoint Online with PowerShell

Original article of PNP Connecting with PnP PowerShell | PnP PowerShell

Images:
Bild von Meine Reise geht hier leider zu Ende. Märchen beginnen mit auf Pixabay

Bild von vargazs auf Pixabay

Bild von Ina Hoekstra auf Pixabay

Bild von saulhm auf Pixabay

June 25, 2021

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 get only the items, you need. It might increase the performance of your queries, when you are dealing with large amounts of data.

Where are the items, which I am looking for?

Preqrequistes

If we want to achieve filtering for SharePoint items, with a CAML query, we have to fulfill following prerequisites:

Permissions to access the list
Installed Module PNP.Powershell. If you don’t know how to, check the post .
Connection to the site via PNP.PowerShell. If you don’t know how to, check the post .

Considerations

You should take care of the case sensitivity of operands and column names
You should take care of the <view> part. Sometimes it is needed, sometimes not – so I would rely on the examples.

Query Schema

A query is structured like this

 "<View><Query><Where><LOGICAL OPERATOR><FieldRef Name='INTERNAL NAME OF COLUMN'/><Value Type='VALUE TYPE'>VALUE</Value></LOGICAL OPERATOR></Where></Query></View>"

You can find the internal name of columns in two ways:

PowerShell or GUI.

Explanation for PowerShell: Getting FieldValues of Items | SPO Scripts
Explanation for GUI: Determine internal name of SharePoint Columns with GUI (workplace-automation.com/)

Value types

Type	Meaning	Examples
Boolean	It means true or false. You can find this in yes/no checkboxes	true, false true reflects 1 false reflects 0
Choice	It reflects the choices in your sharepoint list	apple, banana
Currency	It reflects the amount of an defined currency	5$
DateTime	It reflects a timestamp	23.06.2021 15:30
GUID	Globally Unique Identifier (GUID)	6154ff96-8209-457b-86dd-ee7dcd80b584
Integer	It reflects a number as an integer	10
Lookup	Links to another list: for example an Orders list may have a lookup field that links to customers in a Customer list;	Füller AG
Note	Reflects a multi line text field. Not sortable or groupable	Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec odio. Quisque volutpat mattis eros. Nullam malesuada erat ut turpis. Suspendisse urna nibh, viverra non, semper suscipit, posuere a, pede.
Text	Reflects a single line text field. Sortable and groupable. Corresponds to the nvarchar SQL data type and represented by the SPFieldText class.	Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
User	A Lookup field that references the UserInfo database table.	Email TypeId LookupId LookupValue —– —— ——– ———– Serkar@devmodernworkplace.onmicrosoft.com {c956ab54-16bd-4c18-89d2-996f57282a6f} 11 Serkar Aydin

Source: Field element (Field) | Microsoft Docs

Logical Comparison Operators

In this case X means your entry

Operator	Meaning
BeginsWith	The existing value begins with X
Contains	The existing value contains x
DateRangesOverlap	The existing date overlaps the date range defined in x `\|---- 01.01.-07.01 ------\|` `\|---02.01-09.01 -----\|`
Eq	The existing value equals x
Geq	The existing value is greater or equal x
Gt	The existing value is greater than x
In	X is one of the existing values
Includes	checks, whether x is in the defined values
NotIncluses	checks, whether x is not in the defined values
IsNotNull	Checks wheter the existing value is not null
IsNull	Checks wheter the existing value is null
Leq	The existing value is lower equal x
Lt	The existing value is lower than x

Source: Query schema in CAML | Microsoft Docs

In order to filter by query paramter, you have to define a filter query, depending on your datatype (string, integer, boolean..) you have to choose a different query value type.

Logical Joins

Operator	Meaning
And	Both query operations have to be fulfilled
Or	Only one query operation have to be fulfilled

Source: Query schema in CAML | Microsoft Docs

Query Examples

My blog would not keep it’s promise, If you would not find examples, which give you a fast way to adapt the scripts, so here we go!

In my example, I am using my demo opportunities list. I have marked the names of the columns, the value types, the operands and the actual values bold. Mostly I am using the logical operator “eq”, but I think if you got the basic concept of this, you can adapt it to your solution easily and if not, we will find a way together.

Example for boolean

If you want to find items with TRUE values, you have to enter 1. For FALSE values, you have to make use of 0.

If boolean should be true:

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Eq><FieldRef Name='Win'/><Value Type='Boolean'>1</Value></Eq></Where></Query></View>"

If boolean should be false:

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Eq><FieldRef Name='Win'/><Value Type='Boolean'>0</Value></Eq></Where></Query></View>"

Example for choice

If you want to filter for values choice values, you have to make use of a query like this:

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Eq><FieldRef Name='Product'/><Value Type='Choice'>SAP</Value></Eq></Where></Query></View>"

Example for currency

You have to enter the value of the amount without the currency sign.

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Eq><FieldRef Name='DealSize'/><Value Type='Currency'>40000</Value></Eq></Where></Query></View>"

Example for DateTime

You have to format date times according to this format (ISO8601).

yyyy-MM-ddTHH:mm:ssZ

You can do this by appending -Format s, when creating the variable

$CreationDate = Get-Date "16.06.2021 20:04" -Format s

If DateTime should exactly match a specific date

$CreationDate = Get-Date "16.06.2021 20:04" -Format s
Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Eq><FieldRef Name='Created'/><Value Type='DateTime' IncludeTimeValue='FALSE'>$CreationDate</Value></Eq></Where></Query></View>"

If DateTime should be after a specific date

Example: I want to find all items, created after 15.06.2021.

$CreationDate = Get-Date "15.06.2021" -Format s
Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Gt><FieldRef Name='Created'/><Value Type='DateTime' IncludeTimeValue='FALSE'>$CreationDate</Value></Gt></Where></Query></View>"

If DateTime should be before a specific date

Example: I want to find all items, created before 15.06.2021.

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Lt><FieldRef Name='Created'/><Value Type='DateTime' IncludeTimeValue='FALSE'>$CreationDate</Value></Lt></Where></Query></View>"

Example for GUID

[GUID]$UniqueID= "b4ae9e9f-7103-459a-acb2-73573d035b36"
Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Eq><FieldRef Name='UniqueId'/><Value Type='GUID'>$UniqueID</Value></Eq></Where></Query></View>"

Example for integer

In this case I want to find all opportunites with 2 stakeholders.

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Eq><FieldRef Name='Stakeholder'/><Value Type='Integer'>2</Value></Eq></Where></Query></View>"

Example for lookup

Get-PnPListItem -List "Opportunities" -Query "<Query><Where><Eq><FieldRef Name='Contact'/><Value Type='Lookup'>Sus Spicious</Value></Eq></Where></Query>"

Example for Note aka multi line text

Get-PnPListItem -List "Opportunities" -Query "<Query><Where><Eq><FieldRef Name='Notes'/><Value Type='Note'>He was really curious.</Value></Eq></Where></Query>"

Example for text aka string

In this Query, I am looking for items, where the title equals Opp 3.

Get-PnPListItem -List "Opportunities" -Query "<Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>Opp 3</Value></Eq></Where></Query>"

Example for user

In this query, I am looking for items, where the authors UPN is Serkar@devmodernworkplace.onmicrosoft.com.

Get-PnPListItem -List "Opportunities" -Query "<Query><Where><Eq><FieldRef Name='Author' /><Value Type='User'>Serkar@devmodernworkplace.onmicrosoft.com</Value></Eq></Where></Query>"

Example for OR

In this query, I am looking for items, where the value for Stakeholder is 1 or the value Win is yes.

Get-PnPListItem -List $ListName -Query "<View><Query><Where><Or><Eq><FieldRef Name='Stakeholder'/><Value Type='Integer'>1</Value></Eq><Eq><FieldRef Name='Win'/><Value Type='Boolean'>1</Value></Eq></Or></Where></Query></View>"

Example for AND

In this query, I am looking for items, where the value for Stakeholder is 1 and the value Win is yes.

Get-PnPListItem -List $ListName -Query "<View><Query><Where><And><Eq><FieldRef Name='Stakeholder'/><Value Type='Integer'>1</Value></Eq><Eq><FieldRef Name='Win'/><Value Type='Boolean'>1</Value></Eq></And></Where></Query></View>"

Complete example

$Url = "https://devmodernworkplace.sharepoint.com/sites/Sales" 
$ListName = "Opportunities"

Connect-PnPOnline -Url $Url -Interactive

$AmountOfStakeholders = 2
$ColumName = "Stakeholder"

Get-PnPListItem -List $ListName -Query "<View><Query><Where><Eq><FieldRef Name='$ColumName'/><Value Type='Integer'>$AmountOfStakeholders</Value></Eq></Where></Query></View>"

Troubleshooting

I am getting to many items

Error

You get nearly every item in the list, but you are filtering for specific SharePoint items

Cause

Maybe you forgot the <View> part?

Resolution

Without view:

With view:

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Eq><FieldRef Name='Stakeholder'/><Value Type='Integer'>2</Value></Eq></Where></Query></View>"

Exception from HRESULT: 0x80131904

Error message:

Get-PnPListItem : Exception from HRESULT: 0x80131904
In Zeile:1 Zeichen:1
+ Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><gt ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (:) [Get-PnPListItem], ServerException
    + FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Lists.GetListItem

Cause:

You did not care about the case sensitivity of the logical operands

Resolution:

Wrong:

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><gt><FieldRef Name='Created'/><Value Type='DateTime' IncludeTimeValue='FALSE'>$CreationDate</Value></gt></Where></Query></View>"

Right:

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Gt><FieldRef Name='Created'/><Value Type='DateTime' IncludeTimeValue='FALSE'>$CreationDate</Value></Gt></Where></Query></View>"

Field types are not installed properly

Error message in german

Get-PnPListItem : Mindestens ein Feld ist nicht richtig installiert. Wechseln Sie zur Listeneinstellungsseite, um diese Felder zu löschen.
In Zeile:1 Zeichen:1
+ Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Gt ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (:) [Get-PnPListItem], ServerException
    + FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Lists.GetListItem

Error message in english

Get-PnPListItem : One or more field types are not installed properly. Go to the list settings page to delete these fields.
In Zeile:1 Zeichen:1
+ Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Gt ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : WriteError: (:) [Get-PnPListItem], ServerException
    + FullyQualifiedErrorId : EXCEPTION,PnP.PowerShell.Commands.Lists.GetListItem

Cause

You did not care of the case sensitivity of the column name

Resolution

Wrong:

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Gt><FieldRef Name='created'/><Value Type='DateTime' IncludeTimeValue='FALSE'>$CreationDate</Value></Gt></Where></Query></View>"

Right:

Get-PnPListItem -List "Opportunities" -Query "<View><Query><Where><Gt><FieldRef Name='Created'/><Value Type='DateTime' IncludeTimeValue='FALSE'>$CreationDate</Value></Gt></Where></Query></View>"

Bild von Deedee86 auf Pixabay

June 20, 2021

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 "https://devmodernworkplace.sharepoint.com/sites/Sales" -Interactive
- After connecting, get the list.
  
  $Items =Get-PnPListItem -List "YourList"
  
  I am using the list opportunities:
  
  $Items =Get-PnPListItem -List "Opportunities"
  
  If you don’t know what the internal name of your list is, you can make use of the cmdlet
  
  $Items = Get-PNPListItem | Out-Gridview -Passthru
After getting the items, you can get all fieldvalues like this:
$Items.Fieldvalues

Filter items by specific value

You can filter items like this. You have to use the key, which you get with $Items. FieldValues

Filter by Where Object

$Item = $Items | Where-Object {$_.Fieldvalues["KEY"] -eq "VALUE"}

I filter for items with the title Opp 2

$Item = $Items | Where-Object {$_.Fieldvalues["Title"] -eq "Opp 2"}

Filter by -Query Parameter

I have created a separate post for this. Check it out.

Getting only specific amount of Items

It might happen, that your list contains many items. In order to get only 1000 Items, make use of the parameter -PageSize

Get-PnPListItem -List "Opportunities" -PageSize 1000

Getting a specific value for specific item

First get one single item, either by filtering, or by using the index

You can use indexing with following method

$Item= $Items[INDEX]

For the first Item: $Item = $Items[0]

For the second Item: $Item = $Items[1] etc,

If you got a single item, you can get the fieldvalues like this:

$item.FieldValues.KEY

In my case I use the key “Product”

$item.FieldValues.Product

Or “Contact”

Example script to get all fieldvalues for all items
```
$Url = "https://devmodernworkplace.sharepoint.com/sites/Sales" 
$ListName = "Opportunities"

Connect-PnPOnline -Url $Url -Interactive
$Items = Get-PnPListItem -List $ListName

$Items.Fieldvalues
```
Example script to get all fieldvalues for a specific item
```
$Url = "https://devmodernworkplace.sharepoint.com/sites/Sales" 
$ListName = "Opportunities"

Connect-PnPOnline -Url $Url -Interactive
$Items = Get-PnPListItem -List $ListName

$Item =  $Items | Where-Object {$_.Fieldvalues["Title"] -eq "Opp 2"}

$item.FieldValues
```
June 16, 2021

Tag: Scripting

How to use LINQ in PowerShell to compare arrays

Concept of using LINQ in PowerShell

Using LINQ for Strings in arrays

String – Get the red amount

String – Get the yellow amount

String – Get the orange amount

String – Get everything except orange

Using LINQ for integers in arrays

Integer – Get the red amount

Integer – Get the yellow amount

Integer – Get the orange amount

Integer – Get everything except orange