Unable to process template language expressions in action 'Return_value(s)_to_Power_Virtual_Agents' inputs at line '0' and column '0

(0) Share

Report

Posted on by CU20080932-1

I using filter array to filter data as output below:

[
{
"@odata.etag": "",
"ItemInternalId": "0262cbd9-6c2c-",
"sku_num": "709-BBFE ",
"item_short_name": "CH",
"service_level_code": "AB",
"SL_Update_Dts": "0.6",

}
]

then we want to display "item_short_name" value as output but getting above error

output expression: concat(first(body('Filter_array'))['item_short_name'])

All responses (4)

Answers (1)

CU20080932-1 99 on at

Like (0)

Report

Re: Unable to process template language expressions in action 'Return_value(s)_to_Power_Virtual_Agents' inputs at line '0' and column '0

@v-jefferni yes, there is only one item in the filter output. you solution works. thank you so much!!
Verified answer

v-jefferni on at

Like (0)

Report
Re: Unable to process template language expressions in action 'Return_value(s)_to_Power_Virtual_Agents' inputs at line '0' and column '0

Hi @Yallaling ,

Could you please confirm that there would be only one item in the array of Filter array outputs? If this is the case, you can use below expression to have a test:

body('Filter_array')[0]?['item_short_name']

Best regards,
CU20080932-1 99 on at

Like (0)

Report

Re: Unable to process template language expressions in action 'Return_value(s)_to_Power_Virtual_Agents' inputs at line '0' and column '0

error:

Unable to process template language expressions in action 'Return_value(s)_to_Power_Virtual_Agents' inputs at line '0' and column '0': 'The template language expression 'concat(first(body('Filter_array'))['item_short_name'])' cannot be evaluated because property 'item_short_name' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.
CU20080932-1 99 on at

Like (0)

Report

Re: Unable to process template language expressions in action 'Return_value(s)_to_Power_Virtual_Agents' inputs at line '0' and column '0

@Expiscornovus please help