Hi all,
I am trying to automatically create orders in SAP via PowerAutomate. The whole workflow is simply as below: read basic data of orders in Excel >>> open SAP and run the VBScript to automatically create orders based on Excel data >>> copy the order number and write it back into the Excel.
However, I had several issues during testing:
1. only numbers of Excel data can be input in SAP, if the data is a combination of character and number (e.g., D111), then it fails to be input in SAP;
2. when the Excel data contains a hypen (i.e., -), then it will be recognized as minus symbol and calculation is automatically made. For example, "2-21" is the Excel data read by PowerAutomate but the actual input in SAP is "-19";
3. when the first digit of the number is 0 (e.g., 0001), the Excel data is also failed to be input in SAP.
In order to solve these issues, I tried to set the Excel data format as Text, but it didn't work in SAP system even though all the data stored in PowerAutomate are correct.
I don't know how to resolve these issues, can anybody kindly give some suggestions/share some ideas? Thanks a lot!!!
