Array' cannot be initialized or updated with value of type 'String'.

[nikitamobile85]

Hello everyone,

I' m trying to initialize a variable like shown on the screenshot but getting an error message 

The variable 'vAuthorization' of type 'Array' cannot be initialized or updated with value of type 'String'. The variable 'vAuthorization' only supports values of types 'Array'. I'm a bit confuced by this error cause I have checked everything and array format should be fine. Please advise!

[
{
"Postion": "Applicant",
"Name": "@{triggerOutputs()?['body/Author/DisplayName']}",
"Status": "Submitted",
"Date": "@{formatDateTime(triggerOutputs()?['body/Created'], 'yyyy-MM-dd')}",
"Signature": ""
},
{
"Postion": "MNG",
"Name": "@{triggerOutputs()?['body/General_x0020_Manager/DisplayName']}",
"Status": "@{outputs('Get_item')?['body/General_x0020_Manager_x0020_appr/Value']}",
"Date": "",
"Signature": ""
},
{
"Postion": "DGM",
"Name": "@{triggerOutputs()?['body/Deputy_x0020_General_x0020_Manag/DisplayName']}",
"Status": "@{outputs('Get_item')?['body/DGM_x0020_approval/Value']}",
"Date": "",
"Signature": ""
},
{
"Postion": "GM",
"Name": "@{triggerOutputs()?['body/Manager/DisplayName']}",
"Status": "@{outputs('Get_item')?['body/Manager_x0020_approval/Value']}",
"Date": "",
"Signature": ""
},
{
"Postion": "Chief Accountant/FD Asst Manager",
"Name": "@{triggerOutputs()?['body/Chief_x0020_Accountant/DisplayName']}",
"Status": "@{triggerOutputs()?['body/Chief_x0020_Accountant_x0020_app/Value']}",
"Date": "",
"Signature": ""
},
{
"Postion": "FD Deputy GM",
"Name": "@{triggerOutputs()?['body/FD_x0020_Deputy_x0020_GM/DisplayName']}",
"Status": "@{outputs('Get_item')?['body/FD_x0020_Deputy_x0020_GM_x0020_a/Value']}",
"Date": "",
"Signature": ""
},
{
"Postion": "GD",
"Name": "@{triggerOutputs()?['body/General_x0020_Director0/DisplayName']}",
"Status": "@{outputs('Get_item')?['body/General_x0020_Director/Value']}",
"Date": "",
"Signature": ""
}
]

[Django]

That is strange!

This works for me:

[
{
"FolderOrder" : 1,
"FolderPath": "A_Engagement Letter and scoping"
},
{
"FolderOrder": 2,
"FolderPath": "B_Planning"
},
{
"FolderOrder": 3,
"FolderPath": "C_Documentation"
},
{
"FolderOrder": 4,
"FolderPath": "D_Reporting"
},
{
"FolderOrder": 5,
"FolderPath": "E_Quality Review"
}
]

Result:

Are the empty values an issue or maybe the double quotes are of the wrong type??

[VictorIvanidze]

I'm not sure but it seems you cannot use dynamic values in "Initialize  variable" action.

Initialize it with [] and add array elements after that.

[elltav22]

have the same issue

[VictorIvanidze]

Show your "Initialize variable"

[elltav22]

  
the problem is converting object to array 

[VictorIvanidze]

Could you show real outputs of Compose action?

[CW]

Me too. Very simple. It looks correct. 

[
{
"userid": 1,
"firstName"; "Sarah",
"lastName"; "Tabor"
},
{
"userid": 2,
"firstName"; "Bob",
"lastName"; "Taylor"
},
{
"userid": 3,
"firstName"; "Jeff",
"lastName"; "Green"
},
{
"userid": 4,
"firstName"; "James",
"lastName"; "Tabor"
}
]

Then same error. ?????????????????????????????????????

Every time you try and do something with this blasted platform I always, ALWAYS run into these SANAFUs. EACH AND EVERY TIME!!

So it only works if its a Tuesday with a full moon???

[CW]

Yes, that worked for me as well, but the other didn't. Same structure, as far as I can tell.

[aburke]

---

 I know it's been a few weeks, so you probably already figured this out, but those colons look like semicolons. 

{
"userid": 4,
"firstName"; "James",
"lastName"; "Tabor"
}

[CW]

Tom Riha's article worked for me

https://tomriha.com/how-to-convert-array-to-a-string-in-power-automate/

[Anonymous]

I'm having the same issue and I'm not using dynamic content. I'm hard coding the array on init. Did you find a solution?

Here's my schema:

[
{
"Name": "Jonnie H.",
"UPN": "Jonnie.H@email.com"
},
{
"Name": "Kevin G.",
"UPN": "Kevin.G@email.com"
},
{
"Name": "Ken W.",
"UPN": "Ken.W@email.com"
}

]

[Anonymous]

When I go to peek the code I see this: 

"\n[\n    { \n        \"Name\": \"Jonnie H.\",\n        \"UPN\": \"Jonnie.H@email.com\"\n    },"

Looks like it's wrapping the entire schema in double quotes which is converting it to a string. Any idea how to get it to not do this?

[VictorIvanidze]

Please show your "Initialize variable" in edit mode.

[CW]

Try the replace function based on the content of that action.

[VictorIvanidze]

Hi @CW, 

replace function in initialize variable? Really?

[Anonymous]

Here it is

[VictorIvanidze]

Hi @Anonymous,

it is the renamed "Initialize variable" action, correct?  And what error do you see?

[Anonymous]

Yes, it is an initialize variable I just renamed it for readability in the overall flow. Here is a screenshot of the exact error I'm getting.

[Chriddle]

In general, this error means that your JSON is not correct and is therefore interpreted as a string value.

Just check your value with a JSON validator: https://jsonformatter.curiousconcept.com/#