Unanswered

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

I have the same question (0)

All responses (3)

Answers (1)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
zematsirhc 90 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

zematsirhc 90 on at

Like (0)

Report

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.

Was this reply helpful? Yes No