Get Response output is randomized, not Form field names

[Anonymous]

I need to create  JSON expressions in my Flow using the schema created by Get Response Details. However the output is not the names of the fields, but rather the long string of random number typically seen when creating an expression. "r843513873.....". How do I get the output to be the actual field name, such as first name, last name, etc?

Thanks

[grantjenkins]

I feel your pain - the output is horrible.

If you have access to premium connectors then you can use an HTTP request using the forms api to retrieve the names and associated ids then perform a dynamic mapping within your flow.

Alternatively you could map out an object manually using a Select then add a Parse JSON step using the output from the Select.

[Anonymous]

Thanks...no premium connectors.

Can you walk me through the alternate method? Broad strokes and I'll puzzle it out.

I'm trying to take a form response that has about 30 lines of "r" random id's. I need to grab 6 of them and make them integers so that later on in the flow, I can do (mul) calculations in an email response.

So far, I have this. 

Am I on the right track? How do I parse JSON from here?

[grantjenkins · Accepted solution]

Hopefully this is what you're looking for.

For this example, I'm using the following Microsoft Form.

See full flow below. I'll go into each of the actions.

When a new response is submitted and Get response details is what you already have.

Compose builds up our object containing the values we want from our Microsoft Form (the quantities). I've also converted them to numbers (int) since they always come back from Microsoft Forms as strings. The expressions used are below. Note that you would just need to use your names and dynamic Ids here.

{
    "BizCardQuantity": @{int(outputs('Get_response_details')?['body/r744b46f0008349129dff96dc2d43a0e6'])},
    "LetterheadQuantity": @{int(outputs('Get_response_details')?['body/r96d7c4c0b75d4beabc102f16dbf97279'])},
    "CustomEnvQuantity": @{int(outputs('Get_response_details')?['body/r89a8124c44d94d3a9a016b786b5b73e1'])},
    "RegEnvQuantity": @{int(outputs('Get_response_details')?['body/r8e1bf2568b1143d581047d44d54a722b'])}
}

IMPORTANT: At this point you should save and run your flow and copy the output from the Compose. You will use this to build your schema in the Parse JSON step next.

Parse JSON uses the output from Compose. And for the schema, click on Generate from sample, and paste in the output you copied in the last step. This will generate the schema based on your data.

Compose Test is just showing how you can now get your data via the Parse JSON dynamic properties to use in your calculations, etc.

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

[Anonymous]

Thanks, Grant. Just what I'm looking for. I'll work it in the next couple of days and come back and accept it. Very much appreciated.

[Anonymous]

Brilliant. Well-explained, worked like a charm and, not only that, I understand the process. Thanks so much