Unanswered

Respond from Flow with success or fail from each item

(0) Share

Report

Posted on by JimmyW

2,563

Im trying to figure out how to return data to power apps from flow. I can return strings and Boolean values. But i want to return and show each item that has failed or successes.

My Power App lets the user select multiple files and then multiple locations the files should be created at. I then want to return the data for each item if it succeeded or failed in being created at the location.

I'm not really sure how to do this. I guess i need to get the respond result from the apply to each first?

2020-03-22 14_26_05-Edit your flow _ Power Automate.png

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

JimmyW 2,563 on at

Like (0)

Report

Or if possible collect everything in a table and send as email.
For example

Apply to each results for each location.
Filename1.pdf Success
Filename2.pdf Fail
Filename3.pdf Success
Filename4.pdf Success

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report
So i figured out how to get success message

array(outputs('Create_file')['statusCode'])

Then i create a HTML table from this.
But how do i join all tables for each item as i know get 1 table for each item i just want one big table containing the results from all apply to each items.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

Rather than creating an HTML table I would suggest creating an Array and then return that as JSON using a Power Apps using a Respond to HTTP request. The JSON array can be saved as a collection making it available in Power Apps to be loaded into a data table or Gallery for display.

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

@Pstork1 Thank you for answering.
Im not really sure how to do that, my array seems to only contain 1 item as i do a apply to each in flow. So my return for the json would just contain 1 item i guess?

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report

@Pstork1 Im just getting the data for 1 item. I dont know how to join them into one big json or table.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

If you initialize an array variable before you enter the Apply to Each loop you can append the results to the Array inside the loop so that you don't end up with just one response. When you use a compose you are just overwriting the result each time you loop.

Was this reply helpful? Yes No