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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,417)