Unanswered

Power Apps is giving me wrong outputs from PowerAutomate

(0) Share

Report

Posted on by logost1agow

Hello everybody

I'm having some troubles about flow outputs in Power Apps

I have this flow

The output (Response) from flow is right, giving me right outputs, but when I show the data in powerapps, it seems 'addicted' to me, because it doesn't show the columns according to the correct output

It always shows the columns of a specific output.
On monitor I can see that PowerApps receive the right data, but when I manage it into collection, It is wrong

For example:

Output 1:
{
A:1
B:2
C:3
}

Next run, if different data, when the columns have the same name, it gives me the values, otherwise, if have different columns, It shows blank.

{
C:10
😧 blank
F: blank
G: blank
}

It doesn't show me right columns according to flow outputs
Has anyone ever experienced this? Could you tell me how to get around this situation

Thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-jefferni on at

Like (1)

Report

Hi @logost1agow ,

A collection will have static columns once it's been created. Thus, you should output an object with all the possible columns from Flow to your App. Could you please share screenshots of flow run history and show the results of the HTTP action? Sensitive data can be masked.

Best regards,

Was this reply helpful? Yes No
logost1agow 65 on at

Like (0)

Report

Thanks for helping @v-jefferni !

There is the information you asked for, I just transferred the data to VScode to show, to be able to show all the data

As you can see, the data above is ok, is taking info from all columns correctly (Some columns are blank in the first print becausa we don't use some columns at the beggining, but now we have data as we can see in PowerApps print, that are the recently ones)

But when I run flow again, I have other columns as you can see, but It gives me the same table format (all columns as the first) and only the 'StartDate' and 'DisplayName' are filled, because they have the same column name

Sometimes this happens the other way around, I have only the 4 columns from table 2 and the blank columns from the other table

I'm using ClearCollect to catch the data from flow
Is there any way around this situation?

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @logost1agow ,

I still don't understand why the outputs of HTTP action have different table structures. Why the second run only returned 4 columns?

Best regards,

Was this reply helpful? Yes No
logost1agow 65 on at

Like (0)

Report

HTTP request gets information from 2 different APIs, depending on the input, that's why it brings different columns.
Is this not supported in PowerApps? I wanna know why the columns from flow doesn't show correctly in PowerApps

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @logost1agow ,

Generally speaking, in the Response action the JSON schema is defined for all the columns of tables/ that pass to PowerApps, which also means columns of the table being passed to PowerApps are static. So, if you only need 4 columns to be passed to PowerApps, you can use a parse JSON action below the HTTP request, after that use a Select action to map only those 4 columns and pass the result array to PowerApps. As the result, there would be a collection with only 4 columns in PowerApps.

Best regards,

Was this reply helpful? Yes No