|
Learn how to build Flows here. Many of the templates for Flow are quite esoteric – when a tweet on a particular topic appears, write a log to a Sharepoint site and send a notification to a Teams channel, that kind of thing. But there are plenty of really useful connectors that can be combined in time-saving ways; here’s a really handy way of bringing traditional data sources into the modern era: an email parser, called Parserr. After signing up with Parserr – free if you only need a few uses per month – you can then crack open mail that is consistent in format and contains some information you’d like to extract and use elsewhere, such as confirmation of an appointment or maybe a travel booking. In practice, you get given an inbox with a unique email address within Parserr and you’d set up a rule in Office365 or Outlook.com to send mails that meet some inbox rule to that address, where it would be parsed for you and key data fields then sent back to Flow. e.g. if email comes from a specific source address or it has a subject that indicates it’s a particular type of reservation, then forward to your nnnnn@mg.parserr.com inbox address, extract the details of the booking then do something with them within Flow.
Create a rule for each piece of information you want to extract, and it will effectively create a field:
Once set up, you create the Flow by choosing the connectors for Parserr and whatever other applications you need to work on the information. In this example, we’re using Office 365 to create an appointment that matches a reservation – the arrival and departure dates are provided by the source email, and converted to YYYY-MM-DD format within Parserr, then dragged across in Flow to match the Start & End times of an “event”. We’ll tack on T16:00 to the arrival time and T10:00 to the departure as that’s the check in and check out times, and thus create an ISO8601-compliant date/time such as 2019-04-05T08:00, which Office365 will use as the start or end time of an appointment. “Advanced options” gives you further control (such as adding body text that might contain static text and other fields provided by Parserr, other addresses to forward the invite to, setting if you want it to be free/busy/tentative, reminder duration, time zones etc).
And that’s it: you can test the logic is working within each system – in Parserr, you can continually re-run the processing of your initial sample mail until you know the data is being extracted as you’d like, and within Flow you can keep testing your formatting etc by Once you’re happy just save the Flow, and it will automatically create an appointment in your calendar every time you get a matching email forwarded to the Parserr system – all in a few seconds. See more on using Parserr with Flow and here’s a worked example. |
Category: Office
Tip o’ the Week 472 – Update Store & Office apps
|
The Windows 10 October 2018 is now being pushed to (nearly) everyone, though business users will have the option of pausing Windows Updates in case they want to enact a temporary delay for some particular reason – you’re about to go on a trip, for example – though it’s not meant as a centralised policy control: IT departments have other ways to do that. Windows 10 Homes users will soon get the ability to defer updates for up to 35 days, too. How often applications update themselves is largely down to the publisher,
Or check the View Updates option at any time, and it’ll take you to the web to see what the latest updates contain. |
![clip_image001[4]](https://tipoweek.azurewebsites.net/wp-content/uploads/2019/04/clip_image0014.png "clip_image001[4]")
![clip_image003[4]](https://tipoweek.azurewebsites.net/wp-content/uploads/2019/04/clip_image0034.png "clip_image003[4]")
![clip_image004[4]](https://tipoweek.azurewebsites.net/wp-content/uploads/2019/04/clip_image0044.png "clip_image004[4]")
![clip_image006[4]](https://tipoweek.azurewebsites.net/wp-content/uploads/2019/04/clip_image0064.png "clip_image006[4]")
![clip_image008[4]](https://tipoweek.azurewebsites.net/wp-content/uploads/2019/04/clip_image0084.png "clip_image008[4]")
![clip_image009[4]](https://tipoweek.azurewebsites.net/wp-content/uploads/2019/04/clip_image0094.png "clip_image009[4]")
![clip_image011[4]](https://tipoweek.azurewebsites.net/wp-content/uploads/2019/04/clip_image0114.png "clip_image011[4]")
Tip o’ the Week 468 – Get Office, My Office, Office app appears
|
Get Office became “My Office”, which was a lot more useful in the sense that it was showing documents you used etc, but its main aim appeared to still be to help you find and launch Office apps, or buy them if you’re not already using them.
The search bar also reaches across SharePoint sites you use, OneDrive locations you have and even brings in the global address list so you can get to people details really quickly, including a really fast org chart ability. The new Office app will be delivered automatically for a lot of people as it will replace the My Office and Get Office apps in due course; if you’d like to check it out sooner, go to the Store. |
![clip_image002[4]](https://msdnshared.blob.core.windows.net/media/2019/03/clip_image0024.png "clip_image002[4]")
![clip_image004[8]](https://msdnshared.blob.core.windows.net/media/2019/03/clip_image0048.png "clip_image004[8]")
Tip o’ the Week 453 – Outlook Quick Steps
|
Put simply, Quick Steps make some repetitive tasks easy with a single click or even a shortcut key combo – start by selecting a message you’d like to apply some action to (such as moving or categorizing it), or if you’d like to start some new item based on the contents of the message – like create a task or an appointment, including the body of the original mail.
If you haven’t played much with Quick Steps before, have a go – they’re fab-u-lous! |
Tip o’ the Week 451 – OneNote auto-listing
 Here’s a quick tip in OneNote – both the full-fat desktop client and the modern app version – which was inspired either through PEBKAC type unexpected clickery or maybe an Office update that inadvertently switched something off. A common feature stopped working, and it caused a serious dent in productivity…
Despite the two parallel PC versions of OneNote – which have been covered previously in ToWs #441, #427, #386, #320, et al – offering a good chunk of similar functionality to each other, there are still quite a few areas where the old desktop x86 version wins through. Add-in support is available in the 2016 variant, for example, so you can run OneTastic (and in particular, OneCalendar, which is immensely helpful if you use many notebooks and take a lot of notes throughout your week).
Search in the desktop OneNote is more powerful, too – CTRL-F takes you to the search box, CTRL-E expands your search, but the most powerful and probably least used is to press ALT-O when you have search results from the CTRL-E dialog; it will order them by the date of the page update… helping to filter out current vs obsolete info.
Bullet lists & indentations (sounds like a Muse song) Did you know that, in both OneNote versions, if you’re typing notes and press the asterisk or dash key at the start of a new line, and then the space bar, it automatically turns your text into a bulleted list? Asterisks in the middle of a text block are ignored; it’s only seen as an auto-correct function if on a new line. Just hit enter after you’ve started typing to add another new bullet or hit enter at the beginning of new bullet to finish the list. TAB and SHIFT-TAB lets you indent and un-indent a bulleted line. It doesn’t sound all that revolutionary, but if you’re typing notes during a phone call, it can make all the difference between keeping up or missing discussion points as you fish around with the mouse looking to click the toolbar. If you’re used to it and it gets switched off, it’s a real pain. The same kind of functionality exists in Word and Outlook too, but now and again it does get in the way – if you’re marking a block of text* that you then want to expand on later without auto-bulleting, for example. * The simplest way to get an asterisk or dash at the start of a new line is to quickly press Undo – CTRL-Z – as soon as the indentation with the bullet happens, and you’ll be reverted to simply having the character at the start of the line. To enable or disable the automatic list features on desktop OneNote, go into Options and look under Advanced…
There doesn’t appear to be any way of disabling the feature on the Modern App (which you can start by running onenote-cmd: at the Win+R box, if you read ToW #445 and #443) – maybe that’s a good thing, preventing the user from harming their own productivity… |
A simpler and more useful feature for many is the ability to grab the contents and context of a meeting request from your Outlook calendar – so you can take notes during a phone call or a meeting, with all the text in the invite, names and email addresses of attendees etc. Can’t do that with
Tip o’ the Week 450 – blur: team life?
|
Back in the OCS days, it was assumed you had a server on-premises (style note – the opposite of “in the cloud” is “on-premises”, ie in or on the premises you have, possibly abbreviated to “on-prem”. It is definitely not, ever, “on-premise”. If you are on-premise, that means you’re in agreement with a point of view, not that you still run your own datacent(re|er)…), not an assumption that you’d make today, with flexible working and Wi-Fi everywhere.
Anyway, as well as having on-prem kit that’s quite possibly connected to a physical phone system, Lync/S4B largely assumed your client (wired to a LAN) connected to a local server. That communicated to other clients and servers in the same environment (mostly) and, maybe via a gateway, to the outside world for the POTS. How cool it was to click a link in the communicator client, and next thing your desk phone was calling that number! As Teams imminently starts to replace Skype for Office 365 customers, we’re seeing lots of best practice guides and other resources for successful adoption. Further Teams ToWs will follow as well – in fact, if you have one you’d like to share, please write it up and send it over. This week’s tip focuses – or rather doesn’t – on a very cool trick when using Teams for video calling: the ability to blur your background, so as to remove distractions for other parties in the call. There’s a great short video ad illustrating the feature, here. See it in action here.
Blur background was made generally available to coincide with Ignite – as were a bunch of other updates. |
Tip o’ the Week 449 – Snipping Tool gets the snip
 As mentioned in ToW #447, there are some tweaks coming in the Windows 10 October 2018 update, which might be with us sooner than you think.The old Snipping Tool (not to be confused with the similar screen snipping utility that’s installed if you have OneNote 2016, activated by pressing WindowsKey+S) is going away, and giving way to a new program. And some people aren’t happy about it (in fact, if this was a story which features on the sponsored clickbait tiles on the Edge browser homepage, it’d be described as Microsoft Has a New Trick, and These People are Furious About It…).
If grabbing a free-form selection, once you’ve more-or-less completely made a shape and when you release the mouse button Despite the fact it’s a Modern App and People With Too Much Time On Their Hand Think This… is a bad thing, it’s actually pretty snappy and provides a useful polish to one of the more esoteric but handy features in Windows.
Of course, another method (useful in the preparation of this very note) is to rely on the old PrntScn button, the pressing of which dumps the contents of the screen – floating toolbars and everything – straight into the clipboard. Paste the contents into MSPAINT, then use the Snipping method above to grab the relevant section of your screen grab, and you’re sorted. |
The new 
olbar at the top of a greyed-out screen, making it quick and easy to either grab a rectangular portion of the screen, a free-form selection, or the whole screen itself.
you’ve been holding down, then a large “toast” appears in the bottom right of the screen advising that it’s now in the clipboard. If you click on that, 
you’ll be launched into the Snip & Sketch app, where you can do various tweaks to your grab, save it, share it and so on. An alternative to the Win+S method of invocation is to go into Snip & Sketch to start with, and initiate a new screen grab from there.
Handy especially if you prepare any kind of training documentation, or you’re stupid enough to send out a weekly tips email to thousands of people for 9 years.Tip o’ the Week 448 – Sometimes, size does matter
|
Nowadays, with 50 or 100GB mailbox quotas being the norm, most Outlook users don’t need to worry about reducing the size of their mailbox other than to keep it from being too hard to use – a tidy mind and all that. But if you have massive mailboxes, the storage and organisation of all your content may put an unnecessary strain on your PC, so it’s worth taking a few steps to check and clean up if you can.
In Outlook 2016, go to the File menu and l … and marvel at a dialog box that hasn’t changed since the earliest days of Outlook, evidenced by the fact it measures size in KB rather than MB or even GB… Limits to be aware of There are some recommended limits that have been given to Exchange/Outlook users over the years – not just about the overall size of the mailbox, but the number of items in certain folders and even the number of folders themselves. See a 2005 post on the Exchange blog here, for example, which advises keeping the item count low on certain folders (< 1,000 items in the Inbox, Calendar and Contacts folder was the recommendation then – also on the Exchange Blog, check out some of the examples in this post for early pioneers of huge mailboxes). In more recent versions of Outlook, though, there are some guidelines to avoid performance problems:
Now, you’re probably not going to have too many folders with more than 100k items though it might be worth checking Sent Items and Deleted Items. Unfortunately, the mailbox size tool above shows you the total size of each folder, rather than the number of items – and if you want to know how many folder you have, you’d need to manually count them in the scrolling list box: not an easy task if you have lots of them. It’s quite possible if you’ve had your mailbox for a while, and you’re a very diligent filer (especially if you use a methodology like GTD or tools like ClearContext), you could inadvertently have more than 500 folders – and if you use AutoArchive, then you could find a lot of them are empty, since the archive process moves the items out into another location but leaves the folder structure behind.
FolderCount to the rescue Here’s an interesting little hobby project – a macro-enabled Excel sheet which cycles through all the folders in your mailbox, tells you how many items are in each one and offers to get rid of the empty ones for you. It can be run in:
Use with caution; though anything that is successfully “deleted” will be moved to Deleted Items first, therefore you’ll need to run it again to actually do the damage (or just empty your Deleted Items… a thought that fills some people with dread). To run it, click on the link above, save the file locally, open it up in Excel and you’ll need to Once you’ve done that, click on the appropriate button to let it run. I’d suggest starting with the top one until you feel brave… *The Thread Compressor tool was made available externally after a time, but the domain disappeared… the actual Outlook Addin is again available here, but you’re a bit on your own as far as installing and using it is concerned… |
Tip o’ the Week 446 – What’s brown and sticky?
|
A: A stick… Q: What’s yellow and sticky? Yes, the Post-It note (which has gone on to spawn many imitators, sometimes known as just “stickies” or “sticky notes”) was essentially invented by accident almost 50 years ago, by a scientist at 3M who was trying to make a super-strong glue but instead came up with one that didn’t really stick very well but was at least reusable and didn’t leave any residue behind. Of course, the real story is a lot less simple – the product really took more than a decade to perfect, and convincing people that it was a viable business took several attempts, but eventually it went on to be one of the most-bought office supplies in history. The digital equivalent has had decades of evolution too, from a simple note app from the company that brought you Tiny Elvis to the Sticky Notes application that shipped with Windows 7, and innumerable similar apps in the various mobile and desktop app stores. Starting with the Windows Insider “Skip Ahead” community (but soon to roll out wider), the Microsoft Sticky Notes app has been heavily revised, consolidating the multiple windows that would typically be left on your desktop with a single list, and then pop-out notes that feature multiple colours, support for ink, cross-device syncing and more.
Keep an eye out for the Sticky Notes 3.0 arrival on your PC. As MJF says, with the same team now responsible for OneNote, To-Do/Wunderlist, and Sticky Notes, it’ll be interesting to see how deeply integrated they get. |
Tip o’ the Week 443 – Starting modern apps
 Power Users often like to start applications quickly, without recourse to grubbing around with a mouse or a trackpad. Super Users might even want to write scripts that automate all sorts of things that mere mortals with less time on their hands are happy to do manually. Regardless of your penchant for automation, here are a few short cuts you can take to quickly start apps that you use often.
Apps pinned to taskbar The taskbar in Windows obviously shows you what’s currently running, but can also be used to pin frequently accessed apps or – by default at least – those that Windows thinks should be frequent (Edge, Store, etc – right-click on them to unpin if you disagree). You’ll see a highlight line under the apps that are running, so those without the line are simply pinned there. If you start typing the name of a favourite app at the Start menu, If you drag the pinned apps around, they’ll stay in that position relative to each other, and new apps will always start to the right (or underneath, if you use a vertical taskbar, as you really should). Now, if you press WindowsKey+number, you’ll jump to the app that is n along the line, and if that app isn’t running, then Windows will start it. So in the picture above, pressing WindowsKey+2 would start Edge, or WindowsKey+3 would bring Outlook to the fore. Shortcut to desktop
Assuming your Start menu isn’t full screen then you’ll be able to drag icons or tiles from the menu to the Desktop, and if you right-click the shortcut and look at Properties, you’ll see a Shortcut key: This method differs from the taskbar one above, because each press of the shortcut you set might start a new instance of the app (if it supports that) – which may or may not be desirable. If you end up with several windows of OneNote, for example, you could cycle through them by repeatedly pressing the appropriate WindowsKey+n as above. Keep on Running There’s no better mark of being a real PC deity than by launching your apps through running the executable name… you know the drill? WindowsKey+R to get the Run dialog (it’s so much faster than pressing Start), then enter the app’s real name and you’re off to the races. winword, excel, calc, notepad… they’re for novices. The genuine hardcases might even dive into the (old fashioned, obvs) Control Panel applets like ncpa.cpl rather than navigating umpteen clicks. Looking at the shortcut to OneNote’s modern app above, though, it’s clear there isn’t a simple executable to run – onenote will launch the on-life-support OneNote 2016 version. Many modern apps do, however, let you launch them from the Run dialog by entering a name with “:” at the end… Examples include:
|
then right-click on it in the list, you can choose to pin it. So far, so good.
You could try an old-
option… just press some key sequence that makes sense to you and press OK to save.