All posts in Office 365

Ever since my Pluralsight course on Microsoft Flow, I have been getting questions about a more power-user Microsoft Certification for the Power Platform, without needing to know the ins and outs of Dynamics! Previously, the only way you could get certified in Flow and PowerApps was trough the Dynamics Certifications, but today, Microsoft finally released a fundamentals certification for the Power Platform, which covers Flow, PowerApps, and Power BI! The new exam is the PL-900: Microsoft Power Platform Fundamentals!

Microsoft releases a new certification for Power Platform Fundamentals

Why a new certification?

From an organizational point of view, the Power Platform has always been under the Dynamics 365 umbrella, and so have been all of the certifications. Flow and PowerApps were both included under various Dynamics 365 exams, but they were there as “supporting” technologies, not really there as the goal of the exam. The goals of those certs were really on Dynamics 365. With Flow and PowerApps becoming stand alone tools, as well as heavily used for SharePoint, a lot of Power users (see what I did there 🙂 ?) wanted to be able to show off their skills with the Power Platform. While this is fundamentals level certification, it’s still a start and allows anyone to certify their knowledge of Flow, Power BI and PowerApps!

What is covered in this certification?

This certification really covers the basics of the Power Platform in an Understand and Demonstrate Business Value kind of testing. First two really focus on the business value / core components, while the last three are product specific. You are still expected to know how to create a PowerApps, Flow, Report etc!

  • Understand the business value of Power Platform (20-25%)
  • Understand the Core Components of Power Platform (25-30%)
  • Demonstrate the business value of Power BI (15-20%)
  • Demonstrate the business value of Power Apps (15-20%)
  • Demonstrate the business value of Microsoft Flow (15-20%)

To view all of the details check out the full skills checked document > https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE43KLw

Certification Path

The Certification path for this fundamentals certification is pretty easy! Pass the PL-900 exam and you will become Microsoft Certified Power Platform Fundamentals!

Microsoft releases a new certification for Power Platform Fundamentals

When can we take it?

The Beta for the PL-900 actually opens today on November 4th, and you can pass it today as a beta exam, but you will not get the results until the beta is over. Remember, you can also get free exams by attending Microsoft Ignite, or Microsoft Ignite the Tour! Check out my blog post on this to learn more!

Learn More and Discount Code!

Learn more about the exam on the Microsoft Learning page or by clicking the image below! You can also save 80% of the beta with Discount code PL-900-Hawaii  if you do the exam before December 13th!  (Limit 300 codes used!)

Microsoft releases a new certification for Power Platform Fundamentals

Will you go for the exam? Let me know what you think about it, and the topics covered in the comments!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (2)

Please rate this

Another certification that’s been released today, and this one is for an audience that has been ignored for the past 6 years: Microsoft 365 Developers! The name of the certification is the MS-600: Building Applications and Solutions with Microsoft 365 Core Services towards the Microsoft 365 Certified: Developer Associate certification!

Microsoft 365 Developers

Why a new certification?

The last time we had a certification for SharePoint Developers was for SharePoint Server 2013! Ever since, Microsoft Learning didn’t show any love to SharePoint / Office 365 developers for SharePoint 2016, SharePoint 2019 or Office 365. I think a big reason for that is that the landscape for Microsoft Dev has changed a lot, and lots of things were introduced like the SharePoint Framework and the Microsoft Graph. This certification is an awesome opportunity for SharePoint and Office developers to get certified on the latest dev technologies.

What is covered in this certification?

This exam really covers the big customizable parts of a Microsoft 365 environment, from identities, to SharePoint, Teams and Office, as well as the Graph which is cross product! You can see the high-level topics and split below!

  • Implement Microsoft Identity (20-25%)
  • Build Apps with Microsoft Graph (20-25%)
  • Extend and Customize SharePoint (20-25%)
  • Extend Teams (15-20%)
  • Extend Office (15-20%)

If you want to see the full and detailed skills tested, you can check them out here: https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE43CZn

Certification Path

The Certification Path for this one is easy, you pass the MS-600 exam, and then you get the Microsoft 365 Certified: Developer Associate title!

Microsoft 365 Developers

When can we take it?

The Beta for the MS-600 opens today on November 4th, and you can pass it today as a beta exam, but you will not get the results until the beta is over. Remember, you can also get free exams by attending Microsoft Ignite, or Microsoft Ignite the Tour! Check out my blog post on this to learn more!

Learn more and Discount Code!

Learn more about the exam on the Microsoft Learning page or by clicking the image below! Save 80%  of the beta if you take the exam before December 20 with discount code MS600Middlebury ! Limited to only 300 codes used!

Microsoft 365 Developers

Will you go for the exam? Let me know what you think about it, and the topics covered in the comments!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (2)

Please rate this

Microsoft Ignite starts in just a few days, and I have gotten a lot of questions on where people should go to get the official Microsoft Ignite announcements from Microsoft directly during the week and then stay up to date! Here are the main channels that Microsoft will use to communicate the news this week!

Microsoft Ignite Announcements

Tech Community

The Microsoft Tech Community is the home of many product team’s official blog, and there is where they will be sharing in more details stuff announced either in the main keynote by Satya, or in the technology keynotes that follow right after. Here is a list of blogs by technology:

All those blogs have RSS feeds you can subscribe to with your favourite RSS reader! Yo can find the RSS feed at the top right as seen in the screenshot below! You can also add those RSS Feeds as connectors in Teams this way you get the updates for yourself and the rest of the team directly there! My friend Jeff Collins from CoupledTech actually created a Teams Template containing all the feeds that you can get from here!

Microsoft Ignite Announcements

Twitter

Twitter is a fire hose of information, and will be extremely active this week, but it’s a great place to hear about everything being announced, as well as ask questions to the different product teams / Product Group members!

Handles to follow

  • @Azure
  • @Microsoft
  • @Microsoft365
  • @MSCloud
  • @MSFTSecurity
  • @MS_Ignite
  • @MS_ITPro
  • @MicrosoftEdge
  • @MicrosoftFlow
  • @microsoftgraph
  • @MicrosoftIOT
  • @MicrosoftTeams
  • @MSDev
  • @MSExcel
  • @MSFT365News
  • @MSFTDynamics365
  • @MSEdgeDev
  • @MSFTnews
  • @MSPartner
  • @MSPowerBI
  • @Office365
  • @OneDrive
  • @Outlook
  • @PowerApps
  • @PowerPoint
  • @SharePoint
  • @MicrosoftStream
  • @VisualStudio
  • @WindowsServer
  • @vladcatrinescu 🙂

To make it easier, you can just subscribe to this list where I have added all the handles above! > https://twitter.com/vladcatrinescu/lists/msignite-official-chnls

Hashtags

These twitter hashtags will also be active during the week!

  • #MSIgnite
  • #Azure
  • #AI
  • #Microsoft365
  • #MSPartner
  • #VisualStudio
  • #SharePoint
  • #OneDrive

If you want to get a recap of all of the news, especially in the Microsoft 365 space, make sure you also register for one of my four webinars together with Drew!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (3)

Please rate this

As most of the followers of my blog are aware, Microsoft has completely revamped their certification paths starting in 2018, with the complete roll out starting in 2019. There is still some confusion out there in what are the different options available, what certs are available, and what are the prerequisites for each. There is some great documentation made by Microsoft out there, but it’s hard to find so I wanted to share it all out in a blog! None of those pictures were created by me, all of them are made by Microsoft, but hopefully this blog will make it a lot easier for you to find!

Apps and Infrastructure Azure Certifications Overview

Azure Certifications Overview

Microsoft Certified Azure Fundamentals

PS : Check out my own Study Guide here as well : https://absolute-sharepoint.com/az-900-study-guide-microsoft-azure-fundamentals

Microsoft Certified Azure Fundamentals

Azure Administrator Associate

PS : Check out my own Study Guide here as well : https://absolute-sharepoint.com/az-103-study-guide-microsoft-azure-administrator

Azure Administrator Associate

Azure Developer Associate

Azure Developer Associate

Azure DevOps Engineer Expert

Azure DevOps Engineer Expert

Azure Solutions Architect Expert

Azure Solutions Architect Expert

Azure Data and AI Certifications Overview

Azure Data and AI Certifications

Azure Data Scientist Associate

Azure Data Scientist Associate

Azure Data Engineer Associate

Azure Data Engineer Associate

Azure AI Engineer Associate

Azure AI Engineer Associate

Microsoft 365 Certifications Overview

Microsoft 365 Certifications Overview

Modern Desktop Administrator Associate

Modern Desktop Administrator Associate

Teamwork Administrator Associate

Check out the study guides:

Teamwork Administrator Associate

Messaging Administrator Associate

Messaging Administrator Associate

Security Administrator Associate

Security Administrator Associate

Enterprise Administrator Expert

Enterprise Administrator Expert

This is it for the blog post, you can find the original source of the documents over here.

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
4.75/5 (4)

Please rate this

While working on an offboarding script, one of the requirements was to send an e-mail to the manager with the OneDrive for Business URL of the user that was going to get disabled. There is quite some information on the internet on how to get this with CSOM, but not a lot in how to get it with PowerShell for IT Pros like me … we prefer PowerShell cmdlets to code! While this is not available in the default SharePoint Online Module ,we can use the PnP PowerShell cmdlets to do it!

The first thing you must do is to get your credential and use the Connect-PnPOnline cmdlet to connect to your SharePoint Online Admin Center!

You can then run the Get-PnPUserProfileProperty cmdlet to get the information about the user’s profile and select only the PersonalUrl which is the URL of that user’s OneDrive for Business!

Find a user’s OneDrive for Business site URL with PowerShell

That’s it! Once you know the right cmdlets to use, it’s that simple!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (2)

Please rate this

One of the big Information Architecture changes with modern SharePoint is the flat architecture, which means that now, instead of your Intranet being one Site Collection with multiple subsites, it will now be multiple Site Collections. I’ve seen multiple example architectures where an Intranet can easily become over 15 Site Collections! That means, each Site Collection has its own settings, including external access! While a new SharePoint Admin Center is shipping, you cannot bulk-change External Sharing settings.

So I have built a quick PowerShell script that you can simply provide the URL of a Hub Site and the level of external sharing you want to enable, and it will do the magic for you! The script seen below requires two parameters, and it has some validations in to make sure you supply the right type of values.

  1. HubSiteUrl : The URL of a Hubsite
  2. ExternalSharing : one of the following options:
    1. Disabled – don’t allow sharing outside your organization
    2. ExistingExternalUserSharingOnly – Allow sharing only with the external users that already exist in your organization’s directory
    3. ExternalUserSharingOnly – allow external users who accept sharing invitations and sign in as authenticated users
    4. ExternalUserAndGuestSharing – allow sharing with all external users, and by using anonymous access links.

If you examine the script, you will realize that I run the Get-SPOSite twice , that is because when you run Get-SPOSite without specifying a URL , it doesn’t return the HubSiteId , so that’s why we have to do it!

Download the following script and save it as HubExternal.ps1.

Here is an example on how to run it:

And this is what it should look like when running it!

External Sharing Settings Across a Hub Site

I hope this helps! You can of course modify this script to take the same logic, and do a bunch of different changes on all the Site Collections in a certain Hub Site!

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (4)

Please rate this

In Office 365, profile completeness is key to multiple cloud experiences. For example, you cannot really do approvals by the manager, if the manager is not set in the user’s profile! Another good example would be a people directory, which would be a bit useless if users don’t have their location and phone numbers filled in! In this series, we will look at how to use PowerShell to create a report of Office 365 Users missing key properties!

Finding users with no country

Office 365 Profile Completeness Series

Finding users with no country/ set in the user profile

In this blog post, we will focus on how to find users that do not have a Country set as part of their Office 365 Profile. The Country can be very useful for international company with more advanced people directories. It can also allow admins to create reports, or do changes by keying on this property.

Requirements:

The Script

First thing we are going to do is get our Office 365 credentials, and connect to Azure Active Directory.

 

I will then get all of the users in my tenant, that are internal to the company (Member) and that have at least one license assigned to them.

Next up, we will create an empty array in which we will later store our users without a country.

Now that we have all our information, we will loop trough each user, and find out if they have anything in the Country property of their Azure AD user profile. If not, we will add our user to the array!

Lastly, we will export the results to a CSV file

And here is the full script in one piece!

The Result

The final result is a CSV file in which we can see the display names and user names of all of the users in our tenant that don’t have the country in their profile! You can either contact them individually, or even Send Email from PowerShell in Office 365 in order to automatically send them a nicely formatted HTML e-mail asking them to fill it!

Finding users with no country

More Resources

PowerShell for Office 365 is an essential tool as part of every Office 365’s administrator toolbox. Without PowerShell, you cannot do cool reports such as the one in this blog post, and you are missing out on multiple Office 365 reporting, productivity and security settings. Here are some resources that you could use to learn PowerShell for Office 365:

Books

Books are really ways to learn a topic from start to master, and even if they cost some dollars, they’re always a good investment!

Learn PowerShell for Office 365

Essential PowerShell for Office 365: Managing and Automating Skills for Improved Productivity
Take your Office 365 skills to the next level. Master PowerShell for Office 365 to stay competitive in today’s world of highly sought after cloud management skills. With expert guidance, IT pros will learn how to leverage the muscle of PowerShell to automate many advanced administrative tasks not otherwise accessible in the Office 365 Admin Center. You will discover how to unlock configuration options and automate tasks in order to free up valuable time and resources.

Get it on Amazon at the following links:

Video Training

NOTE: Pluralsight is a paid resource unlike Channel9, Youtube, and Microsoft Virtual Academy which are free. The quality they provide is also superior because of all the quality checks they go through, and the instructors are one of the best in the industry. The Pluralsight courses have a link to where you can get a free trial and decide for yourself if paying a subscription or not is worth it, but the 10 day free trial should allow you to view all those courses for free.

Learn PowerShell for Office 365

PowerShell for Office 365
In this course, you will learn how to use PowerShell to manage Office 365 services. You will learn how to connect and manage users and licensing, SharePoint Online, Exchange Online, Compliance Center and last but not least, Skype for Business Online.

Learn PowerShell for Office 365

PowerShell Playbook for Office 365
A more advanced look at multiple real-life scenarios that span across all Office 365 Services and show you how your PowerShell for Office 365 skills can be applied in your day to day life

PowerShell for common Office 365 Operations
In this 300 level session, you will learn how to automate the management of Office 365 using Windows PowerShell. We will discuss how to connect Windows PowerShell to Office 365, tour the Office 365 cmdlets, and demonstrate how to manage domains, users, and services including Exchange Online, and SharePoint Online.

Support Corner: Using PowerShell to Manage Office 365 Users
Join us in this fast-paced demo to learn how to manage Office 365 users using PowerShell. Experts show you how to create and delete users, update user IDs and passwords, assign licenses and groups, and much more.

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (3)

Please rate this

In Office 365, profile completeness is key to multiple cloud experiences. For example, you cannot really do approvals by the manager, if the manager is not set in the user’s profile! Another good example would be a people directory, which would be a bit useless if users don’t have their location and phone numbers filled in! In this series, we will look at how to use PowerShell to create a report of Office 365 Users missing key properties!

Office 365 Profile Completeness Series

Finding users with no manager set in the user profile

In this blog post, we will focus on how to find users that do not have a manager set as part of their Office 365 Profile. The Manager property is absolutely needed for features such as the Organization Chart, approvals in Microsoft Flow, quick team-calendar view and other productivity features in Office 365.

There is no out of the box report on Profile Completeness in Office 365, so PowerShell is your best tool in creating reports on user’s profiles! Here is what we will need to get started:

Requirements:

The Script

First thing we are going to do is get our Office 365 credentials, and connect to Azure Active Directory.

I will then get all of the users in my tenant, that are internal to the company (Member) and that have at least one license assigned to them.

Next up, we will create an empty array in which we will later store our users without a manager.

Now that we have all our information, we will loop trough each user, and find out if they have a manager or not set as part of their Azure AD user profile. If not, we will add our user to the array!

Lastly, we will export the results to a CSV file

And here is the full script in one piece!

The Result

The final result is a CSV file in which we can see the display names and user names of all of the users in our tenant that don’t have a manager in their profile! You can either contact them individually, or even Send Email from PowerShell in Office 365 in order to automatically send them a nicely formatted HTML e-mail asking them to fill it!

More Resources

PowerShell for Office 365 is an essential tool as part of every Office 365’s administrator toolbox. Without PowerShell, you cannot do cool reports such as the one in this blog post, and you are missing out on multiple Office 365 reporting, productivity and security settings. Here are some resources that you could use to learn PowerShell for Office 365:

Books

Books are really ways to learn a topic from start to master, and even if they cost some dollars, they’re always a good investment!

Learn PowerShell for Office 365

Essential PowerShell for Office 365: Managing and Automating Skills for Improved Productivity
Take your Office 365 skills to the next level. Master PowerShell for Office 365 to stay competitive in today’s world of highly sought after cloud management skills. With expert guidance, IT pros will learn how to leverage the muscle of PowerShell to automate many advanced administrative tasks not otherwise accessible in the Office 365 Admin Center. You will discover how to unlock configuration options and automate tasks in order to free up valuable time and resources.

Get it on Amazon at the following links:

Video Training

NOTE: Pluralsight is a paid resource unlike Channel9, Youtube, and Microsoft Virtual Academy which are free. The quality they provide is also superior because of all the quality checks they go through, and the instructors are one of the best in the industry. The Pluralsight courses have a link to where you can get a free trial and decide for yourself if paying a subscription or not is worth it, but the 10 day free trial should allow you to view all those courses for free.

Learn PowerShell for Office 365

PowerShell for Office 365
In this course, you will learn how to use PowerShell to manage Office 365 services. You will learn how to connect and manage users and licensing, SharePoint Online, Exchange Online, Compliance Center and last but not least, Skype for Business Online.

Learn PowerShell for Office 365

PowerShell Playbook for Office 365
A more advanced look at multiple real-life scenarios that span across all Office 365 Services and show you how your PowerShell for Office 365 skills can be applied in your day to day life

PowerShell for common Office 365 Operations
In this 300 level session, you will learn how to automate the management of Office 365 using Windows PowerShell. We will discuss how to connect Windows PowerShell to Office 365, tour the Office 365 cmdlets, and demonstrate how to manage domains, users, and services including Exchange Online, and SharePoint Online.

Support Corner: Using PowerShell to Manage Office 365 Users
Join us in this fast-paced demo to learn how to manage Office 365 users using PowerShell. Experts show you how to create and delete users, update user IDs and passwords, assign licenses and groups, and much more.

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (3)

Please rate this

In Office 365, profile completeness is key to multiple cloud experiences. For example, you cannot really do approvals by the manager, if the manager is not set in the user’s profile! Another good example would be a people directory, which would be a bit useless if users don’t have their location and phone numbers filled in! In this series, we will look at how to use PowerShell to create a report of Office 365 Users missing key properties!

Office 365 Profile Completeness Series

Finding users with no skills set in the user profile

In this blog post, we will focus on how to find users that did not set their skills as part of their SharePoint Online profile. The Skills field can be very useful in an expertise finder directory, when people try to find other colleagues that have knowledge in a certain area or in certain products. Without the skills information being set, the expertise finder in your organization will be way less valuable

There is no out of the box report on Profile Completeness in Office 365, so PowerShell is your best tool in creating reports on user’s profiles! Here is what we will need to get started:

Requirements:

The Script

First thing we are going to do is get our Office 365 credentials, and connect to both Azure Active Directory and the SharePoint Online Admin Center (with the PnP cmdlets)

I will then get all of the users in my tenant, that are internal to the company (Member) and that have at least one license assigned to them.

Next up, we will create an empty array in which we will later store our users without any skills .

Now that we have all our information, we will loop trough each user, and find out if they have a SharePoint Online Profile or not (since the skills are  stored in the SPO profile, not in Azure AD).   If the profile exists, and the SPS-Skills property is equal to an empty string, it means the skills for this user are not set, so we will save the user object in the array we created in the previous step!

Lastly, we will export the results to a CSV file

And here is the full script in one piece!

The Result

The final result is a CSV file in which we can see the display names and user names of all of the users in our tenant that don’t have any skills in their profile! You can either contact them individually, or even Send Email from PowerShell in Office 365 in order to automatically send them a nicely formatted HTML e-mail asking them to fill it!

More Resources

PowerShell for Office 365 is an essential tool as part of every Office 365’s administrator toolbox. Without PowerShell, you cannot do cool reports such as the one in this blog post, and you are missing out on multiple Office 365 reporting, productivity and security settings. Here are some resources that you could use to learn PowerShell for Office 365:

Books

Books are really ways to learn a topic from start to master, and even if they cost some dollars, they’re always a good investment!

Learn PowerShell for Office 365

Essential PowerShell for Office 365: Managing and Automating Skills for Improved Productivity
Take your Office 365 skills to the next level. Master PowerShell for Office 365 to stay competitive in today’s world of highly sought after cloud management skills. With expert guidance, IT pros will learn how to leverage the muscle of PowerShell to automate many advanced administrative tasks not otherwise accessible in the Office 365 Admin Center. You will discover how to unlock configuration options and automate tasks in order to free up valuable time and resources.

Get it on Amazon at the following links:

Video Training

NOTE: Pluralsight is a paid resource unlike Channel9, Youtube, and Microsoft Virtual Academy which are free. The quality they provide is also superior because of all the quality checks they go through, and the instructors are one of the best in the industry. The Pluralsight courses have a link to where you can get a free trial and decide for yourself if paying a subscription or not is worth it, but the 10 day free trial should allow you to view all those courses for free.

Learn PowerShell for Office 365

PowerShell for Office 365
In this course, you will learn how to use PowerShell to manage Office 365 services. You will learn how to connect and manage users and licensing, SharePoint Online, Exchange Online, Compliance Center and last but not least, Skype for Business Online.

Learn PowerShell for Office 365

PowerShell Playbook for Office 365
A more advanced look at multiple real-life scenarios that span across all Office 365 Services and show you how your PowerShell for Office 365 skills can be applied in your day to day life

PowerShell for common Office 365 Operations
In this 300 level session, you will learn how to automate the management of Office 365 using Windows PowerShell. We will discuss how to connect Windows PowerShell to Office 365, tour the Office 365 cmdlets, and demonstrate how to manage domains, users, and services including Exchange Online, and SharePoint Online.

Support Corner: Using PowerShell to Manage Office 365 Users
Join us in this fast-paced demo to learn how to manage Office 365 users using PowerShell. Experts show you how to create and delete users, update user IDs and passwords, assign licenses and groups, and much more.

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (3)

Please rate this

In Office 365, profile completeness is key to multiple cloud experiences. For example, you cannot really do approvals by the manager, if the manager is not set in the user’s profile! Another good example would be a people directory, which would be a bit useless if users don’t have their location and phone numbers filled in! In this series, we will look at how to use PowerShell to create a report of Office 365 Users missing key properties!

Office 365 Profile Completeness Series

Finding users with no Picture set in the user profile

In this blog post, we will focus on how to find users that did not set their picture as part of their Office 365 profile. With remote work becoming more and more popular and with teams spread across the board, it’s important to be able to put a face on a name. Multiple Office 365 experiences such as Teams, Delve, SharePoint leverage that profile picture in order to make the tools you use look a lot better, and quickly identify people inside the company. Without pictures, all of those experiences will only show gray placeholders, which is not optimal.

There is no out of the box report on Profile Completeness in Office 365, so PowerShell is your best tool in creating reports on user’s profiles! Here is what we will need to get started:

Requirements:

The Script

First thing we are going to do is get our Office 365 credentials, and connect to both Azure Active Directory and Exchange Online!

I will then get all of the users in my tenant, that are internal to the company (Member) and that have at least one license assigned to them.

Next up, we will create an empty array in which we will later store our users without a picture.

Now that we have all our information, we will loop trough each user, and find out if they have a picture as part of their profile. If not, we will add that user object to the array we have created earlier!

Lastly, we will export the results to a CSV file

And here is the full script in one piece!

The Result

The final result is a CSV file in which we can see the display names and user names of all of the users in our tenant that don’t have a picture set in their profile! You can either contact them individually, or even Send Email from PowerShell in Office 365 in order to automatically send them a nicely formatted HTML e-mail asking them to fill it!

More Resources

PowerShell for Office 365 is an essential tool as part of every Office 365’s administrator toolbox. Without PowerShell, you cannot do cool reports such as the one in this blog post, and you are missing out on multiple Office 365 reporting, productivity and security settings. Here are some resources that you could use to learn PowerShell for Office 365:

Books

Books are really ways to learn a topic from start to master, and even if they cost some dollars, they’re always a good investment!

Learn PowerShell for Office 365

Essential PowerShell for Office 365: Managing and Automating Skills for Improved Productivity
Take your Office 365 skills to the next level. Master PowerShell for Office 365 to stay competitive in today’s world of highly sought after cloud management skills. With expert guidance, IT pros will learn how to leverage the muscle of PowerShell to automate many advanced administrative tasks not otherwise accessible in the Office 365 Admin Center. You will discover how to unlock configuration options and automate tasks in order to free up valuable time and resources.

Get it on Amazon at the following links:

Video Training

NOTE: Pluralsight is a paid resource unlike Channel9, Youtube, and Microsoft Virtual Academy which are free. The quality they provide is also superior because of all the quality checks they go through, and the instructors are one of the best in the industry. The Pluralsight courses have a link to where you can get a free trial and decide for yourself if paying a subscription or not is worth it, but the 10 day free trial should allow you to view all those courses for free.

Learn PowerShell for Office 365

PowerShell for Office 365
In this course, you will learn how to use PowerShell to manage Office 365 services. You will learn how to connect and manage users and licensing, SharePoint Online, Exchange Online, Compliance Center and last but not least, Skype for Business Online.

Learn PowerShell for Office 365

PowerShell Playbook for Office 365
A more advanced look at multiple real-life scenarios that span across all Office 365 Services and show you how your PowerShell for Office 365 skills can be applied in your day to day life

PowerShell for common Office 365 Operations
In this 300 level session, you will learn how to automate the management of Office 365 using Windows PowerShell. We will discuss how to connect Windows PowerShell to Office 365, tour the Office 365 cmdlets, and demonstrate how to manage domains, users, and services including Exchange Online, and SharePoint Online.

Support Corner: Using PowerShell to Manage Office 365 Users
Join us in this fast-paced demo to learn how to manage Office 365 users using PowerShell. Experts show you how to create and delete users, update user IDs and passwords, assign licenses and groups, and much more.

Leave a comment and don’t forget to like the Absolute SharePoint Blog Page   on Facebook and to follow me on Twitter here  for the latest news and technical articles on SharePoint.  I am also a Pluralsight author, and you can view all the courses I created on my author page.
5/5 (3)

Please rate this