Excel Add Row with JSON

(0) Share

Report

Posted on by Bahalzamon

I have an Excel file with some scripts that I want to return graphs. To do this so there is no conflict I plan to copy the Excel file, grab the table(s) and populate the new file with the information.

I have gotten it all but populating the table. I am unsure how to format the content so it will input into the table. There are only 2 columns Service & Count.

Here are some things I have attempted.

[{"item/Service":"Test","item/Count":"125"}]
[{"Service":"Test","Count":"125"}]
[{"Service":"Test","Count":125}]
[{"Test","125"}]
"Test","125"

Once I figure out the formatting I will do an Apply to Each with the proper records through my Select operation.

Categories:

General topics

All responses (1)

Answers (1)

Verified answer

Bahalzamon on at

Like
a
(0)

Report
Copy link

Link copied!
Figured it out, just remove the brackets lol
{"Service":"Test","Count":"125"}