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.
I don't see Azure as one of the apps within my profile... Surely there must be another way to do this.
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
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.
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.
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
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.
Move the Get user profile (v2) after the Get Response details. You can get the email id
This is what I get when I try to Get User Profile (V2)
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"?
You need to use Get user profile to get the full name of the person. Here pass the user email address.