How to get email address from name in Power Automate

In this Power Automate tutorial, we will learn how to get an email address from the name. And also we will discuss the below points:

  • Power automate get email address from name
  • Power automate get name from email address
  • Get Current user name and email address in Power Automate
  • Get user profile from name power automate
  • Power automate get user profile from email
  • Power automate search for users
  • Power automate get name from form
  • Power automate get email address from form
  • Get user principal id power automate

Power automate get an email address from name

Here we will see how to get an email address from name using Power Automate.

In Power Automate, select the Manually triggered Flow and then click on the Next step.

Power automate get email address from name
Power automate get email address from name

Now we will search the user based on name or mail id, here will search the user based on name, so click on the Next step and select Search for users (V2) action, then in the Search term provide the name of the user like below.

Microsoft Flow get email address from name
Microsoft Flow get email address from name

Next, we will send an email to the email id, which we get from the previous step. So, click on the Next step and select Send an Email(V2) action. Then provide the To from dynamic content, that will automatically add Apply to each action, subject, and body field.

 get email address from name using MS Flow
get email address from name using MS Flow

Now click on Save and run the Flow, and the user will get an email.

 get email address from name using Microsoft Flow
get the email address from name using Microsoft Flow

This is how Power automate get email address from name

Read How to convert word to pdf using Power Automate

Power automate get name from email address

Here we will see how to get the user name from the email address.

In Power Automate, select the Manually triggered Flow, and then click on the Next step.

Power automate get  name from email address
Power automate get the name from email address

In this step, we will get the user name or user profile from the email address. So click on the Next step and select Get user profile(V2) action, then provide the user UPN or email address.

Microsoft Flow get  name from email address
Microsoft Flow get name from email address

Now click on Save and run the Flow manually to see the user name or user profile details,

MS Flow get  name from email address
MS Flow get name from email address

This is how Microsoft Flow gets user name from email address.

Read Log Gmail emails to a Google Sheet using Power Automate

Get Current user name and email address in Power Automate

Here we will see how to get the current user name and email address in Power Automate.

In Power Automate, select the Manually triggered flow, then click on the Next step.

How MS flow get email address from name
How MS flow get email address from name

Now we will retrieve my profile and then in the next step we will send an email, so click on the Next step and select Get my profile(V2) action.

How Power Automate get email address from name
How Power Automate get an email address from the name

Now we will send an email, so click on the Next step and select Send an Email(V2) action. Then provide the To from the dynamic content, provide the subject, and provide a body of the email.

Power Automate get email address from name
Power Automate get email address from name

Now click on Save and run the flow manually, and you can see the mail in the outlook.

Microsoft Flow get email address from name
Microsoft Flow get email address from name

This is an example of Power Automate getting the current user email address and name.

Read Convert SharePoint list item to PDF using Flow or Power Automate

Get user profile from name Power Automate

Here we will see how to get a user profile from name using Power Automate.

Now we will create a flow that will search for user profiles alphabetically registered in office 365 in your organization, then it will retrieve the profile.

In Power Automate, select the Manually triggered flow and then click on the Next step.

get user profile from name power automate
get user profile from name power automate

Now we will search the user profile, so click on the Next step and select Search for users(V2) action. Here you can provide the particular search term, and also you can provide the Top count, or else it will retrieve all the user profiles registered in office 365.

get user profile from name power automate
get user profile from name power automate

Now to get the particular profile from the above-listed profile, click on the Next step and select Get user profile(V2) action. Then provide the User (UPN), so in this add below expression:

outputs('Search_for_users_(V2)')?['body/value'][6]['id']
how to get user profile from name power automate
how to get user profile from name power automate

Now click on Save and run the flow manually, you can see the user profile registered in office 365.

How to get user profile from name microsoft flow
How to get user profile from name Microsoft flow

This is an example of getting a user profile from name Power Automate.

Read Power Automate copy files with Examples

Power automate get user profile from email

Here we will see how to get user profiles from an email address using Power Automate.

In Power Automate, select the Manually triggered flow, then click on the Next step.

Power automate get user profile from email
Power automate get user profile from email

Now we will get the user profile from the email address, so select Get user profile(V2) action. Then in User (UPN) add the User Email from the dynamic content.

How Power automate get user profile from email
How Power automate get user profile from email

Now click on save and run the flow manually, and you can see the user profile

How Power automate get user profile from email
How Microsoft Flow get user profile from email

This is an example of Power automate get user profile from email.

Read Power Automate employee onboarding

Power automate search for users

Here we will see how to use search for users(V2) action using Power Automate.

In Power Automate, select the Manually triggered flow, then click on the Next step.

Power automate search for users
Power automate search for users

Now we will search for users from the office 365 user, so click on the Next step and select Search for users(V2) action. Then provide the search term that can be displayed name, given email, surname, mail, and mail nickname.

How Power automate search for users
How Power automate search for users

Now click on Save and run the flow manually and you can see the user profile from the Search term.

 How Microsoft Flow search for users
How Microsoft Flow search for users

This is an example of a Power Automate search for users.

Read Power Automate Create a CSV Table

Get user principal id power automate

Here we will see how to get user-principal id using Power Automate.

I have a Share Point list called Employee Information, so when we create an item in the SharePoint list it will generate an id, so by using this id we will the user principal id.

get user principal id power automate
get user principal id power automate

Now we will create a flow to get the user principal id using Power Automate.

In Power Automate, select the trigger ‘When an item is created‘ action. And then provide the site address and list name.

how to get user principal id power automate
how to get user principal id power automate

Now we will send an HTTP request to SharePoint, so click on the next step and select ‘Send an HTTP request to SharePoint‘ action. Then provide the site address, in Method choose Get and Uri provide the end API like below

_api/web/SiteUsers/getByEmail('domain.onmicrosoft.com')
how to get user principal id Microsoft flow
how to get user principal id Microsoft flow

Now we will get the userPrincipalid, so click on the Next step and select the Initialize variable action. Then provide the variable name, type as a string, and in value write the below expression.

body('Send_an_HTTP_request_to_SharePoint')['d']['id']
how to get user principal id MS flow
how to get user principal id MS flow

Now click on Save and run the Flow create an item in the SharePoint list.

 get user principal id MS flow
get user principal id MS flow

Now you can see the result in the initialize variable action output,

get user principal id Microsoft flow
get user principal id Microsoft flow

This is an example of getting user principal id using Power Automate.

Read How to update SharePoint Multiselect column in Power Automate

Power automate get name from form

Here we will see how to get a name from the form using Power Automate.

Now we will create a flow to get the form responder name using Microsoft Flow. I have created a Form called the Training Feedback form.

How power automate get name from form
How power automate get name from form

When the above form gets submitted, we will get the responder’s email and store it into the below excel sheet.

power automate get name from form
power automate get name from form

Let’s see how to create a flow to get the responder’s name when the form gets submitted.

In Power Automate, select the trigger ‘ When a new response is submitted‘ action. Then provide the Form id of the form.

How power automate get name from form
How power automate get name from form

Now we will get the response details, so click on the next step and select Get response details action and then provide the form ide and response id from the dynamic content.

Microsoft Flow get name from form
Microsoft Flow get the name from the form

In this step, we will retrieve the responder name, so click on the Next step select the Get users profile(V2) action, and then provide the user UPN field from the dynamic content.

How Microsoft Flow get name from form
How Microsoft Flow get the name from form

Now we will add a row into a table, so click on the Next step and select Add a row into a table-Excel Online. Then provide the location, document library, file name, and table of Excel. At last the map the field with the value from the dynamic content.

How MS Flow get name from form
How MS Flow get the name from the form

Now click on save and to run the flow fill the form and submit the form and you can see the responder name in the excel table.

MS Flow get name from form
MS Flow get the name from the form

This is an example of Power Automate get name from form.

Read How to create a word document from a template in Power Automate

Power automate get an email address from the form

Here we will see how to get the email address from the form using Power Automate and Microsoft flow.

In this Power Automate flow, we will use the above Training Feedback form. Then when a user responds to that form we will retrieve the email address and store it in the below excel table.

power automate get email address from form
power automate get email address from form

In Power Automate, select the trigger ‘When a new response is submitted, and then provide the Form id.

How power automate get email address from form
How power automate get an email address from the form

Now click on the Next step and select Get response details action. Then provide the form id and response id.

How Microsoft Flow get email address from form
How does Microsoft Flow get an email address from the form

Now we will get the responder profile, so click on the Next step and select Get User profile (V2) action, Then provide the User UPN from the dynamic content.

 Microsoft Flow get email address from form
Microsoft Flow get an email address from form

In this step, we will add a row into an excel table, so click on the Next step and select Add a row into a table action. Then provide the site address, document library, file, and table of the excel. Next map the field with the value from the dynamic content.

MS Flow get email address from form
MS Flow get email address from form

Now click on Save and to run the flow submit the form and you can see the responder email address in the excel table.

How MS Flow get email address from form
How MS Flow get an email address from the form

This is an example of Power Automate get email address from the form.

Related Power Automate tutorials:

In this Power Automate tutorial, we learned how to get an email address from name using Power Automate. And also we discuss the below points

  • Power automate get email address from name
  • Get user profile from name power automate
  • Power automate get user profile from email
  • Power automate search for users
  • Power automate get name from form
  • Power automate get email address from form
  • Get user principal id power automate
  • Hi Bijay,

    Very interesting and helpful article for a beginner like me, thank you for sharing your knowledge here.

    I’m hoping you can assist with a flow I’ve been having some trouble with. I am trying to obtain a user’s email address by specifying their job title, I tried using the Search for users (V2) action with the following Search term but it is not working:

    LookUp(Office365Users.SearchUserV2({searchTerm:””}).value, JobTitle=”CEO”).Email

    Any guidance you can offer is greatly appreciated.

  • >