Unanswered

Send an Email v2 randomly converting email address in from field

(0) Share

Report

Posted on by Brian-M

437 Super User 2024 Season 1

I have a flow that does a bunch of stuff (specific, I know...) but at the end of the flow it needs to send an email. During testing it's working flawlessly a large portion of the time. However, randomly the from email address, which is being grabbed from a Power BI table, gets changed and 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/From' is required to be of type 'String/email'. The runtime value '"Ym1lcnJpa2luQGJyYXZlcml2ZXIuY29t"' to be converted doesn't have the expected format 'string/email'.

Anyone know what's happening here?

Categories:

Business Process Flows

I have the same question (0)

All responses (5)

Answers (0)

abm abm 32,596 Most Valuable Professional on at

Like (0)

Report

Re: Send an Email v2 randomly converting email address in from field

Hi @Brian-M

Where you getting the email address from? Check what format it's returned by checking the run history of the flow.

Thanks

Was this reply helpful? Yes No
Brian-M 437 Super User 2024 Season 1 on at

Like (0)

Report

Re: Send an Email v2 randomly converting email address in from field

It's coming from a Power BI table and, like I said, most times I run the flow it goes through flawlessly. Just random failures where the email address comes back like above. Not sure why it randomly fails and randomly succeeds. Note that I'm currently testing the flow so my data set isn't changing at all.

Was this reply helpful? Yes No
abm abm 32,596 Most Valuable Professional on at

Like (0)

Report

Re: Send an Email v2 randomly converting email address in from field

Hi @Brian-M

Thanks for your reply. Check the Power BI dataset record against the failing one. Looks to me its a data quality issue here.

Thanks

Was this reply helpful? Yes No
Brian-M 437 Super User 2024 Season 1 on at

Like (0)

Report

Re: Send an Email v2 randomly converting email address in from field

It's fine in the data set. As I said, sometimes during a test run it will read the email addresses correctly. But randomly it will end up as that weird string. It's not one particular email address, it's all of them. It's like something just randomly breaks even though nothing's changed in the database.

Was this reply helpful? Yes No
abm abm 32,596 Most Valuable Professional on at

Like (0)

Report

Re: Send an Email v2 randomly converting email address in from field

Hi @Brian-M

Need to see your flow and determine what's going on. Could you post a screenshot of your flow?

Thanks

Was this reply helpful? Yes No