Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Invalid template error

(0) ShareShare
ReportReport
Posted on by

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

  • v-duann-msft Profile Picture
    v-duann-msft on at
    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

  • 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 at
    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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics