cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamFestival
Regular Visitor

Array variable "value of type 'String'" error when testing the Flow

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'.

screencapture-emea-flow-microsoft-manage-environments-Default-e757cfdd-1f35-4457-af8f-7c9c6b1437e3-flows-450597f6-6474-484a-b3e4-6f9e9f7d470f-2021.png

1 ACCEPTED SOLUTION

Accepted Solutions
JamFestival
Regular Visitor

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.

View solution in original post

4 REPLIES 4
Paulie78
Super User
Super User

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.

JamFestival
Regular Visitor

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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,270)