cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Masor
Advocate III
Advocate III

Getting respondents Name from Microsoft Forms into Flows

Is it possible to get the (dynamic) name of de respondents from FORMS in flow?

I can only seen respondents e-mail adres in the dynamic fields.

3 ACCEPTED SOLUTIONS

Accepted Solutions
v-micsh-msft
Community Support
Community Support

Hi @Masor,

 

As you noticed, currently it is only available to get the respondents E-mail Address.

For Emails within your own organization, you could take use of Office 365 Users Action to get the User Profile, then use the Name field provided there.

But for the respondents who are outside your organization, there is no proper way to get the UserName, as the only available data that could be obtained from the Form response is restricted to the Emails.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

You can use the action "Get User Profile (V2)" from "Office 365 Users". In the field "User (UPN)" you insert the dynamic field "Responder's Email".

After this you can use the fields from the "Get User Profile (V2)". This includes for example the "Display Name", which is the name of person corresponding to the email adress of the responder.

 

View solution in original post

Thank you! Moving it to after get response details worked. 

View solution in original post

12 REPLIES 12
v-micsh-msft
Community Support
Community Support

Hi @Masor,

 

As you noticed, currently it is only available to get the respondents E-mail Address.

For Emails within your own organization, you could take use of Office 365 Users Action to get the User Profile, then use the Name field provided there.

But for the respondents who are outside your organization, there is no proper way to get the UserName, as the only available data that could be obtained from the Form response is restricted to the Emails.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks for this Michael. I am faced with the same challenge. Could you please help explain the steps for "take use of Office 365 Users Action to get the User Profile, then use the Name field provided there." in some more detail. This would help me greatly. 

 

Thanks,

Sean

You can use the action "Get User Profile (V2)" from "Office 365 Users". In the field "User (UPN)" you insert the dynamic field "Responder's Email".

After this you can use the fields from the "Get User Profile (V2)". This includes for example the "Display Name", which is the name of person corresponding to the email adress of the responder.

 

Why would you use "Get User Profile" when "Get my profile (V2)" is available?
That doesn't need the UPN or Responder's email, wouldn't it automatically get the profile of the current user?

 

https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/resources/user#properties

https://docs.microsoft.com/en-us/connectors/office365users/#myprofile_v2

 

EDIT:
Thanks Tugel, you are absolutely correct - Get My Profile doesn't work. I confirmed by testing it too.

"Current User" in the documentation is ambiguous in my opinion. I would think it means the currently executing user, whereas they mean the design time user. I can't imagine what property of the Flow developer's information could be needed in a flow that he doesn't already know at design time.

Hi zoidberg,

 

I just test your sugestion, unfortunately it does not work. I receive my own user profile regardless of the user that answeres my Microsoft Forms.

 

Therefore to get the user profile of the user that answered the Microsoft Forms, "Get user profile (V2)" has to be used and the UPN is required in "Get user profile (V2)".

 

Hi @v-micsh-msft ,

I created a quiz-form and wanted it to share outside organisation.

Quiz-Form 

 

Found the restriction to Numbers, but restriction to Emails not available.

 

Kindly Help,

Basant

Thank you so much, worked perfectly! 

Hello, 

When I try to use Get User Profile (V2) the only dynamic content available is Response ID. 

Am I missing a step?Screenshot 2022-04-13 101050.png

Masor
Advocate III
Advocate III

n the field "User (UPN)" you insert the dynamic field "Responder's Email".

Call me stupid, but can this just be typed in? Responder's Email isn't in the Dynamic content list to choose from, as you can see from my screenshot. 

 

Can anyone fill in this form or only people in your organisation?

When anyone and so extern people can fill in the form, you can not use this function!

 

And.......you have to move 'Get User Profile' after 'get response details'

 

Hope this will help.

Thank you! Moving it to after get response details worked. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,870)