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!

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

🤝 BE MY FRIEND:

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

📧 GET IN TOUCH:

[JoelTing]

Hi everyone,

If your encountered syntax error, be sure to check if your recorded vbscript contains % symbol. Make sure you substitute % with %% for it to work.

[jimmyk]

Amazing delivery - simple, concise and well executed! Thank you Joel

[afterrecession]

This is amazing. Thank you, Joel, for your kindness in sharing this with us! I'm new to Power Automate and am looking forward to automate my SAP data extraction like the one you did.

[jesseniatavares]

Joel, thank you so much for sharing your knowledge with us. The universe will see the good you are doing!!!

[noway]

I really like your video regarding power automate desktop, and I think other people too.
I hope you can keep creating it if you have time !

[Crashdownfully]

Wow, just wow. The possiblities ... I am blown away.

[CRUBIOLP]

Love this video, greetings from Spain! Keep working on this channel, your content is gold!
Muchas Gracias!

[richynero]

This is sick bro. Didnt even realise there was a macro recorder in SAP and the fact you can link it to Power Automate is very clever. I can think of so many ways where this could be used. Brillinat stuff!

[emekaobi]

Was looking for a second bell icon to double subscribe. Fantastic use case; great Job!

[StundeDesSiegers]

This is a very good summary! Much appreciated

[nikimath]

Thanks for this video and detail narration on SAP and power Automate features. Its Brillant

[igrieger]

You are an excellent tutor, sir. Thank you for the video!

[dennisdeger]

Thanks for the nice tutorial! It is easy to follow and helped me a lot.

[dennisdeger]

Hi Joel,
Are you planning on doing more Power Automate Videos? This one is amazing and it helped me to bring Power Automate to my workplace. So your video is responsible that I am now the key User for Power Automate in a Company with more than 4000 employees. We already automated tasks which would need hundreds of hours manuel work every day. So you had a huge impact with this video and I hope to see more of you :)

[paulskelton]

This is awesome. Thank you so much for taking the time to share your knowledge

[Francalberto]

You are the greatest! Thank you very much. Really useful.

[CP-zbky]

Wow this is awesome, but so above my non-tech brains. I'll need to watch it perhaps at least a hundred times before I'll get it all :)

[reng]

Wow amigo this is really awesome!!! i got some ideas for my daily work to test it and implement it. Thanks for this Great tips if you happen to share some other scenario we would really appreciate it!!!!

[degigerel]

i am grateful. I created this one button in my excel which extract from SAP and copy&paste to excel...when i looked at my colleague's template, it seemed like very complicated coding skill hahahaha in the end, that was not the case

[denidoloksaribu]

Hi Joel,
Thanks for the usefull tips.