SharePoint Online is not enough!


You can’t just know SharePoint and think this is it! It just doesn’t work, you need to ramp up on Teams as they work together just perfect so add Teams to your skills, its necessary.

Add Power Platform too, you will need to create apps & automate a cycle and have a dashboard and who does not have a Bot nowadays! 

Remember SharePoint Online is not enough! 

Filter GetItems in Power Automate by People Picker Field


So very simple character that does the trick of it… if you are trying to filter Items from a SharePoint List using Get Items Action in Power Automate and your field is of type People Picker, so here is how to do so…

Write the Field Name and then back slash EMail as per screen shot below and voila works.

I have seen other posts trying to add filter array but actually you don’t need to complicate things.

Happy SharePointing and Automating 🙂

Turn on ATP for SharePoint, OneDrive & Teams


In the previous post, we saw how it looks like and what happens when a malicious files are detected in a SharePoint Library and OneDrive.

In this post, we will walk through turning ATP on for SharePoint, OneDrive and Teams.

1- Go to Security Admin Center, under Thread Management, click on Policy,

2- Start by clicking Create to create a new policy.

3- Follow the steps for the policy, in the settings, choose to block all,

4- Once the policy created, select it and select Global settings;

5- By default, the policy will have ATP turned on for SharePoint, OneDrive and Teams.

ATP – Malicious file detected in a library – SharePoint, OneDrive & Teams


People regularly share files and collaborate using SharePoint, OneDrive, and Microsoft Teams. With Office 365 Advanced Threat Protection (ATP), your organization can collaborate in a safer manner. ATP helps detect and block files that are identified as malicious in team sites and document libraries.

How Office 365 ATP operates

When a file in SharePoint Online, OneDrive for Business, and Microsoft Teams has been identified as malicious, ATP directly integrates with the file stores to lock that file. The following image shows an example of a malicious file detected in a library.

Files in OneDrive for Business with one detected as malicious

Although the blocked file is still listed in the document library and web, mobile, or desktop applications, the blocked file cannot be opened, copied, moved, or shared. People can, however, delete a blocked file. Here’s an example of what that looks like on a user’s mobile device:

Deleting a blocked file from OneDrive for Business from the OneDrive mobile app

Depending on how Microsoft 365 is configured, people might or might not have the ability to download a blocked file. Here’s what downloading a blocked file looks like on a user’s mobile device:

Downloading a blocked file in OneDrive for Business

I’ll be speaking in Microsoft 365 Virtual Marathon


I’m happy to announce I will be speaking in the virtual conference in Microsoft 365 Virtual Marathon on the 27 of May..

I’m more delighted to announce I will be speaking with Amr Ibrahim a Principal TAM in Microsoft.

All the sessions can be found here: http://www.m365virtualmarathon.com/sessions.html

Ctrl+Alt+Shift+1 Microsoft Teams


If you are losing your connection during screen sharing.

Or Microsoft Teams Client crashes and restarts automatically.

You will need to view the Microsoft Teams debug logs to troubleshoot the issues. Or if you are the End User, this is how to get the logs to send to your Support Engineers to troubleshoot..

Open Microsoft Teams, and on your keyboard, select Ctrl+Alt+Shift+1

You will see these files in your downloads folder;

In another post, I will walk you through each log file and how to read it .. Stay tuned.

Post to the Channel in Microsoft Teams by E-Mail


The reason I would see to send email to the Channel in Microsoft Teams, would be if its a long formatted email that you want to forward to all members in the channel to be aware of..

To do that, let’s get Channel’s email.. select the channel, you want to send email to, from the dots, a menu will appear, select, Get email address; as below..

And below how it should look like when posted to the channel by email;

Announce when callers join or leave could be noisy if thousands are attending


In a Live Event, with thousands of attendees, joining and leaving … if we keep this option “On” .. “Announce when callers join or leave”, it will be difficult to hear the presenter.

Here is how to disable it without going to Microsoft Teams Admin Center; in the meeting click, Meeting options; and besides “Announce when callers join or leave”; mark it as “No”.

Who really attended and who left in the middle … Microsoft Teams Live Event


The previous post, I showed you how to get an excel file with the list of attendees.. here I want to talk to you about the values of this excel file..

Basically, I was testing with my husband 🙂

The column header called “Action” has the status whether;

  • Joined,
  • Left
  • Reconnected
  • …..

Where you can filter this excel file and have an understanding of how people are participating all the time in the event.