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.

All responses (9)

Answers (1)

Ramadas 12 on at

Like (0)

Report

Re: Power Automate

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

Like (0)

Report

Re: Power Automate

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

Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Power Automate

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']
Ramadas 12 on at

Like (0)

Report

Re: Power Automate

And this is the OUTPUT from the download
Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Power Automate

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.
Ramadas 12 on at

Like (0)

Report

Re: Power Automate

It skipped the dependent action
Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Power Automate

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

Like (0)

Report

Re: Power Automate

This is the List rows I have
Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Power Automate

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