cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ErkC_GWChatt
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
abm
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 blogPower Automate Video Tutorials

View solution in original post

5 REPLIES 5
abm
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 blogPower Automate Video Tutorials

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

abm
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 blogPower Automate Video Tutorials
abm
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 blogPower 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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (46,863)