Unanswered

Email address's not being recognized, error showing data is not string/email format

(0) Share

Report

Posted on by Community Power Pla...

Hello I have a flow that runs off a microsoft form. It sends an email to the email address selected from a question on the form. It has been working for a year up to a couple weeks ago. I get this error.

The 'inputs.parameters' of workflow operation 'Send_an_email_(V2)' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'emailMessage/To' is required to be of type 'String/email'. The runtime value '"name.lastname@company.com\n"' to be converted doesn't have the expected format 'string/email'.

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

It looks like you have a carriage return that is being included in the value you are submitting as the email. That's what the \n is. You'll need to do a replace() on the email be using it to remove that value.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

HI pstork1,
Would this be written replace( "email address" ) or do you mean to just simply erase and replace the existing email address?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
I normally do that using the following.

Replace(<<emailstring>>, decodeUriComponent('%0A'),'')

But here's a good blog on the topic.

How to replace new line ('\n') in a Power Automate expression (tomriha.com)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

After some thought. I'm not sure how to implement this in my scenario. This flow is run off of a microsoft form and the To: value in the send email action could have 1 of 5 different email address's depending on which one is selected in the form.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Can you show some screenshots of your flow?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

What are people entering in response to the Assigned User IDs question? The To field in the email needs to be a string with a semicolon delimited list of email addresses. Unless that is what is being put in the answer in the form you'll need to process the answer to get that string.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The Assigned User Id question response is a selection of email addresses (which is our User Id's), only 1 can be selected. The answer for what goes in the To field is the same response. It's interesting it isn't working because this same flow was working in previous months.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I just tested this with a different selection (email address) to the question. And the flow ran. The only email address that it is failing on is mine. Could this be failing because the form is under my microsoft account, and it's not letting me send myself an email?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

That was it. I just re made the form and moved all the connections to a general company account and it is working fine now

Was this reply helpful? Yes No