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:

Building flows

All responses (5)

Answers (0)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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
Brian-M 437 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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
Brian-M 437 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Brian-M

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

Thanks