Answered

RUN VB Script for SAP Data extraction - Syntax error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I'm trying to run a PAD flow to extract certain data reports from SAP. As per the Playbook (link: https://flow.microsoft.com/en-us/blog/rpa-playbook-for-sap-gui-automation-with-power-automate-api-flows-ui-flows-and-power-automate-desktop/), I have used the scripting engine in SAP to record a script that I want to run (and then automate the output further with PAD).

For some scripts, I get an error message stating that there is a Syntax error (see screenshot). I have manually run the scripts in SAP and they work fine. Now to the question: Is there any way to see where (on what line) PAD has thrown a syntax error in the script? I have about 100 lines, and just by looking at it, nothing seems wrong.

Categories:

Power Automate Desktop

All responses (5)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Addition:

I looked through the script again and found that SAP generates lines containing multiple instances of the character "%" which are interpreted as a variable by PAD. So the generated script is OK, but is not interpretes correctly by PAD. Anyone have any idea on how to get around that?

Best regards,
Erik
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Final update: Found that there is a way to escape from variable interpretation: using two subsequent "%" characters. Now the script runs through perfectly.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Hello friend, help me, I did not understand you, I have this code with the same problem
it's a button click

session.findById("wnd[0]").maximize
session.findById("wnd[0]/usr/ctxtW_MATNR-HIGH").showContextMenu
session.findById("wnd[0]/usr").selectContextMenuItem "%001"
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

If the text ”%001” is auto generated from SAP, try changing it to ”%%001”. Adding an extra ”%” makes PAD interpret it as a single %-character instead of a variable.

Hope it helps!

BR
Erik
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

thank you very much for your help