Response an instance of Power apps from Power Automate

(0) Share

Report

Posted on by Evbelda

I'm Trying to get data from a PowerList using a PowerAutomate in a PowerAPP

The only way I could find is using a block Called "Response an instance of Power apps or a flow"

But the answer it can be only a text, number, date, email, file, boolean. Not an Array.

So, I can only get the data from power automate from a Text data: Json (text), a CSV (text), a html (text), etc

I try to convert Text in a Collect inside Power apps with Match, MatchAll, etc. But text return is too long (more than 20 fields.

The simpliest way was trying with CSV. This is an example:

The CSV format is: "Title, TituloPropuesta, DireccionN1, .... \r\n, 14, QQD SBC resto de Accesos menos VoLTE. V, Pruebas Cliente, ... \r\n"

ClearCollect(TextoLibre;MatchAll(Datos.respuesta; "[^,]+" ).FullMatch)

But I couldn't separate Titles (first row) "\r\n", asign the titles to de Array Titles from content.

How can I do that?, and there are any way to do this returning an Array from power Automate?

This is the result making; Set(Mostrar;JSON(TextoLibre;IndentFour))

[ { "FullMatch": "Title" }, { "FullMatch": "TituloPropuesta" }, { "FullMatch": "DireccionN1" }, { "FullMatch": "Estado" }, { "FullMatch": "AprobaciónComite" }, { "FullMatch": "Importe" }, { "FullMatch": "FechaComite" }, { "FullMatch": "Direccion" }, { "FullMatch": "Gerencia\r\n14" }, { "FullMatch": "QQD SBC resto de Accesos menos VoLTE. V" }, { "FullMatch": "Pruebas Cliente" }, { "FullMatch": "Aprobada" }, { "FullMatch": "Aprobado Comité" }, { "FullMatch": "1000000" }, { "FullMatch": "2022-02-08" }, { "FullMatch": "Mi direccion" }, { "FullMatch": "Mi gerencia\r\n" } ]

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (4)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Look at this thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Collect-JSON-data/td-p/683712

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @Evbelda ,

You could use 'response' action instead of 'Response an instance of Power apps or a flow' action.

This action could return an array from flow to canvas.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Evbelda 64 on at

Like (0)

Report

@v-xiaochen-msft thnak a lot, but where you cn find this action ("response") in automate?
I send you a capture of I can see when I look for "response".
I couldn't find the dark green "response" object. Is it necesary an specific profile?

Was this reply helpful? Yes No
Evbelda 64 on at

Like (0)

Report

Ok @Nogueira1306 , I'll try to include the "big" expression to my code, and I'll answer you.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Evbelda ,

It looks like this is caused by different translations.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Evbelda 64 on at

Like (0)

Report

Fine!!!!
Next to the solution. I found it: "Respuesta" but it is PREMIUM:
Anyway I tried it:
with a JSON schema exactly the answer of the list generated . I checked that out of "Respuesta" has data, it is not empty.
Then I get answer in power apps:

Set(RespuestaPAuto;JSON(RespuestaListaaPowerAuto.Run();IndentFour));;
But RespuestaPAuto is null, so may be the "Respuesta" block is not returning data to PowerApps.

Could be for PREMIUM caracteristic or any other problem?

Thanks for continue trying with this!

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (1)

Report

Hi @Evbelda ,

There are many tutorials for this action online.

For your information:

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Evbelda 64 on at

Like (0)

Report

First of all, thank you very much for your information. Finally I could try the flow and I going to explain how I could get It:
The output of the PowerList its to complex to parse it, so I should use a JSON
analysis block with the body. After it, I get in a variable as Matrix to convert object to array, only with the values answered, with the pattern of the JSON analysis (we need to execute it to obtain the pattern of the powerlist answer):

This method clean other information not used in the content of the data, so after that we can apply de response block:
Also, we take the pattern of the matrix to include it in the response JSON scheme (we need to execute it to obtain the pattern of the matrix answer)
In PowerApps, we asociate the flow to a button with the next code:

Set(QueryResult;PruebadeflujoResponse.Run());;

Important! We no "Clearcollect", only Set, because The flow-back is a Table.
If we'd like to asociate this result to a Gallery, we only need to put it in the Item property and we get this:

QueryString is a table, and we can show everyvalue in a place of the gallery

Thanks for all!

Was this reply helpful? Yes No