web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dynamic Content Missing
Power Automate
Unanswered

Dynamic Content Missing

(0) ShareShare
ReportReport
Posted on by 12

Trying to create a simple Power Automate flow.
1.) Created a form "Only people in my organization can respond"
2.) Open results in Excel. "Name" is a column/field in the Excel table/spreadsheet. Note this "field" does not appear as an entry request from the Form; believe it is drawn from the user/email profile of the person completing the form.
3.) Created a List in Sharepoint from the Excel document.  "Name" is one of the columns/fields present in the List. This column is set as a "single line of text"
4.) Open Power Automate to create a new flow.
5.) Create Item "Name" appears as a blank field in the template.
6.) Dynamic Content does NOT show or have an option to select "Name" from "Get Response Details" or from "When a new response is submitted".

QUESTION: What do I have to do to get "Name" to appear in my choices within the Dynamic Content? This is more important than the email address of the person completing the form. Should not have to have users type their names in the form, especially if the "Name" autofills into the Excel doc and the List. Edit your flow.PNG

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,979 Most Valuable Professional on at

    Hi @ManzieDownUnder 

     

    You need to use Get user profile to get the full name of the person. Here pass the user email address.

     

    image.png

  • ManzieDownUnder Profile Picture
    12 on at

    This is what I get when I try to Get User Profile (V2)Get User Profile.PNG

    This function does not seem to trigger Dynamic Content to include the "Name" of the user.

    Any other suggestions? Is there something in a setting somewhere? Should I use this before or after a "New Response has been submitted"?

  • abm abm Profile Picture
    32,979 Most Valuable Professional on at

    Hi @ManzieDownUnder 

     

    Move the Get user profile (v2) after the Get Response details. You can get the email id

     

    image.png

  • ManzieDownUnder Profile Picture
    12 on at

    I am already able to get the Responder's Email.... I cannot get the First and Last Name "Name" of the user automatically from the form or Excel spreadsheet. Their first and last names are used for other functions - merged documents to create certificates, letters, and such - for which their email is not properly suited for. Remember the form creates an Excel spreadsheet/table that includes the field titled "Name" though it is not built into the form. I need the name (a first and last associated with the user's email), to transfer into the list each time a new form entry is submitted. I tried to include what I believe you suggested into my flow -- see below.Responder's Email_User Details.PNG

  • abm abm Profile Picture
    32,979 Most Valuable Professional on at

    Hi @ManzieDownUnder 

     

    I am not sure I fully understand. From Get user profile you can get the Display name (user full name) , given name (first name) and surname as dynamic properties of the person who submitted the forms.

     

    Thanks

  • ManzieDownUnder Profile Picture
    12 on at

    I agree with you... I should be able to get the display name (user full name), given name (first name) and surname as dynamic properties of he person who submitted the forms... and that's not what's happening and I don't know where to fix it. The example below show two entries -- one with the user full name, and one without.

     

    List view.PNG

     

    Peter's shows up with his given and surname, while the second one is blank next to the email. I surmise the reason the first one has a full name is because when I created the List in Sharepoint, it was from the Excel spreadsheet created when viewing the responses after clicking on "Open in Excel" in the Form itself. That would be the original output from the Form when it as created. When a new entry is entered in Forms, the list does not update with the most recent submission, which is illustrated the second entry lacking the user's full name.

     

    The steps you recommended I add did nothing the change the list in any discernible way. None of the dynamic content seems linked to the User's profile other than their email.

     

    The whole point of a Flow is to not have to refresh the list every time with my spreadsheet, or for me to edit the list after a Form submission is completed. There must be something that can be done without me having to open the spreadsheet, and relink/upload it to the List in Sharepoint.

  • abm abm Profile Picture
    32,979 Most Valuable Professional on at

    Hi @ManzieDownUnder 

     

    Get user profile gets the details from Azure. Check with your administrator and see all the relevant properties are updated in Active Directory (AD).

     

    Thanks

     

     

  • ManzieDownUnder Profile Picture
    12 on at

    I don't see Azure as one of the apps within my profile... Surely there must be another way to do this.

     

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 307 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 269 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 115 Super User 2026 Season 1

Last 30 days Overall leaderboard