Array in Excel Table - Duplicating column values in every row

Documents
1

Hi,

I am currently working on an excel template that will be filled up by JSON data through PowerApps. I am calling PlumSail through PowerAutomate. I am using the example of Array as advised in one of the documents by Plumsail on how to use it.

My issue is that its duplicating all the columns including the one in which data needs to be updated.

My JSON:
{
"myArray": [
[
"LOTO-01",
"Yes",
"Desc1",
"No",
"Open",
"50",
"ISM"
],
[
"LOTO-02",
"Yes",
"Desc2",
"No",
"Closed",
"50",
"ISM"
],
[
"LOTO-03",
"No",
"Desc3",
"No",
"Closed",
"50",
"ISM"
]
]

}

image
image1432×1004 64.1 KB

Below is the output

image
image1134×833 57.7 KB

As you can see its duplicating column B values which is really odd

Has anyone faced this before ?

Or am I doing something wrong ?

Thanks.

-Irfan

2

PS: Just realized that its adding extra columns instead of overwriting in the same cell/row.
Since I have 7 records, it has actually added extra 7 columns from the right and has moved the other columns to the left. It has then copied the value from first column to other columns.

3

Hi @irfan.polra,

I replied in the support ticket.

Best regards,
Petr
Plumsail team