Answered

Invalid template error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a flow that I use everyday that grabs data from excel online and sends the selected data into an email. Everyday I either clear or paste over the yesterday's data in the excel table (not the table headers) with the new data. This has been working for the past month. Today I got the error regarding the "closed date" data. I am not sure how to resolve this problem and how it happened in the first place.

InvalidTemplate. Unable to process template language expressions in action 'Closed_Date_Formatted' inputs at line '1' and column '45431': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-duann-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Thanks for your posting.

According to your description, your flow got broken suddenly and error message related to date and time. Actually, it’s a known update for “List Rows action in the Excel Online (Business) connector” around January 15, 2021. Date format has been changed and we don’t need to do date conversion.

For detailed announcement, please kindly refer below link:
Excel Date changes in Power Automate - Power Platform Community (microsoft.com)

Hope the content above may help you.

Thanks.
Anna

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you, that explains what happened with my flow. My question now is how can I get the date in a different format now. This is what I am getting now 2021-01-20T00:00:00.000Z I would like the return date be 01/20/2021 with no time attached.

Was this reply helpful? Yes No
v-duann-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Thank you very much for your reply. Glad to hear the information is useful for you.

If you would like to remove time part, we can use formatDateTime function.

e.g. formatDateTime(items('Apply_to_each')?['Calculated'],'yyyy-MM-dd')

Please kindly check this function if you need:
Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Best regards,
Anna

Was this reply helpful? Yes No