Power Automate Error: InvalidTemplate Unable to process template language expressions in action

Question

Hi Technical Experts,

I am a beginner to Power Automate.

I created a simple flow to send reminder emails to the team on pending tasks, based on the due date in the excel file stored in OneDrive.

I get error at 'Create-Html_table' step and the error is

InvalidTemplate Unable to process template language expressions in action 'Create_HTML_table' inputs at line '0' and column '0': 'The template language expression 'outputs('Filter_array')['body/value']' cannot be evaluated because property 'body/value' doesn't exist, available properties are 'body'.

Please see attached flow details and corresponding error.

Any help will be highly appreciated.

Thanks,

Jay

Answer 1

Jay,

I have just recently run into this issue as I have not used the Filter Array function very much. There is a bug where when selecting the dynamic content for the Outputs of the Filter Array call, it fills in the code "outputs('Filter_array')['body/value']" where that doesn't exist. If you enter an expression that says "outputs('Filter_array')['body']", you will get what you need.

Best regards!

Adam

Answer 2

Sorry, previous uploaded picture was messed-up . Please see below the details

Answer 3

Dear Jay,

From the screenshots, you seem to directly select the row column from the List rows present in a table which will cause Apply_to_each not get a filtered array.

You may use item()?['columnname'] instead of the direct selection.

For example, sub(int(item()?['DueDate']),4) is less than or equal to 45395 in Filter Array.

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 4

Dear Jay,

Thanks for your updates.

I may need some time to investigate the issue and I'll update here as soon as possible.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 5

Dear Jay,

The screenshots aren't uploaded successfully. If it is convenient, you can click on Reply>Insert image to see whether the screenshots are successfully updated.

Note: Remove any private information before uploading the screenshots.

From the error message, it seems that the array can't be captured by the flow.

I have shared a demo for your reference. You can check whether it works in your environment.

For example, I want to filter the tasks whose due date is greater than 4/20/2024 and less than 5/2/2024 and create an array for the HTML table.

You can use the filter query: @and(greater(item()?['Due Date'], '2024-04-20T00:00:00.000Z'), less(item()?['Due Date'], '2024-05-02T00:00:00.000Z'))

Task: item()?['Task']

Due Date: formatdatetime(item()?['Due Date'],'yyyy/MM/dd')

Output:

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator