Answered

Error message in email flow

(2) Share

Report

Posted on by AC-11072016-0

I have the flow attached

I am working on a work project and have an issue I am stuck on and seeking help quickly if possible. I built a Flow where I am connecting a table in Excel and need it to send out an email based on the date column. The flow passes all test until the email portion and this is the message I get" Action 'Send_an_email_(V2)' failed. OpenApiOperationParameterTypeConversionFailed. 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 source type/format 'Object' of the value '{"ashton.coulter@htb.com":""}' is not convertible to type/format 'String/email'. "I have also included screenshots. I can't figure out what the missing issue is. I have confirmed the email is indeed correct so isn't an issue of the email not being correct and consulting with multiple sources on the internet my process has been correct. It is attempting to pull from the email column in the list because I changed the email in the table and when I did the error message reflected the updated email, so it reads the email from the table it just can't send it for some reason and I'm not sure what the issue is. Power Automate was not something I had a lot of expertise with prior and have been essentially self-teaching for this project. This is for an urgent work project, any help would be greatly appreciated. I don't think I can respond to forum request on here unless I am just missing it, so in case I have questions about an answer I just wanted to know if the easiest process to resolve the issue can be broken down step by step with directions to follow because I need to complete a work project and we don't have the package to actually call in for 1 on 1 help, and we don't have any other programmers with power automate experience.

Thank you for your help.

Categories:

Business Process Flows

full flow 1.png

Full Flow 2.png

Power Automate er...

All responses (3)

Answers (1)

Verified answer

trice602 13,986 Super User 2025 Season 2 on at

Like (1)

Report

Error message in email flow

Hi there,

I can't see your attachments. But the root cause is the way you are using the dynamic content from your excel table. Here's what it should look like. I have some type of table data (is a real table, not a range) and one of the columns is your email column.

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn
Suggested answer

Tomac 761 Moderator on at

Like (0)

Report
Error message in email flow

Additionally, you can fix your data source for the email by fixing this action:

In your map, you want the key to be the word "email" and the value to be your dynamic content.

Then in your Send An Email action, put this in the To field:

outputs('Select')?[0]?['email']

and then you don't need to build the XPATH system I noted below.
Suggested answer

Tomac 761 Moderator on at

Like (0)

Report
Error message in email flow

Looks like your data source for the email address is formatting it as the key in a key/value array. We can fix this, but it will take a few steps:

Here I'm setting up an array variable to match the email array you've got. Then I'm using a Select action with the following:

From

xpath( xml(json(concat('{"Root":', variables('arrEmail'),'}'))), '/Root/*' )

Note that you'll want to change the variable I used in this statement to your email array name

Map

xpath( item(), 'name(/*)' )

This gives me a single item array with just the email address, but it replaced the "@" with "_x0040_" so we need to fix that in our reference. In the To section of your "Send an email" action, use the following:

replace(body('Select')[0],'_x0040_','@')

Of course, the best way to fix it is to fix the source where you're getting the email address to not make it an array, but this works if that's not an option.

If this resolved your issue, please mark it as the answer to assist future users with this problem.