I am having difficulty sending an email to an email address that I successfully extracted from an Outlook event (appointment) created by Microsoft Bookings.
I want to send an automated email/survey to the user scheduled, however, the flow fails when using the extracted Customer Email.
Below is the flow:
Here is the expanded variable:
Here is the expanded Apply to Each that includes the set variable:
Here is the value: last(split(first(split(outputs('Html_to_text')?['body'],'Phone')),'Email: '))
Here is the email:
For some reason, I cannot get the email to send using the email address variable. Any ideas?
Let me know if there is more information or screenshots needed.
Thank you so much!
Solved! Go to Solution.
Do you get correct email address using that expression. Can you please check variable and output and see if it is a well formed email address?
Thank you for your quick reply!
It appears the email is correct.
Below is the output:
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 '"******@***********.***\n"' to be converted doesn't have the expected format 'string/email'.
Hope this helps -- let me know if you need more.
Try wrapping the expression that you use in the Set customer email compose action in a trim() expression - in other words trim the email address.
Could you assist? I'm new to the trim expression. Would the previous expression nest within trim()?: