No return from my flow using Respond to a PowerApp

(0) Share

Report

Posted on by HenkVlootmN

I send a photo (bas64) to Power Automate by using this code:

Collect(PicResult;{JSONTable: StarliveFaceAPI_v1_test.Run(JSON_64)})

The Power Automate flow StarliveFaceAPI_v1_test contains three steps: PowerApp (V2), HTTP and Respons to a PowerApp or flow. The flows runs well, because Power Automate returns in Respond to a PowerApp or flow the requested JSON table. The output of the Respond to a PowerApp is set to Text and the parameter is named JSONTable, that uses the body of the HTTP request an there the JSON table.

I expect the JSON table to be placed as a table in the PicResult, column JSONTable collection. Unfortunately Power Automate only returns a blank row, no table. I tried to use SET in order te collect a variable, but that neither works.

Can anyone tell me what I am missing here? Thanks, Henk

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

BCLS776 8,994 Moderator on at

Like (0)

Report
It's cumbersome to get a table back from a flow, but it can be done. First, the documentation on this and have a look specifically at this section:

The next thing you need to do is wrap your JSON in a Table() function to separate the individual items into rows:

Collect(PicResult; { JSONTable: Table(StarliveFaceAPI_v1_test.Run(JSON_64)) })

Depending on your schema, you may be able to use the ForAll() as shown in the documentation to further parse. Parsing JSON record types is difficult with the current functionality I find and I often give up on trying to send back a valid JSON and instead send an array of expected types that is easier to parse.

Hope that helps,

Bryan

Was this reply helpful? Yes No
HenkVlootmN 15 on at

Like (0)

Report

Adding the Table() function is not accepted by PowerApps since the run command is not a valid table. In my opinion this is not the problem, since this is a base64 text string that is accepted in Power Automate. I'm looking for the return value into the collect(ion). I have a JSON table returned and even change into a text value, but I don't see the return value (flow1.png). The result in PowerApps is an empty row (Flow2,png)!

Flow2.png

Flow1.png

Was this reply helpful? Yes No
HenkVlootmN 15 on at

Like (0)

Report

I never found such a stupid solution. If you have changed a flow you need to refresh the flow in PowerApps. So change your flow, save the flow and then refresh the flow in PowerApps. Thank you for your help!

Was this reply helpful? Yes No