I've got the above error when building a long-ish flow based on a prototype that worked fine. The full error message is this:
Unable to process template language expressions in action 'SetBusinessAreas' inputs at line '0' and column '0': 'The template language function 'json' parameter is not valid. The provided value 'GetBusinessAreas' cannot be parsed: 'Unexpected character encountered while parsing value: G. Path '', line 0, position 0.'.
It occurs at this step in my flow:
The idea is to format the response to a multi-option question in MS Forms so that it can be written to a similar column in a SharePoint list. The parameters set in GetBusinessAreas and SetBusinessAreas are as follows:
As mentioned above, I've had a smaller prototype using these actions working fine. Whatever the issue is, I'll be able to apply it to 4 more similar constructs prior to creating my item in SharePoint. Any ideas, folks?
Hi abm
Thanks for taking the time to offer a solution to my issue. I checked my flow again this morning prior to rebuilding as per your suggestion and found the problem. I'd forgotten to include the 'outputs' method in my json expression for the "SetBusinessAreas" step. It originally looked like this:
json('GetBusinessAreas')
But should have looked like this:
json(outputs('GetBusinessAreas'))
I've now come across another glitch in a different step that I'll try to resolve myself (pretty new at this game). Thanks again 🙂
Hi @ColinH
Please try the following:
Above expression is as follows:
WarrenBelz
146,776
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional