Automate SAP data extraction to Excel with Power Automate Desktop - No Coding Required.

this is how the flow looks like for my automated sap data extraction process in power automate desktop this video i will be breaking down all the steps needed to build a similar flow for yourself please note that due to confidentiality of some of the information i will blur some parts of the video without further ado let us get started before we start with power automate we would first need to record script using sap's built-in script recording and playback function to access this built-in function click on the last icon of the taskbar then look for script recording and playback click on more button and define where you would like to save the script that will be recorded here for simplicity i'll just rename it as youtube demo.vbs click on the record script button and we can start with our normal routine my routine starts with entering the t code on the taskbar in this case it's ke24 then i will start to put in all the parameters that is needed to run the report once all the parameters have been filled up click on execute now that the table that i need has been generated i will click on the spreadsheet icon and it will open up an excel workbook with the name worksheet in basis one this is where the scripting for sap sapns navigate back to the record and playback user interface and click on stop copy the file path in the destination field and open it in file explorer right click on the previously recorded script and open with a notepad or some other text editor all these scripts are the steps that we took when generating our report you can see here all the parameters that is typed into the different fields this will be the script that we will use in our paul automate flow later with the sap script ready it is time to work on our power automate workflow open power automate desktop and click on new flow i will name my new flow here sap data extraction this is where you will build your automation flow we need to first think about what kind of variable that we want to pass into the script so that we can control the output based on the user's input in my case i need to get the inputs for year and month so that i can dynamically determine the range of data that i would like to extract so the first step would be to ask the users to provide the year and month to avoid users from inputting the incorrect information i will give them a selection to choose from look for message boxes in the actions tab and drag display select from list dialog into the flow i will put in your selection as my title and then some message for the user to know what this message box is all about give them give them a selection of years and click on save next i'll build a similar message box with a list of months to obtain users input for their selected month i want to give users an option to turn off the flow when they click on the cancel button to do that we will need to use the if block here we will set it up in a way that if the user select cancel then we will stop the flow let us test run to see if it works correctly if i click on cancel then it will just stop the flow right away instead of continuing to the next block of action great it works i will now copy the same thing over and implement the same concept for the month selection message box next we will use the action block run vb script what you need to input for this block is simply just copy and paste over the script that we have previously recorded the only thing that i need to change is the year and period so that the vbscript will be executed based on the user selection remember at the end of our sap routine what's the output it is the excel workbook with title worksheet in basis 1. what we need to do here is right after running the script instruct power automate to look for an excel instance where the document name is worksheet in basis 1. then we will use the save excel action block to save the exported excel into the specified file path for the settings i will use the previous excel instance as for the safe mode choose save document as for document format choose xlsx excel workbook for document path feel free to choose any path that you like for the document name i prefer to have a unique one so that every time i run my flow they can be saved as a different file instead of overwriting the previously exported file in order to do that i need the current date and time i will use the get current date and time action block to obtain the current date and time then what i will do is convert the date and time into a string so that it can be used to form my desired document name you can define the custom format of the string here once done click on save and go back to the save excel action block add in the output string from the conversion block as part of the document name we will close the excel instance and the main process is done for the last step i'll just put a message box to inform the user that the flow has been completed now here is an additional step that you can add for error handling if there's an output in the variable script error from the run vbscript block it means that something went wrong when running the bv script so i will just add a prompt here to inform the user of the error and stop the flow let us do a test run here and see it in [Music] [Applause] action [Music] hmm [Music] great data have been extracted based on the user input and name appropriately now we can see that the export file is in the specified folder here's the summary of the entire flow building process that we have gone through just now let me know in the comment section below if you face any issue with power automate if you enjoy this content please give me a thumbs up it always refund that the content that i'm creating is valuable that's all i have thanks for tuning in i'll see you later [Music] you

Channel: Joel Ting - Tech Tips for Accounting

Views: 38,823

Rating: 4.9630609 out of 5

Keywords: power automate, SAP, SAP Data Extraction, SAP GUI Scripting, Excel automation, no code, no coding, SAP automation, sap power automate, SAP Scripting Power Automate, gui scripting, Microsoft Excel, SAP to Excel, SAP to Excel automation, microsoft flow, microsoft power automate, rpa, robotic process automation, microsoft robotic process automation, UI Path, microsoft rpa, ui path alternative

Id: 1206jLK0byU

Length: 9min 36sec (576 seconds)

Published: Sat Jan 02 2021