Microsoft 365 Business Admin Guide: Securing and Managing Microsoft 365 Business Download Free E-Book →
Emergency? Urgent?
Please Call 763.593.3017 or 888.707.3017

Remote
Control

When you work with SUCCESS, you have the opportunity to share your computer screen, mouse and keyboard with one our help desk technicians. Using this technology, we can see what you see on your screen. We can diagnose and fix problems as if we were sitting at your desk. We can demonstrate tricks and tips to help you in the future. Of course, when we disconnect, we cannot get back unless you permit it.

To share your desktop, enter your session code and click Connect.

Customer
Support

Our Customer Support Portal provides a window into our internal service ticketing, invoicing and knowledge base systems. Using it, you'll be able to create, modify or close a support ticket (or just give us some instructions or information). You'll also be able to access pdf copies of each of your invoices and service statements, while also viewing statistics about your use of our services. What's more, each service ticket becomes a searchable knowledge base article, created only for the people within your organization.

You'll be given access to our Customer Support portal when you sign up for our Managed Services. Please contact us if you need help.

To access our Customer Support portal, click the launch button below.

Launch

Service
Request

Click the button below to send an email to our support team. To better serve you, please include the following information in your email:

  • First and Last name
  • Company name
  • A detailed description of your problem
  • Preferred way to be contacted
  • Best times to reach you
Email Support
How to use Microsoft Flow to automate simple, repetitive tasks

How to use Microsoft Flow to automate simple, repetitive tasks

By Alex Fields,
Senior Solutions Architect, SUCCESS Computer Consulting

Use Microsoft Flow to publish a file to SharePoint and post about it in Teams

Today I want to walk you through a simple custom Flow that I have created to help streamline a process that I use to prepare and publish blog articles, with the help of my team.  Even though this is a specific use case, the Flow that I am building has many possible applications. Before we dive into it, here is the process that I am trying to simplify for myself.

When I start drafting a new article, I generally do so right from OneDrive, in a folder called “Blogs.”

Microsoft OneDrive

OneDrive is where a lot of my work starts out, since I am not ready to share it while it is still in a “very rough draft” form, but the idea is to eventually share this content with other people.  Now in the past after I have completed my first draft, I have either emailed this document to my marketing team, or, more recently, I have been uploading the documents into our Marketing channel within Teams.

Either process requires me to open another application, draft a message to notify my team, and then attach or upload the files myself. But like many tasks that basically come down to “paper pushing,” why not have Flow do this stuff for me?

Here’s how. Let’s start with the simple task of copying a file from one place (my OneDrive) to another (like a SharePoint library that my team uses).

First, I will create a new folder called “Ready for review” where I can easily drag and drop the articles that I have completed. My plan is that, Flow will take action when it sees a document show up in this folder.Microsoft OneDrive account with folders and files

From the top ribbon in OneDrive, I select Flow > See your flows. This brings me to the Flow app. Here I click on + New and choose Automated—from blank. (I didn’t find a template that did exactly what I wanted, —so I’ll just build one from scratch).Microsoft Flow using the Automated - from blank option

Skip ahead to go right into the full editor (I find the actual editor is easier and more intuitive than the wizard actually). From the editor, you can (1) give it a descriptive name at the top, and then (2) choose OneDrive for Business to get a list of triggers from OneDrive.Microsoft Flow triggers for OneDrive for Business

The trigger we are looking for is called: When a file is created (preview). This is a newer version of the option above it, and in my testing, it works better to achieve the result I’m looking for.List of connectors and triggers for OneDrive for Business

Here I simply use the folder picker to navigate to the path that I created in my OneDrive earlier: /Blogs/Ready for review. Then click + New step.Folder picker in Microsoft Flow

In the second step, I want Flow to create this same file in SharePoint. So I will search for “create file sharepoint”—then I can pick the option I want: Create filesearch for “create file sharepoint”—then I can pick the option I want: Create file

To build this second step, I can just fill in the fields it needs as follows:

  1. Site Address: Using the drop-down menu, I will pick out the Marketing site where I want to post the content
  2. Folder Path: Next I pick out the folder path I want to use from the folder icon in the second field
  3. File Name and File Content: I can fill in these fields using the Add dynamic content option. This selector will pull and display available attributes from our first step in the process, “When a file is created” from OneDrive.
    1. Pick File name for the File Name field
    2. Pick File content for the File Content field

Preview of Microsoft Flow

Remember I also want to Post a message to Teams. To do this, choose + New step again. Select Teams or use search to find the right action. Let’s use V3 (the latest and greatest at the time of this writing).

Post a Message to Teams using Microsoft Flow

Similar to what we’ve seen before, I can easily pick out the Team and the Channel I want to post in. Then, I can format the message I would like posted in the Channel every time I use this Flow.Message editor for posting in Microsoft Teams using Microsoft Flow

We could stop right here and have a pretty awesome flow. But then again, I don’t really need to keep that original copy in my OneDrive once it has been “passed over the fence” to my team. So why not add one more step to delete the original file and eliminate version sprawl?

In the Flow designer, choose + New Step and search for “delete file onedrive.”

Delete file OneDrive option in Microsoft Flow

I always find it ironic that OneDrive is actually “TwoDrives.” The one I want out of this list is Delete file—specifically the second one subtitled OneDrive for Business—because I am not connecting to my “Personal” or “consumer” OneDrive account but rather the Business account that is associated with my company’s Office 365 subscription. Just be aware of this distinction when you are working in here.

Again, I will want to pick the option to Add dynamic content (which comes from a previous step or trigger in the flow). So I can just scroll down and find the option called File identifier under the heading When a file is created (NOTE: it should have the OneDrive icon next to it—this means the original file that was created in OneDrive from the first step).File Identifier option in Microsoft Flow

When you’re all set, be sure to Save your flow.

So let’s see this thing in action, shall we?  Let’s say my blog post is completed, and I am ready to send it over the fence to my teammates, who will provide feedback and edits as needed before passing it along (again) to our website guy for final publishing. I have a draft right now that’s ready to go, in fact!File Explorer

Like a lot of people, I still tend to work out of File Explorer rather than a web interface, so I can just drag and drop my completed file into the “Ready for review” folder, and let Flow do the work from there!

Note that a flow may not be triggered instantly—this particular trigger fires every 5 minutes looking for new things to do. So, after about 5 minutes, as expected, my draft has found a new home in my team’s SharePoint site (with a message announcing its arrival in Teams).Preview of posted message in Teams

The SharePoint path that I picked out corresponds to a location within the “Files” tab in this channel:

From this point the team has everything they need to start collaborating about the content in Teams, providing feedback, editing it, or whatever they need to do in order to get the article published. One of the marketing team members may even decide to create their own approval process in Flow, and have the result automatically shipped out via email to our web guru, who ultimately posts it online.

So to review, my personal workflow went from:
Draft a blog post in Word > Upload a copy to SharePoint > Draft a message in Teams or email to notify my team members > Delete the original file from OneDrive (optional)

To now:
Draft a blog post in Word > Drag n’ Drop (done)

Pretty slick, huh? This Flow saves me a few steps, and several minutes of my time, every time I go to complete this fairly menial task. Totally worth the effort, don’t you think?

What tasks do you want to automate? Let us know.