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

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
Highlighted
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
Highlighted

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

Highlighted
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
Highlighted
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

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (13,040)