Office 365: SharePoint documentation now available at docs.microsoft.com!

As you know, Microsoft is making a big effor to move all the documentation about the different products, technologies and platforms they have to docs.microsoft.com. As part of this move, Microsoft has already started to publish some of the SharePoint OnPremises and SharePoint online documentation into docs.microsoft.com:

image

Office 365: Disponible la documentación sobre SharePoint en docs.microsoft.com!

Como sabéis, toda la documentación de productos, tecnologías y plataformas de Microsoft se está centralizando en docs.microsoft.com y dentro de este movimiento, ya tenemos disponible la documentación relativa a SharePoint OnPremises y SharePoint Online:

image

Office 365: How to change regional settings in a SPO site using PowerShell!

This time I’m sharing a PowerShell script that allows to change regional settings in a SharePoint Online (SPO) site by means of PowerShell. You can download the script from the following Url: How to set regional settings in a SPO Site

############################################################################################################################################
# Script that allows to change regional settings on SPO Site
# Required Parameters:
#  -> $sUserName: User Name to connect to the SharePoint Online Site.
#  -> $sPassword: Password for the user.
#  -> $sSiteUrl: SharePoint Online Site.
#  -> $sTimezoneValue: Time Zone.
#  -> $ilocaleid: Locale ID.
############################################################################################################################################

$host.Runspace.ThreadOptions = "ReuseThread"

#Definition of the function that allows to change regional settings on a SPO Site
function Change-RegionalSettings
{
    param ($sSiteUrl,$sUserName,$sPassword,$sCSOMPath,$sTimezoneValue,$ilocaleid)
    try
    {   

        Write-Host "----------------------------------------------------------------------------"  -ForegroundColor Green
        Write-Host "Updating Regional Settings for $sSiteUrl" -ForegroundColor Green
        Write-Host "----------------------------------------------------------------------------"  -ForegroundColor Green
     
        #Adding the Client OM Assemblies        
        $sCSOMRuntimePath=$sCSOMPath +  "\Microsoft.SharePoint.Client.Runtime.dll"        
        $sCSOMPath=$sCSOMPath +  "\Microsoft.SharePoint.Client.dll"
                     
        Add-Type -Path $sCSOMPath         
        Add-Type -Path $sCSOMRuntimePath        

        #SPO Client Object Model Context
        $spoCtx = New-Object Microsoft.SharePoint.Client.ClientContext($sSiteUrl) 
        $spoCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($sUserName, $sPassword)  
        $spoCtx.Credentials = $spoCredentials 

        $spoTimeZones = $spoCtx.Web.RegionalSettings.TimeZones       
        $spoCtx.Load($spoTimeZones)
        $spoCtx.ExecuteQuery()
        $spoTimeZone = $spoTimeZones | Where {$_.Description -eq $sTimezoneValue}
        $spoRegionalSettings = $spoCtx.Web.RegionalSettings
        $spoRegionalSettings.TimeZone = $spoTimeZone
        $spoRegionalSettings.Localeid = $ilocaleid
        $spoCtx.Web.Update()
        $spoCtx.ExecuteQuery()

    }
    catch [System.Exception]
    {
        Write-Hoste -ForegroundColor Red $_.Exception.ToString()   
    }    
}

#Required Parameters
$sSiteUrl="https://<Your_SPO_Site>"
$sUserName = "<Office365_User>" 
$sPassword = Read-Host -Prompt "Enter your password: " -AsSecureString 
$sTimezoneValue= "(UTC+01:00) Brussels, Copenhagen, Madrid, Paris"
$ilocaleid = 1033 
$sCSOMPath="F:\03 Docs\07 MVP\03 MVP Work\11 PS Scripts\Office 365\SPO CSOM\Dec 2016"

Change-RegionalSettings -sSiteUrl $sSiteUrl -sUserName $sUserName -sPassword $sPassword -sCSOMPath $sCSOMPath -sTimeZoneValue $sTimezoneValue -iLocaleID $ilocaleid

Office 365: Como configurar las configuraciones regionales de SPO con PowerShell!

En esta ocasión os comparto un script PowerShell que permite cambiar las configuraciones regionales de un sitio de SharePoint Online (SPO). El script en cuestión es el siguiente: How to set regional settings in a SPO Site

############################################################################################################################################
# Script that allows to change regional settings on SPO Site
# Required Parameters:
#  -> $sUserName: User Name to connect to the SharePoint Online Site.
#  -> $sPassword: Password for the user.
#  -> $sSiteUrl: SharePoint Online Site.
#  -> $sTimezoneValue: Time Zone.
#  -> $ilocaleid: Locale ID.
############################################################################################################################################

$host.Runspace.ThreadOptions = "ReuseThread"

#Definition of the function that allows to change regional settings on a SPO Site
function Change-RegionalSettings
{
    param ($sSiteUrl,$sUserName,$sPassword,$sCSOMPath,$sTimezoneValue,$ilocaleid)
    try
    {   

        Write-Host "----------------------------------------------------------------------------"  -ForegroundColor Green
        Write-Host "Updating Regional Settings for $sSiteUrl" -ForegroundColor Green
        Write-Host "----------------------------------------------------------------------------"  -ForegroundColor Green
     
        #Adding the Client OM Assemblies        
        $sCSOMRuntimePath=$sCSOMPath +  "\Microsoft.SharePoint.Client.Runtime.dll"        
        $sCSOMPath=$sCSOMPath +  "\Microsoft.SharePoint.Client.dll"
                     
        Add-Type -Path $sCSOMPath         
        Add-Type -Path $sCSOMRuntimePath        

        #SPO Client Object Model Context
        $spoCtx = New-Object Microsoft.SharePoint.Client.ClientContext($sSiteUrl) 
        $spoCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($sUserName, $sPassword)  
        $spoCtx.Credentials = $spoCredentials 

        $spoTimeZones = $spoCtx.Web.RegionalSettings.TimeZones       
        $spoCtx.Load($spoTimeZones)
        $spoCtx.ExecuteQuery()
        $spoTimeZone = $spoTimeZones | Where {$_.Description -eq $sTimezoneValue}
        $spoRegionalSettings = $spoCtx.Web.RegionalSettings
        $spoRegionalSettings.TimeZone = $spoTimeZone
        $spoRegionalSettings.Localeid = $ilocaleid
        $spoCtx.Web.Update()
        $spoCtx.ExecuteQuery()

    }
    catch [System.Exception]
    {
        Write-Hoste -ForegroundColor Red $_.Exception.ToString()   
    }    
}

#Required Parameters
$sSiteUrl="https://<Your_SPO_Site>"
$sUserName = "<Office365_User>" 
$sPassword = Read-Host -Prompt "Enter your password: " -AsSecureString 
$sTimezoneValue= "(UTC+01:00) Brussels, Copenhagen, Madrid, Paris"
$ilocaleid = 1033 
$sCSOMPath="F:\03 Docs\07 MVP\03 MVP Work\11 PS Scripts\Office 365\SPO CSOM\Dec 2016"

Change-RegionalSettings -sSiteUrl $sSiteUrl -sUserName $sUserName -sPassword $sPassword -sCSOMPath $sCSOMPath -sTimeZoneValue $sTimezoneValue -iLocaleID $ilocaleid

Office 365: Updates en Site Scripts y Site Designs para SPO–Abril de 2018!

Microsoft sigue añadiendo más funcionalidad a la extensibilidad de sitios modernos de SharePoint Online (SPO) mediante Site Scripts y Site Designs. En concreto en la actualización de abril de 2018 podemos encontrar las siguientes nuevas acciones para Site Scripts:

Site Settings

  • setRegionalSettings – Used to configure the regional settings of the site
  • setSiteExternalSharingCapability – Used to manage guest access

Lists & Libraries

  • createSiteColumn – Defines a new site column that can then be associated to a list directly or using the addContentType action
  • addSiteColumn – Subaction to add a previously defined site column directly to a list or content type
  • createContentType – Defines a new content type that can then be associated to a list using the addContentType action
  • addSPView – Defines and adds a view to the list
  • addSPFieldXml – Enables defining fields and their elements using Collaborative Application Markup Language (CAML)
  • Additional field properties: internal name, group, enforce unique

Apps & Solutions

  • installSPFxSolution – Install add-in or SharePoint Framework solution from the tenant app catalog
  • Associate SharePoint Framework extension action also coming soon

Miscellaneous

  • triggerFlow action supports additional site properties
  • joinHub action has now also name parameter
  • Invoke-SPOSiteDesign cmdlet to apply Site Design to an existing site (also supported through APIs)
  • site design default preview image

Además de estas nuevas acciones, en GitHut podremos encontrar ejemplos de como utilizarlas:

+ Información:

SharePoint Site Scripts and Site Designs – April 2018 release

Office 365: Creating a simple Flow to send OnDemand notifications on specific documents!

Microsoft Flow integration in SharePoint Online (SPO) provides a very simple way to model common collaboration scenarios such as send an OnDemand notification when a specific document has been uploaded to a document library or a list item has been created in a list. In this article I will show you how to create a simple Flow to send an OnDemand notification when a document is selected in a document library. You can continue reading the full article at petri.com: https://www.petri.com/creating-simple-flow-send-ondemand-notifications-specific-documents

Office 365: Nuevas capacidades en la SharePoint Migration Tool!

Microsoft sigue evolucionando la SharePoint Migration Tool y añadiendo nuevas capacidades tal y como podéis leer en el siguiente post en la Microsoft Tech Community:

SharePoint Migration Tool Beta adds early preview capabilities

Las novedades que incorpora la Beta más actual de la SharePoint Migration Tool son las siguientes:

  • Soporte para migrar listas de SharePoint 2013 lo que incluye el siguiente tipo de plantillas de listas:
    • GenericList
    • DocumentLibrary
    • Survey
    • Links
    • Announcements
    • Contacts
    • Events
    • Tasks
    • DiscussionBoard
    • PictureLibrary
    • XMLForm
    • GanttTasks
    • Posts
    • Comments
    • Categories
    • MySiteDocumentLibrary
    • AdminTasks

  • Mejoras en el soporte de AuthN de manera que es posible conectar a entornos OnPremises en los que se hayan configurado los siguientes tipos de autenticación:
    • NTLM
    • Kerberos
    • Forms
    • ADFS: MFA | SAML Claims | Client certificates.
  • Creación del sitio de destino: La herramienta creará de forma automática, en el caso de no existir, el sitio en el que se van a migrar listas y biblioteca de documentos.
  • Soporte para JSON en migraciones de tipo masivo.