Answered

Power Apps Collection from a JSON Blob

(0) Share

Report

Posted on by zematsirhc

I'm using Power Automate to retrieve large volumes of data from a SP List to get around delegation. The return is a JSON blob, in this format:

To access the fields, the template I'm using has this:

Table(ParseJSON(QueryResult))

And then you access the column like this: Value.column_name

My issue is that I have a huge app with hundreds of controls all mapped to the column names, so I don't want to edit them all to be Value.column_name.

Does anyone know how to transform the table to use the original column names?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@zematsirhc

You need to use the Rename function and rename them all

I am too lazy to link my own site lol.. So here are some folks I have found to be very helpful and accurate

Rename The Columns In A Collection - Matthew Devaney

AddColumns, DropColumns, RenameColumns, and ShowColumns functions - Power Platform | Microsoft Learn

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
zematsirhc 90 on at

Like
a
(0)

Report
Copy link

Link copied!

This isn't quite working. Since the table doesn't directly have the columns (field_2, field_3), etc., I'm unable to rename them. I also tried Value.field_2, but both are giving me the error, "The specified column does not exist."

My guess is that it's because of the Table(ParseJSON()) structure of the data.
Verified answer

zematsirhc 90 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay, I ended up figuring it out.

The JSON was nesting all the columns below a "Value" column. I needed to use

ClearCollect(NewCollection, AddColumns("New Column Name", Value.Column_name));

which allowed me to bring the values up. I also had to cast each column with Text() or Value() since PowerApps couldn't infer the data types from JSON.