cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Invalid template error

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Hi @trr0068 

 

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

View solution in original post

3 REPLIES 3
Microsoft
Microsoft

Hi @trr0068 

 

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

View solution in original post

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

Hi @trr0068 

 

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Kudoed Authors
Users online (81,946)