News Categories
Announcement (9) Amy Babinchak (64) Tips (1) SBS 2011 (6) Windows Essentials 2012 (4) Edwin Sarmiento (28) SQL Server (22) SQL Server 2012 (6) SQL Server Clustering (3) SQL Server Disaster Recovery (6) Windows Server 2008 Clustering (1) log shipping (1) Brian Higgins (3) Uncategorized (42) Hyper-V (67) Virtualization (13) Windows 8 (13) Cisco VPN Client (1) Windows Server 2012 (24) Friend of TT (4) Hangout (2) Office365 (4) DNS (8) Jeremy (7) Cliff Galiher (3) Active Directory (12) ClearOS (4) Linux (4) presentations (2) SQL PASS (6) Chris Matthews (4) Printers (2) SharePoint (8) SQL Server Administration (7) Windows PowerShell (3) recovery model (1) sql server databases (1) Dave Shackelford (7) SMB Nation (1) Steve (1) Boon Tee (5) Kevin Royalty (3) Lee Wilbur (2) Philip Elder (10) SMBKitchen Crew (31) Susan Bradley (15) AlwaysOn (1) AlwaysOn Availability Groups (4) readable secondaries (1) row versioning (1) undocumented (1) The Project (2) Webinar (3) Enterprise for SMB Project (9) Security (25) Remote Desktop Connection for Mac (1) Remote Desktop Services (8) Windows Server 2008 (1) Exchange (15) Powershell (6) Microsoft (15) Performance (7) data types (1) Server 2012 (1) monitoring (1) DevTeach (1) SQL Server High Availability and Disaster Recovery (5) Clusters (44) Hyper-V Server 2012 (2) Business Principles (26) Cost of Doing Business (13) DHCP (7) sbs (15) Windows Server (30) SMBKitchen (26) Windows Server 2008 R2 (4) StorageCraft (1) P2V (1) ShadowProtect (6) StorageCraft ShadowProtect (1) VHDs (1) Intel RAID (2) Intel Server System R2208GZ (1) Intel Server Systems (17) RAID (2) SAS (2) SATA (2) Server Hardware (12) Microsoft Licensing (2) OEM (2) System Builder Tips (4) Intel (5) Intel Channel Partner Program (4) Intel Product Support (10) Intel Server Boards (2) Intel Server Manager (2) Cloud (26) IT Solutions (2) On-Premises (20) SMB (9) WIndows Azure (2) StorageSpaces (1) Error (47) Error Fix (35) Intel Desktop Boards (2) Intel SSDs (2) SSD (2) Business Opportunity (17) Data Security (11) Identity Security (7) Information Security (14) Privacy (2) Intel Modular Server (6) Promise (2) Storage Systems (9) Live ID (2) Microsoft ID (4) User Profiles (2) Articles (2) Building Client Relationships (6) DBCC IND (2) DBCC PAGE (2) filtered indexes (2) SQL Server Index Internals (2) training (11) Adobe (3) Internet Street Smart (8) Intel Storage Systems (2) LSI Corp (2) LSI SAS6160 Switch (2) Storage Spaces (7) Firmware Update (2) Product Support (7) Hybrid Cloud Solutions (3) Server Core (2) MAXDOP (1) SharePoint 2013 (1) SharePoint best practices (1) SQL Server Authentication (1) Family (5) Alternatives (1) SBS 2011 Standard (4) Microsoft Small Business Specialist Community (2) Microsoft Surface (2) SBSC (2) Networking (4) Availability Groups (3) CANITPro (1) HA/DR (1) Step-By-Step: Creating a SQL Server 2012 AlwaysOn Availability Group (1) webcast (1) VMWare (2) Conferences (2) Client Focus (2) Disaster Recovery (6) Error Workaround (8) Troubleshooting (4) Logitech (2) Product Review (7) Windows Features (4) XBox Music (2) SBS 2008 All Editions (4) MDOP (2) Microsoft Desktop Optimization Pack (2) Software Assurance (2) W2012E (6) Windows Server 2012 Essentials (6) Internet Explorer (3) USB 3.0 (2) USB Hard Drive (2) Bug Report (2) Microsoft Office 365 (5) sharepoint online (2) BitLocker (2) Windows (2) Microsoft Update (3) Swing Migration (2) Windows Update (4) Outlook (2) Group Policy (9) WS2012e (2) WSUS (3) Office (3) Microsoft Downloads (5) Microsoft Office (3) DRP (3) Virtual Machines (2) Virtual Server Hardware (2) online course (1) SQL Server learning (7) 2 Factor Authentication (2) 2FA (2) PASS Summit 2013 (4) SQLPASS (5) Contest (1) e-learning (1) Udemy (1) smbtechfest (1) backups (2) PASS Summit First Timers (3) IIS (2) RD Gateway (4) RD RemoteApp (2) RDWeb (4) Remote Desktop Connection (2) Remote Web Access (2) Remote Web Workplace (2) Cryptolocker (6) Backup (4) Restore (2) CryptoLocker (1) AuthAnvil (1) SBS 2003 (1) SBS Migration (1) Windows Server 2012 R2 (9) Documentation (1) IE 11 (4) testimonials (11) SQL Server 2008 (1) Best Practices (1) Support (1) Intel Xeon Processor (1) RemoteApp (1) Android (1) iOS (1) Hyper-V Replica (2) PowerShell (2) SBS (3) Break (1) Business Intelligence (1) Excel 2013 (1) Power Map (1) Power Query (1) PowerBI (1) MultiPoint (2) Surface (1) Net Neutrality (1) Opinion (2) ASP (9) HP (2) Scale-Out File Server (8) SOFS (10) Windows Phone (1) Updates (1) Intel NUC (1) Intuit (1) QuickBooks (1) Office364 (1) Intel Server Systems;Hyper-V (1) Firewall (1) Patching (1) Mobile (1) Mobility (1) sharepoint (1) Microsoft Security (1) Beta (1) Storage Replication (1) outlook (1) Hyper-V Setup (3) JBOD (1) Azure (1) PCI (1) PCI DSS (1) PII (1) POS (1) MicroStaff (2) Catherine Barr (2) Third Tier (1) BeTheCloud (1) BrainExplosion (1) LookAWhale (1) Manuel (1) Rayanne (3) SuperSecretNews (1) TechYourBooks (3) Managed Services (1) Training (1) E-mail (1)
RSS Feed
One way Microsoft 365 pays for itself
Posted by Amy Babinchak on 12 June 2019 09:53 AM

What if there was an application, maybe even an artificial intelligence, that could watch over some of your tasks and do them for you? What if letting that AI do those things for you ended up increasing your productivity so much so that it paid for the whole Microsoft 365 subscription all by itself? What if it also made your job less annoying? Well there is and most people haven’t started to use it yet. It’s called Microsoft Flow and it’s part of your Microsoft 365 subscription.

Do you hate uploading files into SharePoint?

Well stop doing that and let Flow do it for you. We’re going to configure Flow to watch a OneDrive for Business folder and when Flow sees that a new file has been put in the folder, Flow will copy that file into a specific SharePoint library.

  1. Create a folder in OneDrive for Business. Give it name that indicates where files put into it are going to end up. In my example I’ve created a folder called Upload to Training and I want files that are put in that folder to copy up to the Training Materials document library in SharePoint.

Files move from one folder to the next automaticallyNext I need to open OneDrive for Business in my browser and select the Flow I want to use. The easiest way to open up OneDrive is to click on the little blue cloud in your system tray and then select View Online.

View onedrive online easily

  1. In OneDrive press the Flow button in the menu and choose Create a Flow. This will let you browse through the available OneDrive for Business Flow templates.

Create a onedrive Flow in sharepoint

  1. Choose the template called Copy files between OneDrive for Business and SharePoint. You’ll be presented with a form to fill out. In the OneDrive for Business Folder filed press the folder icon and browse to the folder that you created. (in my example, this is the Upload to Training folder). In the SharePoint Site Address filed use the drop down arrow to select your SharePoint site. In the SharePoint Folder Path use the folder icon to select the document library into which you want Flow to copy your files. (in my example the Training Materials folder) Then press Create Flow.

Chose a Flow template to move files

  1. You’ll get a prompt asking you to give Flow permission to access your OneDrive for Business folder. Accept that request and you’re ready to start moving files into SharePoint without having to touch your SharePoint website. I created a shortcut for this folder and put it on my Desktop for easy drag and drop.


Everyone has tasks in their day that essentially involve pushing paper, digital paper in todays world but still it’s about taking a file from one place and putting it into another. Microsoft Flow is great and doing this. Harness the power of this everyday AI and safe yourself some time and annoyance.

Get your file approved for distribution

It’s the case for a lot of sales organizations that a quote must be approved by the sales manager before it goes out to the customer. This often involves a lot of back and forth in email. File attachments and file downloads. All of which take up time in the say. Flow can help eliminate a lot of that and return focus time to the sales staff.

Here is what this is going to look like for the manager when a quote is waiting to be approved.

Flow approval email

And after the quote has been approved here is what it looks like for the manager.

completed flow approval email

And here is what it looks like for me. My file moves into my approved quotes folder. Anything in that folder I know is ready to send to a customer.

Files move automatically into the approval folder

Here's how to set this up.

  1. We’re going to do something very similar to our first example. This time we’re going to create two folders in OneDrive for Business. Here I’ve created one called Quotes for Approval and one called Approved Quotes. My work process will be to save a new quote into my Quote for Approval folder. Flow will ask my manager to approve the quote and once it has been approved Flow will move the file into the Approved Quotes folder for me. So in this case Flow is taking two tasks from me. Flow is asking for the quote to be approved and then moving the file after it has been approved.
  2. After I have created my Quotes for Approval folder I need to share it with my manager. Because the manager will need to be able to open the file to review it. Now that I have my two folders and the one is shared with my manager I’m ready to setup my Flow.
  3. As before I’m going to go into OneDrive for Business in my browser and use the Flow button in the menu to create my Flow. For this one I’ll select the Flow called On Approval, move a new OneDrive for Business file to a different folder. I will be prompted to give Flow permission to the OneDrive for Business folder I created as well as the ability to send an email to my manager on my behalf.

Simple approval template

From here I fill out the form as I did in the first Flow example. That’s it! I’m ready to start using this Flow.

What have I accomplished by eliminating the task of asking my manager to approve a quote? I eliminated the need to compose and email, attach files to that email. Wait for a return email, download the approved files and save them somewhere. On the mangers side I’ve also eliminated the need for the manager to have to remember if there are quotes waiting for approval. The job status is right there in the managers email.

Microsoft Flow is your private artificial intelligence just waiting to take tasks off of your plate. We all have far too many paper pushing tasks even though we might not have the paper anymore.

I’ve only presented two examples, but can you imagine how many tasks each person at your company has that could be automated? I have about a dozen of them setup for tasks that I do. Think of it think way. If you can phrase it as an If-Then statement, then Flow should be doing it not you. If I need to get approval for a file, then have Flow do it. If I need to move files from one place to another, then have Flow do it.

Microsoft has a few thousand templates available and you can every create your own. When you get really good with it you can create much more complex multi-step Flow solutions. Imagine the possibilities. Add up that savings and you’ll see that Flow has the potential to pay for your whole Microsoft 365 bill and more. Increasing productivity is no small thing for businesses. It’s the best way to add to the bottom line. So if you’re in IT person that wants to be valuable to your employer, start introducing people to Microsoft Flow. If you have a Microsoft 365 subscription then you own it already. Why not start harnessing the power of everyday AI and be the one that uses technology to add to the bottom line of company. Put that on your resume!


Make your IT business better than the competition. Open a ticket with us! IT Pro Helpdesk, TechYourBooks, Super Secret News,  Ransomware Prevention Kit and more.

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako Fusion