
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:
Can anyone please suggest me to resolve the issue?
Thank you!
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:
and for the problem with Hyphen I suggest you use the SUBSTITUTE formula from excel:
So, you record these action and then stop and save the script. After that you can run the script in any excel sheet.
After that you run the flow desktop and see if SAP is getting the new cells.
Hope thats help