Unanswered

Mismatch in data types when Returning data to PowerApp from cloud flow

(0) Share

Report

Posted on by sb_teal

128

I'm having problems with a mismatch in data types between the output of the "Respond to a PowerApp or Flow" action and the expected data type in PowerApps. Also, the variable name doesn't respect the camel case I give it in the flow.

I'm using the PowerApps connector, "Respond to a PowerApp or Flow" action. The output type selected in the action is not respected when passing the data back to PowerApp, it seems that no matter what data type I select for the output, it is passed as a string.

For example, when I select "Number" as the output type, the json is formatted as string and I see the mismatch error in Monitor: you can see in the output that by enclosing the value in quotes, it is a string:

The same situation arises with Yes/No datatype:

How can I ensure I have the same data type between the output from the Flow and the expected data type in PowerApps - why isn't the data type being respected?

I have success only when I use the "Text" output type in the "Respond to a PowerApp or Flow" action. I'd like to be able to use the other output types, otherwise what is the point of having different output types if they are not actually respected in the JSON?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

I haven't seen the issue with camel case, but the other issues are known bugs when using the Respond to Power Apps action. Yu can either pass everything as string and convert it in Power Apps or use the HTTP response action where you can specify the actual JSON schema for the returned values.

Was this reply helpful? Yes No
sb_teal 128 on at

Like (0)

Report

Thanks for letting me know @Pstork1 . I couldn't find details of known issues - do you have a URL where this issue is documented? I couldn't find the connector reference docs either - the other Power Apps connectors are listed but not the "Power Apps (v2)" one I use.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/common-issues-and-resolutions

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

Like (0)

Report

This is the documentation, such as it is.

Return data to PowerApps from a flow - Release Notes | Microsoft Docs

The fact that Number and Yes/No data types don't work correctly is a known issue, but its not documented anywhere that I'm aware of.

Was this reply helpful? Yes No
cherniaevpublic 3 on at

Like (0)

Report

Using "Response" action solved the issue. Action "Response to power app or flow" seems to be still bugged and does not respect typing. Thanks for advice!

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

Like (0)

Report

The workaround to get this to respect the real types is to use literals for the first run of the flow. After that you can substitute the variables that contain the typed data in the output. Something about using literals the first time gets Power apps to accept the correct schema. Not sure why the bug hasn't been fixed, but that workaround does work.

Was this reply helpful? Yes No