cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GiovanniVetere
Frequent Visitor

Power Automate HTTP response of JSON array to table or Gallery

I have a power automate that grabs data and converts it into an JSON array, I have a Power Apps that calls this Flow.

 

I dump the results of the run function into a collection, however, on testing, the collection has a variable called 'Value' and inside this is the array data in table format.

 

I can't seem to show this data in a table or gallery as they don't see the columns??

GiovanniVetere_2-1660643973104.png

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "productCode": {
                "type": "string"
            },
            "statusCode": {
                "type": "string"
            },
            "priceList": {
                "type": "string"
            },
            "listPrice": {
                "type": "string"
            },
            "standardCost": {
                "type": "string"
            },
            "salesMargin": {
                "type": "string"
            },
            "isObsolete": {
                "type": "string"
            },
            "productDescription": {
                "type": "string"
            }
        },
        "required": [
            "productCode",
            "statusCode",
            "priceList",
            "listPrice",
            "standardCost",
            "salesMargin",
            "isObsolete",
            "productDescription"
        ]
    }
}

 

GiovanniVetere_1-1660643944546.png

 

 

GiovanniVetere_0-1660643922337.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
AJ_Z
Super User
Super User

First(PricingData).Value

Try that 🙂



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

View solution in original post

4 REPLIES 4
AJ_Z
Super User
Super User

what happens when you put the response in a First()

e.g. First(Value)

does it then bring out the data inside?



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

Where do I use First()?

AJ_Z
Super User
Super User

First(PricingData).Value

Try that 🙂



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

AJ_Z
Super User
Super User

Thanks for accepting this as the answer!

 

 

 



Signature:


If you appreciated my comments/responses please be sure to Like/Kudo them it really does make me smile 🙂 !
Link to the Power Platform Professionals United Kingdom User Group:

https://powerusers.microsoft.com/t5/Power-Platform-Professionals/gh-p/PowerPlatformProfessionalsUnit...

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,735)