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

(2) Share

Report

Posted on by 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": ""
}
]

Categories:

General topics

I have the same question (0)

All responses (38)

Answers (0)

m3ngi3 725 on at

Like (0)

Report
Copy link

Link copied!
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??

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
elltav22 6 on at

Like (0)

Report
Copy link

Link copied!

have the same issue

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Show your "Initialize variable"

Was this reply helpful? Yes No
elltav22 6 on at

Like (1)

Report
Copy link

Link copied!

the problem is converting object to array

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Could you show real outputs of Compose action?

Was this reply helpful? Yes No
CW 1,044 on at

Like (2)

Report
Copy link

Link copied!

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???

Was this reply helpful? Yes No
CW 1,044 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
aburke 4 on at

Like (1)

Report
Copy link

Link copied!

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"
}

Was this reply helpful? Yes No
CW 1,044 on at

Like (0)

Report
Copy link

Link copied!

Tom Riha's article worked for me
https://tomriha.com/how-to-convert-array-to-a-string-in-power-automate/

Was this reply helpful? Yes No