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

(0) Share

Report

Posted on by wonka1234

920 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?

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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-wenjuan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-wenjuan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No