Power Platform Community Forum Thread Details

Hi I have a flow where by people answer questions on MS Forms and it saves it into Word. Some of the questions have numerous answers to it. With the help of users in here I have been able to remove the '[]' from multichoice responses and for it to not fail if the question is skipped or branched over.

The issue i think I am facing now is if the multichoice question - only one choice is chosen then its failing. I am using if(empty(json(outputs('Get_response_details')?['body/r06ac0a9ab07d4da58b1d3c320484f67d'])),null,join(json(outputs('Get_response_details')?['body/r06ac0a9ab07d4da58b1d3c320484f67d']), decodeUriComponent('%0D%0A'))) at present but I am getting an error that states: Unable to process template language expressions in action 'Populate_a_Microsoft_Word_template' inputs at line '0' and column '0': 'The template language function 'json' parameter is not valid. The provided value 'The LEV system will be tested at intervals not exceeding 14 months by a competent person.' cannot be parsed: 'Unexpected character encountered while parsing value: T. Path '', line 0, position 0.'. Please see https://aka.ms/logicexpressions#json for usage details.'.

Any ideas or solutions please?

Categories:

Building flows

Dear clarkyb,

There could be various things wrong here ... but difficult to figure out what exactly.

My first thoughts are:

Instead of "if(empty(json(outputs('Get_response_details')?['body/r06ac0a9ab07d4da58b1d3c320484f67d'])),null,join(json(outputs('Get_response_details')?['body/r06ac0a9ab07d4da58b1d3c320484f67d']), decodeUriComponent('%0D%0A')))" can you try "if(empty(outputs('Get_response_details')?['body/r06ac0a9ab07d4da58b1d3c320484f67d']),null,join(outputs('Get_response_details')?['body/r06ac0a9ab07d4da58b1d3c320484f67d'], decodeUriComponent('%0D%0A')))"?
It could be that the value/field you are trying to retrieve is empty or cannot be retrieved, which in some functions gives an error like ".... inputs at line '0' and column '0': ". You could test this by ensuring that you have a value, maybe by hardcoding it in the expression.
Overall, in shaping the right expressions, I have found that ChatGPT is a great help ... also with wrong expressions.

Hope the suggestions help,

Happy flowing,

Koen