Skip to main content

Notifications

Power Automate - General Discussion
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

  • ManzieDownUnder Profile Picture
    ManzieDownUnder 12 on at
    Re: Dynamic Content Missing

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

     

  • abm abm Profile Picture
    abm abm 32,296 on at
    Re: Dynamic Content Missing

    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
    ManzieDownUnder 12 on at
    Re: Dynamic Content Missing

    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
    abm abm 32,296 on at
    Re: Dynamic Content Missing

    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
    ManzieDownUnder 12 on at
    Re: Dynamic Content Missing

    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
    abm abm 32,296 on at
    Re: Dynamic Content Missing

    Hi @ManzieDownUnder 

     

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

     

    image.png

  • ManzieDownUnder Profile Picture
    ManzieDownUnder 12 on at
    Re: Dynamic Content Missing

    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
    abm abm 32,296 on at
    Re: Dynamic Content Missing

    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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard