Column Formatter for SharePoint Online

Applies To: Office 365 Modern listviews support the addition of custom formatting for most field types. This is an awesome feature designed to make custom formatting simpler and less administratively difficult than packaged solutions. Unfortunately, the tooling is still very minimal. Users are given a simple text field within a panel to paste the JSON code and a preview […]

via Column Formatting Client-Side Web Part: Column Formatter — The Chris Kent


Share with Anyone | Office 365 Groups

Sharing anonymously with Office 365 groups is disabled by default. And no matter what tenant settings you apply in the SharePoint Admin Center or in the Settings module in the Office 365 Admin Center, you will not be able to share with ‘Anyone’. This is by design and though you may not like it, it’s purpose is to ensure that external guests or even group members can’t just create anonymous sharing links to your data.

The difference between sharing with Anyone and sharing with a Specific Person is that sharing with Anyone or Anonymously does not require authentication. It’s open and public access that anyone with the sharing link can access. You can read more about the specifics on sharing with SharePoint here.

However, for those of you who still want this ability, below are some steps to enable this feature using PowerShell. Follow the steps below to enable sharing with Anyone in your Office 365 group.

  1. Download and install the SharePoint Online Management Shell tool. This will allow you to connect to SharePoint online through PowerShell.
  2. Open and run the SharePoint Online Management Shell and type the following:
    • $userCredential - Get-Credential
      • Please note that you will be prompted for your Office 365 admin credentials, and if you have Multi Factor Authentication enabled, click here for those instructions.
  3. Now that you are connected and authenticated, you will need to run the command below.
    • Connect-SPOService -Url -Credential $userCredential
      • Please note that you must replace the above url with your tenant ID which is embedded in your SharePoint (365 Group) address. It will look like this:
  4. Now that you are connected to your SharePoint Online tenant, you can now change the property to enable Anonymous sharing with Anyone in your 365 Group. Run the following command against the group site.
      • set-sposite -identity -sharingcapability ExternalUserAndGuestSharing


  5. Congratulations! That’s it. Refresh your browser and the Anyone sharing should be available now.

You can read more about how to work with SharePoint Online via PowerShell using the links below.

Let me know if this has helped your tenant.

Resume Assistant in Word

Microsoft is leveraging their social media platform LinkedIn by integrating it with Office365. The latest integration involves using Word to create or update your resume and pulling in intelligence from LinkedIn to modify your resume and even apply directly through LinkedIn.

See the video linked below for more info:

You can read more about this feature here: Bringing AI to job seekers with Resume Assistant in Word, powered by LinkedIn

Will you be taking advantage of this new feature? Comment below.

New Office 365 OME not working?

The new Microsoft Office Message Encryption for Office 365 and Exchange Online is a fantastic upgrade that allows external recipients to open encrypted messages using either their Microsoft, Yahoo or Google accounts. You can still use a one time code as well which is very convenient.

However, those of you who have enabled (via PowerShell) the new Office Message Encryption may have encountered an issue where recipients are getting a ‘You don’t have rights to view this message’ error. This is simply because the old Transport Rule you were using still uses the old message encryption method and now needs to use the Rights Management Service.

To fix this simple do the following:

To update an existing mail flow rule to use the new OME capabilities by using the Exchange Admin Center.

  1. In a web browser, using a work or school account that has been granted global administrator permissions, sign in to Office 365.
  2. Choose the Admin tile.
  3. In the Office 365 admin center, choose Admin centers > Exchange.
  4. In the EAC, go to mail flow > rules.
  5. In the list of mail flow rules, select the rule you want to modify to use the new OME capabilities and then choose Edit icon (Edit).
  6. To enable encryption using the new OME capabilities, from Do the following, choose Modify the message security and then choose Apply rights protection. Select an RMS template (YOU MUST CHOOSE DO NOT FORWARD) from the list, choose Save and then choose OK.

    The list of templates includes all default templates and options as well as any custom templates you’ve created for use by Office 365. If the list is empty, ensure that you have set up Office 365 Message Encryption with the new capabilities as described in Set up new Office 365 Message Encryption capabilities built on top of Azure Information Protection. For information about the default templates, see Configuring and managing templates for Azure Information Protection. For information about the Do Not Forward option, see Do Not Forward option for emails.

    You can choose add action if you want to specify another action.

  7. From the Do the following list, remove any actions that are assigned to Modify the message security > Apply Office 365 Message Encryption.
  8. Choose Save.

It is CRITICAL that you select the DO NOT FORWARD template and not any of the other templates as they are designed for internal use only.

More information can be found at the links below:

Please comment below if you are using the new OME in your environment.

New Office 365 app launcher and help you be more productive on the web

Introducing a redesigned, Office 365 app launcher, and new Office 365 gallery to bring you more personalized experiences on the web.

Read more: New Office 365 app launcher and help you be more productive on the web


Microsoft Teams is officially replacing Skype for Business

Microsoft Teams will be officially replacing Skype for Business. Microsoft is bolstering Microsoft Teams to better challenge Slack in the battle of the collaborative, chatty workplace apps.

This looks like it’s going to be a good thing.


Microsoft and Adobe announce expanded partnership – Office Blogs

Microsoft and Adobe announced new joint offerings to increase workforce productivity and drive more efficient business processes.

“Together, we will develop integrated cloud services with best-in-class solutions like Adobe Sign and Office 365 that help businesses digitally transform while delivering great experiences to their customers.”

The big points here are:

  • Integration between Microsoft Office 365 and Adobe Sign will deliver fast, secure electronic signing across Office 365, including Microsoft Word, Microsoft PowerPoint and Microsoft Outlook, so that signing documents electronically, on any device, can become an everyday experience.
  • Adobe Creative Cloud and Adobe Stock integration with Microsoft Teams will give Adobe’s creative customers access to a world-class collaboration workspace that speeds up creative feedback, iteration and decision-making. Microsoft Teams integration will expand to Adobe Experience Cloud in the future.
  • Adobe Sign integration with Microsoft Teams will accelerate electronic agreement creation, approval and signature processes across teams. The Adobe Sign app in Microsoft Teams includes a tab to send documents for signature and a bot that allows team members to manage and track documents.
  • Adobe Sign integration with Microsoft Flow will allow users to build end-to-end digital workflows by adding Adobe Sign to any Microsoft Flow process. In the coming months, organizations will benefit from Flow integration with other Microsoft applications such as SharePoint, Dynamics and OneDrive.

Source: Microsoft and Adobe announce expanded partnership – Office Blogs

Moving SharePoint Library Files FAST

So, this little hack is not endorsed by Microsoft but for those of you who want to make the move from an on-premise file server to SharePoint Online or from a SharePoint Online Team Site Document Library to an Office 365 Group Library and have thousands of files and gigabytes of data, this little tip is for you!

Well, what’s the tip?

Use SPFileZilla! Wait what? Is that it? Yup, that’s it. I have worked with this software for several years now and it has never failed me. Now there are some reported issues with very complex environments who use Active Directory Federation Services and you can’t migrate all the complicated permissions you had setup on your local file share.

But for pure data migration from one place to another, this utility will save you hours of complex PowerShell scripting or Azure Blog creation, etc….

Click this link to download SPFileZilla.

You’re welcome! Let me know your thoughts in the comments below.

The Future of SharePoint Online

(cross-posted to the BlueMetal Blog) This week Microsoft mapped out a bold new plan for SharePoint. Microsoft is investing heavily to modernize the product to make it work as well in the Device and Cloud era as it once did in when the Web was still shiny and new. This article will explain how these […]

via Roadmap to the Future of SharePoint — Bob German’s Vantage Point

Tenant Availability in Office 365

Just a quick note on how to check if a tenant domain is available in Office 365. This is not a Microsoft product or service. Visit


See if a subdomain is available with Office 365.


Modern Authentication for Office 365

By default Modern Authentication or Multifactor Authentication is disabled for new users of Office 365. It’s very easy to enable the service on a user by user basis which allows them to begin using a secondary method of authentication whenever they want to use Office 365.

What is Modern Authentication?

Modern Authentication is really another way to say, Multi-Factor Authentication or Two-Way Authentication. It means that in order to login to a service or account, you will need to enter two different passcodes. The first is your own password that you create, and the second passcode is a randomly generated code or pin that is sent to you through a text message or authenticator application. This method of authentication is very, very secure and should be used as much as possible. You can read more about multi-factor authentication using this link:

Enable Modern Authentication in Office 365

To enable Modern Authentication in Office 365 is a simple process for a Global Administrator to do. Follow the steps below.

  1. Login to
  2. Select the Admin Center app.
  3. Select Users > Active Users.MFA1
  4. In the Office 365 admin center, click More > Setup azure multi-factor auth.
  5. Select the users you want to enable Modern Authentication on.MFA2
  6. On the right user info pane, under quick steps you’ll see Enable and Manage user settings. Choose Enable.
  7. In the dialog box that opens, click enable multi-factor auth.

Exchange and Skype Online

Now that MFA has been enabled for these users, they can use Office 365 with modern authentication enabled but Outlook and Skype for Business but will need an App Password.

Wait a minute, didn’t you say they can use Modern Authentication with Office 365 applications and services? Yes, I did. But first we have to enable Modern Authentication on those Exchange Online and Skype for Business. Follow these steps.

  1. Open PowerShell as an Administrator.
  2. Run this set of commands to connect to Exchange Online:
    • Set-ExecutionPolicy RemoteSigned (say Yes)
    • $UserCredential = Get-Credential (use your admin credentials)
    • $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential $UserCredential -Authentication Basic -AllowRedirection
    • Import-PSSession $Session
  3. Now run this command to enable Modern Authentication for Exchange Online.
    • Set-OrganizationConfig -OAuth2ClientProfileEnabled $true
  4. Now verify the change was successful by running this command:
    • Get-OrganizationConfig | Format-Table -Auto Name,OAuth*
  5. Now we need to enable Skype for Business Modern Authentication and in order to do so we need to install a few items.
  6. Download and install the Skype for Business Online, Windows PowerShell Module using this link.
  7. After it is installed, continue in PowerShell and run the following commands.
    • $credential = Get-Credential (use your admin credentials)
    • $session = New-CsOnlineSession -Credential $credential -Verbose
    • Import-PSSession $session
  8. Now run this command to enable Modern Authentication for Skype for Business.
    • Set-CsOAuthConfiguration -ClientAdalAuthOverride Allowed
  9. Now verify the change was successful by running this command:
    • Get-CsOAuthConfiguration

Congratulations! Now your organization can use Modern Authentication on all applications, including Outlook and Skype for Business. There is no need for an app password.

Let me know how this is working for your organization in the comments section.

Setup Email Encryption in Office 365

So this is really going to be easy. You will enjoy paying just $2 a month for your entire company to have hosted email encryption. NOTE: Commands are italicized.

Here is a summary of what we are going to do. (assuming you use Office 365 already)

  1. Purchase Azure Information Protection and assign the license to any user.
  2. Connect to Exchange Online via PowerShell.
  3. Run a few commands in PowerShell.
  4. Create a Rule inside of Office 365 to encrypt messages.

Step 1 | Purchase Azure Information Protection

To purchase a new subscription in Office 365, login to, go to the App Chooser in the top left hand corner and select Admin.


Next, go to the Billing section and select Purchase services. There you can find and subscribe to the Azure Information Protection Plan 1 for $2.00 per user per month. NOTE: You only need 1 subscription for message encryption.

AIPO365Step 2 | Connect to Exchange Online via PowerShell

If you have Windows 10, then you already have the necessary software. Simply go to your Start menu > Type PowerShell > Right click on it and Run As Administrator.

In PowerShell run the following commands:

  • Set-ExecutionPolicy RemoteSigned
    • Respond with “A” for all or “Y” for yes.
  • $UserCredential = Get-Credential
    • Login with your Office 365 admin credentials.
  • $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential $UserCredential -Authentication Basic -AllowRedirection
  • Import-PSSession $Session

Now we are connected to Exchange Online. Don’t close PowerShell just yet.

Step 3 | Run Some PowerShell Commands

Now that we are connected to Exchange Online with a PowerShell session. Let’s enable the Azure Rights Management service to allow for us to send encrypted emails.

In PowerShell run the following commands:

  • Set-IRMConfiguration -RMSOnlineKeySharingLocation “”
    • Please note this command is for US only.
  • Import-RMSTrustedPublishingDomain -RMSOnline -name “RMS Online”
    • This imports the Trusted Publishing Domain from RMS Online.
  • Test-IRMConfiguration -RMSOnline
    • This just tests that you have successfully configured IRM in Exchange Online to use the Azure Rights Management service.
  • Set-IRMConfiguration – ClientAccessServerEnabled $false
    • This disables IRM templates in OWA and Outlook.
  • Set-IRMConfiguration -InternalLicensingEnabled $true
    • This enables IRM for Office 365 Message Encryption.
  • Test-IRMConfiguration -Sender
    • This verifies that you successfully imported the TPD and enabled IRM.

We have successfully enabled Information Rights Management in your Office 365 tenant. Now all that is left to do is create a Transport Rule that tells the server to encrypt the message.

Step 4 | Create a Rule to Encrypt Email

So now we are done with PowerShell, you can close it or run Remove-PSSession $Session and then close it. Now we just need to create a Transport Rule in Exchange Online to tell the server when a message meets a set of criteria, encrypt it before sending.

Now technically, encrypted emails never leave the mail server. They simply send a message to the recipient saying, “You’ve received an encrypted message from…” So, the recipient can either use a Microsoft Account or a one-time passcode to view the message. See image below for an example of what the recipient sees.


So to setup this rule, go back to and login and go to the Admin Center. Down in the bottom left you will see Admin Centers > Exchange.


Then in the Exchange Admin Center, select Mail Flow > Rules. Here you will create a new Rule and Apply this rule if…

  • The subject or body includes…
    • I would use a word in brackets like [ENCRYPT].
  • and… The recipient is located…
    • Outside the Organization (within the org the messages are encrypted)
  • Then, do the following…
    • Modify the message security and Encrypt the message with Office 365 Message Encryption.



Make sure to enable Enforce this rule. Lastly, you will need to test this out but after a few hours. Technically all these changes take an hour or two to apply.

So that’s it! Whenever someone within your organization sends an email to someone outside the organization, with the subject that includes [ENCRYPT], the message with be encrypted. Take it for a spin and let me know what you think.

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close