Unanswered

Unable to convert parameter from forms to integer for condition

(0) Share

Report

Posted on by Kai--

Hi, recently picked up power automate and I'm having an issue with converted a parameter to an integer. This is the error message:

Unable to process template language expressions in action 'Send_an_email_(V2)_3' 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.'.

Respondents indicate either 1,2,3 or 4 in the forms. If it's 1, an email is sent. If it's not 1 (2,3,4), another email is sent. This is my expression to convert the response to an integer for the condition:

int(outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847'])

Help would be sincerely appreciated!

Flow

Error message

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (1)

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (1)

Report
Hi @Kai--
Could You Show Me Output of Only This Expression.
outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847'])

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Kai--
Could You Show Me Output of Only This Expression.
outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847'])

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Kai--

I think there Is return Value Which is not Decimal value that's why It's create error.

Could you try With This Expression

int(first(string(outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847'])))

-------------------------------------------------------------------------
Did I answer your question? Please Mark my post as a solution
If you liked my response, please consider giving it a thumb up

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

It looks like the condition itself is fine. It's whatever you have within your Send an email (V2) action that's causing the issue. Can you check your int expression within your Send an email to ensure you're using the correct field.

Was this reply helpful? Yes No
Kai-- 16 on at

Like (0)

Report

Hey @Amit_Sharma thanks for your help, really appreciate it

1) Here's the output from the form for "outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847'])". It's a choice question, choose 1-4. Is this what you are looking for regarding "output of only this expression"?

2) I tried int(first(string(outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847']))) but still got the same error message

Unable to process template language expressions in action 'Send_an_email_(V2)_3' 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.'.

I'm not sure why the parameter is invalid

Was this reply helpful? Yes No
Kai-- 16 on at

Like (0)

Report

Hey @grantjenkins thanks for helping.

Send an email (V2)2 works fine but not send an email (V2)3. I can't figure out why the int expression isn't working either

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
@Kai-- Can you add a Compose within your No branch, just before your Send an email (V2) 3 action and add your choice field so you can see exactly what the raw output is.

outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847'])

Also, is that field a required field in your Microsoft Form?

Was this reply helpful? Yes No
Kai-- 16 on at

Like (0)

Report

@grantjenkins Is this what you need?

Yes it is a compulsory field, it has branching logic depending on whether 1 or 2-4 is chosen

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Couple more questions.
On the Compose you just added, can you click on Show raw outputs to see if the number is enclosed within double quotes "4", or just a number 4
Are you able to show your expression you've used within your Send an email (V2) 3 action?

Was this reply helpful? Yes No
Kai-- 16 on at

Like (0)

Report

1. Double quotes "4"
2.
Not sure if this is what you're looking for, but the expression I'm using for the condition
- outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847'])
OR (recommended by Amit)
- int(first(string(outputs('Get_response_details')?['body/r0fcb009ec0854526863a901664ae6847'])))

Was this reply helpful? Yes No