action compose failed

Question

action compose failed

Patricia Gwee Cheng Yuan 1

Unable to process template language expressions in action 'Compose' 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.'.

2 answers

Your answer

Answer 1

Bruno Lucas 4,436 MVP

Hi @Patricia Gwee Cheng Yuan

Look like you are trying to cast a date value to an integer

Considering the 'Reminder Date' in addDays('1899-12-30', int ('Reminder Date')) is a value like '1899-12-30' or 26/10/2022 you will get this error:

"InvalidTemplate. Unable to process template language expressions in action 'Compose' 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.'."

if that value is an integer, like addDays('1899-12-30', int ('1')), it would work

If you share what you are trying to accomplish, I may be able to help.

Patricia Gwee Cheng Yuan 1 Reputation point

2022-10-31T05:36:31.197+00:00

Hi @Bruno Lucas ,
I'm actually trying to set a email reminder base on the date from my excel.
I had tried a method but the flow will jus send email even there is nothing due for reminder.
https://powerusers.microsoft.com/t5/Building-Flows/Reminder-email-based-on-due-date-in-excel/m-p/1034610#M136795
So I am looking at another method which is this.
Bruno Lucas 4,436 Reputation points MVP

2022-10-31T06:36:41.32+00:00

Hi @Patricia Gwee Cheng Yuan
There are different ways to do that depending on the date format you have in excel.
if it is in a format like this, you can use formatdate:

but if the format is different, like '2022-11-01', it will require a different approach.

What format do you have? on your screen shot you have 1899-12-30, but this is a value for minimum date. is that the format you have?

Check this other post I've answered on a similar question: https://learn.microsoft.com/en-us/answers/questions/884670/format-time-in-logic-app.html
Patricia Gwee Cheng Yuan 1 Reputation point

2022-10-31T06:53:51.83+00:00

Hi @Bruno Lucas ,
My date are like this.
or how about if possible to help me with the part that the email wont be send if not date is due.
currently is it sending email with empty body.
Patricia Gwee Cheng Yuan 1 Reputation point

2022-10-31T07:17:20.98+00:00

Hi @Bruno Lucas
I'm actually trialing on the following:

However the apply to each will be sending me 10 separate email if I have 10 items due for email reminder.
able to help me for this? can we do away with the apply to each?
Bruno Lucas 4,436 Reputation points MVP

2022-10-31T08:58:40.177+00:00

Hi @Patricia Gwee Cheng Yuan
did you sort the date part? for that date format you have you can use
formatDateTime(utcNow(),'yyyy-MM-dd') to get today's date and

formatDateTime('your-excel-date-here','yyyy-MM-dd')

Answer 2

Hi @Patricia Gwee Cheng Yuan
For the date part, Excel returns epoch, so you can use this:

value:
if(empty(body('Get_a_row')?['dates']),null,addDays('1899-12-30',int(body('Get_a_row')?['dates']),'yyyy-MM-dd'))

and to get current time: formatDateTime(utcNow(),'yyyy-MM-dd')

To avoid sending email 10 times you need to move send email from the loop. if you need to pick data from all rows to build the email body, you can have something you can append to:

https://learn.microsoft.com/en-us/answers/questions/273842/using-array-in-logic-app-sending-email-with-multip.html

Share via

action compose failed

2 answers

Your answer