Answered

Convert json from Flow to collection

(0) Share

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 (5)

Answers (1)

Sort by

Pstork1 69,201 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
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
Copy link

Link copied!
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 69,201 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

How did you do this?

Was this reply helpful? Yes No