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()?:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.