SharePoint Online: Get Email, Display Name, Login ID from “Created By” Column in PowerShell

Requirement: Get User Name, Email, Login ID, etc. from the “Created By” field value of a List Item using PowerShell

PowerShell to Retrieve User Object from “Created By” Field:

Have you ever wanted to obtain the Email of a user who created an item in SharePoint Online in the middle of a PowerShell script?

#Load SharePoint CSOM Assemblies
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"
Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

#Variables for Processing
$SiteURL = "https://crescent.sharepoint.com/sites/PMO"
$ListName = "Projects"
$ItemID = "1"

#Get Credentials to connect
$Cred = Get-Credential

Try { 
    #Setup the context
    $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
    $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)

    #Get the List Item
    $List = $Ctx.Web.Lists.GetByTitle($ListName)
    $ListItem = $List.GetItemById($ItemId)
    $Ctx.Load($ListItem)
    $Ctx.ExecuteQuery()

    #Get the "Created By" column value of the Item
    $CreatedBy = $ListItem.FieldValues["Author"]

    #Get the User Object
    $User = $Ctx.Web.GetUserById($CreatedBy.LookupId)
    $Ctx.Load($User)
    $Ctx.ExecuteQuery()

    $User | Select Email, Title, LoginName   
}
Catch {
    write-host -f Red "Error:" $_.Exception.Message
}

PnP PowerShell to Get Emails of Users who have Created the Documents

How about getting emails from the uploaded documents? Let’s retrieve users’ emails who uploaded files in a SharePoint Online document library.

#Parameters
$SiteURL = "https://crescent.sharepoint.com/sites/marketing"
$ListName = "Branding"

#Connect to PnP Online
Connect-PnPOnline -Url $SiteURL -Interactive

#Get All Files from the document library - In batches of 500
$Files = Get-PnPListItem -List $ListName -PageSize 500 | Where {$_.FileSystemObjectType -eq "File"}
 
#Loop through all documents
[email protected]()
ForEach($File in $Files)
{
    #Collect Documents Data
    $DocumentsData += New-Object PSObject -Property @{
        FileName = $File.FieldValues.FileLeafRef
        URL = $File.FieldValues.FileRef
        AuthorEmail = $File.FieldValues.Author.Email
    }
}
#Get Files Data
$DocumentsData

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

Leave a Reply