cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User III
Super User III

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

Power Automate Video Tutorials

View solution in original post

5 REPLIES 5
Super User III
Super User III

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

Power Automate Video Tutorials

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

Super User III
Super User III

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

Power Automate Video Tutorials
Super User III
Super User III

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

Power Automate Video Tutorials

View solution in original post

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (8,829)