web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Why does JSON function...

Power Apps

Unanswered

Why does JSON function not support arrays?

(0) Share

Report

Report

Posted on by camer314

173

The JSON function does not seem to work at all with arrays:

Set(arrtest, JSON({arr: [1,2]}))

This should produce perfectly legal JSON however it insists on wanting to create key/value pairs, so instead it produces:

{"arr": [{"Value":1},{"Value":2}]}

Which is entirely incorrect. How can I get it to produce proper json for array data?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

{arr: [1,2]} is a record of an object that contains a property that is an array. That's exactly what the JSON() is translating it too. For the JSON to work correctly the array has to be an array of Key/Value pairs. Otherwise you will get the default key of "Value". This is not an incorrect translation. It is the proper translation of what you have submitted as JSON.

{arr: [1,2]} is not the same thing as [{arr:1}, {arr:2}]. Which would convert to what you want as JSON.
camer314 173 on at

Like
a
(0)

Report
Copy link

Link copied!
I still cant get this to format JSON the way I want. I am trying to call a custom connector that accepts a json object, that object is defined as:

public class ProductInput { public Collection<int> Values { get; set; } }

If I create an instance of this in code and then serialize it I get what I expect, which is not something I can reproduce with the JSON formula:

var x = new ProductInput() { Values = new System.Collections.ObjectModel.Collection<int>() }; x.Values.Add(1); x.Values.Add(2); var s = JsonConvert.SerializeObject(x); // "{\"Values\":[1,2]}"

Join the conversation