Answered

The execution of template action 'Select' failed cannot be evaluated because array index '1' is outside bounds (0, 0) of array

(0) Share

Report

Posted on by Cmundy

I'm running across this error

The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "Title": "@item()['Title']", "Email": "@item()['Email']", "First and Last Name": "@trim(concat(split(item()?['Title'], ',')[1], ' ', split(item()?['Title'], ',')[0]))", "User Principal Name": "@item()['UserPrincipalName']" }' failed: 'The template language expression 'trim(concat(split(item()?['Title'], ',')[1], ' ', split(item()?['Title'], ',')[0]))' cannot be evaluated because array index '1' is outside bounds (0, 0) of array. Please see https://aka.ms/logicexpressions for usage details.'.

I did not write the original code so I'm trying to figure out why it is failing. Any and all advice is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report

Hi , @Cmundy
This error code due to your "split(item()?['Title'], ',')[1]" code .
This may happen when your Title do not have the ',' character.
So you need to use the "split(item()?['Title'], ',')?[1]" , so if the Title do not have the ',' character, it will return blank in your side .

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Cmundy 8 on at

Like (0)

Report

So I looked at the raw input and for the title input this is what I'm receiving:

"Title": "Archer, Amy A",

It has the ',' inside of the title. So I'm not sure why it would be giving me the error. I can make the changes you recommended and see if it remedies the situation.

Was this reply helpful? Yes No