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.
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.
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.
Now click on Save and run the Flow, and the user will get an email.
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.
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.
Now click on Save and run the Flow manually to see the user name or user profile details,
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.
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.
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.
Now click on Save and run the flow manually, and you can see the mail in the outlook.
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.
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.
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']
Now click on Save and run the flow manually, you can see the user profile registered in office 365.
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.
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.
Now click on save and run the flow manually, and you can see the user profile
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.
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.
Now click on Save and run the flow manually and you can see the user profile from the Search term.
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.
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.
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')
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']
Now click on Save and run the Flow create an item in the SharePoint list.
Now you can see the result in the initialize variable action output,
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.
When the above form gets submitted, we will get the responder’s email and store it into the below excel sheet.
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.
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.
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.
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.
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.
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.
In Power Automate, select the trigger ‘When a new response is submitted, and then provide the Form id.
Now click on the Next step and select Get response details action. Then provide the form id and response id.
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.
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.
Now click on Save and to run the flow submit the form and you can see the responder email address in the excel table.
This is an example of Power Automate get email address from the form.
Related Power Automate tutorials:
- Power Automate Create File
- How do I restore removed files in SharePoint with Power Automate
- Power Automate Replace
- How to call a flow from another flow in Power Automate
- Power Automate Set Variable
- Power Automate wait timer
- Save tweets to a Google Sheet using Power Automate (Flow)
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
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Out audiences are from the United States, Canada, United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a SharePoint MVP(8 times), check out My MVP Profile. I have also worked in companies like HP, TCS, KPIT, etc.
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.