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

As an analyst in one of the MNC, I'm always extracting data from SAP to prepare reports for different users.

An IT colleague of mine mentioned about his automation process on Power Automate and thinking 'omg this is absolutely nuts!' It is so user friendly and it is easy to set up your own automation process, even if you are still a beginner.

In this video, I'll break down exactly how I use Power Automate Desktop to automate the process of extracting data from SAP.

Timestamps 00:00 Introduction 00:23 SAP GUI Scripting Basics & Recording Tool 02:26 Build a new flow in Power Automate Desktop 03:16 Obtain User Input using Message Box 03:58 Handle event when users click on "Cancel" 04:35 Copy and Paste SAP GUI Script into "Run VBScript" Block 05:14 Attach to Excel Instance Exported by SAP "Worksheet in Basis (1)" 05:35 Save Excel file as .xlsx in desired file path 06:14 Generating unique file names with current date and time 06:59 Create Message Box to inform users after flow is completed 07:10 OPTIONAL: Error handling for VBScript Error 07:35 Completed flow test run 08:54 Summary/Recap of SAP Data Extraction Automation

WHO AM I: I'm Joel, an analyst working in Singapore. I make videos about technology, automation and productivity.

GET IN TOUCH: If you'd like to talk, I would love to hear from you. Email me directly at joelting92@gmail.com would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.