Skip to main content
Community site session details

Community site session details

Session Id : 1k//iFWROh8W4zJgK/iwzm
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 21 Apr 2023 00:26:07 by 911 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 24 Apr 2023 at 07:48:59
    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
    911 Super User 2024 Season 1 on 21 Apr 2023 at 12:21:57
    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 21 Apr 2023 at 03:04:35
    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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete