web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Is the JSON wrong? I c...
Power Apps
Answered

Is the JSON wrong? I can't get the data I want in the collection

(0) ShareShare
ReportReport
Posted on by yuri_f 11
 
Hello
I'm a PowerApps beginner.

 

I want to display the JSON acquired by the HTTP connector in the gallery.

But it seems that the JSON is written incorrectly.

This JSON was set in the "Response Body JSON Schema" when returning the data retrieved by PowerAutomate from the HTTP Connector to PowerApps in the response.
Perhaps the content written in this "JSON Schema of the response body" is incorrect.
But I don't know how to fix it.

 

Can somebody help me?

 

This is what I'm doing now

・If you set the data acquired by PowerAutomate → HTTP connector as it is to "Response sample", the table type data will be returned to the collection.(Nested by result)
3.png2.png

・If you remove the location nested in the JSON Schema of the response body, the collection will only show the titles described in the schema and you will not be able to retrieve the data.

 

Should I change the JSON?
Or can you display the table type data in the gallery?

 

Here is my JSON

Spoiler (Highlight to read)
{
    "type": "object",
    "properties": {
        "result": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "u_glide_date_1": {
                        "type": "string"
                    },
                    "sub_technical_responsible": {
                        "type": "string"
                    },
                    "sys_updated_on": {
                        "type": "string"
                    },
                    "number": {
                        "type": "string"
                    },
                    "sys_updated_by": {
                        "type": "string"
                    },
                    "u_string_28": {
                        "type": "string"
                    },
                    "u_string_29": {
                        "type": "string"
                    },
                    "sys_created_on": {
                        "type": "string"
                    },
                    "u_string_26": {
                        "type": "string"
                    },
                    "u_string_27": {
                        "type": "string"
                    },
                    "u_string_24": {
                        "type": "string"
                    },
                    "u_string_25": {
                        "type": "string"
                    },
                    "u_string_22": {
                        "type": "string"
                    },
                    "company_project_manager": {
                        "type": "string"
                    },
                    "project_manager": {
                        "type": "string"
                    },
                    "u_string_23": {
                        "type": "string"
                    },
                    "u_string_20": {
                        "type": "string"
                    },
                    "u_string_21": {
                        "type": "string"
                    },
                    "sys_created_by": {
                        "type": "string"
                    },
                    "billing_site_code": {
                        "type": "string"
                    },
                    "responsible_department": {
                        "type": "string"
                    },
                    "u_string_19": {
                        "type": "string"
                    },
                    "transfer_department_code": {
                        "type": "string"
                    },
                    "u_string_17": {
                        "type": "string"
                    },
                    "u_string_18": {
                        "type": "string"
                    },
                    "u_string_15": {
                        "type": "string"
                    },
                    "u_string_16": {
                        "type": "string"
                    },
                    "u_string_13": {
                        "type": "string"
                    },
                    "u_string_14": {
                        "type": "string"
                    },
                    "u_string_12": {
                        "type": "string"
                    },
                    "u_string_10": {
                        "type": "string"
                    },
                    "responsible_name": {
                        "type": "string"
                    },
                    "reception_date": {
                        "type": "string"
                    },
                    "company_technical_manager": {
                        "type": "string"
                    },
                    "pid_daicho_rcl_mail": {
                        "type": "string"
                    },
                    "sys_id": {
                        "type": "string"
                    },
                    "technical_manager": {
                        "type": "string"
                    },
                    "pid_daicho_responsible_name": {
                        "type": "string"
                    },
                    "u_string_7": {
                        "type": "string"
                    },
                    "u_string_6": {
                        "type": "string"
                    },
                    "u_string_5": {
                        "type": "string"
                    },
                    "u_string_4": {
                        "type": "string"
                    },
                    "department_technical_manager": {
                        "type": "string"
                    },
                    "u_string_8": {
                        "type": "string"
                    },
                    "sys_mod_count": {
                        "type": "string"
                    },
                    "sys_tags": {
                        "type": "string"
                    },
                    "billing_company": {
                        "type": "string"
                    },
                    "u_string_33": {
                        "type": "string"
                    },
                    "u_string_34": {
                        "type": "string"
                    },
                    "u_string_3": {
                        "type": "string"
                    },
                    "u_string_31": {
                        "type": "string"
                    },
                    "u_string_32": {
                        "type": "string"
                    },
                    "u_string_30": {
                        "type": "string"
                    }
                }
            }
        }
    }
}
{    "type": "object",    "properties": {        "result": {            "type": "array",            "items": {                "type": "object",                "properties": {                    "u_glide_date_1": {                        "type": "string"                    },                    "sub_technical_responsible": {                        "type": "string"                    },                    "sys_updated_on": {                        "type": "string"                    },                    "number": {                        "type": "string"                    },                    "sys_updated_by": {                        "type": "string"                    },                    "u_string_28": {                        "type": "string"                    },                    "u_string_29": {                        "type": "string"                    },                    "sys_created_on": {                        "type": "string"                    },                    "u_string_26": {                        "type": "string"                    },                    "u_string_27": {                        "type": "string"                    },                    "u_string_24": {                        "type": "string"                    },                    "u_string_25": {                        "type": "string"                    },                    "u_string_22": {                        "type": "string"                    },                    "company_project_manager": {                        "type": "string"                    },                    "project_manager": {                        "type": "string"                    },                    "u_string_23": {                        "type": "string"                    },                    "u_string_20": {                        "type": "string"                    },                    "u_string_21": {                        "type": "string"                    },                    "sys_created_by": {                        "type": "string"                    },                    "billing_site_code": {                        "type": "string"                    },                    "responsible_department": {                        "type": "string"                    },                    "u_string_19": {                        "type": "string"                    },                    "transfer_department_code": {                        "type": "string"                    },                    "u_string_17": {                        "type": "string"                    },                    "u_string_18": {                        "type": "string"                    },                    "u_string_15": {                        "type": "string"                    },                    "u_string_16": {                        "type": "string"                    },                    "u_string_13": {                        "type": "string"                    },                    "u_string_14": {                        "type": "string"                    },                    "u_string_12": {                        "type": "string"                    },                    "u_string_10": {                        "type": "string"                    },                    "responsible_name": {                        "type": "string"                    },                    "reception_date": {                        "type": "string"                    },                    "company_technical_manager": {                        "type": "string"                    },                    "pid_daicho_rcl_mail": {                        "type": "string"                    },                    "sys_id": {                        "type": "string"                    },                    "technical_manager": {                        "type": "string"                    },                    "pid_daicho_responsible_name": {                        "type": "string"                    },                    "u_string_7": {                        "type": "string"                    },                    "u_string_6": {                        "type": "string"                    },                    "u_string_5": {                        "type": "string"                    },                    "u_string_4": {                        "type": "string"                    },                    "department_technical_manager": {                        "type": "string"                    },                    "u_string_8": {                        "type": "string"                    },                    "sys_mod_count": {                        "type": "string"                    },                    "sys_tags": {                        "type": "string"                    },                    "billing_company": {                        "type": "string"                    },                    "u_string_33": {                        "type": "string"                    },                    "u_string_34": {                        "type": "string"                    },                    "u_string_3": {                        "type": "string"                    },                    "u_string_31": {                        "type": "string"                    },                    "u_string_32": {                        "type": "string"                    },                    "u_string_30": {                        "type": "string"                    }                }            }        }    }}

Please Help me

thank you

Categories:
Building Power Apps
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @yuri_f :

    From your JSON, your return value should be in a nested structure. The data you need is stored in the field "result".

    So I suggest you add ".result" when the call returns the result.For example:

    ClearCollect(test,'YourFlow'.Run().result)

    Best Regards,

    Bof

  • yuri_f Profile Picture
    yuri_f 11 on at

    clearcollect (collectionname, Flow.run (). result)
    I was able to operate as expected with ".result".
    I hope it helps someone

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 414

#2
Valantis Profile Picture

Valantis 387

#3
timl Profile Picture

timl 344 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans