Automating business processes and approvals with Microsoft Flow : Build 2018

So by a show of hands how many people have heard of microsoft Flow before? okay So almost everybody, that’s awesome How many people have built an approval flow Before? so much smaller percentage and Doing that in the demos today and if you have already done That, great, you can follow along and one of the things i Will cover in the session today. So when we talk about microsoft Flow i will give a little background on why we are making Microsoft flow, who we see it for and kind of what the purpose Of microsoft flow is. And i like to show this graphic And really what we are trying to say here is today there are — There’s data and widespread of systems inside and outside Organization and e-mail and files, messages and integrate Together today more than not having people doing manual tasks People have to go and they have to copy and paste data between Systems, they have to make sure that when they get e-mail from Their boss they will do the right thing and if they are Sending out approval request it is going to the right people In fact, not only are people doing this, oftentimes people Are doing this with pen and paper. A lot of the processes inside an Organization today still have not been digitally transformed In way they can run inside the cloud and so if microsoft flow We hope to make people be able to work less and do more because We want people to work smarter inside organizations and this Applies not just individuals but also to teams and groups of People inside organizations and they can do this with microsoft Flow by automating the processes and automating the approvals and All the things that go on inside the organization What is microsoft flow? microsoft flow is global scale software service that is Intended to support the digital transformation of processes Across many different verticals. We have data centers throughout The world and run in azure just like you had expect and we are a Complete finished software service and go to microsoft.Com And it works out-of-the-box. We are not like an Infrastructure service. There’s lots of great talks Today and throughout the week about infrastructure and how you Can use azure to build that. That’s not what we are We are a software service to use to sign up today and start Automating things inside the organization. So to set some context of how Microsoft flow fits in with the other microsoft business Applications that we have, there are applications that meet the Needs no matter where you are, if you’re using managing people In the organization and products in the organization and managing Tools and we have like dynamic 365 of that built package Applications that meet the needs and plus a wide variety of tools Like linkedin, bing, all across the board and few key platform Elements and when we talk about the business application Platform i’m talking about the power bi, power apps and flow And together with azure they offer a platform for all the Business applications that microsoft delivers When you’re thinking about digital transformations inside The organization often the fastest and easiest way to get Started is by purchasing an off the shelf finished application Our dynamics 365 like marketing sales, service, talent, they are This, complete application and fact of the matter is many Applications don’t do exactly what you need. Every business hasin own Distinct requirements so you need a platform that allows you To customize the processes of your organization Oftentimes there’s no app for that because there’s no business Process that comes out of box, just magically does what you need So to represent a visual way we have these packaged applications But there’s also all of these individual line of business Processes that need to be created that span the distance Between each of these individual applications So if i want business process that goes between marketing and Talent, i need a way to do that and simple out-of-the-box Business processes that come with the individual applications Won’t do that for me. That’s where microsoft flow Along with power apps and power bi allow you to form the gaps For the processes and capabilities of organization It is becoming more focused on high productivity and low code Of aspect development and what we need by this is you shouldn’t

Have to go and write a bunch of code just to accomplish a simple Workflow and one be a good use of your time and harder to Maintain after you have done it. So we really think That the capabilities will make it easier Whether you’re in it or not and we think the solutions will give You way to build applications and solutions faster than you Ever have before and power analytics power bi and power Apps and automation that exist inside microsoft flow Together we say the three things make up what we call the power platform It is not an official term but two of the three applications Have power in them and so that’s why we call it that and power Platform targets power users. These are the people that are Embedded inside line of business that know what their business Problem is most closely. On top of this we offer the Developer platform capabilities of azure so power bi flow and Power apps are on top of equivalent azure offerings So if you are a prodev in the audience and most are developers Or know developers themselves, that’s where azure comes in and We really see the offerings we have for power users being Closely connected to the azure offerings that we have And both of these together they use new capabilities in common Data service for analytics and apps that are the holistic data Store for the data that your organization has and stores and You can bring all the biz data and bring in sing application or Single database that you can then build applications on top Of. Build processes, build your Analytics on top of and we have connectors and gateways so that Way if you haven’t brought data into the common data service you Can still connect to it whatever it is. Another way to think about this Is how are we differentiating between the audience of Developers and citizen developers is by the breadth of Their offering, so today there’s a small set of applications that Can be built using functions because it requires a lot of School and capabilities to bold those up If we start up leveling the concepts and work at azure logic Apps and dive into a little bit more and comparison later, other Audience toward the citizen developers and if you go all the Way to say for power apps and flow, we see there’s being huge Opportunity because really any citizen developer and citizen Developer is a little bit of misnomer. It means somebody that isn’t a Pro developer which means really they don’t know how to write a Lot of code. That’s where we see power apps And flow being really successful and seen throughout the demos Today all it requires is thinking a little bit about the Business problem to be able to bring together with ui drag and drop capabilities a business Process in a way that works for your organization. So the key goal here is to Democratize digital transformation inside organization and make it Possible for anybody building internal solutions and citizen Developer to create things that their business needs Now, that being said, we don’t want there to be what we call Cliffs where i take a solution and on one platform and then Suddenly i have to rebuild it if i need it to be more advanced And take platform simple solution say from a template and Walk through each of the steps in the demos today but start From a template which is a very simple flow that works out of Box and say i will customize it from the needs and drag and drop Capabilities that we have and even that is insufficient and Continuous integration and deployment and capabilities we Have and take that the further into a prodevelopper environment And created this spectrum that you can always move along, You’re not limited to just a very simple solution and then You have to throw the thing away and start over with powerful Solution so we think this is particularly powerful and unique To our platform inside microsoft unlike many of the other Competitors out there. So i talked about the common Data service apps and what does that entail? Common data service for apps brings in data modeling which Means that you can create all of your business data, your Business entities, relationships, attributes and put that in a single place that Your business can use and security model can live on top

Of that as well. Then there’s the business logic And this is where we see microsoft flow really fitting Into the common data service for apps because microsoft flow is Way to build business logic on top of the business’s data You could have it to do things like send notification, actions, Do whatever you need inside the data that your business has and Then there’s user interface and i won’t talk about that much today but there are sessions That build about power apps and recommend checking that out if You’re interested in how you can use our high priority low code Platform to build ui and that’s power apps and use that to build Both canvas base and model base applications on top of the Common data service for apps and one of the last things i wanted to mentions on this slide that We hear a little bit of confusion about what’s the Relationship between the common data service and dynamics 365 And the answer is the common data service is the data Platform that dynamics 365 uses And at a time platform and use it in dynamics 365 location and Build customized business solutions with microsoft flow And with power apps as well as power bi and most data does not Live in the common data service so we built a robust series of Connectors and over 200 connectors today actually, the Slide is a little out of date, that allows you to connect to Saas cloud services, file providers, Databases, pi solutions pretty much wherever You have data there’s pretty good chance that there’s a Connector for that today and this shows you just a snapshot Of the connectors that we have available Not only do we have connectors to saas services but ability to Connect to on premise data and have an organizational database That runs inside the local network and actually connect to That from microsoft flow and use that to drive the business Processes. You also can build custom Connectors which allow you to connect to custom end points the Organization may have created and talk a little bit about more About that at the end. Some organizations see the slide And freak out a little bit because hey, there’s all of These places that my company’s data can end up going and how do I keep data from being leaked to places i don’t want it to to go And the answer is microsoft flow comes with rich admin Capabilities built in so that way an organization can feel Secure when using it in way that does not result in data leaking Outside the organization and have things that we call data Loss prevention policies and data loss prevention policies Block data flow from source that may be compliant to source That’s noncompliant and how organizations can adopt Microsoft flow and still be confident that data is not Leaking in a way they don’t expect. Wide variety of standards and Accessibility and also has extensibility and developers That want to extend the capabilities of microsoft flow Can as well and there’s those custom connectors i mentioned And ability to connect with azure and when i showed you the Layer diagram and developer platform really that’s what i was talking about how azure can Be used to extend what you build for power users inside your Organization. One of the things that really Excites me personally is flow is embeddable via sdk in your Application and that means if you build a web application and Want work flows to be natively included in your application you Can actually do that simplify by including the flow sdk and in Doing so as long as support azure directory authentication The user flows can show up right inside the application and Customize those views, so it is an awesome way to bring workflow Capability directly into the app. Besides giving it control over what happens inside Organizations we also solve key problems for it Integration is problem that spans the enterprise and at the End of the day there’s only so manyism t guys out there who can Actually build solutions for the line of business So we really believe that by democratizing the ability to Create business processes so that way any line of business Can create the business processes that they need and Automate them, it will make the job of it much easier because Now they don’t have to spend time building out the spoke Solutions every single time that somebody requests a new process To be built. Technical users inside the Organization to feel empowered, to feel like they can make a Difference and make their own lives better. Sometimes though if there’s a Solution that has been built and need to be able to as it take it Over you can do that as well. And with flow we have built it Directly on top of logic apps which means if you have built a Flow as business user and it wants to take it, they can put

It in it’s azure subscription. Which kind of begs the question, What is the difference between logic apps and flow? Well the reality is there’s far more commonalty than differences Flow is built directly on logic apps and literally the exact Same engine and same ui designer and same expression language and performance characteristics are The same, rely billility is the same, same thing at run time Which means that flow is just as robust as logic apps when it runs But there is a key difference in that logic apps is a Prodevelopper offering and targets people who use azure who Alive in visual studio who expect to use source control who Want continuous integration, deployment, those types Of things and ability to go inside Auto logs inside azure and access via Rbac and those types of things you want for the Workflow you’re building azure logic apps are the solution for you There’s millions — i suppose there’s billions of people in The world that don’t use azure today and flow along with power Apps and power bi are a great option because they don’t Require having azure subscription and don’t require Going to the azure portal and studio and using prodev tools There are a way for people to get started with just a few clicks So why don’t i dive into that? building flows So inside flows there are a few key concepts i would like to Talk about. All flows start with what’s Called the trigger. It is the event that kicks it Off. Can have any number of actions And have additional logic like conditions and flows can have Loops, they can have 4h loop and different types of branches and Parallel branches and build out the business process to do Whatever type of workflow you’re interested in Your flows can then trigger other work flows if you want to Isolate the difference logic between different locations To get started with the flow we have literally thousands of Templates available on the flow website. These templates help you get Started by preconfiguring and bringing together actions and Triggers in way that they are already set up so that way Average user doesn’t have to worry too much about exactly how To wire things together if they are coming and getting started out-of-the-box These templates are great show case to understand if you’re Interested what can flow do. Easiest way to find out is go to The website and browse the template gallery and there you Could see thousands of different ways that users use flow today To improve their business. Once you start using template You will get a flow created and then can go to the flow designer This is a little snip-it here what the flow designer looks Like and obviously i will go into this more detail in the Demo and at the top of every flow is trigger Trigger is event that starts it and then below are the actions For the triggers and actions we have what we call input which is The architect boxes on the those actions there and we have to Configure the input in order to make the particular action work If you imagine sending an e-mail, obviously who you will send the e-mail to, subject of The e-mail is, what body is, et cetera In terms of triggers there are three different common types of Triggers. The first one is you can run a Flow manually based on user taking an action For example, we have a flow mobile api will show new a Use flow to run schedule and say every week or everyday at 4:00 A.M. And this can even respond on daylight savings time And those types of things. Finally, and this is the most Commonly that people run flows, is by running on response to an Event that happens out in the cloud. So if i get an e-mail or file Gets uploader somebody posts rss feed, all of these things can Trigger flows. Then let’s look at the actions Actions can runny number of steps that you like and detect Cloud services to data and on premise gateway and connect to Direct htp end point and if you build api inside the Organization and want somebody to build orchestration on top of The api, want somebody to build process on top of the api they Can simply by using direct htp actions inside microsoft flow

Some actions in flow don’t even connect out to other data Services. Sometimes you can use actions of Flow to transform data. If i want to take an array and Filter it down and store variables inside a loop, convert Something into html table and do that inside of flow Another important concept to understand is how data is passed From action to action inside of flow. In order to get data to be used Inside of flow we have a concept called dynamic content and Really all that represents is the outputs of the previous Actions and triggers inside of the flow. For example, let’s say we have a Trigger here that’s uploading when a file uploaded to a Particular place. That trigger has three outputs Outputs the file name, the size of the file and the actual file content Each of these has a different type. If i then go and add an action On to the flow and i have a field that takes any binary Content as input, i can use any of the trigger outputs in that Action. So let’s say the action is Uploading a file to a particular folder. If i were to pass in the file Name i would get new file added to the folder that just has the File name as contents and that isn’t exactly what i want but i Can do that. Now, that action will in turn Output additional data such as the title of the folder and how Many items in the folder. If i add a third step, another Action on to the flow, i can now use any of the data from both The trigger and the action above it So inside a flow you can continue to use any data that’s From anywhere else above you inside the flow The other important note here is that the data that we show is Filtered based on the type of the field. This means that if i have data That’s output as a number and i have a number field that i would Like to pass data into, i can only pass things like the size And count but i can’t pass the title because that’s a string Which doesn’t match that type. So we do intelligent type Matching there and if you really know that that title will be a Number by convention you can explicitly cast types as well as Side of flow. Okay. So i have been talking for Enough time. Why don’t i switch over to the Demo and, of course, my computer has fallen asleep and i need to Sign in Here i am at the flow home page and go here yourself go to Flow.Microsoft.Com and sign in with microsoft account with or With orgid and don’t need to use the company’s credentials and Website number ways to very easily get started and learn About the capabilities of microsoft flow At the top here we have what we call future template collections And since this is billed maybe you all would be interested in Seeing the types of somewhere development task that we can Automated inside of an organization For example, you can respond faster to customer bug requests And few templates you see here that would help you with that or Improved task management or automate the follow-up on tasks Each of these template which means we have already configured For you the steps that needs to run inside the flow and data Flow between each of the actions and come to flow right now and Just start using these processes. In addition to using the Templates you can also browse the different connectors that we have inside of flow You can learn a bit flow and future templates and templates Have been used quite a bit and first template here has been Used almost 250,000 times. So a lot of great scenarios are Being built out today with flow. We also have a mobile app that i Will talk about in a little bit. So now let’s take a look at the Different connectors that we have inside flow and with that You can pull up and see — pull up here and see at the top we Have a recently added connectors and custom connectors inside the Organization and full list of all the connectors and don’t try To minimize the list. What i want to do for this memo Is simple flow that will create a wonderless task when a new bug Is opened in visual institute and assigned — studio and Assigned to me and what wonder list can do inside microsoft Flow and triggers that the wonder list has and trigger when New task is created, when reminder is due, et cetera, but In this particular case i want to find a template that creates

A task for me when item is assigned from visual studio So when you create from template inside microsoft flow all i have to do is fill out the few Required fields to get the copying visual studio and wonder List and where to put it in wonder list and start with the Account name that my visual studio — i’ll using inside Visual studio team services and specific project name and if i Want i can choose specific team to put the item into and i want To make sure that these items are assigned to me and this is An account i created for the build demo So now i have configured this flow to listen to items created In this particular account in this particular project and Team. The only other thing i need to Do is go to the wonder list list i want to populate So in this case i want to put the task into the in box and That’s pretty much it with just say five inputs here i was able To create automation inside of my organization that enables me To now go to my wonder list list to see all the visual tasks created But as i was talking about earlier there’s not a cliff here Not like that uii show you is the only way to manage the flow now I can click on edit flow and see the trigger which is right here, As well as all the actions that are inside that flow and this is The full flow ui designer that i was talking about Created the flexibility and go ahead and test it out and i’m Going to performed the trigger action and actually go and Create an item inside visual studio so i’m going to switch Over to that and create a new bug and just say it seems to be Running a little slow And assign it to myself and there we go and created the item Inside visual studio and see the flow picked up the fact that Visual studio item was created pretty quickly and almost instantaneously in fact and Created a task in wonder list and switch over to wonder list And if i sink my account i should see there we go visual Studio bug seems to be running slow. So in really just a couple Minutes i was able to create a process that listened to visual Studio and automatically created a task and imagine now it Doesn’t have to be just a simple personal automation scenario There’s actually ways to take this and grow it up whole Organization can take advantage of processes like this And so i will switch back to the powerpoint. Let’s talk about that and go Beyond individual creating simple flow like i showed you That’s useful for themselves to creating flows that are really About driving business processes inside an organization Three different ways that we make flows available outside of Just the context of individual and first is you can have that Owned and managed by multiple people at once and say the Security group should be the people that managed this Particular flow and that’s about management of the flow The second thing to talk about is buttons Buttons are unique in that i can distribute flow buttons which is — Not a physical button, software button and distribute Them throughout the organization and then anybody can invoke Those buttons. That means that i can create Business processes like approval processes like opening a bug and Make it possible for anybody to clip the button and all they Have to see is button and inputs for it and goes and runs without Them having to worry about all the details and iners of the Flow and find people participate in the decision-making process Of a flow by using what we call modern approvals Approvals allow people to be assigned task that they can then Go and run inside the context of a flow And starting with team ownership i can say that i want a security Group, office 365 modern group or just list of people to be Able to manage a flow. Any robust business process Shouldn’t have one person own that because if that person Leaves the company, you want that process to continue running, right? Now, technically if that happens admin still have full control Over the flow so they could go to the admin center and assign To somebody else but you don’t have to get the admin involved If you don’t have to. Additionally the connections That are in flow don’t have to be tied to just one person The connections that a flow uses so in that demo that i just

Showed you, that was my connection to wonder list and Visual studio. Those connections could be tied, For example, to service account and that way create a service Account and as long as named user and ad and have it just Control what you want it to control and use the connection Inside of your flow. And if somebody does leave the Company that flow continues to function So team ownership is very important concept and helps People to create robust processes inside organizations Second thing i want to talk about is buttons and buttons Useful when you’re on a mobile device Flow that is a lot of mobile capabilities so you will see in Next demo how to use flow mobile and use buttons and approval Processes but even monitor activity in wide variety of things The flow buttons can even be tied to physical devices so we Have partnerships with flick and vttn, if you ever heard of Those, that make tiny wi-fi and bluetooth buttons and distribute In an organization and buttons to trigger a flow What i’m showing on screen here this is a software button, isn’t A physical device but button nonetheless and can click and Have that go and run a flow If there’s a six day process and everybody in the organization to Use, i can click the six day button and simply share it with Everybody inside the department and they can click that button And run it and also, of course, get links directly to buttons Show them directly to people via that route as well but buttons Are really the best way to share the ability to run a business Process inside of your org. One other thing about sharing Buttons is sometimes if you would like you can have a button That’s tied to the permissions of something other than security group For example, if i have a process that i want to kick off from a Sharepoint list or sharepoint to document library, i can do that By creating a button that is tied to the permissions of that Sharepoint list or document library and everybody who has Access to that sharepoint list will be able to run that button And relatively new feature that we recently released and built This because people had the pain of keeping permissions in sync And weren’t sure if the people had access to the right security Group had access to run the flow and solve that by allowing these Buttons to be shared directly to sharepoint list Now, the third and final point that i want to mention in this Section, approvals are the way that you can have processes that Run across your business and have many different participant In the same process. If you think about hr, for Example, hr request forms can spend many different people and One of the most common — scenario have inside microsoft Is travel authorization. We often microsoft send people Across the world, sometimes to less safe regions and when you Have approval process that is established to make sure that You really have a true business need to go to a particular Region of the world and that’s built on top of microsoft flow approvals Of course, you have all the things you expect like contract Approval, speck approval, all of these can go through the Approval processes inside microsoft flow And keep in mind flow is the successor to sharepoint designer Workflow which means today if you’re out there and still using Sharepoint designer and using sharepoint work flows, now is The time to start thinking about how to get the processes into Microsoft flow. Flow has the vast majority of Capabilities that sharepoint has today and gaps we are working on Closing the next several months and everything on designer is There and can do it soon. If you have processes in the Organization that use that the, start looking at flow today What does modern approval inside flow offer? They give the ability to view, send and receive requests and Ability to do approval on the go, right from the phone or in Box and we have actionable message support inside outlook So if you’re in outlook and get approval and single button and Respond or reject to the approval request The approvals can be customized to meet the specific business Needs. So if you want sequential Approval, want one approval after another and parallel Approvals and two or three or five people to handle approval Process you can do that by using the flow designer and i will Show you a simple example of that right now

So to build this flow rather than building from a template What i will do is create from blank. Create from blank is how to Create any type of process that you would like and when do you Your first presented with popular triggers that might help You get started but what i want isn’t in this list and what i Want to do from this flow is create a button to share a Colleagues that will create a bug for visual studio for the specific product or team When first presented with a list of all the different connectors That have triggers here and this is just a small subset Here you can see when i click see more there’s a huge number Of connectors that we have Available that can trigger flow and i want to use float button And select — flow button and select and it has been added Flow button i would add any input that i would like and Different types and file upload associated with the button and Want somebody to take a picture with the phone and upload the File to send along with the flow And add text input and bug title Next i’m going to add actions into the flow and can do that by Clicking new step and adding an action Searching for actions is just like searching for triggers and That i have a list of connectors as well list of actions down Here and can see here the 327 actions that we have recommended This isn’t actually the full list because you see here There’s three for outlook and actually about 30 actions for Outlook and thousands of actions can use and that’s out the of Box ones. We also allow you to connect to Any of the custom services as well so really the possibilities Are limitless with microsoft flow For this example i would like to start approval process so i can See more here and select approvals and when i do that i Have one action the approval has and added on Two types of approvals that the we support and first is anybody Must approve on the approval list and another one is Everybody must approve and think about the difference between that one is much more probust Than the other and somebody to say this is okay and other is i Need everybody to say this is okay However, for the demo i’m just going to be able the only Approver and doesn’t really matter which one to choose Going to populate the title of the approval request and when i Do that that dynamic content popover that i talked about Earlier pops up and can see here the list of all the outputs from The button trigger and so in this particular case i want the Title to match the bug title and in addition to using dynamic Content i can use content directly into the flow designer Of course and some fields are intel jen, so this one is e-mail Field and it automatically can do auto complete and since i’m The only approver i don’t need anybody else on the list Next add condition into the flow and condition is branching logic And when i do that get if yes branch and if no branch and Inside the condition i’m choosing what i want to check And 99 case i want to make — check the approver and response From the approver is equal to approve. So that will make the flow go Down yes branch of the flow and as long as i approve the request Now on the branch i can add the specific action i want to flow To do and in this case i would like to find a visual studio Item to be added so i search for visual studio and it shows me All of the actions at visual studio has inside a flow and 11 Here, seven triggers so a lot of things to do with visual studio But in this case i would like to create a work Item. So when i create a work item Similar to what i show in the first demo but i have to choose The account as well as the project that i’m interested in In creating the bug in Like to put the title into the work item and use the bug title And output from the trigger and accumulate and step above it and Start approval or from the trigger add additional actions On you will see i can use any of the data as hong as it matches The right type. So i just need to give this a

Name, say bill demo and hit save and now this flow will be saved And start showing you mobile device This is the flow mobile app here and inside the flow mobile app And first tap we have activity which just shows you what’s been Happening with the flows recently and see here i have Flows like outlook task, create that task and note for assign Visual studio and that was a flow that i ran in the first Video, 13 minutes ago and see all the flow activity here and For this demo click a button to start approval and buttons tab Here gives me all the buttons that i have created inside of my Account and actually go get buttons from the lock screen on Your phone so if i lock my phone here you can see there’s a flow Button section in the widget and that build that i created right From here. Let’s do it from the app and go To the build demo and click the button and as soon as i do if You remember i had to provide the bug title so i can say Here — you know, if i can spell properly and hit done As soon as i do that it is going to start running the process and See i immediately got the approval request and i was the Approver and now in real life have different people submitting The bug as proving the — approving the bug and what’s the Point if it is one person and demo purposes i have done it all At once. As you can see as soon as i Clicked on the notification, tailored ui here showed me what I typed in the bug, bug title, who it came from and it was me, What time and want to approve or reject the incoming request so i Will go ahead and approve it and actually no, i will reject it Because — no i will approve it. Approve it and add comment if i Want and hit confirm. As soon as i do that it will go And create item inside visual studio So i will switch back to the desktop and see if that item got Created. I will go back to the list of Bugs and see here bug just got created and been successfully Put into visual studio after i triand it from my phone quickly And enhance the approval process as much as i wanted and one of The things we support in flow is, for example, adding parallel Branches so if i wanted two people to be handling this Approval in parallel, i could do that here You see when i do that get the same ui we have seen a few times Before where i can add parallel actions in and say hey, i want To start separate approval and send this to somebody else and Want, for example, to do escalation path for approvals, i Could do that by after that second approval and get the Manager of the person that approved the first request and Then i could add yet another approval action below that and Imagine how build the approval flows to meet the businesses needs So now i will start talking about one of the more advance Concepts that we have inside microsoft flow So that was hopefully the easy part and now let’s talk about Expressions. Expressions are the way to make Advanced consent inside microsoft flow and if you have, For example, type kind you want to convert and math and divide Two numbers or add or subtract or do something like that and Get the current time and one of the most powerful things you Could do inside expressions is use the if conditional which Allows you to say hey, if this value is equal to something, i Want to select either a or otherwise want to select b, so Just like if inside excel. So our goal with the expression Language was to make it similar in concept to what inside excel Formula is today. The actual language itself is a Little different because based on azure logic apps but concepts In many ways are similar. The big difference is that with Flow data types are based on json which means if you ever Used javascript or equivalent language, you’re already know

What type data we support today. Talking about the nontextual Types and arrays and those behave like the json types that You’re familiar with and even support xml content inside Microsoft flow so if you have legacy api that returns to xml And convert to json. In addition to nontextual types We support strings. Api bay 64 object or returns Back something that’s uri enclouded and handle that as well Strings inside flow, inside expressions and see that in a Second, need to use single quotes to wrap the string and Different from how languages often time double quotes but something that’s reason i will Mention in the future. One final note here because of Data types the string tlue does not equal the token true and Make sure making putting proper data type in when constructing Strings directly. So how to create expression and Saw me click the add dynamic content button and when i got That i got a dialogue popped up that had dynamic content tab and Second tab there called expression that i can click and Build in expression there. As soon as i do that i can hit Okay and get expression placeholder placed directly into The action let’s break apart what exactly the expression Looked like. Let’s say this example object i Have output for previous step and three properties Id, title and name. What i want to do is take the Title and replace that placeholder which is bracket Time with actual current time stand and i will do the string Replace function and first type the expression and have to Understand how many parameters that that expression has For a place there are three parameters. First parameter is the string That you’re passing in and second parameter is the string You’re searching for in it and third parameter the string you Will go and replace it with. Once you know what the Parameters are you can start filling it in and for the search Stringy want to just type in bracket time and use single Quotes there because that’s illiterate and search for Next you can use other expressions inside of this Expression on right-hand side there i’m going to call the utc Now function that gets the current time stamp and and on The left i’m going to get the body from the record step that Actually output those three properties Finally you can dereference into json objects as far as you would Like and in this case i have title property from that and i’m Going to use the square bracket syntax and also use the json dot Syntax to get to particular properties. So with these few steps i was Able to construct and expression that replaces content with the Current time stamp. And one of the things that is Important to work with in expressions as well is arrays And unfortunately inside flow arrays are probably one of the Most difficult things to work with and bunch of different ways You may want to use array and arrays composed of many Different things and array of strings or numbers or objects Array of objects and pass that to another action, schema of the Object may not even match with the — between the source and destination So sometimes you have to transform arrays inside and use Expressions and actions to do that. Actually use expressions and get From a list. Get the first item from the list And last item from the list and use expression to do that and Filter a list down and take set of items and reduce you can do That as well. You can deal with arrays and Advanced array handling and reading up on documentation on The different ways you can do that How to handle errors and normally when a flow runs it Runs in sequence which means it runs first step and second step, Et cetera, and if any of the steps fail all the subsequent Actions are skipped. That means that a single fairly In flow if you don’t handle it properly can result in your

Entire different process being terminated so what we have done To prevent that though is creating air handling actions And handle action anywhere in the flow, beginning, end, Anywhere you like and run after previous action has been failed Or skipped because of an action above it failed This is allows you to create more rebust processes by sending Yourself notification and undoing a previous action and Whatever you imagine inside of your flow So now i will switch over to my next M o I will modify the flow i created from the first one and what i Would like to do today when i created this flow created button That i could trigger think it would be more interesting if i Could have all the people in the audience trigger this button to Be able to open bugs for us. So what i will do is first Remove those outputs from the trigger so i can change it and i Will change this from a button trigger to a e-mail trigger and Set up in box that i can actually use to get ideas be Submitted from you all in the audience and just in a Particular folder that i have here, full contact So now this flow rather than listening to awe button now Listens to new e-mail arriving. E-mail can come from anybody Next i can update the approval action to use say the subject of The message as the — as title of the bug. Another thing i want to do is Create a live power bi dashboard that shows me how it is Executing and do that by pushing data to streaming data inside of Power bi. So i can search for power bi Here and see we have an add rose to dataset action inside of that flow Then i choose what power bi work space and in this case it is the Flow contact work splays and as Well as the dataset and what i would like to stream data into And when i do this you would notice that we have gone to the Particular dataset and gotten the columns from the dataset and Each dataset may have distinct set of fields but in this case It has particular fields here that i have created for the demo For the name of the person i can pass that the In, for the idea subject of the e-mail and status Will start out as pending and for the date that’s when the E-mail was received. So that i have added at the Beginning of the flow and other thing i need to to is add an Action at the end of the flow to push to the power bi streaming Set and approval has been completed and another row to the Dataset and pick the same work space that i created before and Same dataset and same table and likewise i’m not going to change The name so come over here and also search inside dynamic Content, so wanted to search for the from and a lot of outputs And previous actions and faster just to search so i can do a Subject and for the status i’m now going to pass in the status From the approval action. Go and hit the response Now i’m going to use the expression and using content tab Extensively and come over to the expression tab and gives me list Of all the different options that i have for filling an Expression. Get the current time stamp and Come down here i can see there’s utc now and a lot of them Actually and over 100 different functions you can call and just Going to use utc now and hit okay. Now that it has been added and Track duration how long it took for me to approve the request And writing more advanced expression, so this expression Is i will subtract two day times and type suband notice that Shows you parameters of the expression as you go

Soil subtract — i want to subtract — from the current Time stamp and need to convert the time so that way i can do The math because you can’t subtract two strings obviously and taking ticks of utc now and Other thing i will do is ticks of receive time of the e-mail Now, in this popover i can switch back to do the dynamic Content tab and fine that received time that i had and Automatically drop in the expression for that Particular — for particular output so you see here received Time is actually a property inside the json object and Scroll over there. Look like i lost the output but Rebuild it real quick Now, if i save the flow and looks like i have valid Parameter somewhere and let’s take a look at exactly Where that is I have removed subject from here and put That back and misclicked again and try one more time and If this doesn’t work i will switch to the Backup flow. Killed it again and switch to The backup flow now and not that ever happens in demos and we can See that i built but 1 hour ago And expression that i put there and can see this is what it is And oftentimes you can always just click on this to edit it Again when everything is running exactly as it is supposed to be So what i’m going to do now is turn on this flow and if you Would like you could send e-mail to Flowcontact@service.Microsoft.Co m and it will start kicking off The approval process. So again, so type it On the screen type properly, Flowcontact@service.Microsoft.Co flowcontact@service.Microsoft.Co m Send the e-mail and started kicking off approval process and Created this power bi dashboard here that takes that data as you Go and prepopulated with ideas that i already had put in but You see somebody put in get the slide deck for this Session and as people submit more ideas this Will start going and now what i can do is triage the ideas to go To the approvals tabs and request about getting the slide Deck for the session that should actually show up here and see Somebody submitted this and approve this because i believe All the sessions are streamed and fully recorded So say great idea and hit confirm and go back To the power bi report now because i push that second event It will actually see approval grew a little bit more and Latency for doing the approval, .71 Minutes and more coming in And did encounter bug and work on that and how build flow that Uses a lot of differentia exits Inside power bi and huto do air handling action and i can show That at flow and go ahead and Add at the end Flow has failed When toy that the i can go up to this dot dot dot menu and Different settings for action And policy and other thing that you could do is figure run after And how you can make an action that runs only after the

Previous action has failed or was kept When do you that, you may notice that the designer it highlights The arrow red to indicate that this particular branch will only Run previous actions failed so that was building out a flow That uses expressions. So for the final section talk About how to take the flows and grow them up into logic apps and With the flows today you could already call logic apps directly If you like so because flow supports calling arbitrary htp End point, in the flows you could make that call to have a Flow or logic app that has a trigger called request and Request trigger allows you to receive htp call and a little Hard to see url and copy and paste and use and use that Isolate logic and pro developer come build key logic inside the Logic app and call it a flow and flow is mechanism Likewise if i really want to take a flow and want to convert That to logic app, i can do that by exporting float as logic app Resource definition template and wherever you go to flow in that More menu there’s two ways you can, in fact, extensible — Export flow and across Environment and useful say if you have dev environment Test them out to make sure they work and don’t encounter areas Like i did and go to production ver And get simple resource definition file and with that File when you bring it into the azure portal you have to repair the connections for the Particular logic app because connections that live inside of Flow are tied to a particular owner or individual in that Environment whereas the connections that live inside Azure are stored in the resource group so you do have to use new Set of connections when you bring the flow over as logic app App. There are limitations that go From flow to azure. For example, not all connectors Are available inside logic and connectors rely on the flow app Are not available and flow button, approval and Notification are not available inside azure logic apps today And building the process like the last one i showed you, that One you have to use flow for. Besides that you can really Bring any other capabilities to logic apps you want Finally as i mentioned you can call logic apps from flow as thm Or custom connector. Now, custom connector has whole Dedicated session tomorrow and if you’re interested in how you can build connectors in our Organization and allow people to call isv application if you have One you can do that by building a custom connector strongly Recommend check out that session if you find it interesting Embed flow into websites and screen shot me of doing it with Wunderlist and frame many different types of flow views And put them into application and have application and create Own set of templates and capabilities with flow and get That with url and slides will be posted you could come to that Url later if you like. For the last demo i will show Real quick how to take a flow pp and What that looks like. Go back to the list of flows and Take a simple flow like the disflow and go to the menu here And hit export and export as logic apps package and say this And go with azure portal create a resource from template by Searching for template in the market place And select template deployment and because i downloaded that File and actually upload it into the template uploader here Hit load file and select that flow that i exported and hit save and then give it a specific Resource group name. I have to give my logic app name

And it will automatically create those connections for me and i, Of course, agreed to the terms of conditions, blah, blah, blah, And it will go and start creating this logic app from That definition that i downloaded. And take a few seconds and click On this to see the progress And deployed the first connection and there we go and Completed in ten, 15 seconds there and open up the logic app And notice the logic app disabled by default and Connections aren’t yet configured and before i can Actually make this logic app work select edit and open up the Logic app designer and when i do that notice it gives me warnings To indicate that indeed i have to repair the connection so Single sign-in working properly and grant access This creates a connection in this particular logic apps Resource group and same thing for wunderlist and take a moment Is he and then i can hitst and now logic app is able to go and It will run instead of the flow inside of the — flow portal That i created and edit this, can each go back and see the Full code view for this logic app and take in definition and Source control and do whatever you like with it as a prodev Capability from the azure port portal Just before we close i will leave a few minute for q&a and Stick around afterwards as well and talk about i awe more Things. First, how was microsoft flow available Get it as part of the office 365 or dynamics 365 subscriptions so Include, for example, 2000 runs per month with office 365 Second if you don’t currently have office 365 and dynamic 365 You can purchase flow for $5 a one for flow p2 for $15 a month And additional runs and additional features as well We have a public road map which is available here and i won’t Read through all the bullet points on the slide but some of The interesting points are one were continuing to improve the User experience, provide better guidance for debugging flows, For example, when they do fail and further up q3 will have rich Html text editor and doubling down office 365 integration and Use flow better from inside of sharepoint and inside exchange And we have more compliance capabilities coming and gdpr and I’m sure all of you heard about gdpr and that coming soon and Fully compliant there now and bring in more data residency in The coming months. So definitely check out road map Offline if you get a chance and number of other sessions coming Up so if you’re interested in learning about custom connectors Check it out, learning about how to embed flow in your own Applications we have isv session coming up as well, so definitely Check that out and you could get started. So with that i’m going to open It up to q&a and so if you wouldn’t mind coming up to the Mic and people on the webcast can hear You and that would be great. Or if you don’t have any Questions we could end early [applause] >> Microsoft flow and compared to existing and mention earlier And share point on premise and designer workflow what’s in the Gap, flow would be the successor to sharepoint workflow and Explain more on that? especially on Premise and involve few areas and sight and Administration like ability to create and manage sharepoint Sites and doc set management and so if you’re using capabilities Inside sharepoint workflow and don’t have native actions to do Those today and any web api and httm web point and get the nice Kind of ui designer show there and put the json object for Making that api directly and anything do in sharepoint

Designer and closing gaps in terms of action sets in the coming months >> Thanks. >> Thank you >> General question on that flows there and timeout on there And is it possible timeout could be infinite in the flow and Overall — is there overall lifetime in flow and after Certain period of time? >> flows last for up to 30 days Today and that means any individual action also can’t last more than 30 days, so like Approval action if i don’t respond within 30 days, it will Be sampled and create timeout that’s like starts new flow >> 29 Days if still with that start the new flow >> Of. >> Times that are skipped and Putting that in the end and effectively the global air Handler. >> Workflow and sharepoint Thinking about other things like in dynamics things like that That has own work flows, is that kind of what you see flow Becoming eventually as well. >> Goal ultimately will Microsoft just has microsoft flow and shouldn’t need separate Workflow for dynamic and sharepoint and all the various Other applications that we have. The number of gaps we have with Dynamics is bit bigger than we have with sharepoint today and Can’t tell you go on flow and nd Inside integrity that runs integrity with dynamics 365 and Continue to use the dynamics 365 workflow is the right choice >> Thank you. >> Sharepoint on premise? >> So flow will probably forever Run only in the cloud and gateway to connect sharepoint Gateway for premises and data can be on premises if you want And as long as okay with that and sharepoint on scenarios Any other questions? okay. I will >> I t department is going to build flows for a lot of people And so we are concerned about, you know, don’t want an Individual user or group of users to own that because if They leave, right, is it a good practice to have a service Account to basically own the work flows? >> yes So i would say in terms of ownership of the workflow Itself, security group should be find and make sure it dev team Has access to security group and security group owns the flow For specific connections inside the flow that’s where service Account comes in and grant service act — account for Whatever connected to in case something goes wrong with it >> Ask two questions. The first just ties on to what You just answered about on premise and install on premise Update or call a flow when record created on on premise Sharepoint or dynamics 365. >> So on premise sharepoint you Can trigger flows as well. >> Is there something we have Installed to do that? >> yeah. So it is on premises data Gateway. Same gate away power bi uses as Well and common layer between power ups and flow uses same Technology. >> Second question is sort of Similar which is is it possible you said you can call logic app From flow, can you do reverse and flow from logic Apps? >> create trigger request Trigger which is the end point, call that from anything so call From the logic app if you wanted as well. >> One more, because now Microsoft mentioned that flow is going to replacement, successor For sharepoint designer workflow. When do you — when do we Anticipate microsoft saying for the dynamics 365 workload? >> Can’t give specific timeline and at this point we are saying

Publicly that in the fullness of time all the capabilities that You can do inside dynamics workflow will be inside microsoft flow and it is not the Case today. If building a solution today you Have to make that choice between hey am i doing something Transaction inside the data or doing something that’s kind of a Synchronize business process. And there will combine under one Technology stack. I will stick around if you want To talk any other questions, feel free to stop by Thanks a lot for spending time Ct-with me today [applause]