vbScript output syntax?

(0) Share

Report

Posted on by Zy_Sin

Hi,

I am running PAD for SAP using vbScript and had echo out 4 items into it's variable hereby %VBScriptOutput%

How do i write each item onto excel?
i tried %VBScriptOutput[1]% onto cell A1 but it only wrote 9, how do i write the entire 99047030 onto cell A1?

What is the syntax i should put?

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Deenuji_Loganathan_ 6,250 Moderator on at

Like (2)

Report
Copy link

Link copied!
@Zy_Sin
Please follow the below suggested approach.
First use split function and split your text variable(vbscriptoutput) with newline and iterate with foreach and write into your excel.

Code:

Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance SET VBScriptOutput TO $'''99047030 90019853 0.00 515.83''' Text.SplitText.Split Text: VBScriptOutput StandardDelimiter: Text.StandardDelimiter.NewLine DelimiterTimes: 1 Result=> TextList LOOP FOREACH CurrentItem IN TextList Excel.GetFirstFreeRowOnColumn Instance: ExcelInstance Column: $'''A''' FirstFreeRowOnColumn=> FirstFreeRowOnColumn Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CurrentItem Column: $'''A''' Row: FirstFreeRowOnColumn END

How to copy/paste above code into your power automate flow?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Zy_Sin 79 on at

Like (0)

Report
Copy link

Link copied!

Hi
it works
can you help with this syntax
i want it to do the following if the split text item 1 is not empty but it don't seem to work for what i wrote here
if Not %TextList[1]% Then
....
thanks

Was this reply helpful? Yes No
eetuRobo 4,478 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I think the issue there is that your syntax is doing if without comparing it to anything. You would need to compare it to something. What are you trying to check in that if statement?
So lets assume %TextList[1]% = 123. Your syntax is asking "If Not 123 then do something" but the syntax doesn't determine what should be 123.
Also I am not sure but it might be better to use <>
So if you want to check if it is empty then:
If %TextList[1]% <> "" Then

Was this reply helpful? Yes No