cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amairaz85
New Member

Compose issue

am trying to converted my date in excel in Power Automate

i'm using compose function with below formula 

addDays('1899-12-30',int(outputs('Compose')),'dd-MM-yyyy')

 

error pop up 

InvalidTemplate. Unable to process template language expressions in action 'Compose_2' inputs at line '1' and column '15765': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

It looks like you are doing a date conversion from Excel - you no longer need to do that.

In your Excel action, set the DateTime format (Advanced options) to ISO 8601 - that way a date will be returned.

image.png

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

1 REPLY 1
ScottShearer
Super User
Super User

It looks like you are doing a date conversion from Excel - you no longer need to do that.

In your Excel action, set the DateTime format (Advanced options) to ISO 8601 - that way a date will be returned.

image.png

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,478)