Answered

Power Automate

(0) Share

Report

Posted on by Ramadas

Unable to process template language expressions in action 'Approving Email' inputs at line '0' and column '0': 'The template language expression 'first(outputs('List_rows_present_in_a_table')?['body/value'])['ApprovingEmail']' cannot be evaluated because property 'ApprovingEmail' cannot be selected.

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (1)

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

Seems that „ApprovingEmail“ is not part of your array. Have you checked the output of “List rows present in a table”?

Was this reply helpful? Yes No
Ramadas 12 on at

Like (0)

Report

This is the List rows I have

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

You have to open a previous run and check the output of this action. There you can find what data was received.

Was this reply helpful? Yes No
Ramadas 12 on at

Like (0)

Report

It skipped the dependent action

Was this reply helpful? Yes No
Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

I don‘t see the step „List_rows_present_in_a_table“ in your flow run history. It has to be before the error of course. This step has an output and that is important for you to find.

Was this reply helpful? Yes No
Ramadas 12 on at

Like (0)

Report

And this is the OUTPUT from the download

Was this reply helpful? Yes No
Verified answer

Matthy79 4,180 Super User 2024 Season 1 on at

Like (0)

Report

It seems that your array is empty. If you want the formula to work even with empty arrays this will do the work:

first(outputs('List_rows_present_in_a_table')?['body/value'])?['ApprovingEmail']

Was this reply helpful? Yes No
Ramadas 12 on at

Like (0)

Report

It worked now. Awesome, Thank you very much for your help👍

Was this reply helpful? Yes No
Ramadas 12 on at

Like (0)

Report

Looks like on my expression there was an extra character which caused the error.

Was this reply helpful? Yes No