Skip to main content

Notifications

Announcements

Join us on April 2nd for the Power Platform AMA - Copilot Studio Edition
🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : 72oWb8UfyrVbBTAprnN1Ea
Power Platform Community / Forums / Power Automate - Building Flows / Get User Profile Question
Power Automate - Building Flows
Unanswered

Get User Profile Question

Like (0) ShareShare
ReportReport
Posted on 28 Mar 2025 16:03:53 by jdash20 32
Hello!  
 
I've built a couple forms that save to an excel spreadsheet that i report out on each month.  Within my flow there is a field used to capture a users email address.  Is there a way to use the "get user profile" to capture the email IDs First and Last name but also add it to the spreadsheet that the form is already saving to?  My current flow uses "get user profile" to add the email addresses first and last name to the email that i have sent out at the end of flow.  I'm just trying to find a way to capture that first and last name within the same excel spreadsheet that my form is dumping to.  Please let me know if this is possible, thank you!
 
my current flow is listed below but the get user profile is tied to the email address from the form thats submitted.  
 
Categories:
Business Process Flows
  • jdash20 Profile Picture
    jdash20 32 on 01 Apr 2025 at 15:22:44
    Get User Profile Question
    Currently after my flow runs it collects the data submitted and dumps it into an excel doc and it looks like below:
     
     
     
    What i'm basically trying to do is find a way to lookup the user provided, in this case JaneDoe@company.com, and update the row to add their display name based on the get user profile connector.  Listed below is what i'm trying to accomplish when everything is said and done.  Is this possible? 
     
  • jdash20 Profile Picture
    jdash20 32 on 31 Mar 2025 at 12:56:47
    Get User Profile Question
    I think thats what im was looking for.  How would i go about this??
  • ronaldwalcott Profile Picture
    ronaldwalcott 1,802 on 29 Mar 2025 at 04:47:26
    Get User Profile Question
    If you are using Power Apps to capture the data you could add a name field and use Office365Users.UserProfileV2(Email).DisplayName to get the name and save it as the default value of a hidden field in the form.
  • jdash20 Profile Picture
    jdash20 32 on 28 Mar 2025 at 18:23:28
    Get User Profile Question
    so in a nutshell my employees are entering the email addresses of users, and thats what gets stored in the spreadsheet.  The end result is an email gets sent to that email as well as their manager, but i was hoping there was a way for me to store the first and last name by using the get user profile connection based on the email address we captured.  I could have the form updated to include a first name and last name but i was hoping to avoid that as it could create human error.  
  • David_MA Profile Picture
    David_MA 10,199 Super User 2025 Season 1 on 28 Mar 2025 at 17:47:04
    Get User Profile Question
    What spreadsheet are you referring to? The spreadsheet generated by Microsoft Forms to store the responses. If so, I have never tried this, so I would test this first before using it on something in production.
    1. The spreadsheet for the form is stored in the OneDrive of the owner of the form.
    2. Find the spreadsheet and add a column to store the name.
    3. When the flow runs, use the update row action to add the data.
    However, if you are capturing the e-mail address of the person when they submit the form, their name is saved in the spreadsheet in the name field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us on April 2nd for the Power Platform AMA - Copilot Studio Edition
🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,636 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans