web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How do I "expand" a ta...

Power Apps

Answered

How do I "expand" a table? It is an array inside a JSON object

(0) Share

Report

Report

Posted on by dlprentice

628

Hey All

I've got an array inside a JSON object that I'd like to output to a data table. How do I do this?

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@dlprentice

PowerApps does not support turning a JSON text string into a table.

You would either need to employ PowerAutomate to try and parse the JSON and return to PowerApps, or if your array is fairly simple (single array of name value pairs), then you can do it with a relatively simple formula in PowerApps.

I hope this is helpful for you.
dlprentice 628 on at

Like
a
(0)

Report
Copy link

Link copied!
@RandyHayes

I think I need to elaborate. I am getting some SharePoint items (more than 2000 by a lot). The objects that make up the table I want are nested in array called "value". Does this make my objective a bit clearer?

This part in particular is the part I'm having trouble with:
"body": { "type": "object", "properties": { "@@odata.nextLink": { "type": "string" }, "value": { "type": "array", "items": { "type": "object", "properties": { "@@odata.etag": { "type": "string" }, "ItemInternalId": { "type": "string" }, "ID": { "type": "integer" }, "Title": { "type": "string" }, "Status": { "type": "string" }, "yfyu": { "type": "string" }, "nnku": { "type": "string" }, "cj7y": { "type": "string" }, "fm1s": { "type": "string" }, "Created": { "type": "string" }, "Modified": { "type": "string" }
Verified answer

dlprentice 628 on at

Like
a
(0)

Report
Copy link

Link copied!

I might be good to go, I used a Select action in PA to do some mapping, and it appears to be working now.

Join the conversation