Power Platform Community Forum Thread Details

All,

I am trying to create an array for my variable "Managers". How can I fix this error?

Error message:
The value 'x' of type 'Array' cannot be appended to the variable 'X' of type 'Array'. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

SQL Table:

Column Name: Managers
Row 1: test@test.com;test@test.com

Row 2: test@test.com;test@test.com

Thanks

Categories:

Building flows

Hi @PowerAppsUser99 ,

Apparently Power Automate does not allow you to create an "array of arrays". I ran some tests and a possible solution here is to convert your child array in a string (you can use the 'join()' expression for that) and, if you need the child array in a later action, split it again.

With this approach, your would get this result:

array_input_1: ['test@test.com', 'test1@test.com']

array_input_2: ['user@test.com', 'user1@test.com']

output: ['test@test.com, test1@test.com', 'user@test.com, user1@test.com']

Please note that you will have all the emails from each row in a same string (and each of these strings being elements of your array variable), and that's why you will have to split it in a future action if you need to access these values individually.

Let me know if it works for you or if you need any additional help.