web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Problem with jSON arra...

Power Apps

Answered

Problem with jSON array coming from Power Automate to a Canvas App

(0) Share

Report

Report

Posted on by nmendes

17

I have a Power Automate flow that is returning (using a HTTP Response action) a json array with some data.

I'm calling the flow and storing the response with in a onSelect of a button as this:

Set(
 json,
 Table(myFlow.Run())
)

I know that the flow is returning the correct data as I can see inspect the content when I press the button:

Screenshot 2024-04-20 at 23.30.00.png

Now, the problem is that I get the right columns but no values:

Screenshot 2024-04-20 at 23.32.59.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Sunil Kumar Pashikanti 2,313 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nmendes ,

Use ClearCollect Instead of Set: Instead of using Set to store the response, try using ClearCollect to create a collection from the flow’s output. This can sometimes handle JSON arrays better.

ClearCollect( jsonCollection, myFlow.Run() )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
nmendes 17 on at

Like
a
(1)

Report
Copy link

Link copied!

Sunil,
I tried that before and the result is the same.

Was this reply helpful? Yes No
Verified answer

nmendes 17 on at

Like
a
(1)

Report
Copy link

Link copied!
Ok, the problem was that the schema generated in the HTTP Response action Power Automate was wrong. It was defining the response as an object instead of an array.

Here's the correct schema:

{ "type": "array", "items": { "type": "object", "properties": { "name": { "type": "string" }, "description": { "type": "string" } }, "required": [ "name", "description" ] } }

Was this reply helpful? Yes No

Join the conversation