How to check for empty or null SharePoint field values in Microsoft Flow

If you are using Microsoft Flow with SharePoint list or library data and need to check if a field is empty or null, then you can use the @empty function.

Here is an example

First, add a Condition and add the field you want to check.

Next, click on the “Edit in advanced mode” link.

Next, you will replace the content in the box with the empty() function. 

Note the following:

  • The “triggerbody()’, in this case, is what triggered the flow. This may be different depending on where in your Flow your field is coming from.
  • The “Title” is the name of the field.
  • The function returns true if the field is empty.

Additional details about functions can be found here.

4 new updates to Microsoft Planner – Making Due Dates more useful

Microsoft Planner has a few new updates that make it much more useful for daily task tracking and planning.

1. Group by Date

Before this update, assigning a due date in planner wasn’t very useful. There was no way to see which tasks were due unless you looked at each card individually. Now you can group your tasks by date, allowing you to see what is past due, due today, due this week, due in the future, or has no date assigned.

This allows us to plan out our projects more efficiently if we like to use dates as a driver for when things need to be done.

You can also group by date from your My Tasks page so you can organize your own tasks across all of your projects in Planner.

2. Receive an email when a task is late, due or upcoming

Now that Due Dates are more useful while in Planner, we now have another bonus. If you are assigned a task that is late, due today, or upcoming, you will receive an email in your inbox stating what is due. This can serve as helpful reminders that we have tasks scheduled.

3. Group by Label

In addition to grouping by date, we can also group by Label. You can make your labels anything you want in Planner. This gives you another great way to organize the tasks for your project.

4. Filter Tasks

Do you need to quickly find a specific task in Planner? Now you can filter your tasks in the project by keyword, due date, or assignment. You can even select multiple values.

What’s next?

I assume the mobile Planner app will soon be updated to allow some of these features. I also believe a calendar feed is coming soon. I’m hopeful that more integration with other servers is on the near-term roadmap.

The best tools to use for detailed time tracking

Since I work on multiple projects across various clients simultaneously, I need to keep track of my hours very closely so that I can bill my clients accurately and to quickly recall what I was working on a particular day and time. In my search for the most efficient way to handle this, I found many great tools along the way.


Toggl is a very popular time tracking tool that is a great solution for tracking your time quickly and for free! Toggl has a great web app for tracking your time, but also an open source desktop client that can be used as well.

  • Toggl is free, although you can upgrade for additional features.
  • You must be okay with starting and stopping a timer when you work. You can also go back and fill in manual entries but you need to remember to do so and remember what you were working on at the time. The Toggl desktop app has some activity tracking so you can see what application you were using at a particular time, but it doesn’t seem very robust.
  • You need cross-platform support. Toggl provides apps for Android, IOS, Windows, Mac, Linux, and Web.
  • You can create external integrations with Toggl using IFTTT or Zapier.
  • You get some detailed reports of your time.
  • Toggl is web-based, which means your data is stored online.



Timely is another timer tracking application that lets you track your time towards specific projects.

  • Timely has a free trial, but to continue it will cost you starting at $7 per month per user.
  • Like Toggl, with Timely you must also start and start the timer when you log your work. However, Timely also has a nifty feature called “memory” that you can connect to your calendar, Todoist, Wunderlist, and your desktop. This feature shows you what you were working on during specific periods of time. Then you can simply select an item to add it to your tracked time.
  • Timely has a web version as well as Android, IOS, Mac, and Windows clients.
  • Timely is web-based which means your data is stored online.


ManicTime is my personal favorite time tracking tool and the one I’ve stuck with for the past 8 months or so. ManicTime is a desktop client that tracks your activities including what applications your using and what websites your visiting. The data is all kept local to your machine. The biggest reason I’ve stuck with ManicTime is because it shows when I was at my computer and exactly what I was working which makes going back and tagging blocks of time for my time sheet is a piece of cake. It also doesn’t hurt that the timesheet report gives me exactly the right format for me to submit my time, while the other apps I’ve tried I always have to tinker with it to get it right.

  • ManicTime costs $67 with a year of free upgrades.
  • It doesn’t seem to use up much memory.
  • You can pull in data from external sources like your calendar so you can easily tag blocks of time you were in meetings.
  • You can setup auto tags that automatically track time you spend in certain applications or with specific documents towards a specific project.
  • You can create all kinds of interesting reports. For example, I have a couple of tags that I use so that I can see how much time I spend each week in internal meetings, client meetings, doing administrative work, development, and miscellaneous work.

Additional time tracking apps

  • Time Doctor
  • RescueTime – Track what your doing on your machine and/or Android phone. Doesn’t do great at actual time logging.
  • WorkingHours – If you use Windows 10 and Android, this app does a good job at providing simple time logging.

6 Tips to get the most out of Microsoft Teams

Many organizations have started to use Microsoft Teams as their tool for office communication. The idea is to help get conversations out of email and into a place where the knowledge can be shared and discovered. However, Teams can be a bit daunting at first. It takes some time to transition from the old way of working to this new way of doing things. Here are a few tips to get the most out of your Teams experience.

Tip #1 Know when to use Teams

One of the first questions when introducing teams to an organization is “When do I use Teams?”. While the answer could be very different for your organization, here are some key uses of Teams.

  • Replace internal email to distribution groups and create a Team instead.
  • Create a company-wide Team (for smaller organizations) and have a channel for company announcements.
  • Create a “Water Cooler” channel where anyone can post fun things, or ask general questions.
  • Create a team for your company knowledge base, where you can post FAQ, Industry News, company documents, templates, scripts, etc.
  • Use teams to collaborate on projects.

Tip #2: Use your Activity Feed

The activity feed is a great place to start as it can show you recent activity all in one place. The activity feed is analogous to an email inbox in that you can process new activity from one location.

  • The default feed shows all content that is relevant to you. This would include updates to conversations you are a part of or when you are mentioned.
  • The Team Activity feed shows all activity across your favorite channels. This lets you see what people are talking about, even if you are not a part of the conversation.
  • The My Activity feed shows all of the new posts, replies, and other activity that you created. This is a great place to jump back into a conversation or to find something you posted recently.

Tip #3: Ask T-Bot

If you have a question about how to use something in Microsoft Teams, just ask T-Bot! T-Bot is a chat bot that is built into the Teams product. Go to your chat and search for T-Bot, or click on T-Bot from your recent chats.

  •  Ask T-Bot any question about Microsoft Teams just like you would a real person. The bot will respond with the suggested answer. This is a great way to get familiar with interacting with a bot. Microsoft Teams has several other bots that you connect to.
  • You can also use the Tabs in the T-Bot chat to go straight to FAQ and see what is new in Microsoft Teams.

Tip #4: Use Search

If your organization uses Teams, after a short while there will be an overwhelming amount of content. Browsing to find anything will be continuously more difficult. Try to get familiar with the search functionality early on.

  • Use the search box to quickly find a specific Team or Channel that you are a member of. Click on the result to quickly jump to that location. This is a great shortcut for navigating to various teams and channels without browsing.
  • Use the search box to quickly find a person. Just enter their name and you’ll see the matching results. Clicking on the result will take you directly to the latest conversation you had with that person. From that page, you can use the tabs to see recent activity.
  • Enter any keyword or phrase and let search work it’s magic. The results will return all of messages, people, and files related to what you entered. You can then quickly filter the results to narrow your search.

Tip #5: Use Connectors

Connectors allow you to connect to external services and bring relevant content into your Teams conversations. You can add a connector to any channel.

  • Connect to your source control repository and have it post recent check-ins to your channel.
  • Connect your social media accounts and have posts from specific people or topics automatically added to the channel conversation. This lets everyone see recent activity without the need to hit all of your social media sites throughout the day.
  • Connect to news sources to bring in the latest relevant news.
  • Connect to your other favorite services. There are hundreds to choose from!


Tip #6 Save conversations

Teams will let you save conversations so you can quickly access them for later reference.

  • You may want to think about how you want to use this feature. If you want to be able to find all of your favorite conversations, you may want to “Like” the post instead. Then you can easily filter your activity feed to see all of the posts you liked.
  • The way I use the Save feature is to mark things that I need to come back to and finish later. It would be similar to flagging an email. You flag it (save it) and come back to it later and complete it. Removing the bookmark when you are complete will remove the item from your Saved list.
  • You can access your Saved conversations from your profile menu.

Wrap Up

I hope these tips help you enjoy your Microsoft Teams experience! Let me know if you have any questions or if you have any additional tips you would like to share.

How to manage the new SharePoint document library experience

Microsoft has recently started pushing out a new SharePoint Document Library experience that is must more like OneDrive (New Experience) than the traditional SharePoint (Classic Experience).

Overall, I think these changes are a good step to making SharePoint more modern. The new library experience is faster, visually more appealing, and works better across devices. 

However, customers may have a reason not to use this new experience. They may have customization, or just like to stick with the classic look and feel.

Currently, the new experience is only available to First Release tenants in Office 365, but will eventually be rolled out to everyone.

To manage the experience at the Library level

  • Open library settings > Advanced Settings.
  • At the bottom there is a new option to change the list experience. It can use the default, force to the New experience, or force the classic experience.

To manage the experience at the tenant level

  • Open Office 365 Administration > Admin Centers > SharePoint.
  • Click on Settings.
  • You should see a new option to set SharePoint Lists and Libraries experience. Choose either classic or new experience.

To manage the experience at the site collection or site level

Unfortunately, there is not a place in the UI to change the experience at the site collection or site level. Yet, we can change it using PowerShell. Check out this support page from Microsoft for the PowerShell script to do this.



Simplified storage management in SharePoint Online

Have you ever thought it was cumbersome to set the storage quota for each and every site collection you create in SharePoint Online? Now you can avoid it all together by enabling automatic site collection storage management. By doing so, all of your site collections will use as much storage as it needs pulling from the total storage available.

To enable this feature

  1. Log into your SharePoint Online admin page.
  2. Click on Settings.
  3. Select Automatic for the Site Collection Storage Management option.
  4. Save.
Site Collection Storage Management
Site Collection Storage Management

Is the feature enabled by default?

For new SharePoint Online tenants, this feature will be set to auto by default. For all existing tenants, it will be set to Manual and your admin will need to opt-in to the change.

For more information, check out Microsoft’s post.

How I organize Evernote for GTD – Getting things done with Evernote tags.

As a solutions architect I constantly have a huge list of tasks that need to be completed. For the longest time I have used Microsoft Outlook to manage my tasks which worked okay at first, but over time it turned into huge list of red (overdue) tasks. I discovered that “date” driven tasks don’t work well for me. I was constantly rescheduling tasks and always feeling behind.

I then discovered GTD (Getting Things Done) by David Allen, which introduces the concept of Next Actions to manage tasks. Rather than assigning a date to the tasks, you add it to a Next Actions list and simply work off of that list. There is a lot more to it then that, but I’ll spare the details here.


Why Evernote? I’m a Microsoft guy overall and I love OneNote. I still use OneNote every day for shared project notes and other things. However, I find that using OneNote to organize content gets to be cumbersome and messy. In Evernote, I can simply tag a note and not worry about which notebook and section it is in. Evernote allows me easily cross-reference notes using tags and search, which I love. It also feels more like a database than a notebook. I suppose the developer in me likes that aspect of it. I can build my daily workflow in Evernote, while in OneNote I spend more time organizing and searching.

So let’s get on with it.

Inbox Notebook

My default notebook is called Inbox. This is the dumping ground for everything I want to process in Evernote. This includes ideas, tasks, emails I want to review, documents I want to edit, articles I want to read. Inspiration from the web. The purpose of the Inbox is to hold any content that may need further action.

Cabinet Notebook

The Cabinet notebook stores everything else in Evernote. I keep it simple by keeping all of my processed notes in this one notebook and use tags to organize the content within it.

Evernote Notebooks

Next Action Tags

My Next Action tags are very simple. Rather than using the “Context” as described by David Allen for GTD, I organize my next actions around the mode that I’m working in. I picked up this idea from Mike Vardy. The difference is that a “Context”, as described by David Allen, is more about where you are, while a “Mode” is about what you feel like doing at that moment.

By working on tasks that are in the same mode I can jump from one to the next without switching gears and losing focus. All of my Next Action tags start with an @. This makes them easy to find when typing into Evernote search and when tagging items.

Here are some examples of my Next Action tags.

  • @agenda – Items I need to discuss with others.
  • @chores – Chores I need to do when I’m at home.
  • @development – Tasks that require me to write code.
  • @documentation – Tasks that require me to write documentation or technical design.
  • @errands – Tasks that need to be done while I’m not at home or work.
  • @planning – Tasks that involve planning. I like to do these tasks together while I’m in the zone.
  • @read-review – Items I want to read or watch later.
  • @waiting for – Tasks that are being worked on by others that I need to follow-up on. (I like to keep this one full.)
  • @writing – Blog posts that I’m writing and ideas for future blog posts.

Horizons of Focus Tags

In addition to Next Action tags I also tag content based on the project or topic it belongs to. I find that organizing the tags in a hierarchical outline helps me think of other projects that I may want to work on. I also keep active projects separate from inactive projects. Here is a snippet of how my project tags are organized. Notice that the actual project tags start with a . (dot). Again, this is to make them easy to find when tagging new items or searching across Evernote.

Evernote Horizons of Focus

Other Tags

I use tags for other things as well. But I don’t spend time organizing them. I just put them in an “Other” bucket and generally use them when searching in Evernote.

Reminders and Calendar

While I generally do not to assign a due date to my tasks, I do use Evernote Reminders to remind me to review things on certain days. This could be a reminder to send a weekly status report, or just to change the air filters in my house every six months.

If I do have tasks that should be completed on or before a specific day I block off time on my calendar to work on that project. By utilizing my calendar to block off time I get a better sense of how my week looks and how busy I am with important tasks. It also lets others, who want to book meetings, see that I’m busy working on things.

Putting it all together

  • Capture – Any ideas I have, tasks I need to process, articles to read, email to review, or anything else that I need to work on will go into the inbox.
  • Process – I go through each item in the inbox and either do it (if it takes less than 2 minutes), or tag it appropriately and move it to the cabinet. I don’t actually do any of the work from the inbox (unless it takes less than a couple of minutes).
  • Organize – About once a week (usually Sunday night) I’ll review my tags and make sure everything is up to date.
  • Execute – If I have time blocked off on my calendar for a specific project or task, I’ll work on that. If not, I’ll pick a Next Action tag that makes the most sense based on where I am and the energy I have. I then start working on those tasks.
  • Complete – When a task is complete I simply remove the Next Action tag. The note is always available as reference but no longer appears in my Next Actions list. Since each task is also tagged with a project, I can quickly see everything for that project in one list of notes by selecting that project tag.

Evernote Tags


While my process is always changing over time, this is how I work today. I find it interesting to see how others organize the work they need to get done. I hope sharing my approach is helpful to others who are trying to get work done using Evernote.