Vue normale

Il y a de nouveaux articles disponibles, cliquez pour rafraîchir la page.
À partir d’avant-hierFlux principal

Identifier les comptes inutilisés

Hi folks,

Souvent on me demande s’il est possible de trouver les comptes des utilisateurs non utilisés, je vous propose ici de voir cela avec un exemple des comptes invités qui sont en grande partie non utilisés sur les environnements, ou bien qui sont utilisés très ponctuellement.

Notre objectif est donc de les identifier et les gérer, notamment en les ajoutant à un groupe pour faciliter leur suppression ou autre action. Mais surtout pas de tous les supprimer… Après vous avez la sauvegarde peut-être sinon c’est dans la corbeille Entra ID pour 30 jours.

1. Créer un groupe cible

  • Créez une liste de distribution ou un groupe Microsoft 365 pour regrouper les comptes invités inactifs.
  • Vous pouvez utiliser le centre d’administration Exchange/Microsoft 365 ou des cmdlets PowerShell tels que :
    • New-DistributionGroup pour une liste de distribution.
    • New-UnifiedGroup pour un groupe Microsoft 365.

2. Identifier les comptes invités inutilisés :

  • Utilisez le cmdlet Get-MgUser du Microsoft Graph PowerShell SDK pour récupérer les comptes invités.
  • Filtrez les comptes :
    • Ceux qui n’ont pas signé depuis plus d’un an.
    • Ceux qui n’ont jamais signé (optionnel) mais souvent le cas.
  • Exemple de script pour filtrer :
    • $CheckDate = (Get-Date).AddYears(-1)
    • [array]$InactiveGuests = Get-MgUser -All -PageSize 500 -Filter "signInActivity/lastSignInDateTime le $($Checkdate.ToUniversalTime().ToString("yyyy-MM-ddThh:mm:ssZ"))" -Property Id, Mail, displayName, userPrincipalName, signInactivity, UserType
    • $InactiveGuests = $InactiveGuests | Where-Object {$_.userType -eq 'Guest'}
  • Éliminez les faux positifs en filtrant les comptes sans adresse e-mail.
    • $InactiveGuests = $InactiveGuests | Where-Object {$null -ne $_.Mail}

3. Ajouter les comptes inutilisés à un groupe :

  • Pour une liste de distribution :
    • ForEach ($Id in $InactiveGuests.Id) { Add-DistributionGroupMember -Identity Inactive.Guests.DL -Member $Id -ErrorAction SilentlyContinue }
  • Pour un groupe Microsoft 365 :
    • Add-UnifiedGroupLinks -Identity Inactive.Guests.Group -Links $InactiveGuests.Id -LinkType Member
  • Désactivez les messages de bienvenue pour éviter de confondre les utilisateurs :
    • Set-UnifiedGroup -Identity Inactive.Guests.Group -UnifiedGroupWelcomeMessageEnabled:$False

4. Automatisation et suivi :

  • Planifiez un traitement régulier (par exemple, via un runbook Azure Automation) pour maintenir la liste des invités inactifs à jour.

Suppression des comptes :

  • Avant de supprimer, examinez les comptes pour éviter de retirer des comptes importants (par exemple, ceux utilisés uniquement pour des échanges par e-mail).
  • Exportez les données dans un fichier CSV pour validation avant suppression.
  • Exemple de script pour suppression :
    • [array]$InactiveGuests = Import-CSV "c:\temp\GuestAccountsToRemove.csv" ForEach ($Account in $InactiveGuests) { Remove-MgUser -UserId $Account.Id }

Remarques :

  • Tous les comptes inactifs ne doivent pas être supprimés automatiquement. Certains peuvent avoir une raison valable d’être inactifs.
  • La suppression est réversible pendant 30 jours via l’interface Entra Admin Center.
  • MAIS SURTOUT – Pensez a mettre en place de la gouvernance des identités.

Stay tuned !

La gouvernance des accès utilisateurs

Très souvent, on me demande quel est la marche à suivre pour retirer les accès d’un collaborateur qui quitte une société. Alors voici une checklist rapide des éléments à prendre en considération.

  1. Bloquer la connexion : Désactivez le compte pour empêcher les nouvelles connexions. Utilisez la commande cmdlet Revoke-MgUserSignInSession pour forcer la déconnexion de toutes les sessions immédiatement.
  2. Désactiver le compte AD local : Si votre entreprise utilise Active Directory, désactivez le compte dans l’AD local.
  3. Réinitialiser le mot de passe de l’utilisateur : Mettez à jour le compte avec un mot de passe aléatoire pour empêcher l’employé de continuer à accéder au tenant.
  4. Soumettre une demande d’effacement sélectif des applications/effacement des appareils : Si Intune est déployé, soumettez une demande d’effacement pour tous les appareils enregistrés.
  5. Soumettre une demande d’effacement ActiveSync : Si Intune n’est pas déployé, soumettez une demande d’effacement pour les appareils utilisant ActiveSync.
    • Clear-MobileDevice -AccountOnly -Identity User -NotificationEmailAddresses "admin@domain.com"
  6. Désactiver les appareils de l’utilisateur : Invalidez toute authentification basée sur un compte d’ordinateur en utilisant les cmdlets du Microsoft Graph PowerShell SDK.
    • $Device = Get-MgUserRegisteredDevice -UserId "user@domain.com"
    • Update-MgDevice -DeviceId $Device.Id -AccountEnabled:$false
  7. Activer la délégation sur OneDrive for Business : Déléguez l’accès au OneDrive for Business de l’employé à un utilisateur autorisé.
  8. Conserver la boîte aux lettres de l’utilisateur : Convertissez la boîte aux lettres de l’utilisateur en boîte aux lettres partagée ou utilisez des rétentions pour conserver la boîte aux lettres en tant que boîte aux lettres inactive.
    • L’impact sur les éléments chiffrés, tels que les emails ou les documents, peut être significatif lorsqu’un utilisateur est supprimé. Avec l’adoption croissante des étiquettes de sensibilité, des problèmes peuvent survenir pour les éléments stockés dans Microsoft 365. Les étiquettes de sensibilité appliquent des restrictions d’accès et/ou un chiffrement à ces éléments. Si les étiquettes restreignent l’accès de manière à ce qu’un seul utilisateur soit le propriétaire d’un document, et que cet utilisateur est celui qui est supprimé, il n’y a pas de moyen facile d’identifier quels documents ou éléments sont impactés par la suppression du compte utilisateur.
    • Pour résoudre ce problème, il existe une configuration appelée Super User dans Azure Rights Management Service (RMS), qui est la technologie utilisée par les étiquettes de sensibilité pour appliquer le chiffrement et/ou le contrôle d’accès. Le Super User est un compte administratif spécial qui a des droits de propriétaire sur tous les éléments protégés par Azure RMS
  9. Supprimer la licence de l’utilisateur : Réduisez les coûts de licence en supprimant la licence de l’utilisateur.
  10. Supprimer le compte utilisateur : Après une période de grâce, supprimez le compte utilisateur du système.
  11. Services avancés : Cette liste couvre les étapes de base pour les tenants Microsoft 365. Si vous avez des services avancés comme Defender for Cloud Apps, des étapes supplémentaires peuvent être nécessaires.
    • Ajouter les utilisateurs aux politiques de Defender for Cloud Apps : Cela permet de surveiller les téléchargements massifs de fichiers inexpliqués depuis Teams/SharePoint.
    • Configurer les notifications de flux de travail : Configurez un flux de travail de notification dans votre tenant pour que votre équipe IT soit informée lorsque des actions sont nécessaires.
    • Utiliser PowerAutomate pour automatiser le processus : Envisagez d’automatiser le processus en utilisant PowerAutomate cloud flow pour minimiser les interventions manuelles.

Les directives NIS2 et DORA

Comprendre les Nouveaux Cadres Réglementaires pour les Entreprises

La Directive NIS2 et le Règlement DORA représentent des avancées majeures dans la réglementation de la cybersécurité et de la résilience opérationnelle numérique au sein de l’Union Européenne. Ici nous allons explorer ces deux cadres réglementaires, les opportunités qu’ils offrent pour les entreprises, les bénéfices potentiels, les risques associés, et proposer une feuille de route pour assurer la conformité. L’entrée en vigueur de NIS2 est prévu pour Octobre 2024 et l’application à partir de Janvier 2025, cependant il n’est pas exclu que les sanctions prévues par les textes soient appliquées avant l’été 2025. Ce qui laisse “très” peu de temps à la mise en conformité.

Directive NIS2

La Directive NIS2 (Network and Information Security 2) est une mise à jour de la Directive NIS originale de 2016. Elle vise à renforcer la cybersécurité à travers l’Union Européenne en étendant le champ d’application aux secteurs et services critiques supplémentaires et en imposant des exigences de sécurité plus strictes.

Objectifs de la Directive NIS2

  • Amélioration de la cyber-résilience : Renforcer les capacités des États membres en matière de prévention, de détection et de réaction aux incidents de cybersécurité.
  • Harmonisation des réglementations : Établir un cadre commun pour la cybersécurité afin de réduire les disparités entre les États membres.
  • Renforcement de la coopération : Améliorer la collaboration entre les différents acteurs au niveau national et européen.

Règlement DORA

Le Règlement DORA (Digital Operational Resilience Act) est conçu pour garantir que les entreprises du secteur financier puissent résister, répondre et se remettre des perturbations opérationnelles liées aux TIC (Technologies de l’Information et de la Communication).

Objectifs du Règlement DORA

Sensiblement similaire mais avec quelques nuances

  • Résilience numérique : Assurer que les entreprises financières disposent de systèmes robustes pour résister aux cyberattaques et autres interruptions numériques.
  • Gestion des risques : Mettre en place des mesures de gestion des risques informatiques, y compris la surveillance, l’identification et la réponse aux incidents.
  • Harmonisation et supervision : Fournir un cadre réglementaire uniforme pour la résilience opérationnelle numérique et établir des mécanismes de supervision au niveau européen.

Opportunités pour les Entreprises

Amélioration de la Sécurité et de la Résilience

  • Renforcement des systèmes de sécurité : En adoptant les exigences de NIS2 et DORA, les entreprises peuvent améliorer leur posture de cybersécurité et résilience numérique.
  • Réduction des risques : Une meilleure gestion des risques informatiques et une préparation aux incidents peuvent réduire les coûts liés aux cyberattaques et aux interruptions.

Avantages Compétitifs

  • Confiance accrue : Les entreprises conformes peuvent gagner la confiance des clients, des partenaires et des investisseurs en démontrant leur engagement envers la sécurité et la résilience. Et par conséquent gagner en valeurs
  • Accès aux marchés : La conformité peut devenir un prérequis pour opérer dans certains marchés ou pour collaborer avec certaines entreprises.

Risques Associés

Coûts de Mise en Conformité

  • Investissements initiaux : Les entreprises devront investir dans des technologies, des processus et des compétences pour répondre aux nouvelles exigences. La suite 365 est une des réponses possibles offrant un bundle de produit permettant de répondre économiquement à ces enjeux.
  • Coûts opérationnels : La maintenance continue des mesures de conformité peut entraîner des coûts supplémentaires. Mais cela dépend aussi des sécurités mise en place en termes d’identité, de gestion des données, des serveurs, des data, des réseaux, etc. … et de l’approche ZeroTrust (ZTA) que vous pouvez avoir.

Complexité de la Mise en Œuvre

  • Adaptation des processus : Les entreprises doivent adapter leurs processus internes pour se conformer aux nouvelles réglementations, ce qui peut être complexe et chronophage. La mise en place de nouveau processus peut prendre du temps, mais permet également aux utilisateurs d’assurer la sécurité de leur donnée, leur identité, leur appareil aussi
  • Formation et sensibilisation : Former le personnel et sensibiliser toutes les parties prenantes aux nouvelles exigences est crucial mais peut être un défi. Effectivement, nous l’avons déjà vu, l’application d’étiquettes de données à la main des utilisateurs est un réel défi, l’application de ces dernières de manière autonome peut nécessité un control des données, mais dans ce cas là, les modèles étant de plus en plus performant, et, entrainer, les controls deviennent moins fréquents. Pensez ici à toujours commencer avec quelques label plutôt que 12… plus simple à comprendre pour les utilisateurs.

Proposition de feuille de route pour la conformité

Concrètement la démarche est connue mais il peut être bon de la rappeler et l’adapter si besoin à votre contexte. Certains produit du marché permettent de vous faciliter la vie, mettant en exergue et corrigeant automatiquement les dérives potentielles des utilisateurs (je pense à des partages sauvages externes – car mal configurés, des règles de redirection de mail également non forcée, etc. …)

Évaluation Initiale

  1. Analyse des écarts : Évaluer les différences entre les pratiques actuelles et les exigences de NIS2 et DORA.
  2. Évaluation des risques : Identifier les risques actuels et potentiels en matière de cybersécurité et de résilience numérique.

Planification et Mise en Œuvre

  1. Développement d’un plan d’action : Élaborer un plan détaillé pour combler les écarts identifiés, avec des étapes claires et des échéances et même des responsables, sponsors moteurs.
  2. Mise à jour des politiques et procédures : Adapter les politiques de sécurité et de résilience pour répondre aux nouvelles exigences.

Renforcement des Capacités

  1. Investissement en technologies : Acquérir et déployer des technologies de sécurité avancées pour protéger les infrastructures critiques. On peut par exemple parler de SIEM (Microsoft ou non) et de produit tiers.
  2. Formation et sensibilisation : Mettre en place des programmes de formation pour le personnel afin de garantir une compréhension et une adhésion complètes aux nouvelles réglementations. Afin de palier pour le cas des étiquettes, au cas de figure de l’utilisateur qui ne va pas savoir si son document est interne ou externe (en grossissant le trait) ou bien si les données contenues sont sensible ou non.

Surveillance et Amélioration Continue

  1. Supervision continue : Mettre en place des mécanismes de surveillance pour assurer la conformité continue et détecter rapidement les incidents.
  2. Révision et mise à jour régulière : Réviser régulièrement les politiques et les procédures pour s’adapter aux nouvelles menaces et exigences réglementaires.

Et concrètement ?

Dans un environnement Microsoft 365, voici quelques exemples

1. Authentification Multifacteur (MFA)

  • Technologie: Utilisation de l’authentification multifacteur via Azure Active Directory (AAD) pour renforcer la sécurité des accès utilisateurs.
  • Implémentation:
    • Activez MFA pour tous les utilisateurs.
    • Configurez des options MFA telles que les notifications push, les SMS ou les applications d’authentification comme Microsoft Authenticator.

2. Etiquetage des Données

  • Technologie: Utilisation de Microsoft Information Protection pour classifier et protéger les données sensibles.
  • Implémentation:
    • Créez des étiquettes de sensibilité pour classer les documents en fonction de leur niveau de confidentialité (Public, Interne, Confidentiel).
    • Appliquez des étiquettes automatiquement en fonction du contenu ou manuellement par les utilisateurs.

3. Gestion des Identités et des Accès (IAM)

  • Technologie: Azure Active Directory pour gérer les identités et les accès.
  • Implémentation:
    • Utilisez les rôles basés sur les accès (RBAC) pour limiter les permissions aux seules nécessaires pour les utilisateurs.
    • Mettez en place des politiques d’accès conditionnel pour renforcer la sécurité.

4. Protection Contre les Menaces

  • Technologie: Microsoft Defender for Office 365 pour protéger contre les menaces telles que les malwares, le phishing et les attaques de ransomwares.
  • Implémentation:
    • Configurez les politiques anti-phishing et anti-spam.
    • Activez les fonctionnalités avancées de détection et de réponse aux menaces (ATP).

5. Sauvegarde et Récupération des Données

  • Technologie: OneDrive for Business et SharePoint Online pour la sauvegarde et la récupération des données.
  • Implémentation:
    • Configurez les stratégies de sauvegarde automatique pour les fichiers critiques.
    • Utilisez la fonctionnalité de restauration des fichiers pour récupérer les données en cas de perte ou de corruption.

6. Gestion des Appareils

  • Technologie: Microsoft Intune pour la gestion des appareils mobiles et des points de terminaison.
  • Implémentation:
    • Déployez des politiques de conformité pour assurer que tous les appareils accédant aux ressources de l’entreprise répondent aux critères de sécurité.
    • Configurez l’accès conditionnel pour restreindre l’accès aux appareils non conformes.

7. Surveillance et Audit

  • Technologie: Microsoft 365 Compliance Center pour la surveillance continue et l’audit des activités.
  • Implémentation:
    • Configurez les journaux d’audit pour suivre et enregistrer les activités des utilisateurs et les modifications des fichiers.
    • Utilisez les alertes de conformité pour être informé des activités suspectes ou des violations de politique.

8. Cryptage des Données

  • Technologie: Azure Key Vault et BitLocker pour le cryptage des données au repos et en transit.
  • Implémentation:
    • Stockez les clés de chiffrement dans Azure Key Vault.
    • Activez BitLocker pour chiffrer les disques sur les appareils Windows.

9. Gestion des Risques

  • Technologie: Microsoft Cloud App Security pour la gestion des risques et la surveillance des applications cloud.
  • Implémentation:
    • Détectez et évaluez les risques liés à l’utilisation des applications cloud.
    • Appliquez des politiques de sécurité pour contrôler les accès et protéger les données sensibles.

En conclusion

La Directive NIS2 et le Règlement DORA représentent des opportunités d’amélioration significatives pour les entreprises pour leur cybersécurité et leur résilience opérationnelle. En suivant une feuille de route structurée (et avec un bon accompagnement), vous pourrez non seulement assurer votre conformité mais aussi renforcer votre position sur le marché et réduire vos risques opérationnels. Adopter ces nouvelles réglementations est un investissement dans la sécurité et la pérennité de l’entreprise.

Stay tuned !

Add Modern Calendar to a SharePoint Online page

In my previous blog, I explained how to create a modern calendar view in SharePoint Online/Microsoft Lists. In this blog we will see how to add the modern calendar to a SharePoint online page.

We have a List web part in SharePoint online which allows you to display a list from your site on a page. But currently it doesn’t support modern calendar views. So, you will need to use below workaround to add Modern Calendar to a SharePoint Online page.

Workaround

We can use Embed web part in SharePoint online to add modern calendar to a page.

Follow below steps to embed modern calendar to a page:

1. Go to your SharePoint list and open the calendar view.

2. Copy the URL of calendar view from browser and note it down as we will use it in later steps.

3. Go to your modern SharePoint page and open it in Edit mode by clicking Edit button from top right corner.

4. Add Embed web part on your page and open it in edit mode.

5. Construct the embed code using the <iframe> tag in below format:

<iframe src="https://<tenant>.sharepoint.com/sites/siteName/Lists/ContentScheduler/Calendar.aspx" width="100%" height="600"></iframe>

6. Replace src attribute in above code with the URL of calendar view we noted in step 2.

7. In the property pane of Embed web part, paste the embed code into the Website address or embed code box.

Embed modern calendar to SharePoint Online page
Embed modern calendar to SharePoint page

7. Close property pane of Embed web part and Publish/Republish the page.

You will see the final output on SharePoint page like given below:

Modern calendar added to modern SharePoint online page
Modern calendar added to SharePoint online page

UPDATE: SharePoint out of the box List web part now supports modern calendar views (to show on modern pages), see Add Modern Calendar to a SharePoint Online page using List web part.

Learn more

SharePoint: Collapsible sections on modern pages

Finally Microsoft is releasing much anticipated feature in SharePoint online – Collapsible sections on modern pages. This new feature will allow users to create rich, information-dense SharePoint pages with sections that can expand and collapse. As part of this release, Microsoft will enable the page authors to configure sections within the modern SharePoint page to be able to expand, collapse and set the default page-load state for the section.

Users will have the ability to show collapsible page sections in an accordion view (collapsed or expanded) or as tabs (future release). The accordion view will be collapsed by default, but can be set to show expanded. This feature will help users to quickly navigate between the page sections and consume the page content more easily.

Release Timeline

Microsoft will begin rolling out this feature to Targeted release tenants (selected users and organization) in early July (complete) and expect to be complete for Standard release in late September (previously late July).

How this will affect your organization

This feature will give page authors new ways to build rich and interesting SharePoint pages with collapsible sections – accordion or tabs.

Collapsible/Expandable Sections in SharePoint Online modern pages
Collapsible Sections in SharePoint Online modern experience

When you will edit a section on modern page, you will see collapsible group options like below:

Collapsible/Expandable Sections in SharePoint Online modern pages
Collapsible Sections settings in SharePoint Online

Note: Tabs layout will be rolled out with future releases.

Set Expand/Collapse icon alignment & show divider line between sections

Starting from September 2021, you have two more settings on Edit section panel as shown below:

  • You can set Expand/Collapse icon alignment to Left or Right
  • You can show divider line between two sections
Set Expand/Collapse icon alignment & show divider line between collapsible sections in SharePoint online modern experience
Set Expand/Collapse icon alignment & show divider line between sections

Anchor links on collapsible section heading

On SharePoint online modern pages, anchor links are automatically added to H1, H2, and H3 headings when you add those in Text web part. Similar anchor links are now available on collapsible section headings as shown in below image. When you hover over collapsible section heading, you will see a link symbol. Clicking this link will give you the full URL of modern page, including the anchor in browser URL bar. You can also right-click on the link to copy it.

Anchor links on collapsible section heading on SharePoint online modern pages
Anchor link on collapsible section heading on SharePoint modern page

What you need to do to prepare

You might want to notify your users about this new capability and update your training and documentation as appropriate.

Learn More


Update from Microsoft

We have updated the rollout timeline. While in Targeted Release we received valuable feedback around the behavior of anchor links when used in collapsible sections as well as some formatting issues experienced by users of right-to-left languages. We feel that both of these issues are important for us to address prior to making the feature generally available. We are actively addressing these issues now and expect the solution to reach General Availability with all fixes in place by the end of September 2021. Thank you for your patience.

Updated September 30, 2021: As shared previously, the new collapsible Sections was deployed to 100% of Targeted Release customers. We held the solution at the Targeted Release phase while we addressed some issues that were reported with the solution. The issues have now been addressed and we will be resuming the global rollout to all customers. It is now our expectation that we’ll complete the rollout of the feature by the end of October 2021. Thank you for your patience.

Show/Hide See all link from SharePoint list/library web parts

When you add a List web part or Document Library web part on modern pages to show the (filtered) list items or documents, it shows See all link at the top right corner of web part as shown in below image. By clicking this See all link, users can navigate to the full list/library page.

See all link in list web part on SharePoint online modern page
See all link in list web part on modern page

But sometimes when you are showing the filtered list views or custom created list views on modern pages, you don’t want other users to access the original list/library and switch between views or modify existing list views. Previously there was no SharePoint out of the box way to hide the See all link from web parts. But, recently Microsoft has added a new option to Show/Hide “See all” button in list/library web part property pane settings.

Show/Hide See All link from SharePoint list/library web parts

Follow below steps to show/hide See all button from list web part in SharePoint online:

1. Go to SharePoint modern page where you have added the list/library web part.

2. Open the page in Edit mode by clicking Edit button from top right corner.

3. Click on the Edit web part button against your list/library web part.

4. Toggle Show “See all” button option and change it to Hide “See all” Button as shown in below image.

5. Click Apply button.

6. Click on Publish/Republish button to save the changes to the modern page.

Show/hide See all button in list/library web part property pane in SharePoint online
Show/hide See all button option in web part settings

Here’s how the list/library web part will look after you hide the “See all” link from web part settings:

Hidden See all button from list web part in SharePoint online modern page
See all button hidden from list web part

Update SharePoint Page Banner Image using PnP PowerShell

Using pages in SharePoint is a great way to share information or any news/announcement in your organization to SharePoint site users. SharePoint site pages can be improved by utilizing banner images in the page title area. Adding banner images to the page title area not only makes the page more visually appealing but also helps to convey the page’s purpose to the user more quickly and effectively.

In this blog post, we will see how to change the SharePoint Page Banner Image using PnP PowerShell.

First of all upload a high quality image in one of the document libraries in your SharePoint site. SharePoint site page banner images in title area look best when they are landscape or 16:9 or greater in aspect ratio, and when they are at least 1 MB in size. Check this Microsoft official documentation for recommended specifications for banner images: Image sizing and scaling in SharePoint modern pages

Then you can use below PnP PowerShell script to update the banner image at the top of the SharePoint online modern page:


# SharePoint online site URL
$siteUrl = "https://contoso.sharepoint.com/sites/wlive"	

# Connect to SharePoint online site  
Connect-PnPOnline -Url $siteUrl -Interactive

# Update SharePoint site page banner image
Set-PnPPage -Identity "Open-Door-Policy" -HeaderType Custom -ServerRelativeImageUrl "/sites/wlive/SiteAssets/work-remotely.jpeg"

Once you run above script successfully, you will find that banner image for your SharePoint site page is updated successfully:

Update SharePoint online modern page banner image in page title area using PnP PowerShell
Update SharePoint Page Banner Image using PnP PowerShell

Learn more

How to find the Internal name of columns in SharePoint Online?

The internal name of a SharePoint column is a unique name that is automatically generated by SharePoint when a column is created. It is used by SharePoint internally to reference and retrieve the value of a particular column associated with an item or document. The internal name is generated based on the display name you provide but all special characters and spaces will be replaced with Unicode’s by SharePoint. Internal name is generated only once while creating a new column and it cannot be changed even if you change the display name of SharePoint column.

The internal name is not visible to users in the SharePoint user interface by default, but it is commonly used in various scenarios, such as in SharePoint REST APIs, Power Automate flow expressions, Power Apps formulas, PowerShell, etc. to interact with column data programmatically.

Where are Internal names of SharePoint columns used?

  1. Custom Scripts: When creating custom scripts, such as JavaScript or PowerShell, the internal names of columns are required to reference and manipulate the values of the columns while interacting with SharePoint data.
  2. Workflows: In SharePoint Designer workflows or Microsoft Power Automate (formerly known as Microsoft Flow), the internal names of columns are used to reference the values of the columns as inputs or outputs in the workflow actions and in expressions.
  3. Custom Solutions: When building custom solutions, such as SharePoint apps, SharePoint framework (SPFx) web parts, or custom code, the internal names of columns are required to interact with the columns programmatically.
  4. Power Apps: Few of the Power Apps functions like ShowColumns, SortByColumns, etc. requires using internal names of SharePoint columns in formula.
  5. JSON Formatting: Internal name of SharePoint column is required in JSON formatting to reference the column value with [$InternalNameOfColumn] syntax.

How to find the Internal name of a SharePoint column?

Using Modern experience list view

You can use sorting or filtering options from SharePoint online modern experience list view to find the internal name of a SharePoint column. Sort by and Filter by options are supported by most of the column types in SharePoint like Single line of text, Choice, Number, Date and Time, Yes/No (Boolean), Person or Group (single selection), etc.

For this afticle, we will use sorting based on SharePoint choice column as an example:

1. Go to the SharePoint online list for which you want to check the internal name of a column.

2. Click on column name/header from the list view and select either Ascending (A to Z) or Descending (Z to A) option from the popup menu:

Find internal name of SharePoint column by sorting choice column from SharePoint online modern experience list view
Find internal name of SharePoint column by sorting choice column

3. SharePoint will sort the list view based on selection and the browser URL will be changed like:

https://contoso.sharepoint.com/sites/wlive/Lists/InternalNames/AllItems.aspx?sortField=ChoiceColumn&isAscending=false

Where column name (ChoiceColumn) after sortField= is the internal name of your SharePoint choice column.

4. Similarly, when you use Filter by option in SharePoint modern experience to filter the list view based on Date and Time column (named as Start Date), SharePoint changes browser URL like:

https://contoso.sharepoint.com/sites/wlive/Lists/InternalNames/AllItems.aspx?FilterField1=Start_x0020_Date&FilterValue1=2023-04-05&FilterType1=DateTime

Where column name (Start_x0020_Date) after FilterField1= is the internal name of your SharePoint date and time column. Notice _x0020_ in internal column name which is an Unicode encoding of the space character in the display name of date and time column (Start Date).

Using Classic experience List settings page

Few of the SharePoint column types like Multiple lines of text, Hyperlink or Picture, Image, etc. does not support sorting or filtering from SharePoint modern experience list views. So, you have to use the classic experience list settings page to find the internal name for such SharePoint columns.

Follow below steps to find the internal name of multiple lines of text column using SharePoint classic experience list settings page:

1. Go to the SharePoint online list for which you want to check the internal name of a column.

2. Click on Settings (gear) icon from the top right corner and select List settings:

Open SharePoint online List settings page from modern experience list view to find the internal name of SharePoint column
Open SharePoint online list settings page

3. From list settings page, scroll down to the Columns section and click on the column name for which you want to find the internal name:

Open SharePoint online column settings page from classic experience list settings page to find the internal name of SharePoint column
Open SharePoint online Column settings page

4. SharePoint will open column settings page for the respective column with browser URL like:

https://contoso.sharepoint.com/sites/wlive/_layouts/15/FldEdit.aspx?List=%7B6FBA7FAE-AFC0-45D6-99EE-0AB20629EE41%7D&Field=MultilineTextCol
SharePoint online column settings page showing internal name of column
SharePoint online column settings page showing internal name of column

Where column name (MultilineTextCol) after Field= is the internal name of your SharePoint online multiple lines of text column.

Note: You can use this classic experience method to find out the internal name of SharePoint columns for all column types.

Using SharePoint REST API

You can use SharePoint REST API endpoint like below to get the internal name of SharePoint column based on it’s display name. Open URL in below format directly from browser tab:

https://contoso.sharepoint.com/sites/SPConnect/_api/web/lists/getbytitle('InternalNames')/fields?$select=Title,InternalName&$filter=Title eq 'Multiline Text Column'
Find internal name of SharePoint online list column using SharePoint REST API
Find internal name of SharePoint column using SharePoint REST API
Using PnP PowerShell

You can use below PnP PowerShell script to find the internal name of SharePoint online list column using PnP PowerShell:

# SharePoint online site URL
$siteUrl = "https://contoso.sharepoint.com/sites/wlive"

# Display name of SharePoint list
$listName = "InternalNames"

# Display name of SharePoint list column
$columnName = "Multiline Text Column"
 
# Connect to SharePoint online site
Connect-PnPOnline -Url $siteUrl -Interactive
 
# Get internal name of SharePoint list column
Get-PnPField -Identity $columnName -List $listName | Select Title,InternalName
Find internal name of SharePoint online list column using PnP PowerShell
Find internal name of SharePoint column using PnP PowerShell
Using CLI for Microsoft 365

You can use below CLI for Microsoft 365 script to find the internal name of SharePoint online list column using CLI for Microsoft 365:

# SharePoint online site URL
$siteUrl = "https://contoso.sharepoint.com/sites/wlive"

# Display name of SharePoint list
$listName = "InternalNames"

# Display name of SharePoint list column
$columnName = "Multiline Text Column"
 
# Get Credentials to connect
$m365Status = m365 status
if ($m365Status -match "Logged Out") {
	m365 login
}

# Get internal name of SharePoint list column
m365 spo field get --webUrl $siteUrl --listTitle $listName --title $columnName --output text
Find internal name of SharePoint online list column using CLI for Microsoft 365
Find internal name of SharePoint column using CLI for Microsoft 365

Best practices for naming SharePoint columns

When creating columns in SharePoint, it’s important to follow best practices for column naming to avoid using special characters or Unicode characters in internal names. Here are some recommended best practices:

  1. Use only alphanumeric characters: Stick to using letters (A-Z, a-z) and numbers (0-9) in column names. Avoid using special characters such as @, #, $, %, _, etc. Avoid column names beginning with numbers.
  2. Avoid spaces: Use PascalCase to separate words in column names instead of spaces. For example, use ColumnName instead of Column Name. This can help prevent issues with URLs, Unicode encoding, and referencing column names in scripts or code.
  3. Avoid reserved words: SharePoint has reserved words that are used for system functionality, and using them in column names may cause conflicts. Examples of reserved words include “ID”, “Modified”, “Created”, “Title”, etc. Avoid using these reserved words as column names.
  4. Keep it concise and meaningful: Use descriptive and meaningful names for columns that clearly indicate their purpose. Avoid using vague or generic names that may be confusing or ambiguous to users. Use column description to provide more information about the columns.
  5. Be consistent: Establish a consistent naming convention for columns across your SharePoint site or site collection to ensure uniformity and ease of management. This can also help with documentation, training, and maintenance of your SharePoint environment.

I hope you liked this article. Give your valuable feedback & suggestions in the comments section below and share this article with others.

Learn more

Create a SharePoint online site using Power Automate flow

In this article, I will demonstrate how to provision a SharePoint online modern site using a Power automate flow. As there is no standard Power automate action for creating a SharePoint site (previously called “site collections”) using SharePoint connector, we will use the Send an HTTP Request to SharePoint action and SharePoint REST API in Power automate flow.

Follow below steps to create a SharePoint online modern communication site using Power Automate flow:

1. Go to make.powerautomate.com and create a new Instant cloud flow with Manually trigger a flow trigger.

2. Add Send an HTTP request to SharePoint action in Power automate flow.

3. Use configurations for Send an HTTP request to SharePoint action in below format:

MethodPOST

Uri_api/SPSiteManager/create

Headers:

{
	"accept": "application/json;odata=verbose",
	"content-type": "application/json;odata=verbose"
}

Body:

{
	"request": {
		"Title": "My Communication Site",
		"Url": "https://contoso.sharepoint.com/sites/MyCommSite",
		"Description": "My Communication Site created using Power Automate flow",
		"Owner": "gsanap@contoso.com",
		"Lcid": 1033,
		"WebTemplate": "SITEPAGEPUBLISHING#0",
		"SiteDesignId": "6142d2a0-63a5-4ba0-aede-d9fefca2c767",
		"ShareByEmailEnabled": false
	}
}

Where,

Url

URL for the new SharePoint online modern site (site collection)

LCID

Locale identifier (LCID) for the site language. 1033 is for English language, check LCID for other languages at: Language.Lcid property

WebTemplate

WebTemplate property is used to specify which type of SharePoint site to you want to create. You can use following values for this property:

  • Communication Site: SITEPAGEPUBLISHING#0
  • Team Site (not connected to M365 group): STS#3

SiteDesignId

SiteDesignId property is used to apply site template (previously called “site design”) to newly created SharePoint site.

If you want to apply an out-of-the-box available site template, use the following values:

  • Topic: 96c933ac-3698-44c7-9f4a-5fd17d71af9e
  • Showcase: 6142d2a0-63a5-4ba0-aede-d9fefca2c767
  • Blank: f6cc5403-0d63-442e-96c0-285923709ffc

ShareByEmailEnabled

If this property is set to true, it will enable sharing SharePoint files via Email.

Your final Power automate flow should look like this:

Create a SharePoint online modern communication site using Power Automate flow and SharePoint REST API
Create a SharePoint online site using Power Automate flow

4. Save your flow and Run it using Test > Manually options at the top right corner. After flow run completes successfully, navigate to the site URL mentioned in Send an HTTP request to SharePoint action in Power automate flow and you will see a newly created SharePoint online modern communication site like:

SharePoint online modern communication site created using Power Automate flow and SharePoint REST API with Send an HTTP request to SharePoint action
SharePoint online modern communication site created using Power Automate

Learn more

Add, update, or delete images in SharePoint/Microsoft Lists using Power Apps

In my previous blog about image columns in SharePoint, I explained all you need to know about New Image column type in SharePoint online including how to create an image column, how to add image to a list item, where the Images will be stored, etc.

Last year Microsoft added support for displaying images from SharePoint Online/Microsoft Lists to Power Apps canvas apps. Now, Microsoft is adding support for adding, updating, and deleting images from image columns in SharePoint online/Microsoft Lists using Power Apps canvas apps.

Newly created canvas apps that have a SharePoint data connection and are connected to a list can use controls that can add, update, or delete images from the SharePoint list. To use the same functionality in existing canvas apps, you have to delete the existing SharePoint data connection and then re-add it to refresh the data schema.

Configure SharePoint Form control to add pictures/images

Follow below steps to configure SharePoint Form control in canvas app to add pictures/images to SharePoint lists:

1. Create a SharePoint online list and then create an image column in the SharePoint list.

2. Go to make.powerapps.com, create a blank canvas app and add SharePoint list data source.

3. Add Form control in app from Insert > Forms > Edit form

4. Set Data Source property of form control to SharePoint list data source and DefaultMode property to FormMode.New

5. Select form control from tree view, click on Edit fields option from Properties panel at the right side of screen.

6. Add your image column to form using + Add field option on Fields panel and select Add picture as a Control type as shown in below image. Power Apps will add Add picture control inside the data card for image column.

Add image column to form and select “Add picture” as control type

7. Add a button control in canvas app and set it’s OnSelect property to:

SubmitForm(Form1)

8. Now when you run the canvas application, you can select an image from your computer using Add picture control and save it to SharePoint list using SubmitForm() function used in button control.

Add, update, or delete images in SharePoint/Microsoft Lists using Power Apps

Using Patch() function to add/update image column using Power Apps

You can also use the Patch() function to add or update an image in image columns in SharePoint/Microsoft Lists using Power apps canvas apps. You can use similar code as given below on OnSelect property of button control:

Patch(
    'Logo Universe',
    Defaults('Logo Universe'),
    {
        Title: TextInputControl.Text,
        Image: ImageControl.Image
    }
)

Delete an image from SharePoint image column using Power Apps

You can delete an image from SharePoint image column using Blank() value for image column in Power Apps Patch function:

Patch(
    'Logo Universe',
    Defaults('Logo Universe'),
    {
        Title: TextInputControl.Text,
        Image: Blank()
    }
)

Limitations

  1. Images up to 30MB in size are supported while adding/updating images.
  2. Below image formats are supported currently while using this feature.

Supported Image formats

Below image formats are supported currently while using this feature:

  • JPG and JPEG
  • PNG
  • GIF
  • TIF and TIFF
  • HEIC and HEIF
  • JPE, MEF, MRW, NEF, NRW, ORF, PANO, PEF, RW2, SPM, XBM, XCF

Release Timeline

  • Targeted Release: Rollout started in late September 2022 (previously early September 2022) and expected to complete by mid-October 2022 (previously mid-September 2022).
  • Standard Release: Microsoft will begin rolling out this feature in mid-October 2022 (previously mid-September 2022) and expects to complete it by late October 2022 (previously late September 2022).

Learn more

I hope you liked this blog. Please give your valuable feedback & suggestions in the comments section below and share this blog with others.

Introduction to SharePoint Spaces

In this blog we will explore the SharePoint spaces, it’s history & roadmap and how to enable SharePoint spaces in a SharePoint online site.

What’s SharePoint Spaces

As per the Microsoft documentation, SharePoint spaces is defined as:

“SharePoint spaces is a web-based, immersive platform, which lets you create and share, secure and extensible mixed reality experiences. Add a new dimension to your intranet by using 2D and 3D web parts to create your mixed reality vision.”

SharePoint Spaces allows users to easily build mixed reality experiences that interact with content stored in SharePoint Online.

SharePoint spaces empower creators to build immersive mix reality experiences with point-and-click simplicity. You can get started with smart templates to create a mixed reality environment complete with beautiful surroundings, ambient sounds, rich textures, and lighting. You then add content, which can include files you already have in SharePoint, allowing you to repurpose your existing data, documents, and images.

History & Roadmap

  • Microsoft announced SharePoint Spaces first time during its annual SharePoint Virtual Summit held in May 2018.
  • Microsoft announced SharePoint spaces public preview in April 2020, Roadmap.
  • Microsoft added 360° tour web part in SharePoint spaces which allows creation of immersive virtual tours for SharePoint sites, Roadmap.
  • Microsoft added touch device support in SharePoint spaces which enables users to interact with a space using touch interactions in addition to the mouse and keyboard-based interactions, Roadmap.
  • Microsoft announced General Availability of SharePoint spaces, Roadmap.
Organization chart in SharePoint spaces in SharePoint online site
Org Chart in a SharePoint Space

That’s it for SharePoint spaces introduction and history. Let’s see how you can enable SharePoint spaces in your SharePoint online site to get started with it.

Enable SharePoint spaces in a site

SharePoint spaces are not enabled by default in SharePoint online site. To use SharePoint spaces, we need to enable a site feature named “Spaces”.

You can activate this feature using any one of the methods given below:

Manually:

You can activate Spaces feature from user interface by navigating to Manage site features page.

Hit (URL: https://tenant.sharepoint.com/sites/siteName/_layouts/ManageFeatures.aspx) in browser tab by replacing tenant and siteName or follow below steps:

  1. Go to SharePoint site where you want to build a space
  2. Click on Settings (gear icon), select Site information and then select View all site settings.
  3. On the Site settings page, select Manage site features under Site Actions.
  4. Scroll down the page to Spaces feature and click on Activate button.
  5. Wait till the page refreshes and confirm that feature is activated successfully.
SharePoint online site features settings
Activated Spaces feature
Using PnP PowerShell:

You can easily activate features in SharePoint online using PnP PowerShell. To activate a site feature using PnP PowerShell you will need the GUID of feature. Check how you can quickly get the GUID of a site feature. GUID of Spaces feature is 2ac9c540-6db4-4155-892c-3273957f1926.

Use below command to activate Spaces feature:

Enable-PnPFeature -Identity 2ac9c540-6db4-4155-892c-3273957f1926 -Scope Web

You can find the detailed example of how to activate a site feature in SharePoint Online using PnP PowerShell here.

To get an idea about what you can do using SharePoint spaces, check out some of the awesome samples here.

See also

New Site Header Options are coming to SharePoint Online

Microsoft is expanding the SharePoint Online branding options, including new header configurations for modern sites that will make your job easier to customize your SharePoint Online site.

Microsoft has started rolling out the updates to site header options to all SharePoint Online tenants, see Roadmap.

The header in your SharePoint site is the container for the site logo, site title, site navigation, and some other links like Follow and Share.

Where can you find header options?

Header options are located under Change the look settings. You can see change the look settings when you will click on Settings icon in the top right corner of your SharePoint site.

Header Layouts

Before this release there were only two header layouts available, Standard and Compact. With this release, Microsoft is adding two more header layouts, Minimal and Extended.

Minimal Layout

A minimal layout uses a reduced height to provide quick visual access to content in a single line including small site logo, site title, site navigation, site actions and labels.

Use minimal header when the branding is not much important, and you want to make the more space available for content to display on your page.

Minimal header layout in SharePoint Online
Minimal layout with Site title visibility set to Off
Compact Layout

Compact layout is a larger height layout that uses the full-size site logo while keeping content on a single line similar to minimal layout.

For all SharePoint sites created after this release, the default site header will be the compact header instead of the standard header.

Compact header layout in SharePoint Online
Compact layout with Site title visibility set to On
Standard Layout

Standard layout was the default header for all SharePoint sites before this release. Standard layout uses the full-size site logo and the content will be split onto 2 lines.

Standard header layout in SharePoint Online
Standard layout
Extended Layout

Extended layout is the largest layout of all. In this layout, content will be split into 2 content areas:

  • Site logo, site title, and an optional background image at the top area
  • Site navigation and other contents at the bottom area.

An extended header layout includes an optional background image, expanded site logo widths, and site logo alignment options like left, center & right.

Extended header layout in SharePoint Online
Extended layout with left aligned site logo

Site title visibility

Using this new option, you can easily toggle the site title visibility to On or Off.

Site title visibility option is available with all four header layouts.

Site Logo and Thumbnail

Before this release there was only one option available to select site logo that will appear in the site header, which can be transparent or non-transparent​.

Now you can add a Site logo thumbnail that will appear in search results, on the site card, and wherever else a square logo is needed. ​

If you are using an extended layout, you can change the site logo alignment to left, center or right of the site header.

SharePoint Online site title visibility and site logo settings
Site title visibility and site logo options

I hope you liked this blog. Give your valuable feedback & suggestions in the comments section below and share this blog with others.

Create a modern Calendar view in SharePoint Online/Microsoft Lists

Microsoft is currently rolling out the calendar view feature for SharePoint Online and Microsoft lists, Roadmap. In this blog I will explain how to create a calendar view in SharePoint Online modern list or Microsoft lists.

Create a modern Calendar view

Follow below steps to create a calendar view:

1. Go to your list. If you don’t have a list then Create a list with date columns as per your requirements.

2. From list view, click on Switch view options dropdown from command bar and select Create new view.

Create new view in SharePoint Online list
Create new view

3. Give name to list view, select Calendar under Show as option and then Select Start date & End date columns from dropdowns.

4. You can make this a public view using Make this a public view checkbox. Public views can be visited by anyone with access to this list.

5. Click on More options to select Title of items on calendar. Select appropriate column from dropdown as this column will be shown as the title of items on calendar view.

6. Click on Create button.

Create a modern calendar view in SharePoint online/Microsoft lists
Create a modern calendar view

The new modern calendar view will be created in a list as given below:

Modern calendar view in SharePoint Online/Microsoft lists
Modern calendar view

Calendar view shows the current events at the right hand side in Events Pane when you select a date from calendar. You can show/hide the events pane using icon button given at top of events pane (Highlighted in above image).

Set calendar view as the default view

If you want to show the calendar view by default when user navigate to SharePoint Online or Microsoft list then you have to set it as the default view.

Follow below steps to set the newly created calendar view as the default view:

  1. Click on Switch view options dropdown from command bar and select the name of the view that you want to make as the default view.
  2. Click on Switch view options dropdown again and select Set current view as default.
Set calendar view as a default view in SharePoint online list
Set calendar view as a default view

Next Step: After creating a calendar view in SharePoint list, you would want to add this modern calendar to a SharePoint page. For more information about this, check:

Learn more

Audience Targeting for Quick Links Web Part in SharePoint Online

Microsoft is finally introducing an audience targeting feature for the Quick links web part in SharePoint Online, Roadmap. By using audience targeting, you can promote links to specific groups of people. This is useful when you want to present information that is especially relevant to a particular group of people.

With the release of this update, you will be able to target specific links to different audiences, helping you provide more personalized experiences on SharePoint pages.

Key Points:

  1. The feature is disabled on the web part by default, so nothing is required to prepare for its availability.
  2. To use audience targeting, you must first enable audience targeting on the web part from property pane, and then edit each quick link to specify the audience to target.
  3. Currently you can only use AD groups or Microsoft 365 groups to target audiences. If you want to use SharePoint groups for audience targeting, vote on this UserVoice.
  4. You can target maximum 50 audiences (AD groups or Microsoft 365 groups) per link.

How to Use Audience Targeting:

As I mentioned earlier, to use audience targeting, you must first enable audience targeting on the web part from property pane, and then edit each quick link to specify the audience to target.

Enable audience targeting:
  1. Go to your modern SharePoint page and open it in Edit mode by clicking Edit button from top right corner.
  2. Select the Quick links web part and click on Edit web part (Pencil icon) button.
  3. From the property pane, change the toggle for Enable audience targeting to On.
Enable audience targeting for quick links web part in SharePoint Online
Enable audience targeting
Set the target audiences for each link:
  1. From Page Edit mode, click on the link you want to edit, and select the Edit (Pencil icon) on the link.
  2. Under Audiences to target, type or search for the group(s) you want to target.
Set the target audiences on quick link in SharePoint Online
Set the target audiences for each link

Below Audiences to target, you can see the maximum limit of 50 audiences and number of audiences left to target.

On the page, while you’re in edit mode, you can see which links have audiences selected by looking for the audience icon next to the link as shown below:

Quick Links with targeted audience in SharePoint Online
Links with targeted audience

Once you publish the page, audience targeting will take effect.

Output:

The SharePoint page will show filtered links based on targeted audiences. A user who is not a part of the audience targeted for Learning & Development link will see the quick links web part as shown below:

SharePoint Online Quick links web part with targeted audience
Quick links web part with targeted audience

Note: If you’ve selected an audience group that you recently created or changed, it may take some time to see targeting applied for that group.

I hope you liked this blog. Give your valuable feedback & suggestions in the comments section below and share this blog with others.

Rules in SharePoint Online/Microsoft Lists

Microsoft is rolling out a feature using which you can create rules in SharePoint Online and Microsoft lists to set reminders and send notifications to users based on changes to list information, Roadmap. In this blog I will explain how to create a rule in SharePoint Online modern list or Microsoft lists.

Previous options to send notifications

Before this feature, if you wanted to send notifications about changes in a SharePoint Online or Microsoft List, you had below two options:

Create an alert

SharePoint alerts are email notifications that are sent to SharePoint users when something changes in a list or library. You can create an alert for:

  • Whole list or library
  • Folder, file, or list item
  • SharePoint search criteria

However It doesn’t provide the ability to send notifications for column level changes. This is where you will find list rules very helpful.

Create a Power Automate/Microsoft Flow

Another way of getting notifications for file or list item changes is to use Power Automate with the SharePoint connector.

Using Power Automate, users can create simple change notifications as well complex, multiple condition-based notifications. However, some users may find it difficult to create a Power Automate flow from scratch without any development experience or assistance.

Creating list rules

Creating list rules is very easy as compared to creating power automate flow and you have much more control using list rules compared to the existing alerts functionality.

With this feature update, SharePoint users with edit permissions on a list can create and manage simple if/then rules based on changes to list information, to set reminders and send notifications. Users with read-only permissions will not be able create or manage rules.

Follow below steps to create rules in SharePoint online/Microsoft lists:

  • Go to SharePoint Online/Microsoft list where you want to create a rule.
  • Click on the Automate option from command bar and then select Create a rule.
Create a list rule in SharePoint online/Microsoft lists
Create a list rule

There are four different conditions that triggers the rule as shown in the below image:

List rule conditions in SharePoint online/Microsoft lists
List rule conditions
  • Under Notify someone when, select a condition that will trigger the rule. For example, A column changes.
  • Creating rule is like writing a sentence. Select each of the underlined portions of the rule statement to customize the condition by choosing a column, the value of the column, and who to notify.
SharePoint online list rule to notify author when the Status column changes
Rule to notify Author when the Status column changes

For example, to notify Author when a Status column changes, you need to choose the Status column, and then select Author from Suggestions list. Suggestions from this list shows the Person or Group columns from the list.

If you want to notify yourself, you could select Me from Other suggestions. You can also select the users by using Enter a name or email address option.

  • When you’re finished customizing the statement, select Create. You’ll see your rule on the Manage rules page and the rule will be turned on by default.

Now when Status column changes, list rule will send notification email to Author. The notification email will contain a link to display/view form of SharePoint list item. These notification emails will be sent from Microsoft 365. Check below image for reference:

Email notification send by using SharePoint online list rules
Email notification send by using list rules
Notes:
  • Users will be able to create a maximum of 15 rules per list.
  • Currently it is not possible to customize the email notification template

Editing a list rule

You can edit a list rule from the Manage rules page. Follow below steps to edit a rule for a list:

  • Go to SharePoint Online/Microsoft list, select Automate from command bar and then Manage rules.
Go to Manage rules in SharePoint Online
Go to Manage rules page
  • From manage rules page, you can create/edit/delete a rule. You can also turn off the rule by changing the slider to Off.
  • To edit the rule, click on the rule and then change the underlined portions of the rule statement.
Manage rules in SharePoint Online
Manage rules page
  • After making all changes, Click Save.

Deleting a list rule

When you no longer need a rule, you can either turn it off or delete it from the Manage rules page. Follow below steps to delete a rule for a list:

  • Go to SharePoint Online/Microsoft list, select Automate from command bar and then Manage rules.
  • Select the rule you want to delete and click Delete rule at the bottom of the Edit rule page, .
Deleting a list rule in SharePoint Online list
Deleting a list rule

Supported/Unsupported column types

List rules allow sending notifications when a column or it’s value changes. However, it does not support all column types currently.

Supported column types

Currently below column types are supported while using when a column changes and when a column value changes conditions:

  • Single line of text
  • Choice (single & multiple selection)
  • Number
  • Date and Time
  • Yes/No
  • Person or Group (single & multiple selection)
  • Created By & Modified By (while using when a column value changes condition)
Unsupported column types

Below column types are not supported currently:

  • Multiple lines of text
  • Currency ($, ¥, €)
  • Lookup
  • Hyperlink or Picture
  • Calculated
  • Image
  • Managed Metadata

I hope you liked this blog. Give your valuable feedback & suggestions in the comments section below and share this blog with others.

Add Modern Calendar to a SharePoint Online page using List web part

In my earlier blog, add modern calendar to a SharePoint online page, I explained how you can show modern calendar list view on SharePoint Online modern pages using Embed web part. I used embed web part because modern calendar views were not supported in SharePoint out of the box List web part at that time.

Fortunately, Microsoft is rolling out a new feature which will support modern calendar views in List web part. This feature is associated with Microsoft 365 Roadmap ID 70750. In this blog we will see how to add the modern calendar view to a SharePoint online page using List web part.

1. First of all, create a modern calendar list view by following this blog: Create a modern Calendar view in SharePoint Online/Microsoft Lists.

2. Go to your modern SharePoint page and open it in Edit mode by clicking Edit button from top right corner.

3. Open web part toolbox and search for List.

Search "List" in SharePoint online modern web part toolbox
Search “List” in SharePoint web part toolbox

4. Click on List web part from Search results. It will add the List web part to your modern page.

5. Initially the List web part shows all the lists available on your SharePoint site. Click on the list name where you created a modern calendar view OR you can also select a list from web part configuration property pane which opens when you click on Edit web part button

Select a list in "List" web part on SharePoint online modern page
Select a desired list in “List” web part

6. By default the List web part will load the default view of your SharePoint list. If you have set newly created Calendar view as your default view, skip this step. Else, select your calendar view from Switch view options dropdown as shown below:

Select modern calendar list view from views dropdown in SharePoint online list/ Microsoft Lists
Select modern calendar list view from views dropdown

7. Click on Publish/Republish button to save the changes.

You will see the final output on SharePoint page as shown below:

Modern calendar list view web part added to SharePoint online modern page
Modern calendar list view added to a SharePoint online modern page

Learn more

Introducing Embed web part in SharePoint spaces

Tech giant Microsoft is introducing Embed web part in SharePoint spaces which will allow users to show SharePoint pages or HTML page embed content as an interactable overlay on a SharePoint space. Space viewers will see a thumbnail image in the 3D space that can be viewed as a fully functional HTML overlay when selected by the user. Space viewers that are using a mixed reality headset will only see the thumbnail when selecting the web part unless they return to the browser to interact with the embedded content.

This new feature release will allow users to add content such as:

  • Microsoft Forms
  • The PowerPoint embed viewer
  • SharePoint Pages
  • Power Apps

This message is associated with Microsoft 365 Roadmap ID 70732.

Release Timeline

  • Targeted release (selected users and entire organization): Roll out will begin in early November and expect to be complete by mid-November.
  • Standard release: Roll out will begin in mid-November and expect to be complete by late November.

How this will affect your organization

SharePoint spaces authors will see a new embed web part available in the spaces web part toolbox while designing a SharePoint space.

SharePoint spaces authors will see embed web part as shown in below image:

Introducing Embed web part in SharePoint spaces in SharePoint online
Introducing Embed web part in SharePoint spaces

What you need to do to prepare

You might want to notify your users about this new capability and update your training documentation as appropriate.

Learn more

❌
❌