Unanswered

Cannot Connect JSON Script into PowerApps Using Power Automate

(0) Share

Report

Posted on by HarryPipes

I am trying to connect a PowerApps application to an Azure function through PowerAutomate, I have requested the output from the function successfully, however when I try to pass those values back into PowerApps I get no output, only the variable names with no values, even though the raw output is almost indentical in nature to data previously extracted successfully from an SQL database.

I have attached below the outputs of my response call and JSON Parse call to see if there are any issues there

Any ideas would be much appreciated

Cheers

Raw output from response block

Raw output from Parse Json block

Collection data in PowerApps

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @HarryPipes ,

You will not need the Parse JSON operator in your flow because Response action already included this operation. Please generate JSON schema from the template, populate the template of below:

[ { "Materials":"", "PerfReq":"" } ]

So the Response bode JSON Schema would be as follows:

{ "type": "array", "items": { "type": "object", "properties": { "Meterials": { "type": "string" }, "PerfReq": { "type": "string" } }, "required": [ "Meterials", "PerfReq" ] } }

Best regards,

Was this reply helpful? Yes No
HarryPipes 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Jeffer
Unfortunately had already tried this initially but it didn't parse the Json Correctly, here is what it outputs without
this doesn't parse at all properly in to PowerApps, same as before

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @HarryPipes ,

I can see the output is correct, so the problem is going into PowerApps. Could you please share more details of your App, particularly the button where triggers the flow?

Best regards,

Was this reply helpful? Yes No
HarryPipes 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Jeffer,
Currently I have a button that I use to generate the table, I pass it two label values that concatenate from a gallery, though these are just test inputs and only partly determine the output
with the two labels being label 1 and 2 respectively
This is the function that calls the Power Automate flow
This is the output

whilst the Power Automate flow outputs the following
So I think there is an issue connecting between PowerAutomate and PowerApps, but can't diagnose what

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @HarryPipes ,

I created a variable in a flow and test it with responding to PowerApps in a collection, which worked fine:

Could you please share the flow with screenshots so that we will be able to understand how you process the data from PowerApps?

Best regards,

Was this reply helpful? Yes No