Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0':

(0) ShareShare
ReportReport
Posted on by 909 Super User 2024 Season 1

Hi,

I am getting this error when run my power automate flow - 

 

compose - 

items('Apply_to_each')?[concat('Start of WT Period Planned ''/'' Revised Date')]
 
compose_2 - 
addDays('1899-12-30',int(outputs('Compose')),'yyyy-MM-dd')
 
These are date fields. Why is this error happening?
 
wonka1234_0-1682036737782.png

 

 

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

 

 

  • v-wenjuan-msft Profile Picture
    Microsoft Employee on at
    Re: Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0':

    Hi @wonka1234 ,

     

    You would like to add some days to 1899-12-30 right? 

    The addend should be number of days rather than a date. Please tell me specifically what days you would like to add to the 1899-12-30 and how will you get that from above action, so that I may help you to generate a function.

     

    Community Support Team _ Wenjuan Zou

    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • wonka1234 Profile Picture
    909 Super User 2024 Season 1 on at
    Re: Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0':

    how can I fix this though? These are date fields in excel going into date fields in sharepoint.

  • v-wenjuan-msft Profile Picture
    Microsoft Employee on at
    Re: Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0':

    Hi @wonka1234 ,

     

    According to your error message, the issue happens to int(outputs('Compose')). It means output from Compose is not a valid parameter to convert to integer.

     

    Seems like output from compose should be a string as concat() function could only be applied to strings.

    Refer to this link for its usage:

    Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

     

    Community Support Team _ Wenjuan Zou

    If this post helps, then please consider Accept it as the solution to help the other members find it.

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >