Ben Prins – Page 5 – Consulting and developing on Office 365

Teams: 20 Tips and tricks

December 7, 2020 Ben Prins Office 365

Most of use have been working from home for months and use Teams on a daily basis. Working remotely can be challenging especially if you just started working with Teams. The following 20 tips and tricks should help you get more out of Teams even if you are an experience user.

This blog post is an extension of the older Teams: Tips and tricks post.

Teams: Tips and tricks

The tips and tricks

Pin favorite chats

By default, the most recent chats are shown under chats. This means that all the chats with users and your meetings are mixed together. This can be a bit confusing since is changes all the time. You can pin frequent conversations to the top of your chat list, to create a clear and use full overview.

Open the chats in Teams.
Click on the … or right click on the chat you want to pin.
Click on Pin.

The pinned chats will be grouped above the recent chats.

Pop out chat

When working with Teams you might feel stuck with one screen, but this is not the case. When you hover over one of your chats, you’ll see the Pop out icon. Choose that option and the chat will be opened in a new pop out window.

Pop out list

When working in Teams you might feel stuck with one screen, but this is not the case. You can pop out a connected SharePoint list.

Select the pop out icon.

Use mentions in chat messages

To make sure a specific colleague in a group chat or channel reads your message, use the mention option.

In a chat window type @ and fill in or select the correct colleague.

Turn on do not disturb

Constant messages and alerts are a productivity killer when you’re trying to focus. You can turn off those messages by enabling the do not disturb mode.

Click in teams on your profile picture.
Click on the > next to the current availability.
Select Do not disturb.

Create rich-text messages

Some messages need rich formatting to be more effective. In a chat message click on the format icon for all the options.

Send urgent chat message

If you need an immediate reply on a message, tag the message as urgent.
The recipient will get notifications every two minutes for the next 20 minutes or until it’s read.

Save / bookmark a post for later

No time to read an important post? Save the message to make sure it does not get lost. Use the slash command /saved to access all the saved messages.

Click on the … of a message and select Save this message.

Mute a chat

Chat messages from meetings can be a bit noisy, mute them if you are not involved in the conversation. When you mute a chat, you’ll still be included in the conversation, but won’t get notifications from it.

Click on the … of the chat and select Mute.

Slash commands

Slash commands are command you use in the search bar and all start with you quested it a / (slash). These commands will help you be as efficiency as possible.

Type / in the search box to see all the available commands.

Shortcuts

Microsoft Teams has a lot of useful shortcuts. Use the slash command /keys to see all the options.

Expand tabs

Most tabs can be expanded to focus on the content and hide the navigation.

Click on the expand icon, the two arrows.

This image has an empty alt attribute; its file name is image-12.png

Send an email to a channel

If you want to send an email to a channel in Teams, you can use the channel email address. Once an email is part of a channel, anyone can reply to it to start a conversation.

Click on the … of the channel and select Get email address.
Click on copy in the popup window.

Change the order of the teams

The order of the teams can be changed, simply drag and drop the teams in the preferred order.

Hide teams or channels

If you don’t want a team or channel to show in your teams list, because you almost never use it you can hide it.

Click on the … of the channel or team and select Hide.

Pin a channel

Pin your favorite channels for fast and easy access. Pinned channels stay at the top of the list so you don’t have to hunt them down.

Click on the … of the channel and select Pin.

Record meetings

Recording meetings can be incredibly helpful. You can watch the discussions, find out what the decisions where, listen to the training again or watch a meeting you missed (recorded by someone else).

During a meeting click on the … followed by Start recording.

Mark messages as read

Chat messages from meetings or chat conversions you did not take part in or from a while back might not be that interesting. You can simply mark them all as read and ignore them.

Click on the … of the chat and select Mark as unread.

Mark messages as unread

In Teams you can mark a message as unread so you can come back to it later. Use the slash command /unread to see all the unread messages.

Click on the … of the channel and select Mark as unread.

Change channel notifications

Not all channels are equally important. Reduce the notification noise by customizing the notifications for specific channels.

Click on the … of a channel.
Click on the > next to the Channel notifications.
Select the preferred option.

Teams: Polls

November 10, 2020 Ben Prins Office 365

Want to start a survey or poll during a meeting or in a Team channel? With Microsoft Forms, you can create a survey or poll in seconds in Microsoft Teams. Its easy, simple and extremely fast.

This image has an empty alt attribute; its file name is The-Poll.png

How to create the poll

Go to a chat, channel or meeting chat where you want to add the poll.
On the bottom of the window there is a Forms icon, click on the icon.

If you don’t see the Forms icon press on the more option (the three dots).
- Click on More app and then on Forms.
- Click on open, this will add the Forms icon to the chat and open a screen to create a new poll.

Create the poll, by adding questions and answers.
Click on save and on send.
You have now created a poll that is automatically posted in the chat.

Office 365: Lists

October 13, 2020 Ben Prins Office 365

Lists in Office 365 is a powerful tool and it integrates perfectly in Teams or your personal OneDrive. You can use one of the list templates provide by Microsoft or create your own. The best way to use Lists is with Teams, then you can work together in real time with conversation and lists side by side. Track what matters most to your team using rules, reminders, and comments.

The bonus is that you can also create a Power App directly from the list. Now you can really use the list anywhere and anytime. The Power App can also be connected to the Team for easy access.

Lists in Teams

Add a Tab in Teams and select the List and click on save.

Create a new list.
You can use a template or create a blank list.
Click on the Work progress tracker template and click on Use template.

Fill in the name and description.

You have now create the List in Teams.

List with Power App in Teams

Its very easy to create a Power App based on a list. This Power App can also be added to Teams to be as productive as possible.

Navigate and open the Work progress tracker list.
Open the list in SharePoint, this is the SharePoint site that is connected to the Team.

Click on Power Apps and Create an app.
Note that you can also create a Power Automate Flow for the list.

Fill in the name of the Power App and click on Create.
The app will be created, this process takes a few moments.

If required, you can change the Power App.
In this example I don’t change the Power App.
Navigate to the Team and add a Tab.
Find the Power App and click on Save.

You can now use the Power App in Teams.

Lists in OneDrive

Open Lists and click on New.
Select a template or create a blank list.

3. Select the Work progress tracker and click on Use template.
4. Fill in the name and description.
5. The Save to location for your OneDrive is My lists.

Power Automate: Start a Flow from a column change

September 1, 2020 Ben Prins Office 365

With Microsoft Power Automate we can now create flows that start based on specific columns being updated in SharePoint! This is a feature I have been waiting on for years! The action is called Get changes for an item or a file. The action returns a boolean for each field, whether it was just changed or not. Based on this boolean you know if a field was changed.

Creating the flow

Create a SharePoint list, I created the following project list.

Enable versioning on the list.
Create a flow and use the trigger When an item or a file is modified.
Select your site and list.

Add the action Get changes for an item or a file (properties only).
Fill in the site address, library name and the ID of the item that was triggered.
The field Since is used to get the changes we need to make a comparison. If you use 1.0 you will compare the current item version with version 1.0. But we want the latest changes so we use the following expression.

sub(int(triggerOutputs()?['body/{VersionNumber}']),1)

I want to send an email when the end date of a project changes.
Add the action Conditions to check if the end date was changed.
Add the dynamic content Has Column Changed: End date.
This returns a boolean value.

Put the required actions in the If yes section after the condition.
In my example I am sending an email.
Add the action Send an email (V2) and fill in as follows.

Office 365: What’s new?

August 7, 2020 Ben Prins Office 365

The updates for Office 365 keep coming and coming, Microsoft is not sitting still! I am very excited for the following new features. Note that some of these features are already live, being rolled out or still being developed.

Teams: New meeting experience

With the latest Teams update you can turn on the new meeting experience. Meetings and calls will than open in separate windows. Giving you the option to drag a meeting to a different screen and keep working with Teams on your second screen.

The meeting controls are moved to the top of the meeting screen and are always showing, always out of the way of the shared content and video.

The Large gallery view lets you see up to 49 video streams at once. This only works with 10 or more attendees who are sharing video.

I also want to highlight an older feature that most people don’t know about. That is the ability to zoom in on the shared content. Unable to read what the presenter is showing? Zoom into the content by pressing the Control-key and spinning the mouse scroll wheel.

With Contextual Search in Microsoft Teams you can find information very faster. You can search for content in a specific channel or chat by pressing CTRL + F. Search results will only contain messages and files found in the selected chat or channel!

Yammer: New experience is available worldwide

The new experience for Yammer is available worldwide! In my other blog post you can read about the new features.

Search: New user experience

Microsoft gave a preview of the new search user experience. We will be able to create our own vertical (similar to scopes) and filters. The verticals are in preview, so you might be able to use them already.

Power Automate: Creating and updating a document set in SharePoint

July 10, 2020 Ben Prins Power Platform

Many colleagues have asked me how to create or update document sets with Power Automate. I had never done this before so I told them to use a web service. From now on, I can point them to this blog post. The flow is created with the help of my colleague Jasper Voskuilen, because this web service is a bit more complicated to setup.

Creating the flow

Open Power Automate and create a new flow (automation).
I created a flow with the trigger, for a selected item.
In my situation I get all items from a list and then create a document set for each result.
Create the following variables with the related values.
This will make the flow more dynamic for later changes.

SiteURL as a string, fill in the Site URL.
ContentType as a string, fill in the content type id.
URLLibrary as a string, fill in the library name part of the ULR.
For this example it is: Library

https://domein.sharepoint.com/sites/ExampleSite/Library/Forms/allitems.aspx

TitleLibrary as a string, fill in the title (name) of the library.
WebServiceURLBibliotheek as a string, fill in the Library URL used by the web service.
You can find the web service url by using the following URL

https://domein.sharepoint.com/sites/ExampleSite/_vti_bin/listdata.svc/

Add the action Send an HTTP request to SharePoint
Use the varibles to configure the web service.
The name of the document set needs to be unique. I used a value from my list item, your situation might be different.

If required you can update the newly created document set.
Add the action Parse JSON and parse the Body of the Create Document set HTTP request.

Add the action Send an HTTP request to SharePoint
Use the variables to configure the web service.
The properties you need to set might be different than mine. I used values from my list item but your situation might be different.