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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Collections returing v...
Power Automate
Unanswered

Collections returing value: True when API requests are sent using Flow

(0) ShareShare
ReportReport
Posted on by 29

Hi,

 

I'm looking to utilise data (in the form of JSON from a custom API) to create collections in powerapps but the flow i'm currently running seems to return one column: Value with True as the only column value. So the flow seems to work fine - but I can't get any of the data that is in the response from the JSON.

 

 

PowerAuto (1).pngPowerAtuto(2).png

 

 

The idea is to create an app that sends requests to the API returing the JSON in a flow to the App, I've seen a lot of posts suggesting to re assemble the flow and then try it again which hasn't worked for me, but I haven't been able to find a response that worked in my situation.

 

Another issue is that when I include a schema in the Response part of the flow (as i have above), when I attempt to add the flow to powerapps I get the error: Registering error - again I've seen the posts that suggest fields aren't given values however I've checked and they all seem to have values.

 

JSON schema:

{
    "type""object",
    "properties": {
        "total": {
            "type""integer"
        },
        "nb_pages": {
            "type""integer"
        },
        "items": {
            "type""array",
            "items": {
                "type""object",
                "properties": {
                    "id": {
                        "type""integer"
                    },
                    "percentage": {
                        "type""number"
                    },
                    "approaches": {
                        "type""array"
                    },
                    "Alpha": {
                        "type""array",
                        "items": {
                            "type""object",
                            "properties": {
                                "id": {
                                    "type""integer"
                                },
                                "name": {
                                    "type""string"
                                },
                                "parent": {
                                    "type""object",
                                    "properties": {
                                        "id": {
                                            "type""integer"
                                        },
                                        "name": {
                                            "type""string"
                                        }
                                    }
                                }
                            },
                            "required": [
                                "id",
                                "name"
                            ]
                        }
                    },
                    "attributes": {
                        "type""array"
                    },
                    "countries": {
                        "type""array"
                    },
                    "structure": {
                        "type""array"
                    },
                    "cap": {
                        "type""array"
                    },
                    "regions": {
                        "type""array"
                    },
                    "gamma": {
                        "type""array"
                    },
                    "focus": {
                        "type""array"
                    },
                    "as_of": {
                        "type""string"
                    },
                    "geographic": {
                        "type""object",
                        "properties": {
                            "id": {
                                "type""integer"
                            },
                            "name": {
                                "type""string"
                            }
                        }
                    }
                },
                "required": [
                    "id",
                    "percentage",
                    "approaches",
                    "alpha",
                    "attributes",
                    "countries",
                    "structure",
                    "cap",
                    "regions",
                    "focus",
                    "gamma",
                    "as_of"
                ]
            }
        }
    }
}
 
Any help would be much appreciated!
 
Thank you
Categories:
I have the same question (0)

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 315 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 273 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 117 Super User 2026 Season 1

Last 30 days Overall leaderboard