how to reuse a value in send an email body?

[SiyamandRashid]

Hello All

I have an apply to each action and inside it I have Create HTML table action with send an email as below, how to use the full name in the body of the email?

[ManishSolanki]

Hi @SiyamandRashid 

One way is to use "Search for users (V2)" action and pass the email address of the user. This action will return the display name of the user, which you can use in the email body to address the user:

Here is an example:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[SiyamandRashid]

Thank you @ManishSolanki  for your reply, 

Im getting the list from the MS List and may be they are not internal users to get the name from their email address.

to have a better idea below is my flow

[ManishSolanki]

Hi @SiyamandRashid 

Yes, you are right. I would request you to pls share the expression used for 'Full Name' in 'Create HTML table' action.

Thanks

[SiyamandRashid]

Thank you @ManishSolanki 

here it is 

concat(item()?['field_1'],' ',item()?['field_2'])

[ManishSolanki · Accepted solution]

Hi @SiyamandRashid 

I have observed that you put the filter on email address in SP list, so I assume that each row has username in "Full Name" column. In that case, we can get the name from the first element of the array generated from the body of "Filter array" action:

concat(first(body('Filter_array'))?['field_1'],' ',first(body('Filter_array'))?['field_2'])

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[SiyamandRashid]

Thank you so much it worked for me, do you have a resource on this part for learning purpose?

what does the "first" after concat is used for and where it comes from?

[ManishSolanki]

Hi @SiyamandRashid 

I am happy that it solves your problem 🙂

First() function returns the first element of an array. The body or output of filter array action returns an array and using first() we have filtered out the first element. In your case, as array contains object so we retrieve the property's value by its name. Like first(), there is last() function that returns the last element of an array.

Thanks

[SiyamandRashid]

Thank you very much dear @ManishSolanki  for your information much appreciated.