SAP GUI automation with Power Automate Desktop

Name: SAP GUI automation with Power Automate Desktop
Rating: 4.3 (9 reviews)

Automate SAP GUI quickly like a pro with Power Automate Desktop RPA platform

Created byMarcelo Cruz

Last updated 11/2025

English

English [Auto],

What you'll learn

Set up SAP GUI to allow automation scripts
Automate the most common SAP actions with Power Automate Desktop
Automate purchase order creation
Perform data extraction from SAP
Practical challenges to put knowledge in action

Course content

5 sections • 27 lectures • 1h 17m total length

Intro1:10
Learn to automate sapgui with power automate desktop, enabling sap scripting to run automations on sap gui. Explore ERP fundamentals, RPA, and step-by-step setup for desktop automation.
Enable SAP GUI scripting (very important!)2:33
Enable SAP UI scripting on client and server sides to enable automation with Power Automate Desktop. Use R 11 to set SCP UI scripting to true and switch on servers.

Module intro0:28
Learn the basics of SAP GUI automation with Power Automate Desktop, including launching SAP, executing transactions, and interacting with SAP UI elements such as buttons, menu items, and text fields.
Launch SAP4:24
Learn how to launch SAP with a dedicated Power Automate Desktop action, connect to a named SAP logon, enter credentials, and log in, streamlining SAP GUI automation.
Start transaction2:17
Automate SAP GUI transactions with Power Automate Desktop using the SCP transaction action to run ME21N for a purchase order, or populate the text field and execute.
Quick tip for faster testing2:28
Use the attach action to connect to a running SAP instance in SAP GUI automation with Power Automate Desktop, enabling faster testing by bypassing SAP launch using test mode.
Click SAP UI element3:06
Learn to automate SAP GUI with Power Automate Desktop by clicking SAP UI elements, using standard click actions or the dedicated click SAP helmet action, and capturing element IDs.
Select SAP menu item1:48
Use the select SAP menu item action to click messages or cancel on the SCP toolbar. Drag it into the flow, specify the item label, save, and run to verify.
Populate SAP text field1:48
Learn to automate SAP toolbar interactions using the select SAP Menu Item action in Power Automate Desktop, specifying menu item names like messages or cancel and validating the flow.
Get details from element2:17
Learn to extract details from a SAP UI element with Power Automate Desktop, using either standard actions or the dedicated SAP UI element action to capture text and attributes.
Close SAP1:23
Use the dedicated close SAP connection action to close SAP after the flow, supplying the SAP instance, and verify that SAP is closed.

Module intro0:23
Explore how to automate the creation of purchase orders on SAP with Parrot Desktop, as this module introduces the automation approach and previews the next lesson.
Use case overview2:22
Automate SAP purchase order creation with Power Automate Desktop by logging in, opening the PO screen, filling vendor and item data from an Excel file, and capturing the PO number.
Launch SAP + Execute transaction3:17
Learn to automate SAP GUI by creating a flow that launches SAP, logs in, and executes transaction M21 to create a purchase order, with testing in foreground mode.
Read Excel3:54
Launch Excel, read all data from the worksheet, correctly treat the first line as headers, and output a data table for SAP GUI automation.
Fill vendor4:46
Iterate over the Excel data table with a for each loop, using the row to fill the SAP vendor field during order creation, only if the vendor is not empty.
Fill SAP table9:45
Dynamically fill the SAP table with purchase order items from the input file, adding a row per item and populating material, po quantity, and net price using Power Automate Desktop.
Submit PO creation3:22
Automate submitting a purchase order in SAP GUI with Power Automate Desktop, saving the PO, selecting the SAP menu item after a loop, and handling a popup with UI checks.
Extract purchase order number4:18
Extract the purchase order number from SAP by reading the status bar with Power Automate Desktop, then parse the text with a regex to isolate the number.
Save purchase order number + Close SAP2:33
Automate extracting the purchase order number from the SAP status bar and write it to the Excel cell E2, then close SAP and verify the file shows the number.

Module intro0:27
Learn how to extract data from SAP tables and export it to an Excel file using SAP GUI automation with Power Automate Desktop.
Use case overview1:43
Learn to extract SAP data with SC16N in Power Automate Desktop, view MM goods movement types, apply filters, and export results to a spreadsheet, Word file, or local file.
Automating first steps2:28
Automate SAP GUI tasks by launching SAP, logging on, and executing transaction SC16N with Power Automate Desktop, then input the table name for data search in the next lesson.
Search SAP table4:50
Populate the SAP text field with the table name, click execute to search the SAP table, handle popups, and view the data ready for export to a spreadsheet.
Export data to Excel8:26
Automate exporting SAP GUI table data to an Excel file using Power Automate Desktop, addressing element targeting with helmet IDs, and generating a dynamic date-time file name.

Requirements

Windows PC/laptop
SAP GUI access would be preferable

Description

This course will take you from zero to expert in automating SAP GUI, the world’s most widely used ERP, by using Power Automate Desktop, Microsoft’s RPA (Robotic Process Automation) tool.

We will get started by enabling SAP GUI scripting, a very important step to make SAP allow automations running on top of it's own interface. Then we will learn how to automate common SAP actions like login into the system, execute transactions, populate data on input fields, interact with buttons and menu items, etc.

After learning the SAP GUI automation basics, we will learn how to automate end-to-end the creation of purchase orders on SAP, by having as input an Excel file with the data to populate on the purchase order creation, and use the same Excel file to store the automatically generated SAP purchase order number. We will also learn how to automate data extraction from SAP, by consulting it's own tables, and export the data to spreadsheet.

In the end we will have practical exercise, to test knowledge acquired along the course.

On this course, I will provide you technical skills to master SAP GUI automation:

Enable SAP GUI scripting
Automate common SAP actions (such as login, execute transactions, interact with user interface elements, etc)
End-to-end automation of purchase order creation
Data extraction directly from SAP tables
Automate interaction with Excel files
Power Automate Desktop dynamic selectors

...and more!

By the end of this course, whether you are automation/RPA developer or SAP user, you will be more confident on automating SAP GUI based tasks with Power Automate Desktop tool from Microsoft.

Who this course is for:

RPA developers
SAP users looking to save time on repetitive tasks
RPA enthusiasts

SAP GUI automation with Power Automate Desktop

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 4min

SAP GUI automation basics9 lectures • 20min

Purchase Order Creation9 lectures • 35min

Data extraction5 lectures • 18min

Conclusion2 lectures • 1min

Requirements

Description

Who this course is for: