Fetch Username from Lookup-Column using Powershell-PNP

Question

I am trying to retrieve the actual username from a lookup column, the closest I got is

$test=(Get-PnPListItem -List $list -Fields Owner -Id 1).FieldValues

This of course returns the value as Microsoft.SharePoint.Client.FieldUserValue.

Any suggestions?

Ganesh Sanap - MVP · Accepted Answer · 2019-08-14 08:35:36Z

2

I will answer my own question just in case it's useful for others.

First we need to pull the list item:

$listitem=(Get-PnPListItem -List "TestList" -id $itemid).FieldValues

Then pick the column where the user information is stored and get the email back:

$team_lead_email=$listitem["TeamLeader"].Email

If the field has multiple entries we have to loop through the entries:

$users=$listitem["TeamMembers"].Email


foreach ($User in $Users) { 
    Add-PnPUserToGroup -LoginName $User -Identity "$Team Members"
}

47.3k22 gold badges32 silver badges64 bronze badges

answered Feb 20, 2018 at 16:37

user3202981

953 silver badges8 bronze badges

1 Answer 1