Parson JSON Error - need help understanding to create approval workflow.

(0) Share

Report

Posted on by bkcovington

I'm fairly new to automate and have been trying to create a flow that takes a file uploaded to a form and sends it to 2 people for approval. I've followed this tutorial. But I keep getting an error on the third action.

The error:

InvalidTemplate. Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'The template language expression 'body('Get_response_details')?['re00719d160f0409c8c5460c6e2655a04']' cannot be evaluated because property 're00719d160f0409c8c5460c6e2655a04' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

Screenshot 2023-12-13 at 12.04.42 PM.png

Any suggestions on how to solve?

All responses (1)

Answers (1)

Verified answer

Pstork1 65,997 Most Valuable Professional on at

Like (1)

Report

Re: Parson JSON Error - need help understanding to create approval workflow.

The response you are trying to parse is in an array. You can parse the entire array or if you want to parse each entry in the array you'll have to do it in an apply to each loop. Check to see if SplitOn is enabled in the trigger. When the forms connector originally shipped it wasn't, so each forms response was submitted as part of an array. That's why you use an Apply to each to get hte response details. Enabling splitOn will let you submit each form as a single instance of the flow. That would let you parse this response because it wouldn't be in an array of responses anymore.