Convert a data table (with multiple rows) to JSON

[Ckatz]

Hello,

I've been researching the best way to convert a data table from excel (with multiple rows) to JSON.

I found a solution on here that appears to "mostly" work, but I am not familiar with JSON to know if it's converting multiple rows correctly.

Here is the data table that I am starting with (from excel)

Here are the steps I took to convert this to JSON

Step 1: Created an Output variable called INVObject and type is Custom Object

Question: Wasn't sure how to create a regular variable that wasn't part of another action?

Step 2: Set variable called INVObject to be empty to initialize it

Step 3: Added a For each to loop through each Data Row in the Data Table

Step 4: Added a Set Variable to set the INVObject (Custom Object) to the Data Table for each loop in the For each

Step 5: Convert the Custom Object INVObject to JSON

Results: There is one row/object with all 3 rows from the Data table on the same row.

If you scroll to the right, the 2nd row eventually starts and then the 3rd row.

I was expecting to see 3 lines/rows/object to represent the 3 different rows in the Data table.

Can someone provide some insight as to if I am doing something wrong or if this is the expected results for multiple rows?

Thank You!

[Kaif_Siddique · Accepted solution]

Hi @Ckatz ,

Refer this link to Convert DataTable to Json Object:

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Data-Table-to-JSON-object-in-PAD/td-p/132...

Hope this will help you.

Regards

Kaif