Microsoft Flow Bootcamp | Andrew Seeley | Skillshare

Playback Speed

  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Microsoft Flow Bootcamp

teacher avatar Andrew Seeley

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

61 Lessons (3h 24m)
    • 1. Course Structure

    • 2. First flow

    • 3. Flow on mobile

    • 4. Flow key elements

    • 5. Triggers Overview

    • 6. Scheduled Flow

    • 7. Event flow

    • 8. Triggers with twitter monitor

    • 9. Capture tweets in email flow

    • 10. Flow whiteboarding

    • 11. Dynamic content

    • 12. Variables introduction

    • 13. Text, Number, Boolean

    • 14. Arrays

    • 15. Arrays to a string

    • 16. Expressions

    • 17. Advanced expressions remove comma

    • 18. Variables Wrapup

    • 19. Sharepoint Intro

    • 20. Sharepoint dev account setup

    • 21. Sharepoint list setup

    • 22. Add to list

    • 23. Add to list with flow input

    • 24. Deleting from a list

    • 25. Update a list item

    • 26. OData introduction

    • 27. OData in flow

    • 28. Sharepoint things to look out for

    • 29. Sharepoint wrapup

    • 30. Control flow intro

    • 31. If statements

    • 32. Apply foreach

    • 33. Do Until

    • 34. Switch statements

    • 35. Control flow wrapup

    • 36. Twitter more flows intro

    • 37. Dev account setup

    • 38. Notable tweets

    • 39. Flow approvals

    • 40. Schedule delay

    • 41. Tweets to excel

    • 42. Twitter wrapup

    • 43. Advanced flow intro

    • 44. Parallel Branching

    • 45. Merging branches

    • 46. Scope

    • 47. Termination

    • 48. AI Builder intro

    • 49. Sentiment Analysis

    • 50. Image to text

    • 51. Flow Error Handling

    • 52. Flow AI Model animals

    • 53. Flow model AI animals in flow

    • 54. AI Builder wrapup

    • 55. Advanced flow intro

    • 56. Postman install

    • 57. HTTP and rest

    • 58. JSON

    • 59. HTTP Trigger

    • 60. HTTP Get in flow

    • 61. Advanced flow wrapup

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class

Ever wish the mundane daily tasks could be automated?

Learn from an instructor who delivers enterprise Automation projects and has been actively involved in engagements that has won global RPA awards.

Intelligent Automation is at the forefront of disruption, also known as the "digital workforce". It is transforming the efficiency of every organization function from finance, tax, HR and IT. This saves hundreds of hours of peoples time to focus on more higher value tasks.

What does this mean for you?

There are HUGE opportunist in this space right now, RPA grew by 63.1% in 2018 to $846 million. It is currently the fasted-growing segment of the global enterprise software market. This course will enable you to get a first mover opportunity in this market, and also prepare yourself if your role is at risk!

What will this course do for you?

This course will give you a clear overview of the Microsoft flow. We will develop our very own flow to automate a manual process!

Further to this we also take a look at the best practices when it comes to implementing your flows in enterprise grade environments, along the way you will also encounter common issues working through to resolve them. Hint - without help this takes up a tremendous amount of time otherwise! All this is taught in a manner that is akin to hands on experience.

Key learning on this course:

  • Understanding of flow key concepts

  • Integration with various tools (Sharepoint, Twitter, Email and more)

  • AI¬†Builder - integrate machine leanring into your flows

  • Advanced flow with API¬†calls

  • Scheduling and approval flows

Meet Your Teacher

Hi I am Andrew.

I created Seemu Apps to create and share knowledge I have gained on my journey in learning iOS app development. Too often would I look up on how to solve a problem to only find an explanation that seemed to be written in an alien language. As my skills have developed I can understand these solutions, however I remember what it was like to be a novice!

I have been programming since I was in high school and have been developing for iOS for 2 years. I currently have 12 apps on the iOS app store - one of which reached the Top charts in the Lifestyle category for most countries.

My aim is to share my knowledge by creating the courses I wish I had access to when I was learning development.

I also run a youtube channel and website which has quick tut... See full profile

Class Ratings

Expectations Met?
  • Exceeded!
  • Yes
  • Somewhat
  • Not really
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.


1. Course Structure: Let's have a quick look at the structure off how discourse to send out. There's usually two K topics split up section by section, and they are foundational topics and implementing actual flows. The foundational topic will cover the foundational flow elements. These are used in every flow you create, and we'll start with the basic once, and it will get more advanced as we progress throughout the course. In between learning those foundational topics will also look at flows, which is specific application or applications. And we're going to look at SharePoint, Twitter, ai Yoda, the Mouse, and so so their various sections in this course are the introduction. Then we get into triggers and for what they are, how they used to actually run afloat. The actions and integrations with applications of influence will take a look at the variables that can actually score data and retrieve data for later on. Then we'll take a look at SharePoint list, adding items, deleting items, editing items and so on. Then we'll look at a foundational topic around control flow with, If statements switch statements and so on various twitter flows in more detail. Then we'll look at advanced control for so some more events, teaches and floor that you can use an interview plays. It'll finally take a look at flow ai. So take a look, get a I build on and integrate Sean machine learning models in 12 Flows and even create our very own custom model. We'll look at some Advanced Floyd topics around AP eyes and taken. Integrate them to know only run your foot, but also get an update data and then congratulations. You've finished the course Second, See, there is quite a lot of contents, but it is divided up, as I mentioned into foundational topics, which is every two sections or folk. And then we actually look at a complete and total applications. Such a SharePoint Twitter float A I and so on are at how we can implement these for out, of course, and along the way, we're also going to look at common issues Iranian to such as errors, good naming conventions for your phone until one, and that's going to be sprinkled threats hole course. So you get to know that along the way, So let's take a quick break and jump into the rest of the introduction 2. First flow: it's time to make a very first power automate floor. What you need to do is in your address. Bar had to flow dot Microsoft dot com that will automatically redirect you. And that might ask, What country in when you load this page will sign in. So be sure to select the country you're in. I'm going to sign in. You will have need toe already set up on Microsoft account, and I'm just signing it now. And once we sign in, you go to the flow landing page on. You'll see it's got a bunch of templates and popular services. Two years here, various navigation items on the left, such as home action items. My flows create templates, connectors, data A. I build all learned that someone I don't need to worry about all that for now. We're going to come around to that later. But let's just focus on getting our very first floor going, which is super easy. So in order to create a four, you can either go create. But we're going to go to the my flows screen because this will allow us to create one for a blank template, cause a lot of them. Com pre populated, and it's good to see how it works from the ground up. So we're gonna go to New Instant from Blank. You'll have all these options. Were just going to skip this, and you could see we've got out floor here. So what we need to do in order to start it flow, we need a trigger. We're going to use a flow bottom for mobile to trigger this, which you can still run on desktop. So simply select that. Then, on the triggers. Click on manually trigger floor and you'll see we have this first step up here. So this is the entry point to your float, and it's going to start with a manual trigger by clicking on a button on your mobile or running it in the Flows control panel, then toe actually do something. We go, you step. You see, there's several actions here we can take. What we want to use is male, and you consented email notification. Simply click on that, and you'll be asked to accept the send grid terms of conditions to accept that once you've done that, we need to do is put in an email address you want to send it to? I've got flow. Underscore foundations at outlook dot com as an entomologist subject will be Hello world, and my email body will be Hello there. With that done, we can name our floor now. So in the top left, we've got entitled. Simply click on that. We can name this my first floor and once we're happy with it make sure you hit the save button to save your floor. You could see its saving and now it saved. We've got our very first flow set up. Congratulations. So how do we run it? Simple. We have this test button on the screen here. Say simply click on that and you have these options to test the flow. You just want to use our phone trigger action, go save and test. Have to simply run it. All you need to do is hit. Continue. Then down the bottom, there'll be this run now bottom. So click on that. That's going to run in the background and we can see it's run successfully. And all we need to do now is head on over to our mailbox and we can see our in box here we haven't received anything yet on what you need to be careful for is sometimes with automation software and scripts. E mails will actually go directly to your junk mail folder up. So if we see here, we can see I've got two emails. Got one I created earlier and the one I just created. Now we could see would click on it. We've got the email from Microsoft, perhaps, and automate the subject is Hello world and we've got hello there. I'm going to market as it's not drunk, so it moves it to my inbox and we conceive. We have the email here, So congratulations on setting up and running your first flow. You've taken an exciting step on your journey, and it's just absolutely amazing. Thesis Implicit e and the capabilities off Microsoft flow to do some pretty complicated task without needing to know coding or even spend a lot of time going into the details. If you need to set up a small task for yourself, toe, send emails, download files, upload files, check social media. This is a perfect tool for it. So we're going to take a quick break and we'll go to shame the next lecture. How it can actually trigger the flow on a mobile application 3. Flow on mobile: okay with credit. Our very first float on. When you go under my flows, we can see it listed here in power. Automate. Now I'm going toe so something that's absolutely amazingly powerful. And that is on your mobile device. If you go to the APP store, search up power order mate and install it. This is on IOS or Android and now I've got it open here. You'll need to sign in with the same account you're using for power automate flows. And on the landing screen, you'll see your activity for the flows. You see a browse, bottoms and floors down the bottom. I go to bottoms and tap my first float. It's actually going to trigger this float that I've created to send that email. So I'm in my email inbox here. Now let's tap on that bottom. We couldn't see it started the float. Let's give it 30 seconds. Boom! We've got that email here from Trigger Floyd. So that's what the bottom floor trigger by my mom needs is you can actually trigger from your mobile device. You can still trigger online, but this is super powerful in the fact you don't need to be at your computer and you can trigger anywhere at all. And what will cover letter on this court is you can actually provide inputs to these buttons secret. Click on a button and say, Provide someone's order off a product. Let's to say it's toilet paper rolls and you want to order 5000. You could put text boxes that come up when clicking on these buttons to put those in so really powerful. And what's also cool is you wouldn't use it as often. But if you go to the flows, you can actually go into your floor. Click edit float and you can actually edit your float on the mobile so it can rename it. Change the settings. I can change the email address here. The subject, the email body and so on, so really helpful If you realize you're going somewhere and you're like, Oh, don, I forgot to add something to my float. Well, you can jump on your mobile and it directly from their That's way. It's working immediately, as you intended. One final comment on this topic is I just want to go back to the floors website. If you hover over my first floor. You can see this run, but in here, which will also run it, or you can click on it. You can see you have run up the top if we click Run as long as we've set it up to trigger on button within. Click run now and you can see we can also run up from the Web interface so you don't just have to run it on my bar only with a bottle. 4. Flow key elements: So just before moving on into creating flows, let's take a look at the three key elements that make up off lawyer. They are triggers actions and finally connect us. Triggers are is what is used to start afloat. There are three types. You could run a flow with a button, which have already done from a website or from the mobile app. You can schedule afloat so you can make a run every five minutes every 10 minutes and so on . Or you can trigger on events so you might have an email inbox. And when you get a new email, you run afloat. Or you might have a list on SharePoint where when someone adds an item, you trigger a flood. Next up, we've got actions. This is what's used to do something, whether that be sending a file, saving a file, getting the Weber posting on message to slack all teams, updating a SharePoint list or booking a meeting, and so on. Then, finally, we've got the connectors. The's connects to different services together. It's the glue between different applications, such as getting a tweet and sending it toe outlook. In an email, a message taking something from SharePoint and sending a notification when someone tries to make a purchase order over $1000. So then my ball Fine. Oh, sending a message to tame, for example. So what I want to do quickly is just jump into a white boarding activity because I find sometimes that's the best learning. When you get an actual white board or physical piece of paper and draw something out as to how it works or how you would plant would work, it just solidifies a lot more in your mind. So let's go over an example for you could create and identify the key elements of the flow , which triggers actions and connectors. Okay, with what we want, let's take any quick white on example flow to see how this might work in an actual floor. Okay, first of all, in our Florida, we're going to start it with a triple, and this is gonna took run once every five minutes on a schedule. So once every five minutes, run the ball and one every five minutes way are going. Teoh, use another action to go to the Twitter, pay off our company and get any negative responses. What sweet that we have seen. And after that, the next action in a war Will Bay should be mild. It's negative tweets to myself, so you can see here in the floor. We have a trigger at the start. Then suit actions. The 1st 1 to get the negative place on the 2nd 1 Email them to myself. Now you may not realize it, but we actually also have connectors in this slow. And the thing is there subtle that exist in the background. And they really are the core, which makes Marcus off power automate flow so useful. So let's look at weight where they are. So what connectors are is you, Satan? Between the actions, we are getting tweets here, and then we're emailing to myself. What these do is the connectors make us able to take the output off one float and use it in another flow seamlessly. So although we need to do is take this tweets, put them in email, there's no special set up for integration or it just works. So that's what connectors are connecting different applications together that wouldn't otherwise communicate with very Twitter. Email. SharePoint one drive Dropbox, Yemma and so on. Now that we've had a look at this example, here's some examples from the Microsoft website on what we've covered around triggers, access and connectors can see here in Excel on the left, you can delete a row, get a road, get worksheets up there to roll on someone without look here you can create contacts, events send emails, even delayed contacts delayed a miles and so on. So there's a ton off connectors in actions in floor, and that's what makes it really powerful, seamlessly connecting different applications together that don't otherwise talk to each other. 5. Triggers Overview: So in power. Automate Florida Way have three top traders. They are a button, A schedule and finally, events we've already seen about in action. This is way from click on the bottom to run a flow. It could be on desktop on my ball, and you've already seen us set up in our first flow in under five minutes, where we can click on that button to send an email. Next up was scheduled. This is a way just set afloat to run every certain amount of time. So it could be every five minutes, everyone, our once a day, once a week on so on and finally, events. This is where flow will run when an event occurs. When you receive an email, one of follows uploaded toe one drive when a, um, opposes made. So the flow is dynamic and will respond toe actually vantage current. So we've already looked at Baden earlier, so what we're going to do is take a look, it setting up a flow based on a schedule and then events 6. Scheduled Flow: So we've already created our first flow, which is triggered by a button. Let's look at a Floyd that is run on a schedule. I'm going to go to New Instant from Blank hit Skip and then we'll see how floor Here you'll see all the connection and triggers and to run on a schedule. What you need to do is social schedule and then you see schedule, Come up here, click on that click on the re current schedule, and then you can run it every minutes, seconds, Alice days and so on. For this exercise, I'm just going to run every three minutes. You've also got advanced options, which ally to set a specific start time that actually start running. That's scheduled float. Then we can go next step we can put in mail. I'm gonna go send me an email notification the two will be flow. Underscore foundations at outlook dot called Put in your own email address here he likes Hello there for the subject in my body will be This is from a scheduled for Live that down Let's hit Save. I'm gonna set the title to schedule flow. Let's it save now Let's go back to our floors. We can see here. We've got scheduled for here. Status is on. You can see it's already ran 16 seconds ago. So for go to arm out box and the other one on the junk email, we can see I have Hello there. This is from a scheduled flight. So that's how we could schedule outflows to run on a set interval. Be careful because, as mentioned in a previous lecture, there is a limited amount of times it can run flows per month on the free and the first year paid pilling. So what you want to do is in your floor. Go to the turn off bottom to make sure you disable that because if it runs every three minutes, it's going to keep on sending your emails non stop and use up all your quarter for the mouth we can see here. Your flow is off for scheduled flow, so let's take a quick break before we look at event flows. 7. Event flow: OK, now it's time to take a look at float events to trigger afloat. Events are based on external actions when in certain event Claire's we've in some sort of application for this example, we're going to use one driver where when you create a file in a specific photo, it's going to trigger outflow to send an email. So to set this up, we're going to go to New Instant Fly from Blank. Let's skip in the upper right? We're going to name this one Dr Create file, then under connections and triggers, you're going to see one drive for business or one drive. We're going to use one Dr. But if you do have a one drive for business account, you can use that. It does offer a bit more functionality. But before we do that, head on over to one dr dot life that come. And if you haven't signed up for an account, you should sign up with the same account you're using to create flows. So that way you can access it easily. Once you've done that, you have your standard folders and files. Here. All we need to do is go right click and you photo and we're going to create a new for 1/4 floor and then we can see here you have a forecourt flight. So what we're going to do is set it up. So when we create any sort off file in this folder flow, it's going to send us an email. So going back to power order, mate Flow, select one. Drive for your triggers, you conceive. Got multiple option to you when a file is created. DeLay did mortified and so on. We're going to use one of fall is credit. Now you will probably need to sign into one drive here. So hit son in. Put in your account details. Then you'll need to allow power automate to be out of access and use it. I want to do that. You can simply put in the folder here so the right side would put this show father icon simply open that on the right. Click the hour. Then we conceive Got the floor folder. Select that then going, you stop. I'm wet. Simply going to use my only guy. Send an email notification going to do to flow. Underscore foundations outlook dot com The subject is going Toe bay. A file was created in one drive on in a female body. We just put the message. You should check it out when that soul don't hit, save and once that's saved, simply goto one drive, go into outflow photo and then right click. Then you just create a plain text document. Open up a new window. It could give a document. Name will fly, Test it create. We'll talk and test hit. Save what have created this. It might take anywhere from 3 to 5 minutes for the flight to run. So this is my email inbox here. We can see we haven't got any e mails from one drive yet around the creation of it. If we had another back to power automate, we could go to my flows, leave the page, go to the one Dr create false. We click on that. You can see a history off when the flow runs. So let's just wait Hit, refresh until we see it's actually run because on the free plans, deploys don't run as often as the pay plans. So therefore, has a quite wrong yet. So let's go back to our Floyd folder one drive. Let's create a new word document just to make sure it gets triggered. So it's up in Hello. Whoa would then just goto file, and you can see it's already saved automatically. So if we close that tap down, go back to one drive with Conceived would have document one that flight test. Okay, now it can see in our John chemo, we have the email from a Flo file was created in one drive, used to check it out. One for the note pad document on one for the word document. And if we refresh out Floyd Page on our one Dr Craig phone, we can see it's been Iran twice a year. One for another document, one for the word document and just a quick note on the free flow plan. It will actually run it after 15 minutes if it's not a trigger Floyd. So just be aware of that. When you're craving a schedule or using an event to run a float, it does take quite a while to run on the plate plants. This reduces from anywhere from five minutes to three minutes 8. Triggers with twitter monitor: all right actions. Integrations are the bread and butter off power or right float. It's what it makes it really come alive and makes you able to do really cool things. One example we're going to look at is a tweet monitor and doing some other things with Twitter up. But for now, let's look at a simple tweet monitor float. What we want to do is we want to be able to float to monitor its with a feed. Our key words going to be Marcus off floor. Feel free to pick your own. So what we want to do is just monitor Twitter for any mentions off Microsoft flow. It'll we don't want to take some of these tweets and email them to ourselves so we can keep up to date and actually them, if necessary. Imagine if your social media manager for a company and you want to keep an eye out for any negative tweets about your company and have them email to yourself directly so you can see them as soon as possible and take action on them as soon as possible to protect your brand image and provide exceptional customer service Sacred Replace Marc Gasol flow with a negative tweet about a company. So what this will look like is we're going to make it a bottom that's going to look at. It would have paid for the keyword Microsoft flow. Grab those tweets and a melon to myself. So let's take a quick break before we jump into it. 9. Capture tweets in email flow: Let's create a new year float from a blank template to capture at sweets. So we're going to name this capture twitch. It's going to start from a Floyd button manually trigger flight from a button, then hit New Step. We're going to search for Twitter, and you can see Twitter has various actions. You can retweet something, post a tweet, get someone's timeline get follow is get who's following you get used, Tom line and so on. What we don't want to do is use search tweets. We're going to search for Microsoft for then, under advanced options. You'll see you can return a set off maximum results, and you can do it since a particular tweet idea. So don't worry about that one way, discouraged to return three tweets. Then, after that, let's add on you step to email a soap, so we're going to go mail, send an email notification to follow foundations. Uh, look, go home. The subject will bait. There is a new tweet about floor, and finally, after that, we're gonna right. The tweets is, and we're going to actually have to tweet to the email. So how we do that is under this dynamic content. You notice we have various options. One of them is a tweet text, which is he content? Or the tweet. So let's click on that, and that's going to insert that in that, but you'll notice it actually changes out floor. We now have this applied to each. It's selecting a body apple, then sending an email notification. If we click on that, it's going to expand it and have the actual tweet content. So what's happening here? Well, essentially, this search for tweets step actually returned three separate tweet individually. So in order to send an email about them, he needs to send three separate emails. So it's going to take those crates weights for each off. The three tweets grabbed the body off the tweet. Then in an email, send it to flow. Underscore foundation toe calm. The subject. There is a new tweet about floor on the actual tweet text, so let's first of all, save outflow. We'll run it and check it out in our email. Then we'll do some quick white boarding around how this actually works in a bit more data. So hit save bottom hit test. I'll perform using the trigger action you'll need to make sure you sign into Twitter as well. When you add search tweets with your own Twitter account looking, continue then get run floor. We can see here the flow has successfully started. If we had on over to the floor runs page, we can see it's run successfully. So now going toe are male. We can see here we have three. In your emails, we go to the 1st 1 We've got a rates wait bytes at 90 of we go to the next one, the same one and finally the same one. So not many good tweets at that time. But if I go to my deleted items, I have one from an existing float. Well, you can see you actually got the Microsoft flow. Text from the Tweets Microsoft Float Example. Send a customized email the next one Microsoft Power Automate abs Robotic Process Automation in April, which is around power automate flow and then you tweet about flow around. You bump to as well, so going back to outflow. We have successfully used to separate actions which is ascendant, tweet and send an email notification, and they use the symbol connector, which allows you to grab those tweets, put them in an email and run over three times 10. Flow whiteboarding: Let's take a quick look at how the apply for H actually works, using Twitter to get someplace. So what happens is wrong. Twit up. We'll use a trigger to get three tweets when it gets great plates. These busload in something called on all right, which will have three items, each of them containing a single tweet each of these tweets to use Santee Mao to send the amount tweet content. So the way it works is if you have an array of objects and your pie a certain step two that a rate it will put it in a five for each look what that means is all centered in mouth step for each object in your right. It will send an email. So the first week run sending him out. Second tweet will send an email. So that's how these sent a mile works with the plots of age. Flo has the smarts for automatically detect. If you're tryingto apply a step for an array, it will make that step apply over and over again in the flight for each one 11. Dynamic content: all right. What we want to look at now is something called dynamic content, and we've already used it in floor. So what is it and what does it do? We're going back to halfway to capture tweets. You'll notice when we don't search tweets. In order future steps, we can get the content or the tweet body in a tweet text When you click on it. This dynamic contact window comes up here, and essentially, what this dynamic content with that does is that if any of your previous steps capture any sort of information from e mails triggers Twitter, SharePoint marks or planner and someone you can use it in all the future steps. So say, if we shirt tweets, get email content, get from an email list that will then come up in this dynamic content box, and then we can use it in all our future steps. So let's make a new flow and take a look at a basic example off that so go to my flows looks new. Instant from Blank will create it from a new floor by itself, and we're going to use a flow button for mobile to manually trigger afloat then what we'll do is we'll create a new step using mail. Send an email notification to floor foundations that elliptical, and what you'll notice is we already have some dynamic content from the manually triggered off what this man is. When we manually trigger a flow, we actually get information about the user who clicked on that bottom. Such a CD, the Country Ragen, their full address, that latitude longitude, that email. They use the name and so on. So let's email someone that content to ourselves. So we're going to do the subject. I am safe and everybody will be. I am safe. My location is, and inside the latitudes, the top latitude followed by a colon. Then we need to do is click on latitude. He will insert it in here, and what this blue box means is it's going to be replaced with whatever the value is for that dynamic content. So that would be the current uses ladder trip position that one can do the longer true. Click on that as well. And now what this will do. It is when we click on the button to manually trigger a floor. What grabbed the uses latitude and longitude and put it in a mile that sent to flow foundations at home. With the subject, I am safe. So let's add the title to bay. I am safe button. Let's say that and I'm going to run out on one bobo. Now let's check out what happens so we can see I've got the bottom here on power or night. Former, whether I am safe bothered, let's click on that. We can see that started in our email we concealed, but that, you know, here I am safe with my location with my latitude and longitude. And if I put that into Google Maps or Google Search, that will actually show my location. And it will be more accurate on mobile, since Flow actually has access to your GPS information so you can get the actual detailed location rather than running on a desktop or expect less accurate. So that's what dynamic content does. It allows you to access any sort of information you have from any previous step on any application at all, so it's super useful. I recommend taking a look for it as you're building out your flows because it is surprising the wolf off information you can actually get out from dynamic content and using your float 12. Variables introduction: my palate is actually remember things. Store Penry trade for use later on in the foot. We're going to take a look at that in this section. We're going to take a look at the basic data types, which is text numbers and volumes, which saw true or false, the more advanced their taxes to the race, which imagine a shopping list and that can have a one or many items. You might have five irons on your shopping list, such as milk biscuits, tea chips on cheese and that's what a race could do and store. And they're like, good to take a look. Expressions where we convert one data type toe another day. It's hot, so let's jump into taking that variables and how we can initialize them and store data in there with power or donate flight. 13. Text, Number, Boolean: Now we're in floor. Let's create a new floor from Blank. We'll go skip, and we're going to name this one basic variables. With that set up, we're going to trigger it from a fly button and then to set up variables toe actually, store data going, you step. Search for variable and you find variable. Here you can click on it and you'll find a serious of actions to actually set up a bearable to store something click on and its allies bearable. And this is essentially making an empty box. We can put something in it. We're going to name this box name. The type is going to bait off a string, which is essentially text and it install my name and you can set up an initial value So we're not empty box. We're actually going to store my name, which is an drug, and now we have a books with the tag name that's holding the value Andrew that we couldn't use a later on. Let's set up a few more variables than actually email them to myself. So going you step once again, we'll such well variable initialize variable this time will do as a type inter job and this is a number without any decimal places. We're going to do this one. It's age. We'll set the very to 29 hit next up once again. Such a variable. This time we're going to use something different. We're going to use increment variable. We click on that. What we can do. We can select any number or into Joe. We're going to select age and increment it by a number, so we'll do one. So this is going to take our age, which is 29 incremental by one, which will make it 30. Finally, we're going to create a new step quite variable again, will initialize a variable which will be off a top bullion and we're going to call this can vote and this can only be set to true or false. Even it can type in anything you try and type in. Hello. It's come up with an era when you try and run it, we can see up here in Floyd, Check up. We actually haven't era answer in a valid bullion. So you want to make sure keep an eye on that walk within true and finally will create a you step to Emma that to myself. So go mail. Send in email. Notification will do to floor foundations out. Calm. The subject will do my details, then in the Mount body, will do. My details are bullet by name. Cola undone. Dynamic contact. You notice you have variables and you have names. It can click on that and putting your name at an age, and you'll notice you don't actually have aged under here under the dynamic contact variables at the time of recording. For some reason, it only shows actual strings not bullied into just that can easily be solved by searching for the name or the variable, which is age. Remember, that's a label off the box was storing agent and get out at age. Then do you can vote and we just need to search for that can vote, which is the name of our variable. With that done, let's it save. And now when we hit test and run it, it's going to set or these variables inside the box name box age box can vote, and then it's going to unpack those boxes and get what's inside it. So name will be Andrew age will be 30 and can very well be true. So let's go save and test for test for it. Continue and let's keep an eye on our emails. Okay? In my email here, we can see we've got an email with my details are name as Andrew, age as 30 and can vote as truth. Now remember, we initialized all these variables with the name name the age one had the name age in the can vote had the name can vote and then we unpacked the values which is Andrew 30 and truth . So we essentially extracted those and you saw with age we actually set up to 29 in Florida and then we incremental by one. So we actually added one toe age and we can change that value. Fruit floats Variables aren't always going to be the same value. They are dynamic and can change. And one last quick tip I want to show you Inflow is you probably notice all this initialized variable is quite messy. We have initialized variable initialized, bearable to initialize, available free. If you're editing their flow and you come back to it after a day or two, it could be confusing what they're actually doing. What you can do is if you hit these three dots, you could go to rename and weaken Rename the title, please. So we can do in this life bearable cash Name this one with Henry Name Not this one too. Fast age. Rename this one to initialize Variable dust can votes on increment variable suit that age and that way when we click on it to minimize, um, it actually makes a lot more sense rating afloat what? There was our initializing and what you're doing with them. So it's much easier at a glance value to understand how your flu is working rather than have to manually open up the different steps and figure out what it's doing every time. So I really recommend if you're using a lot of steps that have the same title just quickly renamed, it will save you a lot of time and hassle in the future. 14. Arrays: Now it's time to take a look at a race. Let's create a new floor from Blank. We'll go skip. We're going to name its array variables. Well treated a fly from a building on my Volvo create and you Step once again was such a variable we will initialize bearable. We're going to call this one shopping list, and it's going to include our shopping list items. The type will be off an array, and we want to set up the initial value as fruits now shopping list. So at freaks to it, then in our shopping list. We also want to add milk contains. But what we can do that it's why going a new step And if we settle bearable, there's a thing called a pencil right there. What this will do at the end off the array. This will add a new item. So the railway shopping list and we'll call this milk, and that's going to add milk to the end off our shopping list array. Then Acti would just do the same step. So new bearable a pencil rave arable shopping list on I'd say. Would that set up? We wanted him all this to ourselves. So going you Step two male Senate email notification and we'll send it to outflow. Email address unknown under email body. You'll notice it's not listed under dynamic content. If we search for. We also can't find a shopping list, and the reason is a raise you can actually insert directly to an email body by default. Look at the ways we can work with this. The 1st 1 which was seen before, is the same as a thing we did for Twitter, and that's with a four age because we have an array of items. What we need to do is at a new step search with four each under control, select a plot to each and then what we can do. We can select an out from a previous that we can select a shopping list. With that set up, let's delete out a mile notification step at a new accident here called Male. Sending in my notification swear flow email address subject will be a shopping item is, and then any email body we could put one off the shopping items is and you'll notice we have applied to H current autumn. So what this will do is the applied to age will take the shopping list array and for each item in that shopping list. All right, it's going to apply this Sandon email notification. Steptoe and Seamount toe ourselves. So let's say that now. Let's run that to check out our array in action. So let's go test test the flow off for metric action. Continue hit. Run. Now you can see outflows successfully started to monitor it. Goto our floor runs page. If we go to our four runs page, you notice the test failed. Let's click on that, and then you'll notice when you click on the start time, you can see the steps it run. The green tick Maids that step run successfully and the red exclamation marks mean that's that failed and the Great Cross means it didn't even get to that step to run. So you can see at has failed here. And the reason is the variable shopping list of Top Array cannot be initialized updated with a value fruit, off type, string, available shopping list. Only support finds a top right. So what does that Arromanches mean exactly? Let's go back to the flow in my flows in array variables. Let's add it up and then under initialized variable. This value, afraid isn't over. Type around was setting up an array with our benito. Leave it empty and then append to an array variable, which will add items studio or to set up an array with initialized that you were surrounded with square brackets for any item quotation marks in it. So now to square brackets, quotation marks, fruit Let's save this. Let's go test run out floor, you know. And if we go to after Iran's page, you can see here it successfully render Floyd that time and then I'm out box. We can see we've got one of the shopping items is milk. One is fruits, one is take. So our array variables flow has successfully run and actually set up an array with fruits, then added milk toe. How did say and then sent an email for eight of those items. What we can also do in this initial is variable. We could also initializing with milk and tea instead of a pending to the end of the array. And to do that this in taxis you put a comma after an item quotation marks milk inside it. A comma in the last item will do t in quotation marks with no comma at the end. Now we can relate these artists steps and save outflow. Let's test that I'm Ron it a game. Go to the outflow runs page conceit strong successfully. And in our mail walks we have the shopping items or fruit, milk and tea, and that all came in from setting up a shopping list as in Right Justin Dream, utilized by putting them in square brackets and separating the items one at a time with a coma. So just remember, there's two ways you can set up a raise you convinced initialized all at once. Or you can use the A pent or a step on that will add a new item to the end off the array. Let's take a quick break before I go on to expressions, and also in that will take a look at how we consent all these items in on right in a single email at once. 15. Arrays to a string: So we're back in our are a variables float, which will send out an email for each individual item in a shopping list. What we're going to do now is get it so it contend out a single email with their shopping. This items, What we're going to do is delete that email state and then under the initialized, bearable for our shopping list. All right, we're going to create a new step. It's also going to be initialized variable. We're going to make it by type, shrink and what's going to be shopping string. We'll leave the value to empty by default and then in the applied to each were going toe, add an action, which is called Upend String. It's a variable. What we can do now is use our shopping string and in the value put in current item, followed by a comma on a space. What this will do for each item in our shopping list array, they all take the current item and add it along with a coma in the space to the shopping string variable we created. Now we can not a not a step and send that as a male toe ourselves so we'll do. Send mail notification again and subject will do. This is our shopping list in my body. Will be out. Full shopping list is then we'll use the shopping string unbearable. We just created now hit, save. Let's hit test save and tests using not trigger accident. Let's run out for we can see It's wrong now. So let's check out your mouth, okay? And we can see we've got out email here without full shopping list as fruit, milk and take so we no longer get an individual female eats it, gives us all of them at once. You will notice that is a comma at the end of the last item, which is a nice. So we're going to take a quick break up before we get into looking at expressions which can actually remove the last comma in that single string we've created from our initialize variable off a fruit, milk and sea or a shopping list 16. Expressions: Okay, let's take a look at flow expressions. We're going to create a new flow from blank skip. We'll call it expressions in the top, right? We're going to start from a bottom once again when were going toe adding, You step, which is just sent a magnification. So I'm just going to send it to myself with the subject expressions. Example. Then in email body at the right hand side alongside dynamic content. Your notice. We have this expression bottom expressing our a serious or functions to convert data. Check for rules. Modify data on someone If you use a teller. Think of Excel formulas. It's pretty much the same in power automate floor. There's an absolute ton of expressions of by default, it will just show the most commonly used ones and the rules here. So, for example, this one is a stream function which applies to strings, and it will combine any number of strings together and use it by typing contact bracket text one text to on. So then you've got length Here, which will take in the collection are returning the number of elements in that a rail collection, and so one what we're going to do is under stream function to click on, say more and you can see all of them here. We're going to use it to go. But in the Verde string, which will be the city I live in to upper case So in in my content, all typing Hello. The city is then under expression Clip to up up talk in Sydney in lower case Once we hit Okay, we noticed we get an era saying the expression is invalid. The reason is any text inflow needs to be inside single quotation marks that sells flow. Hey, this is actually test. Not a bullion, not an inter John Not available and so on. So here. Okay, let's hit Save now Let's test and Iran Al fly now to see how that actually works In our email we've got expressions example with hello, the City of Sydney. So that worked successfully converted out Sidney text which was in lower case to upper case . Let's go back and edit Outflow won't show you one final thing before we wrap up this lecture, which is using variables with inside expressions. So let's add in action and this time will search for variable will do initialized bearable . We're going to call it City all the type strength, and we're going to do Sydney. And now what we want to do is in our M o, using the same expression builder for converting a string toe. Uppercase actually insert the variable instead. And unfortunately, Florida's a document that this work. But to use a variable inside an expression with simply typing variables, brackets, quotation, mark the name or the variable as a strength. So in this case, the actual name over there will up here is city. So when we go back to our insert expression, what will happen is when this expression evaluate and runs it will pluck replaces Variable City with whatever we're story in the variable city, which currently is Sydney. So it's okay to add that in. Let's say that let's finally test that toe, actually prove that that it worked. So let's go back to our mail and you can say, here I have another email expressions example. Hell of the city has said me. So outflows successfully used an expression to actually convert House City string, certainly toe uppercase, so I'm not going to go for all the expressions scored just too many to look at. I recommend you just actually take a quick look through the list in your own time. And flow by default shows the most popular used ones. But you can click Seymour on each one to have a look Atmore, and they group them, so they got logical functions, conversion date and time ones and so on. So it's just work knowing they're there, because you may need to use them in your flows. 17. Advanced expressions remove comma: you will recall in the previous lecture about arrays, we had out shopping list the right, and then we created a shopping string string for eight vitamin A shopping list. It would add it to our shop only string with a comma and space at the end of it, and then send an email without full shopping this to ourselves. You recall in that email at the end it still had a coma after tea on a white space character, so that's not really that ideal. It should not have a comma at the end of it. So let's have a look at expressions can be used in order to remove that comma. Okay, now that we've refreshed our memory around what we do with a raise and sending a shopping list under apply for eight, let's into a new step with an action type we're going to settle. Variable will do initialize a variable. We're going to call this update trumping list all the type strength on in value. We're going to add expression, and I'm going to copy one I've created in that had earlier I live on screen for you to copy gonna hit, okay, but the important thing is we want to see it working first. Then I'll break down how it works bit by bit, because this is more advanced usage of expressions. I just want to show you what's possible using expressions and how they can be combined to just achieve goals you want to do so understanding in my notification, let's delete that shopping string. Let's insert out updated shopping list. Let's hit, save Let's go test Let's run outflow and send ourselves an AML using that new update, a shopping list of arable we just created with an expression and you'll notice Wonderful actually runs. You'll be taken to the debug screen, and you can click on this initialized variable three. You can see it's value, doesn't have a common at the end of tea and send em a notification. Also sends it without a comma, honest or a space at the end. So you can actually use this debug option to see how you flow around step by step to see if it was successful or not. Will that sending emails and also to figure out where things might go wrong. Let's just go to our am I anyway, and we can see we've got our full shopping list here, or that. A comma at the end of tape. So that was successful and using an expression terribly. The last characters at the end of that string. Okay, let's break down how that expression actually worked and was able to remove that cheeky little coma at the end of the string. So let's break it down. First of all, we had out string, which was fruit milk, and say, and had a comma at end of it. And we also had an extra space character up because when we're adding each item from the list to the shrink, adding a comma in the space so we go to be using the three expressions sub string at length substrate here, or return a subset of characters from mystery. You give it some text, the stock index and the length ad. We'll return the result from adding two numbers and finally length or 10 a number of elements in a rail string. So we were using this expression here, which is sub string variable shopping string zero had length, variable shopping string and minus two to actually remove that coma and that invisible space at the Innovest Ring. So let's break it down. How that actually worked. First of all, the variable shopping string was feel for it milk and tape. So we wanted a substrate off this text here, next up is zero, which is a starting position. So that means start at the very beginning off that string. Then we have this complicated expression here doing several things. What it was doing is it was first of all, it was adding two numbers together. It was taking the length of our shopping string which waas 18 characters. So starting at F ending at the very last space, it was 18 characters. Then it was doing minus two from that length. So it's adding these two numbers together. So 18 plus minus two equals 16. So by doing this, essentially, this sub string is saying Hey, take the substrate here. Starting at position zero, let's take the 1st 16 characters from that string, so that's bought away upto a and then that gives this fruit milk antique without the comma in the extra space at the end. So sub string or fruit, milk and tea starting at position zero. Take the 1st 16 characters off that string. That way, we don't have the last two when we send it in an email. So that's why I copied it out of no pad earlier, because you've run out of space, sometimes using the expression builder in flow. And once you know a bit more about in how words, sometimes it's easier just to break it down, sexual by section at a time. And no iPad, for example, then added all together to use your expression. You'll rarely have to do this, but sometimes, unfortunately you will. And if you ever use Accel A what you should be familiar with this. Sometimes you can get some complicated expressions on Just is what it is to do. A simple little thing sometimes takes a scary looking expression, which is actually quite simple when we break it down. So let's take a quick break before we move on to the next section. So 18. Variables Wrapup: to wrap up variables. Let's have a look at what we have just covered. Flo has memory, he construe, or anything you want to use for later. To do this using initialized variable and that data types, you can store our A string, which is a piece of text. An interview, which is a whole number afloat, which is a decimal number. A bullion, which is true or false, and then a right, which is a list of items which could be a shopping list. A list of inter jizz on someone overwrites something you set variable, and you can use expressions to kind of bearable. So I'm not a data subtypes taken. Convert a strengthened inter job, for example, because you can only do math operations on intelligence afloat, not strength. Expressions can also be used for various utility function, such as the length off a string or collection getting a sub string. So getting a part of a string from an overall string contained checking. If a string contained something and time getting the current time adding time, subtracting time and so on. The list goes on, as I already mentioned are highly recommend. You have a look at yourself in Florida. What the expressions are just to get them in the back of your mind, because I will come and useful for various actions and things you want to do later on in your flood. 19. Sharepoint Intro: Now it's time to look at more of the foundational features off. Look, we're going to look at Tom Pickle control flow, which is how your flow will actually run it and go for various steps we're going to look at , if else statements. So based on a condition you can execute one powerful steps or another path, we're going to look at the types off loops in floor, the benefits on corns of H flute and finally, a switch statement which can let you execute many different cocoa puffs based on a condition. See you, sir, in the lectures. 20. Sharepoint dev account setup: I am going to take you through the steps to get a free SharePoint account for 90 days. This is using the Microsoft 365 developer program. The steps are a bit more involved, but once you've got it, 90 days is plenty of time to test it using float. So you need to go to the link you see up here on screen and click joined. Now you'll need to fill out the steps and account details, and you can also find a link for that, for the resource is in this lecture or in this course once your field out that you then come to a landing patriot with your Microsoft office. 365 Developer subscriptions. You can see here that I've got semen apstar on the map so that calm I'll need to click on goats subscription. To go to that on the logging account is going to be a separate account, which I created here. Just a WC at seem elapse dot on Microsoft dot com. So if I click to go to subscription, this is going to look me in under that eight of you Seeley account into my office APS. You'll have something somewhat, but you'll notice you won't have SharePoint by default. What you need to do is actually at SharePoint as a license to your user profile. So to do that, do that goto all APS and you find this style called admin. Click on that tile and this will go to your adamant center. You don't need to navigate to the users Tab Goto. Active users find your user. This is my one here and us for click on that cheque books. I could go see this Baden managed product licences. You'll see. I get this tab for licenses and APS. If you expand elapse, you can show APS for all licenses. One of the officers in here will be SharePoint, and we can see that here. SharePoint online plants makes all you check that books hit, save changes. Once that saved, you can go back. So the office 365 home. And about 20 minutes or half an hour later, you should see a SharePoint com With that, you just need to click on that SharePoint icon and you just need to go to create site. You could give you a site, a name and details. I've already went ahead and credit one called communication site that will also take about 10 to 15 minutes to set up. You'll get an email. Want that stone? Once you've done that, you just click on that SharePoint thought, and you've successfully set up your own free SharePoint account for 90 days with your own site. So we're going to be using the list fits off SharePoint in the next lectures. So let's take a quick break before I get into setting up a list in SharePoint. 21. Sharepoint list setup: Okay, You should have your SharePoint now. Love that they with your enterprise account your own personal office 365 account or using the Microsoft developer account to get 90 days for freight on your SharePoint side. You should say this button here you on a particular page or the home page will decide it. So if you expand that you conceive, got a new list often what we're going to do is create a new list, and we're going to call it shopping list. We'll leave it sick to shot in the navigation it create, and that will take you to your shopping list. Here. We're going to add a few more calls that a list which will use in the next lectures on float so we can add an item to this list, delayed an item update and item, and also query items to return certain items based on what the user inputs into flow. We can feel tough, the Ivers, based on if it's a fruit, if it's a beverage, if it's in a central item and so on. So we're going to add a column. This one, we're going to make it off the type number. We're going to quote quantity. We'll leave. The rest is default hit. Save. Well, I don't not a call him off the type text, which is a single line of text. We'll call this my description. We'll live the defaults the same as well. I finally got to add another column off the top. Yes, no, which is in stock and that will allow us to set if an item is in stock on. Or so this is going to debate the SharePoint list we use for shopping list in the next lectures in Chef Point, you can add an item by selecting you Convention. Quit in a title, say oranges. So we want to oranges on my description Will be I like oranges and will leave in stalkers. Yes, and what it say we can see. We've got a new item for oranges. You could then select it also ended it up the top or delete it. Let's delete it. And we've gotten rid of that list item in our shopping list for oranges. So let's take a quick break and then we'll start actually using this SharePoint list inflow 22. Add to list: Okay, so we've got a new SharePoint list here which shopping with on we can have a title quantity , my description and in stock. So what I need you to do is go to float, create a new empty flow off court mine at to SharePoint list. We're going to trigger this from a button. Then going, you step sets, will Champlin click on SharePoint and then you'll say all the accidents you can do in SharePoint here. So it is quite a lot. And this is super powerful, especially in enterprise, because a lot of enterprises actually use SharePoint. So what we're doing now is quite basic. We're going to get more into SharePoint, and I'll show you more of the advanced features around lists. For now, all we need to do is go create item. He asked you to put in your site address here and now give you an example, so you probably have some sort of SharePoint dot com slash sites. Last site name Mine is just my roots sharp when you are old, which I can paste in here. Once you put that in, that might prompt you to log in to SharePoint and once you've done that, you can come back here and from the drop down you can select well the shopping with save created and then you see here we've got toddle quantity. My description and in stock. Remember in stock by default was set as yes, And if you wanted, why does a read Asterix next to toe? That's because that's required by SharePoint to insert a new list item we must put that filled in. You can customize it. Other fields to make them required it to actually add an item. But that's what that means in floor when you have a read Asterix next to it. So for tidal wave going to their apples quantity ordered. Three. My description will do a healthy fruit. Andi will set the instructors. Yes, get saved. We'll add to SharePoint list Saved lets the test Oh perform using a trigger action save and test. Let's it continue. Run flawed. And if we go back to our SharePoint list, let's just refresh it Now you can see here we've got apples with a quantity off for a description is healthy for it. And in stalkers Yes, on it has this little icon next to apples here, and that just indicates the island is new. So it's just being recently added to the SharePoint list. So let's take a quick break before we look at how it can actually customize the import when it use a run stuff to put in whatever they want in traditional. 23. Add to list with flow input: Okay, so we're back in outflow on what we want to do here is when we want to create an item we want to let the users toe. Actually, you put the details when they manually trigger flow of a bottle. So to do that, we're going to modify this floor. But what we're going to do is we're going to duplicate it and make a copy because we don't want toe added to the existing one, just in case we want to keep it. So to do that, go to my floors on the left. At the SharePoint list, click on the more commands Go Save as, and this will create a copy off the flood. So we're going to call this one at the Shaft Point list. User input hit. Save It will be disabled by default. When you duplicate a flow, so go to more commands. Let's turn that on, and then let's just go to edit and where in outflow again, you can see exactly the same as a new flow, sir, to allow years attack input to afloat at super simple. All you do is go at an input, and there's different types yet used component text. Yes, no, they can upload a file and email a number or a date. So what we need to do is match these up to create item, which is titled Quantitative Description and then Stock. So title will simply be text will do. Text will call this title Do the description as the title of the shopping island. Then we'll added imports for the quantity. So that's a number you can only put in a number off the quantity say, obey the amounts you want to buy. Description will simply be text so description we'll leave it as a place and in your import . I finally, for in stock, that's simply a yes no, as in Stop and will leave the hints textile description as please select. Yes, Illinois so actually uses. We simply go into the create item. Delete the title apples and it's dynamic content once again. So if we search for title, you can see we've got this title from manually Trigger a floor. So that's this title up here. Click that to put that in there can do the same for quantity. We'll concede that's the number here, so we simply do number my description as description. Finally, in stock, you go entered a custom value on, and each was in stock from the manually trigger flight. Now, if we save this, we can go test. I'll perform the trigger action test could save you. We could put in a title so we could say banana, say one in the description, or be healthy through its once again market as in stalk hit, run floor on the floor, Iran's page we consider so successful. Now if we go to SharePoint and go refresh, we can see we have that banana here and the user was able to enter in that import. Now, if I go back to float or mobile, we can see we've got this out to SharePoint list two years of import. If I tap on that, we can put in a title here as fish. Let's just say we want to buy four fish Description will be something different, and in stock will do as no hit. OK, done up the top, right? That's running it here. You can see it started. If we go back to our SharePoint and refresh what conceive fish has come up here. Quantity for description of something different, and it's not in stock. So this is one of the really powerful features, or flow is allowing a user to actually dynamically evil content and lick it up to any other program at all. That flow supports especially useful for something like SharePoint, where you might want t input data into a list but control what they can actually import and also allow them to input data on the fly. 24. Deleting from a list: now that we've added idols. How Shopping list in South Point through Microsoft Power Automate Flow, Let's take a look at pelican delayed items. So I've created a new blank flow here called Delete from SharePoint List. And before we start developing this float, we need to go back to our shopping list. SharePoint. And we need to set up something to show what the unique identifier is for these items in the list. In order to do that in the new items, click on that at a car of you. You'll get various options and you can see here there's a number of items that are actually hidden, such as who created it. Attachments version on so on. What we need to do is click on this display idea on What that is going to do is that's going to show us unique identifier for each item in that list, you've also got various out of options you can use. All we're gonna do is take that I d click OK, and now backing out shopping with you can see we have these unique days here. So every time you create a new item, if I do one manually here and we're going to say, Chicken off, 10 hit save. You can see it's got an item my day off 10. And it just keeps on incremental. So in order to delete one of these I tens of me in the float, we need to give the unique identify a 40 item we want to delay. So let's create a dynamic floor that will have the user to input identify our, which will delay it. That list on from Shopping West So in the floor, let's do trigger Floyd button for my bow. Well added imports off a type number, and this will be the item I d Will do. Please Antar the shopping list out of my day, then going. You step in so far and share points. And in here there's going to be a delayed item. You just search for delete. We could see we have this delayed Ivan click on that. Put in our SharePoint address. I know this shopping list and in our debt identify. We're going to put in to my date that the user input to stop this lawyer select hit save before we run that. Let's take a look at our list on pick one of them to do it. I'm going to delete Banana, which has Adam my day off number eight. So let's go test. I'll perform the trigger action. Putting an item ideal eight lets it run flow, go to the flow runs page could see it ran successfully. And now if we refresh our shopping list, we can see that we've successfully delayed ID that item banana with an item idea of eight. So SharePoint only allows us to actually delayed items based off in our day. Don't actually based off a title constitutes Kitson and so on. However, you can combine various features which we're going to soon, such as querying items. So you get a particular item such as Apple's. Then you can use that idea to delayed. So let's take a break before we move on into the next lecture 25. Update a list item: So far, we've been able to add an item, take the user's input toe, actually add an item as well, based on what they put into a textbooks and delayed a non from the list. So let's take a look at updating a fundamentalist. We have this blank flow here. I've just called an update shopping list item title and always going to do it. This is make it so the user can put in the idea of an item and a title, and they can up that that title, to whatever they want it to bay. So going back to our flow, we do Floyd bottom for my ball manually trigger for at a input as text will do this as a new title, we'll do the updated shopping list title. Then we'll add another import, which is a number which is an I d off that shopping. This item that we want to update. Then we add a new step we'll set the sad point in actions will set for update on Go up that item and we'll put in our SharePoint details here and then we can see we've got ideas, title quantity and my description and in stock. So for the I D. Will put in the idea we passed in for the title will set for the new title. Okay, now we've got the idee the title. Let's save that. Let's it test. Let's save and test. What we want to do is we'll go to our shopping list and we're going to update apples to oranges. So that's got an idea off. Three. So put in oranges as a new title. I d off free. Let's see it run flow, go down. Let's refresh our shopping list and we can see here That title has updated toe oranges. Now there is something in it'll. Cat four is sometimes a SharePoint. Summer fields are actually required to put in no matter what. So I show what I mean by updating the description only. So let's go back to our update shopping lists. I am title. Let's edit that on or change that to up that tropical. This item description in the manually trigger off floor in this import will changes to new description, the updated description, and then up their item. We're going to remove title and in my description, will simply set for new description. Let's hit. Save on. You'll say we've got an era. Toddle is required. So if we want to update one of actual painless item descriptions, we also need to part in an updated title, which doesn't make much sense. Were in the update in description. How does that work? Well, we're flow with required fields in SharePoint. You always need to pass a value in even if you're updating on. So that is a way around this. A by getting the item we want to update and then updating it with the exact same title. So to do that in between manually trigger flow an update item, I don't use action. We'll set for shop point. Would you get item for this action? And all we need to do is put in our SharePoint list, passing the idea off the idea we used to mainly trigger floor. And now what we can do it is in up that item entitle from the dynamic content, remember the pretty view selection on dynamic content. It gets anything from the previous steps it's able to use. So what we can do is actually find the title which is hit from that SharePoint list item. So if we say this now and let's just say we want to update oranges to my son that likes this fruit. What we can do is hit test. I'll perform the trigger. Action save and test. Do you need description? My son lacks oranges. The I D will be number three. Let's it run flow and we can see here. It's updated this to my son likes oranges. So how that has worked in outflow. We put in our idea off the item. We want to update this Get item will get the item details from the share pointless, forgiven I d. And that way, in the update item, we're just using the title, which is in a dynamic content which was extracted in this Get Ivan step. So we're just replacing the toddle off oranges with oranges again and updating it with the new description out use a top in and that idea they typed in when they run the floor. So keep an eye out for required fields in SharePoint. If you do need to update an item that's has some simply used to get item to get the details on that item and update it with the exact same details except for the field, you wish to what they 26. OData introduction: Let's take a look at her data and why you need it now what we go for dissection. There will be some things that don't immediately make sense at first. Don't worry. By the end of this lecture, it will all come together. Some of the details are a bit more technical, and you don't need to fully understand them, and we'll cover them later on in and advance section of the course, such as a chase on format. So with O data, we will implement it in the next lecture after we cover what it is. What it will be useful is careering a list of items to get servant results back so you can filter by, say, you have a list of people with first name and last name. You can feel so by their first name being Scott, for example. So let's take a look at what Bodega actually does. Imagine. We have the following shopping list with apples, banana, Pepsi, coffee, water and pairs with a category for the shopping list. So have fruits and beverages in this example, and we only want to delete the fruits from this list. Since we were saved a fruit basket as a gift. So what, Oh data will do is it will allow us to query this list and return a subset off it where we only have the fruits and not that beverages. From this. We can then delayed H item using a unique I D, which we've already covered. Let's take a quick look at the definition off Odetta before we move on in computing Open data protocol is an open protocol, which allows the creation and consumption off credible and interoperable rest ful AP eyes in a simple and standard way. Marcus off initiated O data in 2007. Now that is a handful of words, and it sounds super complicated, But let's break it down. But consumption? They mean any one following the O data protocol. You can actually get data from the database to use it in the application on bike, wearable in interruptible. They mean you can using in any system and filter the data as we just saw in a shopping list . Example with the fruits. Why knowing Oh Dana is important is all of Microsoft's products almost exclusively used O data for being able to get data and filter it So by learning it now for SharePoint, you about to use it in any off their other applications. So how does O data work? Imagine we have this website here. An end point, you, Earl, and it gives us a list or people's names we conceive got their years, the name, their first name, the last name, middle name, gender, age, home address, and so on. This is the data. Essentially, we're getting back. And now we want to clear this data toe only return people with a first name off. Scott, what you do is you, then load that same euro. But with this dollar sign, filter pickles. First name, he Q four equals and Scott. And then we'll just get back the list off everyone. Where the first name matches. Scott So had us. Odetta worked in Floyd. Then imagine we wanted to use this and floor. What we would do is in Florida and SharePoint, for example, you have a filter query, and that's where you put the first name Equal Scott here. And if you have a list with first names the last names, it would earn the return. The ones from SharePoint where the first name matches Scott. So going back to our practical example have a shopping list here. Let's just say we wanted to get items whereby the category was only fruit for the shopping list with simple do category 88 year for equals and fruit. And that would return this list here off items where we have apple, banana and pear, where the category is equal to fruit. So this filter can also be useful. Other thing for seeing where it contained a word where it doesn't contain a word where number is greater than or less and something a wide range of things. So now we'll do is we'll use o data inflow. And just before that, in the next lecture, there's some online websites and cheap seats we can actually experiment with Odetta toe actually learn it a bit more, indeed whole, rather than the theory we just covered. So this is just building the foundation for your understanding of what oh data is and why it's important is because all of Microsoft products almost always used o data to be out of feel to the items said by learning that for SharePoint in Florida, you can use it for any of the adult products in and outside float 27. OData in flow: before we get into using our Deborah ploy. Let's take a look at a few examples online. First head on over toe data the or slash o data services. You'll see various basic usage is and then clearing data. You'll notice the 1st 1 here requesting an entity set as the same example I showed you in the slides. So you need to do is copy that link. Open it up in a new tab and what it will do. It will return you the same list of people you saw earlier, but not in a pretty format. So it can see we have the years of name, first name, last name and someone doing control F and searchable. Scott. You'll notice we confined Scott here. So let's close that down. Under requesting an entity set, you'll notice has various career in data examples. And this is where we add it to the SharePoint query option. So this is the example with Scott here. So if we go to that website, you'll notice it returned us all users with the first name Scott. What we can do is simply, let's just delete that field. So for now, let's find someone else of the different names of certain first name. You can see we have a Ronald here. So if we copy this URL, open up a new tab type in. Ronald, he went up. You'll notice it will return us the years of with Ronald so super easy and super useful. So I recommend just having a brief look over these query data options here and requesting data. Just get familiar with because it will show you how to actually use data. Don't need to know it in too much detail. Once we've done that, there is a not a website here which don't leave in a link in the resource is with a teacher or O data queries. So you'll notice you can have query parameters such as count filter, and someone would click on this field expressions. This is the one we wants because of these are the items that you can insert into your SharePoint filter very so we can see we've taken a look for the equal one. You can also select a range of values you could combine fields with, and all statements check if a number is less than greater than or equal to check if it starts with something and to have something contains the value and so on. So this is a really handy reference just to keep on file. If you do need to use O data, were SharePoint or any other marks off products that use it? The funnel Web site before we jump into floor, is this example one. Here It looks a bit daunting at first, but what it's useful for is if you go to the Data Explorer, you'll notice we've got this select option. If we go say products, click home, get data. This will return us a list of products down here. Let's just say we want to return a product with the name Brett. Only click on the plus sample where we're going to click on name equals talking bread. He get data and you'll notice it returns the products with the name bread. What the really cool thing is at the end here, this name equals bread. That's the query. We would stick inflow for the field toe option, so this is super useful or actually having a test data set. Seeing how queries work and seeing what the field toe optional Because anything after this filter equal sign is what you could put skin floor, toe, heel toe items. Now I've done. If the name contains are it will return or those names or anything was bred. Hasn't are fruit punch hasn't are, um, Bridges has an hour or so, and this is what you would stick in your floor query in the field option. So I recommend book marking it. That way. You don't need to manually type it out yourself or try and figure out how to treat sheet tires exactly into it. It's just a nice way to visualize how it works. If you're that type, will think up. Finally, let's get into float. So I have our shopping list here and what we're going to do. We're going to make it so we can put in a certain title and then delete that item from my shopping list. So to do that well, first war query data to return something of a specific title. We're going to use fish as a first example, and then we're going to delay it. So I've created a blank flood here called SharePoint list delayed by title. I'm going to add a new step. It's good to be caught share points. What we need to do is get items we're gonna put in our share points. You are oh, shopping list and then under advanced options, we have this filter query. So if I want to return everything where the title is fish, I just keep the typing title a cure, then fierce coma. Then I can hit, save. And then under this, I'm going to create a new step to delete that. So what I need to do, I go new step such for sap point. We're going to use it. The late item. So now delayed Ahlam What is going to put an outsider dressed? This name a shopping list And then I day here we click on this Remember anything from a step before or confidence of the dynamic contact. So this idea here is from our get items or anything that contains the title fish. So if we click on that, that's going to put this inside a loop. So for each item with a title as fish, it will apply the steps inside this box here to each of those items, and it's going to delete those items. Why that I did because that get items were turn ideas for anything that contains fish in the title. So let's hit save, Let's go test. Let's run out flowing Now we could see it's wrong successfully if we go back to our shopping list. Let's refresh this and we could see we have successfully deleted the item with the title fish so we no longer need to manually delayed by an I D. We can use to get items to get all the honors with a specific title. Could the quantity of description and delayed One useful thing you might want to do is allow the user in the manually trigger off boy step to actually specify the title of the item they want to delete, so we could do title here. Please enter your input and and in their fields of Cleary, if we do just title the title A Que Tato, Make sure you keep these comments in here. That's it. Save let's test outflow and let's type in chicken for our title. So if we go to our shopping list, we've got chicken top 10 chicken. Let's it run floor. That's good. Done. Let's refresh our shopping list, and we could see we've successfully allow the user to talk in a title and delayed. That's one with chickens in the title. So as you can see, it does look a bit complicated. But no data is actually quite simple on its really, really powerful. So recommend keeping it in mind in your tools when you're using flow or any other Marcus off products. 28. Sharepoint things to look out for: Okay, let's take a look at something that you need to look out for in SharePoint when creating flows. Contrive you crazy unless you know how to solve it, which I'll show you now. So what we've got is a shopping list here That would be an editing So far. What I'm going to do is I want to actually delete this record with the description as good in a. So in order to do that, I have duplicated in my flow, which will delayed by the title, and I renamed it to SharePoint list delayed by description, going to edit mainly trigger flow going toe delayed the title as an input. And you notice. First of all, we can't delete this import now. This is because I know the step in the floor actually relies on it. So we have this title equal title here. That's why we can't actually delete that input because these steps are dependent on it. So it's simply hit that X and get items, and then you'll notice you can now actually click on a grey dots and the late this import. So we've got the leader. What we want to do is check if my description is equal to good. If so, we'll delete all the items that have a description is good. So with the title e que good It was good on Anil Update title to my description. So simple enough. We've got my descriptions equals good and what? Each item that has a description off. Good. We're going to delete that Adam So it saved. And with that safe, let's go test. Let's test out floor and see if it works. So it's just running here now. OK, we've run out floor. We're going back to a SharePoint list and refresh the page. You notice Hey, out! Chicken with a description of good isn't elated. We'll go to the floor runs page. We can see the latest run here has failed. If we click on that on the start time, we can get more information. We can see here at the red exclamation mark. It's failed this step. We can see the era here. Here's the expression. My description equal Good is not valid. Creating query failed, so we know something to do without query off. My description equals good is invalid. What you have to look out for and This isn't SharePoint. This is a lot of axel programs is any time you have a space between words. Usually that doesn't work unless you have us around the world in quotation marks, delete the space or use an underscore in share points case. It simply doesn't use a space when you're using floor queries. So we need to do is go back to our flow and it's a in the get items we need. Toe. Go back to that filter query. Delete this space between mind description. So it's all one word hit, save hit test and let's run that flow again and see if it works. So our floors run. Now if, for you refreshed, the chef went list. You know this that chicken is now deleted. So any time you have a list in SharePoint and any off the combs contains a space in it. If you need to actually talk in the coal name in a query, you need to delete the space in between any words. Otherwise it cannot use it. Now there's no fired and fire set rule on how this will behave across different applications. So usually the three methods on screen, including deleting the space will work for you. So I suggest testing them out the door. Quick Google search and you'll usually find people that have had the same problem and solved it. So just something good to keep in mind when things like this fail spaces are typically not your friend if you're manually writing out an actual import field column name. 29. Sharepoint wrapup: before we wrap up this sex Lola, let's just quickly wrap up. What we've done is Chappelle it because we've achieved quite a lot and done quite a lot. And it's just important to keep these in mind for future flight development. With SharePoint, we have added an item toe a SharePoint list, which is our shopping list, and we've even a lateral constant input. So we've actually found out how by triggering afloat on desktop or mobile, we can take uses input and then use that in one of the next steps. In this case, we create a shopping list item. We then have delayed an item in our shopping list using a shockingly study. We have been updated and autumn, and we found out if they have any required fields in the SharePoint shockingly stardom, we actually need to set it back to the same original value. So remember we updated our shopping list description, but we still needed to pass through the title. So were the first of all. Get the item we're updating, grab the title, send it to be the same value. That way, we can update just the description early for one of our shopping list items we then used O day it upto theory and take action on items. Remember every day is a foundation off many Microsoft products, which can be used inflows and a PR integration. So we would allow the user to put a constant input for a title, and then we would actually delayed anything in the shopping list that matched that title. We finally then learned that when using queries, we cannot include spaces in the coal name. So remember, we have my description in now shopping list. We're space in it. But if we wanted to use it in a filter query, we needed to do my description with no spaces. So congratulations on the milestone, your now realizing the full power off Microsoft flow. And at this point, you could actually go out and start creating your own flows and integrating with your own products. We are going to learn more about flow in the future lectures, but it's at a point now where you can probably comfortably start experimenting and creating your own flows by yourself without meeting these lectures 30. Control flow intro: Now it's time to look at more of the foundational features off. Look, we're going to look at Tom Pickle control flow, which is how your flow will actually run it and go for various steps we're going to look at , if else statements. So based on a condition you can execute one powerful steps or another path, we're going to look at the types off loops in floor, the benefits on corns of H flute and finally, a switch statement which can let you execute many different cocoa puffs based on a condition. See you, sir, in the lectures. 31. If statements: First of all, we're going to take a look at your statements. One really good example off. This is checking someone's voting age. What we want to do is check if that 18 years or older, they're able to vote. If not, they're not able to vote. And we're going to send an email to our floor foundations in box in the cattiness. So we're going to trigger with a pardon a gun at an import off the top number, and this would just be age. I will do, please until your age. And then we'll do a new step and we're going to select control and we're going to select condition. And this is an if statement on what we can do for this condition. We can select any dynamic content or variables. In this case, we're going to select age, a way to do if is greater than or equal to 18. It's going to follow this yes option on the left here. Otherwise it's going to follow this no option. So it follows completely distinct flow paths, depending on what the result off this condition is. So if yes, we'll add an action email, send an email notification toe outflow. Foundations in books, diverting details. Congratulations. You are able to vote in the content of the email. Otherwise, if they're not able to vote, we're going toe. Add a male, sending him owner of occasion to flow. Foundations will do sorry in the subject, and we'll do sorry. We are not able to vote as you are not 18 years old, old or older. With that set up, let's test outflow now, so we will savour. Then we'll click on test. We'll run a test first of all, trying my actual age, which is 29. Let's go run flow. We can see it's run successfully. So let's check our email inbox. We can see here. We've got the message. Congratulations. You are able to vote. So now let's run it a game this time, putting in an age that's under 18. So we'll do 10 years old, for example. Let's go run flow, check out in books and we can see here in the in box we got sorry. You are not able to vote as you are not 18 years old. Order So it took the current path off big noise. So that's how you can use basic if statements inflow. A thing to note is, if we go no, we can also delete the step and not do anything at all, which will terminate the flow and finish it so you can actually make a float. Only do certain actions based on conditions. Otherwise, if it doesn't make them, it will finish the flow. There's no further steps in the yes or no condition. And finally, you can add multiple conditions together so I could add at a road. Could it? And the or so it could also do country, for example, and say one countries voting age might be 21 whereas other countries might be 18. So you might want to put in country as an input as well and check a combination of values here. So my challenge to you is also adding a country input into the floor. And if the age is actually over 21 United States that convert, But if it's under 21 the country is the United States, they convert, this will test your skills around reasoning and logic. However, it's a really good exercise, and you'll be using this quite often in floor. So it's just good to know how to combine different if statements together with and and or so let's take a quick break before we move on to the next lecture off control for. 32. Apply foreach: the next autumn in control flow we want to look at is the apply to H Loop. This is something we've already taken. A look cut in existing Lexus, such as the tweets on the shopping list. So let's just go over up once again. I've got a flare here called for each loop, and it starts by manually triggering the floor. We're going to add a step to initialize a variable. The type is going to be array, and we're just going to put inmates as pope and finally one as Sally before the name we're going to put in names and what we want to do is for each off the values in this array. We want to send them a random, a lot of number. So to do that, we'll go to New Step gun control. Will this apply to each and in the selected out from pretty steps you need to select and all right, so we've got the array off names here, which has a both and Sally, and then we can add an accent which will actually do this action for each name that list so we can do mail sending Imo notification. We'll send it to Floyd foundations. That outlook the subject line will be your lots of number on email body. It's going to be high. And then we can click on current item and we could do your lights. Water number is, and you can go to expression. And if we type in rand on do brackets, we can give a random value between a minimum and a maximum value. So we're going to start off at one, and it can be at most 10,000. Do what? Okay. And what this is going to do is for each name in asset on names. We're going to send an email to flow foundations at outlook com with the message of water number high current item. The current island grabs the current item in names so apply to each actually started the first item, which will be Bob the second round with Sally and so on. So this will essentially apply these sets off steps to each item in that list, and you can access that item with that current. Then we just give them a random water number. So if we save that for now, let it test go up form the trigger action. Go save and test Continue on Ron Flow. Let's take a look at that email to see what Randall blogger numbers Bob and said we got. But you know, in my now and we can see we've got High Sally, Your lawyer number is 1988 and then we've got another. Am I with High Bob? Your lawyer number is 661 So this apply for H rent these steps for each item in that array list. What we can do also, if we delayed, or the values in that initialized variable and we run it, this apply to H won't run at all because it will only run if there are items inveterate. So let's go test save and test. And here, Ron Fluid and you can check your email. But nothing is going to come through because we have no names. But what you can do is go to the flow runs page and we could compare by Francois the 1st 1 and the 2nd 1 So the 1st 1 here is one where we initialized variables with Bob and Sally. We can see any apply for H. This email notification has a great tick, which means ran successfully and we can run through each one that it actually ran these steps for. If we go to the second run item in the initialize variable, we have no nays. So this applied to each didn't actually run because there were no names to run on, so it didn't send any emails. So when using that, the applied to each keep that in mind. It will only run if there are items in an array for it to run on. If the Rays empty, it won't run at all. And that's fun. So one actually break your floor by having an India right? Let's take a quick break before we get onto the next loop. 33. Do Until: the other type of look we're going to look at now, is it? Do until this is good, when you don't have an existing set of items where you can't run and apply for each look. So let's take a look at an example offsetting random water numbers off six lottery numbers . So what we're going to do is create and you step, we're going to initialize a variable. We're going to call this bearable water numbers off the top, all right? And we're just going to leave the initial value to empty, and we're going to create a new step toe, add six lottery numbers to this. All right, what we're going to years is in control. I do until look, and what we're going to do is this loop is going to keep on running until we have six numbers in this array and then in the doing to choose a value. What we're going to use is we're going to use length bracket variables. Then if we do another bracket and put in the string, which is the name of a bearable his lotto numbers hit, okay? And what this will do is this is going to get the length off. How long the array Carl is. So grab how maney Lotto numbers we currently have in your right I will do is equal to on Will do six on what this means is this do until loop will keep on running until this condition is met and then it will exit so it will run until we have six items in a lot of numbers array. So what we want to do is at a new action. We're going to set for append to a rape. Once he used a pento rave arable. Select Lauder numbers from the name and in value. In the expression we're gonna de rant once a gang with between one and 100 here. Okay? And what this will do This will add a new item to the lotto numbers, a rape between one and 100. So if we say that now and test that flow, go run flow Once we go to the flow runs page in run history, if we go to that run, what we can do, we can expand its do until and we can see it ran six times and it kept on adding value to a lot of numbers. So 39 we're going next 30 free 56 so on. So it keeps on running until that condition is met. Okay, let's add six numbers to the slaughter numbers. Right? So do 12345 and six. With that done, let's hit Save. Let's test that floor and run it and let's see what happens. Okay, Ah, flow has run successfully. And if we click into it, I notice we've got six items and a lot of numbers. All right. However, this do until runs up to 60 times. So what gives? Why do they add 60 lotto numbers? When we told it to stop when this fire? Well, what happens when they do until Well, what happens over do until it doesn't actually check this condition until these steps and finish running its check at the very end, Not the started this do until so what happened is we initialize a lot of numbers where six values in it. Then it will added 1/7 failure. It takes that length is equal to six. That was not true because it was seven days in there and it kept on running over and over again. Now this is very dangerous because you can get into a situation where the lip will run forever and never stop. That's why if we spend this change limit, he will have a run up to 60 times or time out after running for one hour. So it's a safety guard to make sure that flows don't run forever and consume resources. So if we say removed six and start outlawed or numbers with five, let's go test, save and test Ron floor going into the floor Wrongs page. If we click on outflow, run expanded to do until we can see that only added one item to the Lord and numbers. All right correctly. So going back to our flow. What happened is there were five values in the lower numbers are right. The loop will run the steps first. I don't know, not a value settlers six in there and then it checks the condition at the end to say for sure exit. So just keep that in mind. Even though this check is up the top, it doesn't get executed until the very end off the steps are they do until loop So if I was to recreate the slower game, what might do do until length is equal to or greater band six just as a safety guard so it doesn't run up to 60 times in case we set out water numbers array to start off with six. So that's a do until loop. As I mentioned, it's really useful if you don't have an existing set of values. But you want to do something, such as add Lauder numbers to an array or anything else, so just a good loop to keep in mind when you're creating your flows. 34. Switch statements: an If statement can execute two different curry puffs. The painting of something is true or false. A switch statement. Execute two or many co paths, depending on a value. The example we're going to look at is a day of awake. If it's Friday, we're gonna email ourselves. That's my favorite day. If it's Sunday, we're going to him ourselves. That's our second favorite day. If it's any other day of the week, we're not going to send ourselves an email. So to do that, I've created a blank floor here to score. That's which. We're going to add a new step which will initialize of arable. We're going to call this day or week. We're going to set the value to a string and will set the value through Friday. Innocently, What we'll do now is at a new step, will do control. And then in here there's a switch statement can see here we can add many different paths and there's a default option if it doesn't match any value so we can do if the switch value , which is here to have the week. If it's equal to Friday, we're going to send an email to ourselves and in the subject will do the day off the week. But in the female body, the day is Friday, which is my favorite day. Then what we can do in between this case and a day for action as a plus icon. This will other case to the sweet statement. And then now we can do if this is Sunday and then at an accent once again sent an email notification and in the subject will do. The day is, and in the email body will do my second favorite day of the week. With that done, you could also add a default case. And this will run if the switch statement fights no matching value, so it will check if the day of the week is matching to Friday. If it does, it will send us an email that matches Sunday. It will send us an email and so one for all the cases in the switch statement. However, if none of the match it will do the default case and in this scenario, I don't want to send it came out to myself so we could see got Friday set up as a day of the week. So let's save that float, then test it and see what happens. We concede the floor was wrong. If we go to the flow runs page, we can click into the fly right and you can see here. If you click on this. Which statement it will show it. Grain tick for the case that run so we can see he that the input was Friday in Case one which, if a equals Friday, will send email to ourselves saying Today is Friday, which is my favorite day. And in our m o. We have the days Friday, which is my favorite day. If we go back in tow, added outflow and set the Dow the weight to be Monday, we can go test saving test run out floor, and if we go to the floor, runs page once again for the latest flow run would click on that can see here if we expand out the switch statement by clicking on it. The default case Ron, which done nothing at all, so we don't have any new emails from that. So as it can see here, the switch statement is quite powerful, you know, to see if statement will only let us do too paths off code or float whether or not something is true or false. Well, with a switch statement, we can add as many cases as we want, so this is useful. If you have more than two cases you want to match on, always use a switch statement and it will always have a default fullback case if nothing matches at all. 35. Control flow wrapup: Okay, let's quickly wrap up what we have covered in control flood. First of all, we look if then else, it will evaluate a condition on returns True, which is yes or false, which is no. Then a warren, the flow route based on the evaluation off that. So if it's yes, you can run a seriously steps. If it's no, you can run a serious off different steps. The next only look that busy for a trip. This will take in an input array and run a seriously steps on each of the islands, the current item containing the element that the current steps will apply to. So, for example, in this one, we have a serious of names, which is bullpen Andrew, and it's applied to H will run up all the names in that. All right, The current item will hold the name for the current apply for each. So in one loop it will contain Bob in the next little contain Andrew, or on all those steps on those array Adams. The next item were Look, that is to do until and this war in a series of steps until a condition is Matt and Note the condition is only evaluated at the end off the serious of steps. So in our example, we went over a lot of numbers a rape, and we keep on adding numbers to it until the length was equal to six. But remember, it doesn't check the link that to start before runs the steps to do until we're on all the steps until the very end. And then it was a very way if the length is equal six and stop running that do until loop. We then looked at the switch statement and that will evaluate a condition and runs a certain path based on that result at 10 many cases. In our example, we have a day of the week. We would check for Friday Sunday as our favorite days, and it will always have a devil case. If none of the conditions map service defaulter out will run these steps if none of them match the switch statement at all for the other cases we have set up and you can add another case by clicking on that plus bottom between the last case and a default case. So that wraps up this segment off control flow in my soft power for automated 36. Twitter more flows intro: Now it's time to take a look at a more advanced foundational gauges for flood. How we can branch floats around essentially two floors at the same time, then merger back into to the same flow and patina. Rest of the steps, Hey, can neatly organized a flow using scope to make it easier to read and develop, especially as I get more complicated and how you can also terminate a flow it any step and mark if it was a successful flow or if there was some sort of era within that flight. 37. Dev account setup: for the next years of lectures. Most of the flow features will require a pregnant flow account. The lucky thing is, you can set up a free account for 90 days of the Marks Off Developer program in order to do this. If you didn't already watch the lecture around a SharePoint developer set up, go back and set that up. Once you set that up or you need to do is head over toe offer, stop home and then log in with your developer account and then you seoi applications. You should see power automate for he. If you don't go over toe, elapse and select it. And if you click on it, you'll be taken into float on your developer account, which will have access to the premium features for 90 days. 38. Notable tweets: So our first floor for Twitter is going to look at a key word in a tweet. We're going to use float. You can use whatever you want and what we're going to do. We're going to check the user. And if they have over 100 followers were going to send an email with the tweet content to ourselves so we can track. When someone notable from Twitter actually does a twit, you can adjust to follow a limit, but for this example, we're going to use 100. So to do that head on over to create a new empty float and then what we can do, we concert for Twitter. We can use the trigger off when a new tweet was posted. We're going to search for a text to float, can use whatever text you want has mentioned. Then we're going to create a new step, which will be a tradition, select tradition and into the value if we click or not. You know this, as in one of the early electors, Iraq's widow. We get order details of that tweet so we can actually get the number of followers that 20 user has select followers count. And if it's equal to or greater that so is greater than or equal to 100. We are going to send an email to ourselves saying that we have a notable tweets. It's in the subject. Will say we found a notable sweet and in in a male body will be high. There we found a notable tweets about for then it is an end. What we'll do. We'll do the name off the years up. So if we do name, let's search done in concert for name, get the name of the user. Then we can do the actual tweets. And if we set tweet, you'll see that we a tweet text. Finally, with due dates on, then weaken search for the date. Any dynamic content did it? Date is created at, which is the time that tweet was posted up. With that done, and we can hit save, I remember. This is enough. Liwei. Click on a button. It's going to be automatically run in the background, so make sure when we're finished with, but we actually disabled so we don't hit up for limit or spare, not in books. So let's it save one defeat, saying Let's hear tests, all performers in the trigger, action hit, save and test, and that will trigger outflow. And let's monitor our in box. You can see we've got several emails here saying We have a notable tweets, So this one is high There we have a notable tweet about float. It is Nangk trip studio. The Tweet. So? So if we search Google for true studio twits up, you'll notice I've got the profile for truth studio here and we've got that sweet here, which is a week ahead and biotech cancer conference. They have more than 100 followers, and we've got an email with the content so that super handy. But it would be nicer if we could actually get the link to the tweet in an email. Well, we can actually do that if you notice. If you click on it. Sweets. It's so to light it up in New York, we have twitter dot com slash the user name slash status slash a really big number. Now all tweets follow the same pattern where it's twitter dot com slash user name slash status slash the idea off the tweet, So this number is a unique idea of that tweet so we can reconstruct this. You're out in float, but go back toe power automate flow. Let's add my floor in the sent email notification we're going to do w w w dot twitter, comb forward slash and in dynamic content we want to look for use the name. So that's the screen name off the user, and that's going to be different to the name. The name is actually what they've got set as that explaining user name. He is the true steer, which would concede in your Elba. So there's slash user name flash status. And then, if we do forward slash and search for I. D. Conceived with God's various different ideas, what we want is a tweet i d. That's the idea off that particular tweet. With that done, let's see it save. Let's test that flow on. Let's look at a male's for any new tweets that contained the actual your l to the tweet we can see. We've got to treat here, which is privilege or wisdom. People for measuring look would flow and so on. If we are open up this euro on our Web browser, you'll notice we jump straight to the actual tweet that we had in outlook. And if we click on the years and we can see they have more than 100 followers, so as mountain that flows going to keep on running in the background. So let's go back to our clothes. Let's click on the three dots. Let's turn off that float so it doesn't constantly Iran and use up their monthly quite up. You can always turn it back on later, but this is a good example off combining the various things of lunch. Employees so far actually search Twitter for a particular keyword. Then we could check the follow account. If they have a Senate following, we could amount to ourselves. So say, well, doing publicity's for Twitter on a company. We could search for our company's name, and if someone has over, say, 50,000 while it was, we consent an email notification to ourselves telling us toe action at Wetherby, negative feedback or positive feedback. So let's take a quick break before we move onto their next lex up 39. Flow approvals: The next thing we're going to look at in float is having a floor where we allow the years up at it. Input to post to have to wait up. The key thing about this is we want something security. We want someone to approve the Twitter message so they can't post whatever they want. So you might have a social media manager in an organization who needs to approve or the post to Twitter, Facebook, instagram and so on. Lucky for us in floor, that's Anna Preval's module, which we can use toe actually a sign a flow for someone toe approved to continue running. So to do this, we're going to use manually trigger a floor. We'll add it. Input with the text on it will just be tweet and importantly, the tweets we want to make. Then add a new step. This is going to be approvals, and we're going to use start and wait for an approval. There's several approval types where you can put in a list of people and everyone must respond. The 1st 1 to respond to the action for prove reject will be done, or you can add your own custom responses in. If you want more than a simple approve reject, we're just going to use approve, reject first to respond. You can put a title for the approval, so we're going to do post to Twitter approved. You comport in the email address off the person in the organization you want to assign the approval to. We're going to put in my email address, can put in date out. So we're going to put in the tweets years, and then we're going to put in a tweet. And once that's done, this actually caused a flow to stop running until it's approved or rejected, and it will continue running from the next steps under this. So we want to add a new step, which is a control and simply a condition, and with the approval, the actual response gets stored in outcome. So if outcome is equal to approve, we want to post the Twitter. Otherwise, we don't want to do anything. So if yes, we're going to search Twitter, we're doing a post a tweet and in a tweet text, will just such for a tweet, which we used in the manually trigger off low input. We've saved that now, so let's actually test it out. So let's test the float will perform a trigger action in this week. We're going to do Hello! Won't. So now that we've run at, how do we actually approve or reject out? Sweet. The 1st 1 is in outlook, where you actually get an email from the person who requested it to approve or reject that Floyd and could see you got the tweet is Hello world with the title. As in MT. Title, which is post to Twitter approval. The other area is on the action items. We have this approvals button. If we go toe approvals, we can see here we have a list of order approvals were received. You can also say the approvals you have sent under the center and we can click the tick to approve or extra reject it. If we approved, it's going toe allow. So prove up. We can put in an optional comment. But if I go confirm and then goats Twitter, you can see here that I've posted a tweet Hello world successfully using approvals influence. So let's go back and have a look at our flow to see what happens if we reject it. So let's go back into tweeted approval. Run will make a tweet such as this tweet should not be poster. Let's just say someone person a bad sweet about badmouthing the company or accidentally saying something negative or leaking information. I shouldn't. We can go to Ron Float and we can go to the floor Runs page also before we rejected, and what we can do is we concede a flow is running, and if we click on it, the floor will actually keep on running until this approval gets accepted or rejected. Now this doesn't last forever. By default, the approval will only last for up to 30 days. If it goes over that time limit, the flow will simply stop running. You can change this, which I'll show you in a moment, but let's reject that approval. So we're going to go to accent items, approvals this one go reject. We'll put in a comment say you should not be tweeting this. Let's go confirm. Then if I go back to my floors for the tweet of approval back in the run history, we can see it's being rejected in the condition it will go to the if no so nothing happens at all. I refresh my Twitter up and you can see I havent posted that bad. Wait and finally, as mentioned, if I go to edit the floor, you can change the time out. So this doesn't take up to 30 days. You could make the approval only last for an hour, one day, two days. And so to do that, it's time to cook on the three dots. Go to settings on. You'll see you have this our time out here. The duration is specified in this. I also ate 601 format, and I have some examples on screen out. So PT 30 am would mean it last for 30 minutes. Haiti one d means one day P 85 d means five days, and you can go to this Wikipedia page here, which will actually tell you how this is structured. So why? I mean, you and means month w means awake demon state, so you can actually set your custom time. That's for approvals. If you want to set it to something different than 30 days, I'm going to leave that for now. But this is a really powerful feature off low and in most organisations there will be some sort of approval process. So this is taken integrated. It flowed really nicely. 40. Schedule delay: Let's take a look at schedules now. What they do is that can allow you to run flows every set, amount of time. So say run it once an hour, once a day and so on. And they also to allay to inter delays between steps in your floor. So we need to do is hurtful a schedule. Are you saying this schedule? You got your triggers and actions? The trigger is a rare occurrence. And if we click on that, you can run afloat every month, week, day our and so on. We're going to delete that step, and we're going to actually create a brand new button click and then use a schedule to delay opposed to Twitter. So we're going to use Baden manually, trigger a floor, gonna add two inputs. 1st 1 will be that text, which is the tweet content it. So then we're going toe. Add a new one of a number and what is going to do? The delay. We want to post it and we'll do delay in minutes. Next up we can that the next step and if we search for schedule, we can click on A and there's two types off DeLay and scheduled you can use DeLay, which will delay it by a set time. Or you could do DeLay until which will allay to delay until a certain date. We're just going to use DeLay and we're going toe. Actually, let it specify the input we get from that floor. We'll delay it for that amount of minutes, and then we'll post to Twitter. And the tweet text is just going to say that tweet to text We put in from the bottom when we mainly triggered a flood. Now, if I hit, save and test the floor, we could see we can put in that sweet content in the delay so far. Put in a hello world. We'll just do one minute. Delay, hit, run, flood. We can go to the floor runs page. We can see it's going to keep on running on this page, and if we refresher off the 10 seconds still running, click into it. We can see it's currently at the delay stage here, and you can see over time it will keep on updating. Once we reach one minute, it's going to go into the next step to post a tweet we can see. It's just near a minute now and employees run successfully and we go to Twitter. Refresh my page and we can see it's posted Hello world to my Twitter page. So that's hey can use schedules toe AIBA. Run a floor based on a set time interval you want or actually into a delay in between your flow steps. 41. Tweets to excel: Okay, What we're going to look at now is taking tweets from Twitter about a certain subject and putting them into an Excel file. In order to do that, what we need to do is go to one drive in your one drive account you'll need to create a new Excel workbook. We're going to rename this to tweets, and there's some configuration to be done in Excel File What we need to do. We need to set up an actual table in Excel, which will be used by flight to insert neuro, which will see shortly. So to do that, we're going to do tweet text here, followed by user dates on and will do rate tweets count. So what we're going to have is sweeter. Inserting tweets into Accel document with the tweet text, the user who tweeted it, the date and the rate wake up in order to do that, highlight or those columns in Excel go to insert click on table. I could call my table, has had us and click on her tape because in all of our flow to belt at a road to excel, it needs to be inside a table. Otherwise, it doesn't work so we can live our Excel document. For now. Let's go to floor. The first step for float the trigger is going to be when a new tweeters poster click on that. We're going to search for the text flow. You can put in whatever you like. Then we're going to do in your step search for Excel Online business. And then we need to search for his ad. I rode into a table. Select that, and you'll see various options here. You need to go from top to bottom, so it dropped down location. You should see your one drive for business. Click on that. You could also use SharePoint or any other place to store in that document. Under document libraries, select one drive in file. Click on this folder button to show all the files in one drive and we could save got out Tweets, Excel document here and finally in table. You noticed we've got table one here, so that's the table. We added to excel. If we click on that, we noticed, we can add arose from the columns with creating an Excel earlier. So that's how it knows where to insert it. into an Excel table. Tweet text. Click on that. We can click on dynamic content. Such hexed got twit text for years up will grab user name from the dynamic content for dates. Will user created at and finally for eight. Weight count. Search for rates waits count. With that gone, it's safe. Let's it test saving test and just give it a minute. Also, we can see it's run successfully. Now we head on over to our Tweet Excel document. We can see it actually update in real time. So it concealed What some tweet text here. The user who tweeted at the date and the rates weight. Count off that particular tweet for Go back to power order, mate. Go back to tweets to excel. We can see it's rent several times. If we goto added again, we can I have a test and manually trigger it all. We can let it run and remember that a flow will run every few minutes, usually automatically. So going back into excel, we can see here we've got some more tweets that actually contained the word flow. So, for example, we've got the workout for here, So this is really useful to show how you can collect their from social media or any other application and put it into an Excel document in a super easy way. So what our courage you to think about in the back of your mind is that you have used quite a lot of features or fly. Now you've connected a lot of different systems together. It should start now, be clicking, and you should have that ah ha moment where you notice super easy to connect two completely different systems together that otherwise wouldn't be easy to connect up. And if you go to the home tab in floor, you can see popular services you can go to see or and there's hundreds and hundreds off services that you can use. Inflow that or super simple to connect up. So it's probably worth spending five or 10 minutes just going for having a look at some of these that will get your creative juices flowing. Hey can apply flows to your personal work and also enterprise work in the workplace. 42. Twitter wrapup: let's quickly wrap up what we have done with tweet up and integrating with other features or flow. First of all, we took a look at notable tweets where we take its week. We check if it's got over 100 followers. If so, we then email the content off that tweet along with the user name and link toe ourselves. This could be useful for social media managers who want to keep an eye on tweets about their company or competitors companies. Next up, we took a look at the approval for whereby you can actually use approvals and floor to approve if something happened or not. So, for example, we're using approvals flow so someone could use a four poster Twitter. Then it will go to a particular user for approved They could ever approve it, which will post it to Twitter or reject that which would make it not posted to it up. Remember that approvals have an expiry time by default. It's 30 days, but sitting in the approval list for longer than 30 days, it will be removed on the floor won't run, and you can also customize this approval time and finally, remember this different types of approvals you can use, approved or rejected, making it so the first person can approval deny or everyone in a group needs to approve or reject something, and you can also have custom values for the approval response. It doesn't have to simply be on a proven reject. We then took a look at taking tweets and putting them into excel, using the ads or table. So it's super simple to integrate anything with Excel at all. We finally then took a look at the schedule of waken I've, Ah, Runner Floyd, every X minutes, hours, days and so on, or actually delay steps in a flow. We had the Baden supposed to Twitter and delay the post by a specified amount of time. The user put in in minutes. We don't one minute in our example and the key message I want to get out there now is it Start. Start exploring more. We are going to go into the more advanced features off low, but you should start now keeping in mind for at the rest of this cause and also just your journey, whether it be in floor or your day to day role around different applications you use where you have manual tasks to do something, have to think about. Could that be done in Florida? Could we monitored Twitter in four? Could we add items to excel in floor? If we need an approval flow for something, it can be done in float also. So keep these in mind. You should be realizing now. Although Fly looks quite simple up front, it is a really, really powerful product, and Microsoft are constantly adding new features to it. 43. Advanced flow intro: Now it's time to take a look at a more advanced foundational gauges for flood. How we can branch floats around essentially two floors at the same time, then merger back into to the same flow and patina. Rest of the steps, Hey, can neatly organized a flow using scope to make it easier to read and develop, especially as I get more complicated and how you can also terminate a flow it any step and mark if it was a successful flow or if there was some sort of era within that flight. 44. Parallel Branching: another handy feature offload is something called parallel branching. So we've got a flyer here that is manually triggered from a bottom were simply good to add a new step. We're going toe at mail. We're going to send that amount of cash into ourselves being hello there with the email body as high and what you can do it. Floyd is when you click. To add a new step, there's added action or add a parallel branch. If we select at a parallel branch, you can see it will split the flow up into two separate branches. So in the second branch on the right hand side within, also sent an email on in the subject will do. This is another branch and then they a my bottle. But this is running at the same time. So what happens with peril branches is it will actually run both branches at the exact same time. So when we manually triggered this for it will run the left side and runtime. So the reason that this is super useful is it can do to separate things in the same floor that are independent of each other, so they won't impact each other, they could execute the task at the same time. That way, if one branch fails, it won't impact the other branch. So let's say that flow go test hit, run and let's see it came out ourselves twice using parallel branches so we can see here. The floor has run successfully. We've got the green ticks indicating it ran on both branches. And if we go to our mailbox, we can see we've got the hello there mail here. And then this is another branch came out here. So this is a super handy way off develope off lows if you want to run two separate independent set of steps within the same flow. So, for example, you might have one step that will be doing some actions on a SharePoint list, and the other one might be doing some active on social media or related to the same item that triggered the flow 45. Merging branches: Now that we've set up parallel Brantas, you can merge. Um, super easy. So that way you can have a serious off steps that run after both branches have been wrong. So if you want to add a step toe a particular branch, you hover over it and you have this plus icon. You can vent at an action and add it onto that branch that's running. But if you click on a new step button under both for them, it will merge them both together. And what this made is this action will only execute after both these branches have been this running. So we could say, Send an email to ourselves. Subject can just be both branches have finished running. Look in my body will do, hurry, let's hit, Save It's a test and Ron outflow. So we go to the flow runs page, and what you'll notice is that it will run through. But if branches once that dunk, it will then finally run the last step, which is send an email saying that birth branches, happiness running, you can see in our emails at the very end we got. Both branches have been is running. You might get them slightly out of order because email sometimes take longer to come in. But the actual execution steps and float will always have this step at the bottom run after both branches have fallen compared, it completed processing. We have no Harris. 46. Scope: Okay, let's take a look at something that young count up Well, not deal. Breaking can be kind of annoying when you're creating floors. Let's just say we take this here without parallel flows. Emergent of France's on Let's just say we had one branch here which had a serious of actions to send emails. Do SharePoint items and some sums get at a few actions here. We're just gonna add a blank sent a mail notifications for now, and what you'll notice is that the screen real estate inflow is quite limited. So if you had quite a complicated flow, you could have all these actions taking up the screen. And there's no easy way to collapse, um, into one action. But there is. What we can do is if we just click ad at the top at an action search, full scope, click scope and then what we can do is strike these steps into the scope and what that will do. Scope is essentially running the exact same steps, but it's a nice way off where you can actually collapse all the items. So if we click on the top, it will collect all of them and then you can expand them. So if you had a steerable steps in the flow that related to SharePoint, only you could create this goat and say Rina to SharePoint, adding to a list and setting values. And you could collapse that. So other glance, your floor is super simple to understand. If it's complicated, you just have a quick summary off what the steps are doing in a scope. And then, if you or someone else wants to edit it, they can click on it and expand it out. So it really helpful when working on a large flows either individually, also in a team of people, because you don't have to keep on scrolling down the page to see what's happening. You can just collapse and expand their scopes. You can have as many as you want, so it's just a handy tool to keep in mind when you're creating more complex flows. 47. Termination: the next feature off. Where we go to look at is being up to terminate a flow at any stage in the process. So we've got this flow here for the parallel branch in where I send an email with Hello there. I sent an email. This is another branch and finally went there both for this running. We sent an email. Both branches have finished running. What we can do before that we're going to add a new action and social terminate. And then you can see here we have this terminate control. What we can do is this will actually stop afloat. At this step. We could set a status or failed cancers succeeded, or a custom bay. I'm just going to leave. It has succeeded. Let's hit save on Let's run the floor to see what happens. So it conceive the floats run, click on Don and we can see here. It manually triggered a flow that sent in my notifications. It terminated the flow, which means the flow stopped here so it can see it didn't run any further steps, which was that final step to send an email to ourselves. We could see it was skipped, and we only received to e mails that hello that and this is another branch. So this is a way way could actually make a floor finish running based on a certain condition. Say you might be looping through a shopping list. And if you find a particular item, you might want to terminate the flow, send an email and stop running, so this could be used to control your voice when I terminate if it was successful, or if, for some reason your floors didn't run as expected, you can set it as Dahlia and add your own value messages. 48. AI Builder intro: Now it's time to take a look at a more advanced foundational gauges for flood. How we can branch floats around essentially two floors at the same time, then merger back into to the same flow and patina. Rest of the steps, Hey, can neatly organized a flow using scope to make it easier to read and develop, especially as I get more complicated and how you can also terminate a flow it any step and mark if it was a successful flow or if there was some sort of era within that flight. 49. Sentiment Analysis: the first A. I built a pace we're going to look at in sounds of machine learning and flow is sentiment analysis, and to use that you need to go to the AI builder and then build. You won't be able to use this by default, but they will prompt you for a free trial up the top here so you can click use for a trial for 30 days, or just watch along to see how it works. You can see you can either create your own custom models, so this means you can actually train no machine learning model to recognize objects, predict text and precious forms. Or they have several pre defined models here, such as reading a business card, giving key phrases from text, language detection, sentiment, analysis and so on. We're going to take a look a sentiment analysis, which will tell us if text is positive or negative. You could use this with social media posts, for example, save Twitter or even emails of any organization. So click on sentiment analysis and I can tell you how you can get started. You can actually try at in line, so if we do, I have to go to work, hit the send button it analyzes as neutral hit, and it's got some various details around best practices. So to try it out, we've got two options we can manually created in afloat or using a flow of another templates. Let's take a look the template and then manually craving cyclic using a floy. And you know, Alyssa has several options. Here. We can select this Twitter one, for example, there continue, and that will build a prettified flow for us to analyze tweets, using sentiment analysis to tell if it's us if it's positive or negative in here. If it's a negative sentiment, it's going toe came out this specified email address that and maybe tweet a speaker saved. So let's see how we can actually can use it in our own Floyd. So let's go back to my floors. Let's leave the page that's going you instant from blank skip. We'll do flow button for mobile as a trigger. We'll add a new step and what the step is called for sentiment and assets, its court predict. But if you saw it for it, you're not going to find that in your standard floor That's because you need to actually set it up in another place. At the moment. They don't have it set up so you can use it in my flows. What you need to do is you need to have him over to the solutions tab, create what's called a solution, and a solution can contain flows. And that's how you access a prediction. So we're going to go a new solution. I would call this display name. Machine Learning Publisher will just leave a by default it create, then click on machine learning and inside here you can create your own solution to APS, dashboards, variables and talk. So we're going to create a float. We're going to trigger of a button. We're gonna add in imports with text so the user comported some text, and then we'll do the new step to do sentiment analysis on that. So search for predict you can see now predict comes up under common data services so we can actually accident. Now click on that, you click on your model and you have the day for mothers here or your own created ones. The one we want to use this sentiment analysis. It's going to ask for a language, has different codes. Eight and is for English for the text we want to analyze. We're going to put in the input text from when you clicked on the button to run the floor. And then we're going to send an email notification to ourselves with what the sentiment was from that text. So in subject will do. The sentiment is on any my body will do imports. We'll add the user's input here and then we'll do sentiment. And then you need to use the global sentiment for the sentiment analysis to get the overall sentiment or the text. Let's hit save and you notice we're floor. If you don't give it a title, it will give it a title from the first and last step as follows automatically for you. Good test. Open form the trigger action They continue. Inputs will go. I made dinner tonight on it. It's tasted really nice. Let's go over on floor. Let's go down. We can see here. The floor is running. Finished running. Now we go. Toe amount books. We can see. The sentiment is the import is I made dinner tonight and tested really nice and we can see here. It gives us a positive sentiment rating, so that's a positive sentence. The other results, you can get our neutral or negative, so I recommend trying out the floor yourself, putting a different sentences and see what it comes back with. As mentioned earlier, this could be integrated with, say, managing social media accounts, internal emails, complaints and so on. One final item to remember is we created the flow in a solution. In order to edit it, we need to go back to solutions. It won't appear in the my flows. If we're going my flows, it's nor in there. If we go into solutions, click on machine learning. You can see the flowing here. You can click on it and then you can manage your floor and go into edit and actually access . You fled to edit it so you can't create it in the standard place. Always remember that. So for a I builder, you always need to create your flows inside a solution 50. Image to text: the next day I bought an item we're going to look at is extracting tax from an image Bob. This could be a a scan of a newspaper article like we've got on screen, handwritten text or an invoice and so on. So what we're going to do is, if you go to build, we're going to be using his text erection recognition here. Say you can click on it, see best practices and go through it in order to use it just like before. We need to go to a machine learning solution. We need to create a new flow. We're going to call image to text and to start off the floor. We're going to do a button manually, trigger afloat with an import of a top file, and this will allow the user to upload an image. In the next step we search for predict in the model we're going to do text recognition model and in the image. We're going to select the file content, which is the images uploaded, and this is going to recognize a text in it. So finally we need to email it to ourselves. So if we doing you step with female. So our mouth books well, this subject as the image test is finally in the my body. If you try and find the text, you won't find it in dynamic content. And if you do a search for us, I predict you won't find anything but a page number. So how can we get the text on the predicts step? Well, I'm going to show you how to now manually. And then after we get it running, I'll show you how can figure items like this out by yourself in the future when it's not so obvious. Hey, conduct the result from a previous step for this particular one. We need to add a new step, Goto added. Action for do this as initialized bearable. We're going to call this image tax all the time. Text well, strength, then willing to add a new action from control, we need to apply to age, and then here we need to select lines. What that will do it is that automatically format the supply to each to go through all the results and grab the lines for each of the results. The reason is we predict you could applied multiple images were only up leading one, so I only have one result. And then in that image it will actually give you eight individual wine for the image to text. But we want to combine them all into the one texture in. So we just added, Actually, in here the appendix history invariable. We'll do image, text and in value. If you click on that, we need to sit for dynamic contact for detected text. Click on that. Now, in your a modification, we can put in the Balboni. The text is, and then we can use our new bearable for image text here. Now let's say that on Let's test that out by running and upload over a newspaper article, which you could download in the race Office Force lecture. Or you can find any image. You want to predict the text up so they're test. All performed the trigger action. Continue. Let's play the image. Let's hit room floor. We'll go to refire runs page. Some of the AI field of flowers do take slightly longer to run because it's actually uploading the image, then figuring out what the text is and that emailing it to ourselves. That's actually doing quite a lot in the background, could see here taken 22nd so far and that about 30 seconds it's finished running. Now for Goto our mailbox, we can see we've got a name out here saying The image Texas The text is that it's got Yellowknife. But Wednesday, September 6 2000 and six could see that's correct. Off the top, right? It's got sports and recreation. We can see. We've got that leading by example on all the content in the article, so you can see that worked quite successfully. It's not going to be 100% accurate. There will be sometimes spaces together or words Miss Felt. But it's useful if you're trying to pick up keywords in an email or from a scanned document to take action on. So you edit deploy. You probably want to put in the space after H the text text, because the way the lions essentially work is each line will be a new line of text. So this line here, this line here leading by example and so on. So this is what that applied for H is doing. It's going for all those lines off. Text detected in the image on. Then it's drawing all together into one big street. Now that we're finished, we can easily take any image a recognize that text in it. But going back to one of my previous points, How could you figure out how to extract detective text in these to apply to each loops to grab the text out? It wasn't so obvious, and when we first tried to added in an email, we couldn't see it in a dynamic content. There's several ways to approach this. The 1st 1 is if you click on the step, you can click on this info, then click on loan more. It will then take it to the documentation for that particular step and the actions. So this one is predict. Sometimes it will have more information around the output on the type of the output for that particular step. In this case, unfortunate predict doesn't have the documentation for the text image, but it's a good first place to go to the second place. To figure this out is in a I boto. If you go to build and select text recognition, you can see we've got this using afloat. If you click on that, It has some sample templates here, and then you can click on one of those sample templates. Continue and then you can see here it has a sample template where you can actually get the detective text out. So that's another way to figure out how works with that happen to create a flow, looked documentation. Just use an existing template, a napkin. AIBA, as mentioned beef after a I Boorda. Or if you just search for helpful resource is such as predict, you can say we have templates it. If we click on one of them, it's going to let up a template for predict. So templates are a super useful thing to figure out how steps work and integrate with each other. Other glance on do they make sense sometimes just looking at an existing float. There's something working. So always keep that in mind, especially when using steps where you can't find out, port or import, or how it exactly works. Look at an existing floor that someone else is created for reference 51. Flow Error Handling: so far afloat. We have creative flows that will always a work we haven't encountered. Any errors were flow so far. But having a look at this image to text slow, what happens if a user uploads a file that isn't an image? Let's try it out and see how it can handle this situation. So we're going to go to test, oh, perform this action. We're going to upload just a text file just to see what happens. So let's go run flowed. If we go to the flow runs page, we can see the most recent fly failed. So we tried to upload a text file text that takes tea. And then, obviously the predict fell because we're not uploading an image file, so have to handle the situation in our flawed Well, that's quite simple. Let's go back to our float and what we can do to handle a particular step potential front. Any errors under predict, we can add a new parallel branch. So we have one on the left, which will run if we got an image and owner errors and predict and one on the right, which will run. If there was a narrow So we're going to click Male. We're going to send an email notification and we'll just do. There was an error in the image to text floor on in a female body it will do with you should check it out and the key to this role, all running is the three dots. If we click on this, go to configure run. After we have these options, it will run off the previous step by the has exceeded. We cannot take That Click has failed, has skipped. All has timed out. We're just going to do has failed. Good done. And now what happens is you see you've got a little dash Red Arrow, and that means this step will early run if the previous step failed. If you click on the I, it also tells you that there has been some configuration options on the left side where if it was successful, if you click on the free dot and go configure run after by default, each step will run after the previous one has been to test for. So now let's go test employed that text file. Let's go run flow. Let's go to the flow runs page we can see it failed. But if we click into the run, if we squirrel cross, we can see. Although it failed, it actually sent in a motto also saying that there was an error in the image to text for. And I can say this in my email inbox here, I've got the email. Those an era in the image text for you should check it out. So although the flow run felt, you can configure it to send a miles or take whatever actually you'd like to if it does fell that way, you can get notifications and to gracefully exit the flow. So this is handy inflows where they use on my upload a file or putting it, you put that you don't expect which will cause one of the steps to fail. 52. Flow AI Model animals: for this floor. We are going to take images off cats and dolphins. Train a custom air model to recognize them, and now flow will allow us to upload an image, and it will try and determine if the image is a cat or a dolphin. So to get started, we need to go to a I build our and we're going to be using object detection. If you click on that, it gives you an overview of how you can get started. Some examples of what it could do here with detecting different types of tea, such as greatly rose, great team mint, green tea, cinnamon and so on and some best practices. So to get started, we need to create our own custom a our model, and you need 15 images off each object you want to recognize. So I've got here 15 images off dolphins and 15 images off cats, which can dalit in the race sources for this lecture or course to follow along and train your eye model. So we're going to name this AI model animals it creates. You can select a model domain by day vote. We're just going to use common objects hit next. You can then choose the tops of objects you want. So in this case, we have a cat and we have a dolphin. So the cats dolphin. If you have other animals you want to add, feel free to add your own as well. You just need at least 58 images of each object. With that done, go next. We need to add example images. So I'm going toe upload all of mine. Here, select the wall. Open going up little those images guard close. Then with that done going next on what you need to do, you need to go for each image and tagged them individually. Unfortunately, at the moment, there is no way that I'm aware of to support bulk Uploading an automatic label e So just go for drag a box or click on the hint and you need to select if it's a cattle dolphins or go cap here, tap here, dolphin here and go for all them into ive Label them. I'm just going to fast forward to the spot where have labeled them all. Okay, so now I finished taking all my cats and dolphin. You just go to Don tagging up the top with that dawn hit. Next, you'll have your summer here and you need to then click Train. What will happen in the background is your model will be training to be able to recognize images. This will take about 20 to 30 minutes to train around 30 images. So let's just leave that training in a background and will come back to, let's say, Okay, we can see here are models finish training in order to use up when you to go into it and publish it. But before we do that, there's a quick test. But in here we can upload an image, and it will try and detect what's in it. So let's find a random cat in Google images. So I've just searched for Cat. Let's just use this cat here, going to serve it to my computer on, then upload it. So I've got the image off my cat here, so I'm simply just going to drag and drop it into our quick test window. Then we can see up here it comes up with its detected a cat with a 95% confidence that it is actually attack. So next up to use our actual model to detect if images dolphin or a cat inflow. In order to access that, you need to hit the published bottom and that will make it available to your flows, and you notice you also get a performance rating with your model. You're not always going to get 100%. Anywhere from 70 to 90 is generally pretty good. Machine learning is never going to be 100% right all the time so we can see it's published a model, and we're going to take a quick break and then we'll jump back into the next lecture and use this in a flight. 53. Flow model AI animals in flow: Now we have out animals model that will recognize cattle dolphins in an image. Let's add it, toe afloat. We're going to add it manually. So we're going to go over to our machine learning solution with credit earlier and create a new float. Will call this for cattle dolphin. We're going to trigger with a Floyd buttered many Lee Trigger Floyd at an import off a file . Second applied an image file. Then we're going to need a new step such for predict. Select that and under here will say, a custom model, which is called Animals, that we just trained. Select that and in the image field worker to add file consent that these populated when they clicked on the fly bottom. Now we're going to initialize a variable, and this is going to store what's detected. If it's cattle dolphins in an image, the door over type string will do that. Call it detective content the the value as blank. And then what we need to do is we need to add a new step, which isn't a plot h from the previous step. Select results. I have an accent we're going to assert for append to string variable, select the detective content and then entire the tag name in dynamic content. So searchable tag name. Select that. Let's put it in and let's leave a space at the end of it. And then we're going to add a new step, which is going to email the results to ourselves. Search for email in the subject will do image content, and in the end, my body will do. The image content is full. It by detective content. Let's hit, save Let's run the flow and see it in action and then I'll quickly go over and explain why we need to do this. Apply for age. So let's test outflow continue. Let's search for an image. We're going to use that cat image we used earlier. Let's use that. Go around floor in the floor rooms page for it. We're seeing it's running now. The test succeeded, and then we can see we've got an email with the image. Content is cat, so it successfully identified. We had a cat in the image and not a dolphin. You can use your own files toe applied, various cats, dolphins or any other custom animal. You might have added to your model to see how the prediction and accuracy works of it. The reason we needed to do this apply for H because in the results, it could actually detect multiple captain and image or multiple dolphins or even a cat in a dolphin. So we're just looping over what the results are. The tag name for each result is what it detected in the image. In our case, it only detected one cat for our test cat image. Enough floor. So that wraps up. Look. So that wraps up the custom model part. He can use whatever images you want. It doesn't have to be to objects will just use an example. Cat and dolphin. The more images you have to train, you model them more accurate. It will be. And you probably don't want to add more than 10 different types because it does start not working as well with machine learning 54. AI Builder wrapup: Let's quickly wrap up what we have covered in a. I build up in regards to machine learning in power automate foot. First of all, we took a look at sentiment analysis where it can take it any sort of text, such a tweet or email, then analyzes sentiment over if it's positive, neutral or negative. After that, we took a look at converting an image with some Texan it to actual text. You'll probably notice that you remember things better is misspells here on the right, and that's to remind ourselves that it's not always going to be 100% accurate. However it is useful, or when you want to pick up keywords and try and extract information, you can at least get about to try and do it, and it might work 80% of the time, but that's better than nothing. We then took a look at air handling in float. You remember, our bots could only handle images to analyze sentiment or recognize textile. So if you try to apply any other sort of file such as a text file, the flow will fail. So we set it up that we set up a steptoe only run after a failure off a previous step to send ourself a Nemo saying that but had failed. We finally took a look at custom models where we operated a set of images to be able to recognize him within a float. We used a dog and a dolphin. You could substitute for whatever top of images you want in order to actually use inside your flows. So that wraps up the A. I build apart. This is really, really powerful, and that's at the cutting edge of technology. So this is something that's really exciting and close to me. 55. Advanced flow intro: mounts Thompson cycle Look at the more advanced ages afloat. We're going to look at some people hate C T K and a P I integration pan. What essentially that means is you can expose your float to be outside, be triggered by any application at all. So you could have a developer building an iPhone app on android app a Web, and they could actually make it so that we'll make wanted you flies, run and send some data to it. And we'll also be taking a look at how we can. It's great flows with third party AP eyes. That public whilst flow will have everything already covered for major applications. Just Twitter. Facebook sells for service. Now with that in built steps, they weren't always cover every feature over, and there will be other applications that are supported inflow. But quite often these applications will have a public, a PR that can access and use. So I'll show you inflow how you can actually called his public AP eyes actually get data from a website, and you could also use it to save that up. So I application that has a public NPR, so let's get into it 56. Postman install: for elections. In this section, we are going to be using an APP called Postman. This allows you to test public AP eyes and endpoints and what we're going to be using it for. Used to actually trigger afloat, to run and getting some data. It's super easy to use, so just go ahead and download the app and install it. Once you've got installed and open it up, you'll see a workspace that looks like this. We are just going to be creating your requests for Voronin elections, putting in this method type on endpoint hitting send and then that will ever get us back. Some data such a Cem user data on screen or trigger off later on, I'll run overtly more detail. Tune in the next lectures, but at least get it set up and installed on your computer. 57. HTTP and rest: Before we go on inter flow, we're going to look at what hates to dip A. And rest is, if you're already familiar with this sort of technology and protocols, feel free to skip this lecture and move on to the next lecture. If you want. This is just a review. So I get to scared by all these acronyms and what they actually do in May. I'll show you an example in Floyd soon enough. First of all, hates to to pay sinful hypertext transfer protocol. It is used to exchange data around the Internet rest dental, representational, straight transfer and its use with different types of Web systems to communicate with each other. With some standards for example, a website and you browsing that website, there are different tops off rest of methods. They're commonly use of AP eyes and AP Eyes are a way to expose two different systems to be able to communicate with each other. It stands for application programming interface, so let's take a look at the commonly used rest methods. These a use 90% off the time so you don't really it's not anything outside. This, especially for for 1st 1 is get where it will just get a record or a list of records. Imagine it. Getting a SharePoint list bottom next one is post, where you create a record or update on existing record. Imagine it. Updating a SharePoint list item will create a one. Then we've got put, which will update an existing record and finally delayed, which was delayed a record. So imagine the SharePoint lectures where we deleted a SharePoint Lee style we've arrest in floor. We will be using rest to run flows and to also get records. For example, we're going to make it say, can call this website URL. As an example, one meat is actually going to trigger a flow to run. See, you could give this euro at to anyone they could look from the browser. Or if they're building an application such as an iPhone app, they could integrate their iPhone APS toe, actually trigger float to run from within a custom built iPhone app and pass information such as text, field number fields, dates, files and so on. Next up, we're going to look at Jason and then dive into Florida. Take a look at this. Like I mentioned, Don't worry if it doesn't all make sense yet, it'll auto come together when I show you how to use it in flow, and these are some of them or advanced techniques, and you might not need it day today when it's good to know it exists, especially if you're communicating with developers who are building custom maps or, more technically detail for us. 58. JSON: before we move onto for Let's take a quick look at Jason. We'll be using Jason for some of the more advanced features. And Jason is not just used inflow. It's used all throughout the Web. If you've me off Jason, you can skip this tutorial. I'm just going to run about what it is and how we're going to use that influence. So, first of all, what is Jason? Jason stands for JavaScript Object notation. It is a standard format for different systems to exchange data. For example, you have an app, and you want to send data to your own custom foot. Have your app communicating with floor? Let's just say you want to send a first name. Last name, aging user name. You could do that through a Jason formatted object, and it looks something like this. So let's take a look at the Jason Struck's up. Socially structured as a key pair value, you can access a value by using a cape on Let's just say this example. Object on screen here is named to use them, so we have our keys on the left side, which is user name, first name, last name and age and the values on the right hand side. Let's just say we want to get these details from this object we have named to use up. We would do for use in a youth up. Don't use the name that would equal a silly What if we don't use a dot first name? What would that get that would get? Andrew uses that last name would get Seeley User Thought Age was 29. So how is Jason? Houston for Jason is a universal language. Will APS, Just like English, is a universal business language. Jason is the same in a plant where different APS can communicate. So 99% of APS that have some sort of external integration. We use Jason. So if you know how Jason works, you can integrate with any app that uses it at all. So now that we know Jason, let's get into flow and using that combined with hate CTP AP arkels 59. HTTP Trigger: I've created a new empty floor here. Could hates TTP. Wrongful it. And we're going to use a hatred to be request, actually, trigger float. Remember that hate city Be requests usually used by application developers or Costa maps to integrate with other occasions. So all we need to do is search for hate City. You will need a premium account when I hate you. Tip request is received. You're going to get this configuration here. You get the person oral, which will get after we save the float and a request for the Jason Schema. What? That request boarded Jason Skim it does is it will define what the flow inputs are. So if you think of a flight running a button, you can have text field file uploads, numbers and so on. That's the same with this request body. Jason's came up. So to use this, we can actually give it some example data We might run the flow of and it will generate this scheme or for us. So got no pad here. And what we're going to do is aware Go to set up a new Jason Payload with the first name and last name. I'm gonna put in first name as Andrew in a coma and then finally will do AIDS, and we'll just do 29. Also signed a string like this. So now we've got Jason Payload, which has a first name of Andrew and an age of 29. We can just copy that. Go back to floor. Select users sample paler to generate. This came up paces in it done, and that would generate this camel for a pale it so it will accept a first name of a string type and an age of a string type. It will also give you a hint here to remember to include a content type better as applicants and Jason in your request, I show you that shortly. It's just a hint. Otherwise your floor want Ron successfully. What we'll do now is create a new step and just send an email to ourselves with that first name in ages. So we'll send a modification in the subject with high. I am from a hates to tape a for and in the my body will do. My name is you can see here you've got the first name and age from the hates to taper request Step in a dynamic content. So put out first name and I am Then we'll do age years old. We have that done. Let's it save and in order to run out for experience stated to but our quest received on you see it is hate to take a poster girl. We need to copy that and open up postman on go New request Request name. You can give it whatever you want. I'm just not tonight. One floor trigger. Let's save it and then you'll have some information to fill that. First of all, we need to change. Just wait Post request to trigger a Floyd. They're all using out type post Request, then paste in that you are all we call it from the floor. It will fill out various pieces of content here. Don't share this of anyone. Otherwise they can run your float and we're going to add another key, and we're going to call this content up. That's what application slash Jason in its value, and that's telling it that well, to send a Jason formatted payload to the floor to run and then toe actually add content toe outflow such as the first name in age. We're going to copy that Jason Paler were created earlier without first name in age on the inside postman, you need to click on this body tab. Select role place at it here. And you can change at first name and age to whatever you want. And once you pasted that body content in, change this to Jason from text, then hit send. That's going to run out Floyd now. And you can verify it successfully triggered the floor because it will come back with their status off tour to accept it down here I go to my mouth books. Now we can see we've got this email. Hi, I am from a hasty two. People are My name is Andrew and I am 29 years old. If I go back to Postman Santic named Bob Sansa AIDS to 20 hit send, it's going to trigger that floor and send me another email saying Hi, my name is Bob and I am 20 years old, which I just received here, so that's taken. Set up off lawyer with a hate. She taped her request. If you're not a developer, don't need to notice in full detail. It's good enough just to know the option is to use it. So if you are work of application developers or your own custom maps, you can pass on information to them as to how they could integrate with one of your flows. 60. HTTP Get in flow: next stop with eight p eyes and hate city V requests. We're going to look at how it can get data from my third party AP I endpoint into fire. This is useful for applications that don't have flow steps out the box, but do have public, accessible AP eyes you can use. This will allow you to get and send data to those sorts of applications. We're going to use its Jason Placeholder that type pekoe dot com as an example, a PR What you heard us scrolled out in this several resource is if you click on the users link, this will give you a list of users 10 example uses, and we're going to make it so you can get a specific user by their i D into flight. So if at the end of users with this slash one hit and top, this will get us, he use up with i d one, we change at three, for example, it will get us a years of with idea free and so on. We're just going to use I want for now. So to do that, what we're going to do is first of all, if you go to postmen. Copy this URL create a new request. Paste it in the get hit send. You can also get the details in. Postman on will be using this later. In a moment in our for going back to our flow, we're going to manually trigger the flow for hates to tp get content. We're going to add an input of a type text which will be the youth are I think we want to get so through this as a used by day to get details off that user. Then we're going to add a new step service will hate city. Just use http and this will allow you to specify the details. This one is a get request. If you notice in postman by default, it's a get when you get data. Remember that from the http lecture. We're going to copy this u r l Here. So do a method gets the your eye is just that four year old and we want to replace its use a one with the user i d. We passed in when we manually triggered the floor. We don't need any off the other content. The closest is a publicly accessible FBI and you can access it. But if you did have a private a pie that needed looking credentials, you would also said it in the headers body cookie and so on. Then we're going to create a new step. We're going to search for Jason, and it's going to be posthaste. What this step will allow us to do is by default this hate city pay or attorney content in this body and what that body is, that's just a Jason object here. So this will allow us to convert this Jason object into something more friendlier that could be used by foot. So in Postman Went Night to copy that response. This game on click generate from sample pay set in, Hit Done. And now we've got Ask Emma, and this is going to allow us to access the using night a mile address. Super easy inflow when we send an email in this next step here. So we're going to send an email now for the subject Will be the years are details for I. D. I didn't use the i d the person put in for the flow in this silly and then in the content will do you use a date out off? Pull back on. First of all, with your name research for name, we'll find a name here from the past. Jason Step, user name also and also email, research, email done and content will get the email. So you should be noticing that these actual dynamic content came from that past Jason Step and by passing in the sample paillard, it gives us these properties we can access, which is a user name a mile address. So one and you'll notice we've got then years of name here, a mount and so on. So that's how past Jason worked. It takes that Joseph response and help put into dynamic content that would connect the source field by. Let's hit, save Let's go test and test out all flow we're going to put in years of I won so continue will go run flow and we'll check out emails you can see here. We've got the details in the email the user details for i D. One, namely Engram user name Brett, An email sincere at april dot biz. So mostly filing applications that use AP as our interview with low will have documentation around how you can access the details. So this is a way you can both get and put Baylor into these applications. Once again, you don't need to know fully how you guys work. Typically, you'll have some sort of technical developer that can help you with integration in these areas. 61. Advanced flow wrapup: Now we've looked at some of the advance for features. Let's just wrap up what we have covered. We took a look at hate. See Taper Request. This is how the Internet communicates the various methods and AP eyes. Remember, get Post Port and Billy where get would get new. Some data post will create or update data. Put up thick data and delete will delete data. And finally, Jason, which is essentially the English language off the A p R World. We then set up flow to run from an AP Eichel. So to fly here we ran from Postman and we could pass data into it such a someone's name. So something like this sort of flow could be integrated with up, such as mobile apps and Web apps from third party developers. We then made flow get data from an external a p I. We used the Jason Place on a website to get a user's details fully and Graham so applications they don't have native flow support. So you're notice for his support for at look SharePoint very side applications, but it's not going to support every app in the world. But a lot of APS do support AP eyes. So this is how you could still integrate with those applications, even if float doesn't have a specific step for that application. So you can then access, um inflow. To get data, create data, update data and delete data. So that wraps up the advanced for section. This should help out whether or not you want to integrate with these hatred. To be a PR calls all, you just need to know they exist. So you're aware of them when you develop your own flows or working with actual developers who who need to integrate little fuck.