Answered

Http Response back to Power Apps

(0) Share

Report

Posted on by JeannieF

Hello,

I have a flow where I'm trying to get the http response back to power apps. I get the proper response in my flow but it only returns a true/false value in my collection instead of the results of my variable array. Any thoughts on why it would just return True/False instead of the contents of my errors variable?

I'm collecting the error messages in my flow using a variable array

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (3)

Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report
Make sure the HTTP response action contains an appropriate JSON Schema. Otherwise what you get in Power Apps is just a true or false. Also, to load it into a collection in SharePoint it should be an array of records not just an array of strings. Change your Append to Array statement to include a record indicator before and after and a property name.

{ "property": <<your code>> }

Was this reply helpful? Yes No
JeannieF 15 on at

Like (0)

Report

I don't know Json very well so I'm not sure what the schema should look like. my flow processes a CSV file to post to an ERP system so there's no sharepoint. I'm just looking to load the errors in the collection. I've tried several schemas withouth success.

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

Like (1)

Report

You don't need to write the schema manually. Once you get the JSON array built you can use the Generate schema from sample button in advanced properties of the response object to generate the schema. Just take the output from a sample run and paste it into the dialog that opens when you press that button. That will generate the schema for you.

But you do need to change your append to array statement as I described in my last reply also.

Was this reply helpful? Yes No
JeannieF 15 on at

Like (0)

Report

Thank you for your response. I'm not sure I understand how to change my array to include the record indicators and property name as instructed below. Can you provide a graphic as to what it should look like? Again, many thanks.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report
I already did that. Take everything you currently have in the Append to Array functions in the Value section and put that in the following Where it says <<your code>>.

{ "property": <<your code>> }

The results will then look more like this

[

{ "property": "I 200 is not valid Customer_Code Line No 1 200"},

{ "property": "I 260 is not valid Customer_Code Line No 2 200"},

{ "property": "I 260 is not valid Customer_Code Line No 3 200"},

{ "property": " Line No 4 200"},

etc....

]

Was this reply helpful? Yes No
JeannieF 15 on at

Like (0)

Report

Many Thanks for your assistance thus far. I'm using concat to add the curly brackets but no matter how I format the formula I get the escape characters in my output.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

Adding the curly brackets and the property: field name using Concat makes it a string, that's why you are getting the escape characters. Everything in the sample I gave you except your values should just be typed into the field in the append box, not entered using a formula. Just type what I gave you in and then replace the <<your code>> with your formula.

Was this reply helpful? Yes No
Suggested answer

Ramiz 245 on at

Like (0)

Report

Hi,

Are you using the respond to Power App action in the flow?

I have a same app and flow and I send request to an ERP as well and return the values like that and its working fine.

Was this reply helpful? Yes No
JeannieF 15 on at

Like (0)

Report

Thank you Ramiz but in that solution I believe you used the text prompt so it returns the entire array as one record. I needed it to return an actual array of records which that response doesn't support. With the help of Pstork1 I was able to get it to work.

Was this reply helpful? Yes No