Cannot use a variable in where clause

Question

I am using the PnP SharePoint powershell moudle and trying to filter a users list based on a variable.

Currently here is what I have:

$RootFolder = '/Path/To/Folder'

$folders = Get-PnPFolderItem -FolderSiteRelativeUrl $RootFolder

foreach ($folder in $folders){
    $user = Get-PnPUser | Where Title -Like "*$folder.Name*"}
}

This does not return results. However, if i change | Where Title -Like "*username*" it works fine.

The user name format is "FirstName LastName (FLastName)" and i am trying to filter based on "FLastName".

I tried single quotes and also created a variable $username = "*" +$folder.Name+ "*" and used that variable instead but no difference.

Any thoughts would be appreciated.

Mike Smith - MCT · Accepted Answer · 2018-03-14 17:54:48Z

2

Try this:

Where Title -Like "*$( $folder.Name )*"

The variable expansion/replacement ends with the "." in a simple string.

answered Mar 14, 2018 at 17:54

Mike Smith - MCT

6,8372 gold badges14 silver badges21 bronze badges

Add a comment |

jAC · Accepted Answer · 2018-03-14 18:34:36Z

0

Edited to use Mike Smith's solution.

I was able to get this to work by doing the following adjustment (adding string to the variable)

$RootFolder = '/Path/To/Folder'

$folders = Get-PnPFolderItem -FolderSiteRelativeUrl $RootFolder

foreach ($folder in $folders){
    $user = Get-PnPUser | Where Title -Like "*$($folder.Name)*"}
}

edited Mar 14, 2018 at 18:34

answered Mar 14, 2018 at 17:50

jAC

2172 gold badges4 silver badges10 bronze badges

Add a comment |

Stack Exchange Network

Cannot use a variable in where clause

2 Answers 2

Your Answer

Hot Network Questions

Cannot use a variable in where clause

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions