Do you like the Network Days function in Excel? And do you need to create reminders to do a task but do not want to include weekend days - here is a trick to exclude them. You can re-create it with SharePoint Online and Flow.
Flow Connectors: SharePoint, O365 Outlook
What is the Network Days function? The NETWORKDAYS function is a built-in function in Excel that is categorized as a Date/Time Function to not include weekends when calculating 2 given dates.
Use Case: When a SharePoint item gets created, I needed to add 3 days from the create date not including the weekends and email a reminder. The person field can be any type like assigned to, but in this case it is a writer that has to take action by the 3rd day after an item is added. This type of reminder system and exclusion of network days can work in many scenarios and here is one of them that worked for me.
It is possible to add a document library as a tab in Teams channels, and this post is going to show how you can sync (creation and deletion) such a document library with an external storage source (this use case is for DropBox) via Flow.
Do you ever just want a quick and efficient way to create a request workflow? There are several ways to create a request approval process with Flow and I am going to show you one of the ways that has worked for me. This request process is specific for a vacation request approval flow but can easily be used for any type of request. I will provide you with 5 easy steps for you to successfully create the approval process using a modern SharePoint Online List. This Flow is highly extensible and can even include multi-step approval processes. For more information about multi-step approval check out Jon Levesque’s video: https://www.youtube.com/watch?v=f6ysuQUZ2wQ
Though you can externally share sites and documents in Office 365, sometimes, users need to send out documents to many external contacts, and would like an easier way to do this without having external users create a Microsoft account, without having to attach said document to an email.
The potential of SharePoint is abundant and now with Flow you can do even more. However, with more power comes more responsibility and this is where Cognitive Service's can help. In this blog we'll see how the Computer Vision and Content Moderator connectors can help monitor the images that are uploaded to SharePoint libraries buy tagging them and also identifying those that are either racy or adult.
This blog focuses on how using Flow you can automate the process of monitoring incoming emails and create tasks in existing Plans in Planner. The Flow is smart enough to focuses on new emails only and ignore replies.
As someone who simply cannot win a raffle price I decided to remove 'Luck' out of the equation and instead leverage Flow, Cognitive Service Text Analytics and Power BI to make price winning a little more interesting and fare. One would even say I added a new meaning to the phrase 'Luck favors the prepared'.
Does your business involve handling documents, such as invoices, purchase orders, shipping notes, etc. on a daily basis? Do you find yourself re-keying valuable data which is trapped inside PDF or scanned documents? If your business relies on data which is not available in an easy-to-access format, manual data entry can quickly become a bottleneck and harm your business. Luckily, there is a solution to this problem!
Recently, I’ve been intrigued by Microsoft Cognitive Vision services. This Machine-Learning functionality can extract rich information from images to categorize and process visual data – and machine-assisted moderation of images to help curate your services. Now, as some of you may already know, I’m a huge LEGO fan and I come from a family whose been playing with LEGOs for three generations. One of the struggles each LEGO fan faces is identifying a part number. I took on this struggle as a challenge and have come up with a Proof Of Concept using Microsoft PowerApps and Flow’s integration with Microsoft Cognitive Vision Services’ API. I introduce to you my LEGO Inventory App.
Anyone who has used SharePoint Designer to build 2010 or 2013 workflows is familiar with the 'Set Field in Current Item' action. You might also know that this action is currently not available in Flow. Update item is the only action close enough to achieve the task, however, for every Update Item step in Flow a version is created for that list item. Hence if you do need a 'Set Field in Current Item' action, especially while migrating your SharePoint Designer workflows to Flow then you can consider using the Set Variable action instead. This blog walks you how you can use this action using a demo.
This blog walks you through how you can use the two attached templates to build your own mobile PowerApp as a central place to post comments to Facebook, Slack, Twitter and Yammer. The three attachments includes a MSAPP file for the PowerApp, zipped file for Flow and STP file for SharePoint. The 'SocialMedia.ZIP' file contains the MSAPP and STP files. Hence you will have to unzip that file. Leave the 'Socialmedia_20171213182703.zip' as it is and import it in Flow. The steps described in this article must be followed in the precise order to get the final app as desired.
There are plenty of times that you'd like to be notified when a specific email arrives in an inbox, but what about those times when an email doesn't come through? In this post we're monitoring status emails sent each day by our client's backup programs. If a backup program doesn't send another email within 30 hours, an alert is sent to a backup technician who can acknowledge it using Email Options in Microsoft Flow.