Unable to connect sharepoint online site collection using powershell

Question

I have to upload the CSV file data to the SharePoint list using Powershell, here the connection is established up to the admin site. but it is not accessing the Sharepoint site collection, showing an error like as:

Connect-SPOService : Could not authenticate to SharePoint Online https://siteurl(here I am providing actuall site url, till site name)using OAuth 2.0
At line:1 char:1
+ Connect-SPOService
+ ~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Connect-SPOService], AuthenticationException
+ FullyQualifiedErrorId : Microsoft.Online.SharePoint.PowerShell.AuthenticationException,Microsoft.Online.SharePoint.PowerShell.ConnectSPOService

farismalaeb · Answer

Have you tried to use the PNP Module?

kevin_morgan · Answer

Lokeswar_Reddy&nbsp;&nbsp;This is expected error since you need to pass the Admin site URL (Tenant site url) for&nbsp;Connect-SPOService.&nbsp;You can check this post :&nbsp;https://docs.microsoft.com/en-us/powershell/module/sharepoint-online/connect-sposervice&nbsp;&nbsp;Connect-SPOService -url https://TenantName-admin.sharepoint.com&nbsp;&nbsp;As you know, the&nbsp;Connect-SPOService cmdlet is belong to SPO Management module. For List items update, you have to either use CSOM based script or PnP PowerShell commands.&nbsp;&nbsp;$SiteUrl = "https://crescent.sharepoint.com/sites/marketing"
$ListName = "CustomerContacts"
$CSVPath = "C:	emp\CustomerContacts.csv"
 
#Get CSV file content
$CSVData = Import-CsV -Path $CSVPath
 
#Connect to site
Connect-PnPOnline $SiteUrl -Interactive
 
#Iterate through each Row in the CSV and import as list item SPO List
ForEach ($Row in $CSVData)
{
#Add List Items
Add-PnPListItem -List $ListName -Values @{
"CustomerName" = $($Row.CustomerName);
"Email" = $($Row.Email); 
"Mobile" = $($Row.Mobile);
};
}&nbsp;&nbsp;&nbsp;&nbsp;

kevin_morgan · Answer

Kevin_Morgan&nbsp;&nbsp;The point is: You can't connect the individual site collection using this command (Connect-SPOService ). The command is designed to connect only with admin site. Once you connected the Admin site, you can use the following command to get specific site details.&nbsp;&nbsp;Get-SPOSite -Identity https://contoso.sharepoint.com&nbsp;&nbsp;And you can use the commands listed in the below post to manage SPO sites.&nbsp;https://docs.microsoft.com/en-us/powershell/module/sharepoint-online/?view=sharepoint-ps&nbsp;You can use these commands only to manage SPO sites and I believe, you can't manage specific list or list items using these commands. So, you have to either use PnP PowerShell or CSOM based PowerShell.&nbsp;

lokeswar_reddy · Answer

Thanks for your reply,Actually, I do not see any error while connecting to the admin site, only here this issue is connecting to the Sharepoint site collection.please let me know about this issue.

Forum Discussion

Unable to connect sharepoint online site collection using powershell

4 Replies

Resources