How to iterate over list of json objects using VB script in power automate desktop

(0) Share

Report

Posted on by Atharvazd

I have a list of json objects which needs to be iterated to populate the data into excel using VB script.

LR = %TestJsonObject.Count%

For i=0 To LR

sht.Range("C"&i+25).Value = "%TestJsonObject[0]['Key1']%"

But when i pass i in the place of 0 in the above line ,It throws error as the variable i not identified. i have tried escape character / , also tried to split using & but still it gives error. is there any way to pass the vb script run time variable inside power automate variable when used in VB script.

PS: i have a scenario as the each json is a row in excel and needs to be populated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Atharvazd

How you have passed the variable within vb script, could you show that ?

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The scripting actions in PAD do not accept any complex data structures as inputs or outputs. It will usually only accept numeric values and strings. If you want to pass a JSON object, you will need to pass it as a simple string first and then have VBScript convert it to an object.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No