web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Convert json from Flow...

Power Apps

Answered

Convert json from Flow to collection

(0) Share

Report

Report

Posted on by KS-04101812-0 Microsoft Employee

I have a Power Automate Flow that returns the following json:

[{'Item':'Document.docx'},{'Item':'Document1.docx'}]

In PowerApps I am trying to convert it to a collection.

Set(SearchRslts, PowerApp.Run());

ClearCollect(TestColl, SearchRslts.searchlist);

I then look at the TestColl and it just has one element, instead of two. Any idea on what is wrong here?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Pstork1 68,729 Most Valuable Professional on at

Like (2)

Report
Two potential issues I see.

1) are you using Respond to Power Apps or HTTP response action? If you are using Respond to Power Apps that is the problem. It cannot return a JSON array. It can only return an object with multiple properties. You need to use the HTTP Response action to return an array.

2) You should be creating the collection directly from the response, not storing it in a variable first.

ClearCollect(TestColl, PowerApp.Run());

Was this reply helpful? Yes No
KS-04101812-0 Microsoft Employee on at

Like (0)

Report
I switched my Flow to return an HTTP response and then call ClearCollect(TestColl, PowerApp.Run()) and that still did not work. What does the http response need to be. Does it need to be a json object or json array. Currently, I am returning

[{'Item':'Document.docx'},{'Item':'Document1.docx'}]

from the flow. Is that correct?

Was this reply helpful? Yes No
Verified answer

Pstork1 68,729 Most Valuable Professional on at

Like (0)

Report

It needs to be a JSON array and you need to have the appropriate JSON schema loaded in the HTTP response action.

Was this reply helpful? Yes No
KS-04101812-0 Microsoft Employee on at

Like (0)

Report

I got it working. The issue was I needed to change the json string to use double quotes instead of single quotes.

Was this reply helpful? Yes No
DH-27020923-0 on at

Like (0)

Report

How did you do this?

Was this reply helpful? Yes No

Join the conversation