Using Excel Data (Filtered) As SAP Multiple Selection Criteria with Power Automate Desktop

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 have always been tasked to run SAP report based on certain criteria/values that was usually sent to me via email in the form of Excel.

The process of extracting is repetitive and with Power Automate, we can automate the process quite easily.

In this video, I'll share my way of automating the process of filtering Excel ranges and use them as SAP multiple selection criteria to run the report.

Timestamps
00:00 Introduction
00:17 Excel Input Source and Walkthrough of SAP Report Extraction
01:10 Record Process using SAP Script Recording Tool
01:48 Build the flow in Power Automate Desktop
03:58 Filtering Excel Ranges Prior to Using it as a source in SAP
04:10 Configure Excel to create Macro-Enabled Workbook and access Visual Basic Editor
05:15 Overview of the script being used in Excel
06:12 Set up Power Automate Desktop to run the Excel macro script
07:16 Completed flow test run

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. I 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

📄 RESOURCES:
Excel Macro-Enabled Workbook (.xlsm) File - https://docs.google.com/spreadsheets/...
Excel Macro Script in text - https://drive.google.com/file/d/1tF9W...

#powerautomateSAP #ExcelSAPAutomation #SAPMultipleSelection

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.