web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : OO1paV6LyXrPZcpTogvbsP
Power Platform Community / Forums / Power Automate - Using Connectors / Invalid template error
Power Automate - Using Connectors
Answered

Invalid template error

Like (0) ShareShare
ReportReport
Posted on 20 Jan 2021 19:21:26 by Community Power Pla...

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

remove.PNG

I have the same question (0)
  • v-duann-msft Profile Picture
    v-duann-msft on 22 Jan 2021 at 05:55:06
    Re: Invalid template error

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

    v-duann-msft_0-1611294807901.png

     

    Please kindly check this function if you need:

    Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

     

    Best regards,

    Anna

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 21 Jan 2021 at 14:34:22
    Re: Invalid template error

    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.Date.PNG

  • Verified answer
    v-duann-msft Profile Picture
    v-duann-msft on 21 Jan 2021 at 07:45:00
    Re: Invalid template error

    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.

    v-duann-msft_0-1611215075502.png

     

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 626 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 374 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 284 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans