Hello all,
I have been struggling with this for about a week now and have tired a quite a few different things; including using an initialize/append string instead of array then splitting the string.
Basically, I am using list rows present in a table with a column that contains user UPN -> initialize array variable -> Apply to each loop -> Salesforce Get Record action passing through user UPNs -> Compose to write out the Salesforce Contact ID -> Append to Array Variable -> Compose to write out the Array.
When doing so it is returning what is expected similar to:
[
"XXXXXAW",
"XXXXXAH"
]
As a safety measure, I am using a parse Json to make sure this is an array next using the schema:
{
"type": "array",
"items": {
"type": "string"
}
}
Finally, I am doing another apply to each loop taking the body output from the the Parse Json -> Compose to write out the individual Contact ID's -> Salesforce connector to assign assets to the specific contact ID.
I am getting the following error:
InvalidTemplate. Unable to process template language expressions in action 'Create_record' inputs at line '0' and column '0': 'The template language expression 'outputs('Indiv.ContactID')?['$']' cannot be evaluated because property '$' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'.
Flow keeps changing the Input (red arrow in screenshot) from the output of Indiv.ContactID to what is seen.
Please help!!!!!