Unanswered

Error: Array elements can only be selected using an integer index

(0) Share

Report

Posted on by Ashish2605

Hi All,

I am trying to create a flow where I want to send an adaptive card to each o365 member listed in my teams group. While creating the below flow, I am getting an error saying, "Unable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The template language expression 'body('LGM')?['value']?['mail']?[0]' cannot be evaluated because property 'mail' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'."

I am getting 3 JSONs where I want to extract the mail from individual body, as shown in my screenshot(arrowed in red). How do i do that?

Attached are the screenshots, can you let me know where do I need to correct the expression?

Thanks for your help.

Categories:

General topics

PA error 1.png

PA error.png

PA flow error.png

I have the same question (0)

All responses (4)

Answers (0)

Sundeep_Malik 6,484 on at

Like (1)

Report

Hey @Ashish2605

Your expression here is a little incorrect.

The expression should be:

body('LGM')?['value']?[0]?['mail']

Actually here value is your array and after your array you will have to put your iteration and then the field you want.

I hope this helps 🙂

Was this reply helpful? Yes No
Ashish2605 27 on at

Like (0)

Report

Hi @Sundeep_Malik ,

Thanks for the suggestion, however I am getting the below error now

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('LGM')?['value']?[0]?['mail']' is of type 'String'. The result must be a valid array.

How do i convert this string to array?

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (1)

Report

@Ashish2605

Oh instead of this just pass the value expression in apply to each.

body('LGM')?['value']

And then inside apply to each you can use adaptive card action and use email there.

Was this reply helpful? Yes No
Fars4 7 on at

Like (1)

Report

You saved me,

Was this reply helpful? Yes No