I am trying to initialise an array variable for a single-row HTML table (I'd actually prefer the data to be transposed into rows due to the vast amount of columns, but that's not the issue).
I am initialising the variable with the syntax:
[
{
"Name of first value": dynamic content,
"Name of seconds value": dynamic content
}
]
The dynamic content is a mix of Form entries and variables previously assigned values in the Flow.
It is returning the error when I test the flow:
The variable 'Assessor Table' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'Assessor Table' only supports values of types 'Array'.
Solved! Go to Solution.
To clarify, I am trying to create a single-row table. I thought that, for a single row, all elements in the array need to be contained in curly braces.
I have now abandoned this idea and simply formatted an HTML table within the email, with the data presented vertically by row. Thank you for the advice.
You have the opening bracket the wrong way around and the JSON is not properly formed, try this:
{
"Name of first value": "dynamic content",
"Name of seconds value": "dynamic content"
}
Sorry, that was a typo. The brackets are the right way 'round in the Flow
But you were also missing curly braces.
To clarify, I am trying to create a single-row table. I thought that, for a single row, all elements in the array need to be contained in curly braces.
I have now abandoned this idea and simply formatted an HTML table within the email, with the data presented vertically by row. Thank you for the advice.
Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
User | Count |
---|---|
54 | |
42 | |
39 | |
34 | |
34 |
User | Count |
---|---|
72 | |
64 | |
59 | |
58 | |
50 |