Unanswered

undefinedUnable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The template language function 'json' expects its parameter to be a string or an XML. The provided value is of type 'Integer'. Please see https://aka.ms/logicexpressions#json for usage de

(0) Share

Report

Posted on by Ben_Miller

Need help please...

My low used to work perfectly but now it doesnt. I've tried to rebuild it but I deleted the original. I dont understand what I'm doing wrong. Its a simple flow to collect MS form responses and put them into a sharepoint list.

I've used the forms to sharepoint flow template
I've followed online/video tutorials to use the apply to each action
I've correctly mapped all list columns to questions
The flow says it will work but when I submit a form response it fails with the following error:

Unable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The template language function 'json' expects its parameter to be a string or an XML. The provided value is of type 'Integer'. Please see https://aka.ms/logicexpressions#json for usage details.'.

How do I find column and line 0 to change the type?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,768 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Ben_Miller,

The error from the screenshot is caused by the fact you are trying to convert a number (integer) value to a json type value. That json function only allows text (string) or xml type of values as input.

If you want to keep this flow logic and just fix your error you could convert the number to text first before you use it in the json function. Try the below:

json(string(triggerOutputs()?['body/resourceData/responseId']))

Was this reply helpful? Yes No
Ben_Miller 34 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus - thank you for your response. Unfortunately this didn't work and still getting the same error. Its strange as the flow used to work perfectly when the dynamic content was to use "List of Responses" but this no longer exists.

Oddly, when I take the Get response details and create item out of the "Apply to each" - it works.

Many thanks
Ben

Was this reply helpful? Yes No
Ben_Miller 34 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus

I've managed to solve it.
thanks for your input.

Ben Miller

Was this reply helpful? Yes No