Using Variable string as Outlook recipient

(0) Share

Report

Posted on by Tyrrell94

Hi All,

I have been struggling to get this working and I am not sure if its possible.

I am trying to compose an email address from a full name. To test I am using my own name instead of a dynamic expression. For this example, I am using 'Andrew Tyrrell' but this name will change once it's live.

Then using 'First' & 'Last' to separate the name and create an email address as an output.

First(Split('Andrew Tyrell', ' '))last(Split('Andrew Tyrell', ' '))

Output: Andrew

last(Split('Andrew Tyrell', ' '))

Output: Tyrrell

Compose both these outputs to form an email address:

@{outputs('Compose')}.@{outputs('Compose_2')}@***************.org

Output: Andrew.Tyrrell@*****************.org

I then want to store this email address in a variable to then use later on as a recipient for outlook

flow email.PNG

Doing it this way spits out the following error:

"InvalidTemplate. Unable to process template language expressions in action 'Send_an_email' inputs at line '1' and column '2503': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_office365']['connectionId']' cannot be evaluated because property 'shared_office365' doesn't exist, available properties are ''. Please see https://aka.ms/logicexpressions for usage details.'."

The variable doesn't match the input format of outlook. But I don't know why, I have tried storing the variable in various ways, but I can't get it working.

Any help would be appreciated, there is most likely a much simpler way of doing this.

Thanks in advance!

Categories:

General topics

All responses (2)

Answers (1)

Sort by

Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Tyrrell94,

You could first output the value of the variable, and if it is an invalid email address format, it will report an error.

I did a test on my side. The way to stitch emails may be different from yours. You could use them for reference:

Compose-Email:

concat(outputs('First_Name'),'.',outputs('Last_Name'),'@test.com')

In addition, if the email address of your variable output is valid, then you could consider exporting the Flow and re-importing it as a new Flow. This way Flow will work.

Please take a try and let me know if issue still exists.

Best Regards,

Barry
Tyrrell94 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bacao-msft

Sorry for the late response. I did try this before the new year but I couldn't get it working.

Hope you had a nice Christmas and New year!

I took a break and came back to it in the new year and I have managed to get it working using the method you have shown.

Appreciate the help!