Skip to main content

Notifications

Power Automate - General Discussion
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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard