Hi, I'm having a strange issue passing email addresses via a variable.
I have three flows which all use an initialise variable then apply to each to combine user Emails from a SharePoint person column into a single output seperated by semi colons for Send an Email V2 to use.
On two flows this works fine and the same method is used to combine several other multiple choice values to ensure only on email is needed.
on one flow however this method will not work, i keep getting the following message.
"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 '"\nJBLOGGS@123.com;\JDOE@123.com;"' to be converted doesn't have the expected format 'string/email'."
I've checked the three flows and they are identical.
Can anybody give me some guidance as to why one Send and Email V2 likes it but another doesn't?
Solved! Go to Solution.
Hello @codecheck ,
I think.it's because of the new line you use when you're building the list of email addresses. Keep them all on the same line, just separate them by ; .
Hello @codecheck ,
the emails string in the error message seems strange, it should be just email addresses separated by semicolons, without the \ and \n. I'd check the part where you build the string with addresses for some typo.
JBLOGGS@123.com;JDOE@123.com;
That was my first thought but i cant see any reason why the variable is different to others.
What's odder is the input passed to send an email in this flow seems different to another.
flow with error:
Hello @codecheck ,
I think.it's because of the new line you use when you're building the list of email addresses. Keep them all on the same line, just separate them by ; .
thanks, that seems to work. although Powerapps Notification V2 didn't like them being passed to it that way. no issue though as an apply to each getting the managers email from the sharepoint list will work fine for that bit.
Odd that it would work fine on other flows though.
User | Count |
---|---|
88 | |
37 | |
25 | |
13 | |
13 |
User | Count |
---|---|
121 | |
55 | |
36 | |
24 | |
21 |