Forum Discussion

tcboeira's avatar
tcboeira
Brass Contributor
Apr 06, 2022
Solved

Change the language of some - or all - Sharepoint Online sites

Hello, Our settings were practically the default system activation, and without a doubt the time for adjustment has arrived... Searching the Internet, in the available documentation, I couldn't f...
admin
SharePoint Online
Sites
  • Vertebre85's avatar
    Vertebre85
    Apr 06, 2022

    tcboeira 

    Hi
    When a site is created, it's too late to change language. You can only act on the display language, but onedrive and sharepoint, when created can't be changed.  personal experience, our setting was in French and after verification with microsoft support, i had to recreate some of them.

     

    For any new sharepoint site, you can define the language on the Admin of office 365

    or more easily, you create with PNP powershell and add the "LCID" parameter

    New-PnPSite -Type TeamSite -Title <name> -Description <sometext> -Lcid 1033

    I prefer the powershell option to create new site, as i'm sure which language is the default.

     

    To chagne the default language for onedrive site creation, you need to contact microsoft for new account.

Vertebre85's avatar
Vertebre85
Iron Contributor
Apr 06, 2022

tcboeira 

Hi
When a site is created, it's too late to change language. You can only act on the display language, but onedrive and sharepoint, when created can't be changed.  personal experience, our setting was in French and after verification with microsoft support, i had to recreate some of them.

 

For any new sharepoint site, you can define the language on the Admin of office 365

or more easily, you create with PNP powershell and add the "LCID" parameter

New-PnPSite -Type TeamSite -Title <name> -Description <sometext> -Lcid 1033

I prefer the powershell option to create new site, as i'm sure which language is the default.

 

To chagne the default language for onedrive site creation, you need to contact microsoft for new account.

tcboeira's avatar
tcboeira
Brass Contributor
Apr 07, 2022
Hi ...
Thanks for the feedback Vertebre85

As for the situation... It's unfortunate, but it's ok.
In my organization, although many - almost all - are in our language (pt-BR), and users' mailboxes too, there is a behavior of creating sites from Microsoft Teams, and we don't know why, they are generated in "en-US".


I thought it might be something that went unnoticed, and I can't by volume consider a possible error.


But thank you immensely for the answer, the help, and gave me a referral...


big hugs
  • Vertebre85's avatar
    Vertebre85
    Iron Contributor
    Apr 08, 2022

    tcboeira 

    Hi

    I totally understood, I was in the same situation.

    For the site

    First work around, you can remove all display language and select only portuguese

     

    For the mailbox,

    that could be changed for your user.

    You need an exchange admin right, you connect to powershell and you adapt it

     

    Get-Mailbox <UPN> | Get-MailboxRegionalConfiguration |Set-MailboxRegionalConfiguration -Language en-BE

     

     

    Adapt the upn and the language code ( probably then "pt-br"

    You can also change some regional setting like the date format

     

    Get-Mailbox <UPN> | Get-MailboxRegionalConfiguration |Set-MailboxRegionalConfiguration -DateFormat "dd/MM/yyyy"

     

    You can do a loop then to change it in batch

    For onedrive

     

    In my case, i've added a alternate display language

    I've connected with SPO service

    Then I grant myself site collection administrator role

     

    Set-SPOUser -Site "<url of onedrive space>" -LoginName "<my own UPN>" -IsSiteCollectionAdmin $true

     

    I create a CSV file with all the url of onedrive site (one column)

    Then I run the script:

     

    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"
 
#Authenticate to Site
 
$Username = Read-Host -Prompt "Please enter your username"
 
$Password = Read-Host -Prompt "Please enter your password" -AsSecureString
 
$site1 = import-csv -Path "<path of file>\book1.csv"
foreach($column in $site1) {
$site = $column.site
$Context = New-Object Microsoft.SharePoint.Client.ClientContext($Site)
$Creds = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username,$Password) 
$Context.Credentials = $Creds
 
$web = $Context.Web
 
$Context.Load($web)
$Context.ExecuteQuery()
# please refer to https://technet.microsoft.com/en-us/library/cc287874(v=office.12).aspx for all locale Ids
$web.IsMultilingual=$true
$web.AddSupportedUILanguage(1033)
$Context.Web.Update()
 
$Context.ExecuteQuery()
 
}

     

    Don,t forgot to remove the site collection admin right after (replace true by false)

    The script was not done by me, i adapt it but i don't remenber the source...

     

    This is several steps i've implemented to adapt a bit 2 year ago

Resources