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

Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity!
https://joelting.com/sap-ebook/

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

#powerautomateSAP #ExcelSAPAutomation

DISCLAIMER:
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.

I am NOT associated with SAP AG in Germany or any other country. I am NOT SAP Partners. I do NOT offer live SAP Training. I do NOT offer SAP Access. We do not recommend the use of SAP Access from any particular provider.

MY FAVOURITE GEAR
💻 My Personal Laptop, Legion 5 Pro - https://amzn.to/3nZrn1I
✈️ My Travel Companion, Macbook Air M1 - https://amzn.to/43jLLuE
📷 My Camera Gear, Sony ZV-E10 - https://amzn.to/40T7uIj

🤝 BE MY FRIEND:
🐦 Twitter -   / joelting92  
🏢 Linkedin -   / joel-ting  

🙎🏻‍♂️ 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 [email protected] would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.