Power Platform Community Forum Thread Details

Hi all,

I am using Power Automate Desk to automatically create sales order in SAP system based on the Excel Data. The workflow is: Read Data from Excel>>>Launch SAP>>>Run VB script (obtained via the recording of SAP)>>>Store the sales order number in Excel.

However, I have two problems in running the VB script:

If Excel Data input into SAP system contain a character, e.g., "kg" input in Unit Field, the information will not be input successfully. In contrast, if Excel Data only contain numbers, e.g., "990" input in Weight Field, then it is input successfully.
The hyphen between two numbers is identified as Minus Symbol, and calculation is made when Excel Data input into SAP field. For example, the input Data should be "21-7398", but "-7377" is input into the SAP field. In order to fix this problem, I have tried to set the Data format as Text or set a variable "a"=Data and input "a" into the field, but neither of them worked.

Can anyone please suggest me to resolve the issue?

Thank you!

Categories:

Power Automate Desktop

What a suggest you is: You can create a cloud flow and "Run Script"(is a action from excel connector). The script only work for some plans of office. For see if you have this option, check in excel online--> open any excel file (on excel web) and check if you have "automate" option:

after that, you can record a script in "record actions".

So now, you have so many possibilities: now you can create a new column and use "left" or "right" formula to remove the "kg" sufixe or prefixe. Looks like that: