 Hello everyone and welcome back to another video. So in today's video we're going to be continuing on from where we left off in the last one but I just wanted to round that video off so that we could look at how we could actually save the Excel file and also make sure that we closed down our Chrome browser. So if you haven't seen the previous video put the link to that on the screen now. Else if you have already watched it then we'll just carry on from exactly where we left off. So you may remember that we'd got all of these steps that we see on the screen here where we had opened up Chrome, we had navigated through Amazon and we'd exported a list of all the Excel books that met our criteria. So what we're going to do is follow on from that and just finish this off to make it all nicely and tidy. So one thing that we could do on here that we didn't look in our previous video is the ability to add comments. So if you just set for comment we can see the option of flow control and comment. So if you just click and drag that in there it literally just gives you the ability to add some comments to your flow. So in this one we'll put let's do close and save and then when we hit a save you can see obviously it's now going to show that here. Obviously you could add more of these comments further up here to separate the different elements of initializing and opening Chrome, doing your navigation and then obviously the output but obviously you can drag and drop these wherever you suit but for us we'll literally just leave it in there just an example of what you can do. So the next thing you're then going to want to be able to do on here is obviously we've got this Excel file here which has got all of our data from Amazon but we want to now save that file but because this flow could work or it will run at least daily but it might run multiple times per day I want to extract the current date and time so that I can incorporate that into the file name. So in order to do that I'm going to simply type current date if it works and then once it's loaded you can see we've got a date time option and we've got this get current date time. So all we're going to do is drag that down there below our comment current date and time and at the moment I'm happy for it to be system time zone so the time zone of my current system. Obviously you can define a particular time zone if you acquire so if you to go into that you could obviously select from anything that you require so we've got Europe progressed is obviously defaulted here at the moment but you can choose any other option that was desirable to you. I could just see if I can quickly go and change this to do Europe London so yeah that's going to be most applicable to me and it's going to give me obviously the current date and time for this country and region so if you go save and as you're probably familiar before it's going to store this into a available current date time so having got that information we want to now format this slightly differently so at the moment it's going to give us the date space and in our time whereas I want to do this into like a single string so it's easier to store into a file name so in order to do that I'm going to go into what I'm going to do is search for date because I can't remember what the exact one is and we should have the option available to us of convert date time to text you can also go the other way around but for our purposes we're going to simply use the convert date time to text we'll drag that into here so date time to convert all we need to do is go into our variables and select the previous one we're done so this date time here select format to use well we want to use a custom custom format and what I'm going to do is do the year and you can see as I type this it's going to obviously give you a demonstration or give you a sample output below year want them followed by the month followed by the day and underscore and then the hour and minute as well so you can see it's going to build out this the year month day underscore followed by the current time this way if we've got multiple runs per day obviously they've got the individual timestamp to make sure that nothing is getting overwritten and once we're on this happy about how that's looking let's just do save so now we've got our the key piece of information that we need all we now need to do is to close and save our excel file so we'll close this search option here and we'll navigate down to our excel section and we're going to go to close excel so you also do have the ability to just do save excel but for us would use you will use close excel because we want to also not only do we want to close but we also want to save the document at the same time so we've only got one instance of excel running and we can see it stored in this variable excel instance but for closing excel do not save is the default we just want to change that to save document as and it's going to ask us to give the file extension and our document path so in here i'm going to simply go to csv and then when it comes to document path it wants you to provide the actual file path so if you go into the icon there i would navigate to my desired folder which is this power automate folder and what i want to call this is amazon excel and followed by an underscore so this is going to be the file name but we're we're not quite finished yet but once i hit okay what would happen by default if i did nothing more is every time this flow runs it would save the file name amazon excel underscore obviously as a csv but i want to now utilize this variable we did previously so what i'm going to do is at the end here go into my variables and select my formatted date time hit select and you can see it's now built upon our file path so it's now going to save a file name with the amazon excel underscore and then whatever the current time and date is captured in our variable per that flow so we're simply going to save now and then the last but not least thing you do is to simply close our web browser because we've also got that open still from here so all we're going to do is go into uh i think we should about have a section here called browser automation and that close web browser right down the bottom so i'll just drag that one in there as well and simply again only one browser instance open so it's going to open or close this browser icon here click save and then that is now the extent of all the information we need so what i'm going to do is just close this screen down ever so slightly to try and get everything on one page make that a bit bigger you can obviously close the variables we don't need to see that information and then all we're going to do is open up our destination file path or folder path so i say just make that a bit bigger like so so what will happen now is when i run this hopefully it will pop up on the screen the opening of the browser and navigation we might see excel briefly before it closes but more importantly we should see the output of our desired file name in our desired folder over the right hand side so let's click run okay there's the browser opening now and you see it will go down and navigate through our search term excel and search for that and then briefly you might see excel pop up with the outputted data yep that file's then going to close and then we can see over the right hand side here we've now got amazon excel with the current date and also the time at which that file was run if we obviously to now run this future this would continue to add files here with the applicable date and timestamp date and timestamp for that file when it was run so i hope you enjoyed that video and it helped just to sort tie off where we left from left off from in our previous video if you do have any questions about the content of the video please do drop a comment below and i will get back to you as soon as possible also if you did enjoy that video please don't forget to hit the like button it's not only greatly appreciated by me but does help that all-important youtube algorithm and if it's the first time seeing one of our videos or you've watched them before and you've still yet to subscribe please do hit that subscribe button now and also the bell notification button that way you'll be notified of all other videos when they come out in the future so thank you very much for watching and we'll see you next video