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

Date Conversion error - worked fine yesterday?

Hi all, i have a flow that is taking a date from an excel file, comparing it today's date in a conditional and then, if they match, do some stuff.

 

yesterday - this worked fine. today, it fails with the error:
Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2885': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.


so here are the expressions i'm using to convert the date from the excel file to be the same for comparison purposes:

 

first - the excel input (using the "value - list of items" dynamic content:

formatDateTime(addDays('1900-01-01', add(int(items('Applytoeach')?['Date Conversion']), -2)), 'MM-dd-yyyy')

[Date Conversion] is my excel date column. my input looks like this once read out:
2021-01-13T00:00:00.000Z

 

next, i have an expression to get today's date for comparison:

formatDateTime(utcNow(), 'MM-dd-yyyy')

 

which is where the flow fails and i get the above error.

 

note, i have hundreds of dates in here, and they all fail, not just particular dates.

 

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-duann-msft
Community Support
Community Support

Hi @Seuadr 

 

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

Seuadr
Helper IV
Helper IV

so just to close the loop on this - they switched it back. you know, after i changed a couple dozen flows 😛 (at least it was only a couple dozen)

https://www.dontpapanic.com/blog/?p=681

 

View solution in original post

3 REPLIES 3
v-duann-msft
Community Support
Community Support

Hi @Seuadr 

 

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

Seuadr
Helper IV
Helper IV

right you are! thanks! i didn't even think to look for a change to the connector...

Seuadr
Helper IV
Helper IV

so just to close the loop on this - they switched it back. you know, after i changed a couple dozen flows 😛 (at least it was only a couple dozen)

https://www.dontpapanic.com/blog/?p=681

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,666)