Tag: Office 365

Did you know … you can send a “receipt” for Microsoft Forms submissions?

I had a maths professor who mused that, back when he was an undergrad, calculators were a newfangled thing that kids only halfway trusted. You’d complete your test; and, time permitting, you would power on that calculator and see if it agreed. Decades later, kids didn’t even do a mental check that the calculator’s results were halfway reasonable. As a technology becomes more familiar, innate trust is built. In the interim … trust but verify. Beyond trust, it’s nice to have a copy of what you’ve submitted when discussing your submissions with someone else. Or, for a periodic survey, to remind you what you said last time. Or because you are particularly proud of a particular turn of phrase and would like to use that one again. For whatever reason you want to create a “receipt” for Forms submissions, you can do it.

The first thing you need is a Form created under your user ID. Go to https://forms.office.com/ and click “New Form”

Give your form a name and add some questions

From the hamburger menu in the upper right-hand corner, select “Settings”

Verify that the form is restricted to “people in my organization” and “Record name” is selected.

** If the form needs to be available to individuals outside of the organization, you would need a form field to request their e-mail address … otherwise we don’t know where to send the receipt.

OK, we’ve got a form. Now we need to add a workflow to send the submitter a copy of their responses. Go to https://flow.microsoft.com and select the “My Flows” tile

Click on “New” and “Create from blank” to begin creating the workflow.

Click “Create from blank” again to confirm you really don’t want one of their templates

In the search field, type “Microsoft forms” and select the trigger “When a new response is submitted”

Select the form for which you want to generate a receipt – in my case, the form I just created.

Select “New Step”

Type “Microsoft forms” in the search dialogue again, and select “Get response details”.

Click the inverted caret for “Form Id” and select your form again.

Click in the “Response Id” field – a new pane will appear to the right of your workflow. Click the “See more” button across from “When a new response is submitted”

Select “List of response notification Response Id”

You’ll see the selection populated in the “Response Id” section. Click “Add an action”

In the search dialog, type “send an email”. To send the receipt from your mailbox, select “Send an email” – to send the receipt from a generic mailbox to which you have send-as access select “Send an email from a shared mailbox”.

Click in the “To” field – the dynamic content pane will appear on the right again. Click “See more” across from “Get response details”. If this form is locked down to submitters within the organization and the submitter’s name is recorded, you can select “Responders’ email”, otherwise select the form question where you’re quested the submitter’s e-mail address (warning – since there’s nothing verifying the individual actually owns the e-mail address, forms that take freeform e-mail address submissions can be used to “spam” others).

You’ll see “Responders’ E…” populated into the “To” field. Type in a reasonably descriptive subject for your message.

I start by creating my message template – pretty messages will require HTML, so click to “Show advanced options” and set “Is HTML” to yes.

Now’s the part where we include the individual’s response data – click back into the “Body” field and you’ll see the dynamic content pane again. Within the message body, click where you want the response to appear (here, it’s after my first “<LI>” tag. Then select the question whose response you want to insert into that position.

It’s generally helpful to type something before the answer to remind the person what the question was – it’s freeform text, and pretty much anything you can do in HTML is acceptable here.

Once you have finished creating your message template, scroll down to the bottom and click “Save”

You may get a warning that a “for each” container has been added for you … that’s good, we want to generate a receipt for each submission!

Now that your workflow has been saved, click “Test”

Select “I’ll perform the trigger action” and then click “Save & Test”

Return to your form and click “Preview”. Complete your form and click submit.

Return to Flow. If you are quick enough, you’ll see a message that your flow is running. Wait. Eventually you’ll see the results. You can click on the “Send an email” section to see detailed results.

Including the e-mail address to which the receipt was sent and the status code (200 is good).

Check your mailbox too – you should have a message:

 

Did you know … Excel can convert between units of measure?

Spend enough time reading temperature probe data, and you get to where you just know 23 is room temperature, and 82 is going to cook the CPU. And sure you can type “23 C in F” into Google and get the Fahrenheit equivalent, but that’s hardly efficient with a long list of values. You could look up the formula and have Excel perform the computation, too. But did you know Excel can convert between many units of measure without you finding the conversion formula?

Excel’s CONVERT() function allows you to display values in whatever unit is most familiar to you. Usage is convert(CellToConvert,OriginalUnits,DesiredUnits)

Voila – the values in your chosen unit.

If you use the units of measure in column headers, you can use the header cells as the current and desired unit of measure values — remember to use the $ anchors, otherwise copying your formula will not yield the right answer!

Did you know … Connectors can be used to display external information in Microsoft Teams Channels?

Microsoft Teams is a single workspace that provides access to a vast array of resources. You’ve got links to important web sites, posts from other Team members, discussion surrounding shared documents … but did you know posts can automatically be created from external systems?

Why? Well … doing so allows Teams to simplify finding and distributing information. Instead of having ten people subscribed to a vendor newsletter or five people trying to remember to check a web site for information, the information comes to every Team member directly in their Teams application.

You can turn vendor-provided patch and outage notifications via RSS or Twitter into Teams posts. Google Analytics data for your site can appear in Teams posts. Jenkins has an Office365 connector that reports pipeline information in Teams posts. Browse the available connectors to see what is useful in your group.

“Best practice” recommendation: some of these connectors rely solely on Microsoft’s Internet connection to an Internet-accessible resource – as in the example I present below. These connectors are essentially self-documenting because you can view the Connector configuration to determine the URL with which the connector communicates. Many connectors, however, use web hooks registered within your application or user credentials to access the remote system. In the “Files” or “Wiki” section of the channel in which the Connector is used, create a document detailing any configuration that was done – instructions for creating a web hook in your system, which account was used to access the remote system (don’t write the password in the document!).

For connectors that require user credentials, do not use a personal account. Create a new account for your Teams feed. Twitter, for example, requires a user account to follow other accounts or hashtags. Were I to use my Twitter account in the configuration … if I transfer ownership of the Team space to someone else, they’re inheriting a configuration with my account; but I’m not going just hand my password over to them. Even if ownership of the Team space never changes, we could cease seeing updates next time I change my Twitter password. Or decide to close my account. Or … point being, if you have a non-user account, the Team owners can maintain control of the account and any changes to it.

Using Connectors: Decide where you want the data posted – this can be a dedicated channel created just for this connector or it can be an existing one. Click the hamburger menu next to the channel into which you want messages posted. Select “Connectors”.

Browse through the list. Or type in the “Search” box to locate a specific connector. Click “Add” next to the connector you want to use.

Setup will vary depending on the connector selected – the Jenkins connector provides a URL to paste into your server config, Twitter asks for credentials and individuals or hashtags you want to follow in the channel. In this example, I am adding an RSS data feed.

Type ‘rss’ in the search dialog. If this is the first time you’ve used the connector within this Team space, click “Add”.

In this case, there’s not much on the next screen – read the privacy and terms of use statements.  Assuming the connector permits your intended use and you agree to all of their terms, click “Install”.

Enter a name for the connector, paste in the RSS feed URL, and select how often you want Teams to check for new data in the feed. Click “Save”

A post will be created in your channel with data from the RSS feed. Some feeds will provide information, some just provide a link. And when new data is posted to the RSS feed, a new post will be created in your Teams space.

If you need to make a change to an existing connector, click the hamburger menu next to the channel on which the connector is configured. Select “Connectors”.

In the left-hand column, select “Configured”

The “Configure” button will set up another connector on the channel. Instead, click the “# Configured” link below the “Configure” button. Then click “Manage” for the connector you want to manage.

Make whatever changes you need to make and click save. Or click “Remove” to remove the connector from the channel.

Did you know … you can automatically dismiss past Outlook calendar reminders?

Sometimes opening Outlook and getting reminders for, say, the meetings you missed when you were out sick yesterday is quite helpful. But frequently, reminders for old events are just an annoyance. Like when you create past-dated meetings to remind yourself of what you were doing and forgot to select ‘None’ as the reminder time. That’s not just me, right? Did you know you can automatically dismiss reminders for past calendar events? From your Outlook client, click the file tab of the Outlook ribbon bar

Select “Options”

On the new window that appear, select “Advanced”

In the “Reminders” section, you’ll see a check-box to “Automatically dismiss reminders for past calendar events” – by default, this is unchecked. If you would like to avoid reminders for old meetings, click to check it then click OK.

 

Did you know … you can set image transparency in Word, PowerPoint, Excel, and Outlook?

When you wanted to use an image as the background for a document, you often needed an image editor to lighten the picture – the image was too dark for dark text to be legible but too light for white text. Or you’d compose your PowerPoint slide with the image in one frame and the text in another.

Did you know, in the latest Office 365 Update, Microsoft added a feature that allows you to create faded background images within Word, PowerPoint, Excel, and Outlook? Within one of these programs, insert a picture into your work. Select the image. From the Picture Tools Format ribbon, click on Transparency

You can select one of the pre-set transparency levels or click on “Picture Transparency Options …” for finer control of the transparency level.

Move the slider (or type a number) to adjust the transparency level – 100% is invisible, 0% is the original image.

Voila – you’ve got a background image and legible text.

There are a lot of other image effects available – the vignette is the “soft edge oval” from the “Picture Styles” section of the ribbon bar. Many of the effects I’ve traditionally used Photoshop or Gimp to apply are also available in the “Adjust” section, so click around and check it out!

Did you know … you can draw attention to Teams posts?

Before I tell you how – don’t be the person who flags every single message as urgent. Not because it’s annoying (although it is), but because it’s hard to single something out for attention if YOU ALREADY MARK EVERYTHING URGENT AND USE HUGE, BOLD, RED LETTERS AND END WITH !!!!!!!!!! If everything is urgent, you don’t have a classification for super urgent things.

OK, now that I’ve done my quasi-civic duty and at least tried to avoid having big red icons next to 97% of the messages I see …

You can use @ mentions to draw individuals’ or groups’ attention to a specific post. In the message, type @ and then begin typing either an individual’s name or the Team’s name. The @ mention can be included anywhere in the message – it doesn’t have to come first.

Team members using the desktop or mobile client will get a banner message alerting them that they have been mentioned in a post.

All clients will have a little logo along the right-hand side of the message indicating either a group

Or individual mention.

If you want to draw attention to an item without banner messages, you can also mark a post as important. When you are typing your message, click on the “Format” button when typing the message.

Then click the exclamation point. (For anyone who prefers keyboard shortcuts – use ctrl-shift-i)

And you’ll see both the red bar along the left and the IMPORTANT! designation atop the message.

Team members will see an exclamation point marking channels with important messages too.

If you accidently mark a message as important (keyboard users who type ctrl-i for italics can get both ctrl and shift occasionally), click the hamburger menu next to your post and select Edit.

Click the exclamation point again to remove the important designation.

Voila, the message no longer has an over-inflated sense of self-worth. Or my typo.

Do you know … Teams Activity View?


The very first icon on the left-hand navigation menu, “Activity”, isn’t just a listing of all unread Teams activity. This view provides a customized view of important Teams communications, allowing you to focus on the most important communication first. 

This isn’t a list of every thing that has been posted to every one of your Teams spaces. It doesn’t even include chat messages sent to you –new chat messages will show up as a red circle with a message count on the“Chat” view icon.

So what shows up in the Activity feed? Missed calls – missed calls are only displayed in your Activity feed. Clicking on the entry will display a chat with the caller; you can reply with a chat message or click the phone icon to return their call.

Posts with @mentions – both your individual mentions and mentions for Teams of which you are a member – will appear in the Activity feed.

Beyond that, you control what appears in your feed. Posts to channels you follow will appear in your feed. To follow a channel, click the“Teams” icon. Click the not-quite-a hamburger menu next to the channel name and select “Follow channel”.

When messages are posted to the channel, you’ll see a red circle with the number 1. This indicates that there is one thread with unread post(s). There may be a bunch of replies in that thread, but the thread is only counted once. This doesn’t mean replies won’t be highlighted – if someone replies to a thread you’ve already read, that thread will again be counted as a thread with unread post(s).

You can click on an entry to display the specific thread. Clicking on a reply will focus on the reply – which helps identify what part of the thread you haven’t seen.

If a channel becomes prolific and irrelevant to you, you can simply stop following the channel. Click the not-quite-a hamburger menu next to the channel name and select “Unfollow this channel”. Anything from the channel in your feed will remain there, but new activity in the channel will cease appearing in your Activity feed.

In addition to a feed of activity from other individuals, you can use the activity feed like the “Sent Items” in your mailbox. Click the inverted caret next to “Feed” and select “My Activity”. You’ll see two weeks of your Teams posts.

Did you know … you can prevent meetings from being forwarded?

Have you ever had an attendee forward a meeting that was supposed to be confidential? Microsoft Exchange will notify you when a meeting attendee has forwarded your meeting; unless you are really close on that time machine project, what’s done is done. Unless … did you know that you can prevent the meeting from being forwarded? 

* The forwarding restriction is enforced on the mail client, so attendees outside the company may still be able to forward the meeting request. Additionally, there are ways to circumvent this forwarding restriction – e.g. meeting content can still be copied and pasted into a new appointment item. While restricting forwarding is a way to convey the confidentiality of the meeting and deter casual forwarding, this doesn’t guarantee eyes-only security.

How do I do it?

Right now, you can only restrict meeting forwarding when using the Outlook client on Windows or the Web – Mac, iOS, and Android client users will need to use the Web client.  

Outlook for Windows

This feature has not been deployed to all of the Office 365 channels as of this writing. The screen-shots below were created using an Office 365 installation with the monthly update channel. The semi-annual channel is slated to be updated in March 2019, so use Outlook Web until then!

Create a new meeting:

On the ribbon bar, select “Meeting”. You can restrict forwarding under the “Response Options” button.

Outlook Web

Create a new meeting:

Once you have added an attendee, a gear icon will be displayed above the attendee list.

Click the gear icon – by default, meetings can be forwarded. You can click “Allow forwarding” to prevent the meeting from being forwarded to others.

What does the recipient see?

Exchange Online recipients using Outlook Web will see a banner indicating that forwarding is disabled. The forward option will be grayed out.

Exchange online recipients using Outlook with the Monthly update channel will see the banner as well. Those will the semi-annual update channel will not see any indication that they cannot forward the invitation … in fact, their client will seemingly let them forward the meeting. But Exchange Online will refuse the message and they will get a non-delivery report indicating that the meeting could not be forwarded.

Recipients outside of Exchange online not notice any change — Gmail, for example, happily allows me to forward the meeting request.

Did you know? … Sub-Addressing

There are all sorts of reasons you need to provide your e-mail address to random Internet strangers – purchasing products, registering for a conference, signing up for a newsletter. Unfortunately, disseminating your address across the internet can lead to an inundation of unwanted email.

In addition to spam filters to filter out unwanted mail, Exchange Online supports “sub-addressing”. A sub-address is a slightly modified version your e-mail address that can customize your address for every situation – just before the ‘@’ symbol in your e-mail address, put a plus and then some unique text. It will look like Your.N.Ame+SomeIdentifier@company.ccTLD instead of Your.N.Ame@company.ccTLD.

When signing up for a Microsoft newsletter, I can tell them my e-mail address is Lisa.Rushworth+MicrosoftSecuritySlate@company.ccTLD and messages sent to that address will be delivered to my mailbox. When I sign up for the NANPA code administration newsletter, I can tell them my e-mail address is Lisa.Rushworth+NANPACodeAdmin@company.ccTLD.

Should you start receiving unwanted solicitations to the sub-address, you can then create a rule to delete messages sent to that address. You can even exclude messages from the intended sender from the deletion rule – allowing, for example, messages from the NANPA Code Admin newsletter to reach your mailbox whilst blocking anyone else from using the address.

You can also alert the person to whom you provided the address that their contact list may have been compromised.

Microsoft Teams – Creating A New Team

Anyone can create a Team space – this makes Teams an amazing resource for collaboration because you have all of the features of Teams without filling out a request form, writing a business justification, and waiting for someone to complete your request. Whether you want to call it a quote from the Spiderman comics, Churchill, or the Decrees of the French National Convention … responsibility follows inseparably from great power.

The first consideration is should you create a Team? Teams is an amazing platform for interactive communication, but not all communication is meant to be interactive and collaborative. If you want to broadcast information to thousands of people (and maybe get a little feedback too), then a Stream site may be a better choice. If you want to solicit feedback about a specific topic and analyze the results, a Forms questionnaire or SharePoint form will likely better suit your needs. If you want to share documents, OneDrive for Business or a SharePoint site may be more appropriate. But if much of your content warrants responses, you want to increase collaboration, you share documents and Planner boards and OneNote notebooks … then you probably want a Teams space.

Can my Team have too many members? Well, from a technical perspective … no. There’s a limit to the number of members you can add to a team – the service won’t let you add too many people. Practically, though, the question isn’t if there are too many members but rather if the information stored in the Teams space is relevant to the individuals. Maybe you’ve got a topic that fifteen hundred people should be discussing – the information helps them do their job, their input helps others. In that case, a team of fifteen hundred people isn’t too many. But if I add thirty people to my Team space and the information is only relevant to eight of them … then I’ve got too many members of my team.

Once you’ve decided that a Teams is a great place to host your collaborative efforts and identified the people who will find the information relevant, here are some “best practice” guidelines for creating and managing your Team.

Click on “Join or create a team” at the bottom of your Teams list.

The Teams carousel will be displayed – search your organization’s public teams to make sure there’s not already one out there doing exactly what you want. At the time of writing, this is a starts with search so searching for “Falcon” will not find “Project Golden Falcon”. To create a new team, click “Create team”.

When creating a Team, the first step is to create a name. Team names do not have to be unique, but it will be confusing for members if they have six “Engineering” teams in their list. Use something descriptive. Filling in the Team description will help members identify the purpose of the Team space too. Click “Next” and optionally add team members.

After your team is created, add another owner. While members can perform most functions within a Team space, there are a few rights limited to Team owners. Adding another owner now ensures you’ve got back-up when you go on holiday or are otherwise unavailable.

Click the hamburger menu next to your team name and select “Manage Team”.

You can add additional members here. And click the drop-down next to any member you wish to become an owner and select “Member” – voila, another owner.

On the “General” channel, add tools and resources that are frequently used – that might be a link to a vendor’s web site (in the Team where we discuss updates and issues with a vendor’s product, having a link to the vendor’s support site is really helpful) or a Planner board to keep track of tasks <ref out to ‘did you know’ on adding the auto-created ones!>. Click the “General” channel then click the + next to the channel’s tabs.

You’ll be presented with a list of resources you can add to your Teams space.

To separate discussions into different channels, click the hamburger menu next to your Team name and select “Add channel”. We will create a new channel for different projects and sub-groups to avoid confusion and information overload.