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.'.
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
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.
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