cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Reference email user being sent the email

ErkC_GWChatt_0-1594324781748.png

How do I reference George Washington in the body after the greeting, "Hi".

I would assume there is a function that once I have an individual in the "To" section that their email would be stored and I could access and grab the first name of that individual. This would be going to multiple people and I would want to do the same for each individual, dynamically.

 

For the time being I am ideally trying to replicate what was sent to the owner of the form but since I needed flow/power automate to send to multiple users I am running into the issue above. Pictured below.

 

ErkC_GWChatt_0-1594325644469.png

 

 

Looked this afternoon and did not find anything helpful.

 

Obviously George Washington is fake and not an actual user in our company.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Reference email user being sent the email

Hi @ErkC_GWChatt 

 

Here is an example

 

image.png

 

Above expressions are as follows:

 

Compose  Step: Compose - Get Each email

item()
 
Compose Step: Compose - Get First name
first(split(outputs('Compose_-_Get_Each_email'),'.'))
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

5 REPLIES 5
Highlighted
Super User III
Super User III

Re: Reference email user being sent the email

Hi @ErkC_GWChatt 

 

Where you getting the To values from? Is that collected from forms as email address?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
New Member

Re: Reference email user being sent the email

I manually entered the To addresses at the time of Flow creation.

Highlighted
Super User III
Super User III

Re: Reference email user being sent the email

Hi @ErkC_GWChatt 

 

Declare an array and add all the email address?

 

Then before the send email action step iterate the array and assign the email To value from array. Inside the expression use expression split using space to get the first name.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Super User III
Super User III

Re: Reference email user being sent the email

Hi @ErkC_GWChatt 

 

Here is an example

 

image.png

 

Above expressions are as follows:

 

Compose  Step: Compose - Get Each email

item()
 
Compose Step: Compose - Get First name
first(split(outputs('Compose_-_Get_Each_email'),'.'))
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

Highlighted
New Member

Re: Reference email user being sent the email

Thanks, this got me exactly what I needed!!

Greatly appreciate the example with pictures and comments.
Being 6 years since college with just 3 programming classes I totally have not made use of it and forgot majority of what I picked up.

 

Thanks!

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,021)