Hello
I am a newcomer in MS Flow, and I testing the possiblity to get the "Display Name" of the People who has replied to the survey from my organization. When I get a record from MS Forms I get an email (UPN):
I read that with an action from the connector "Office 365 Users" I could accomplish it but I am not able to guess how I could retrieve this value and use further in a column of an Excel File which I am using as output in Excel Bussiness OneDrive...
Did anyone deal with this issue?
Many thanks for any suggestion
Javier
Why would you use "Get User Profile" from the Office 365 Users Connector when "Get my profile (V2)" is available? That is preferred because there is no need to specify the UPN or Responder's email. It automatically gets the profile of the current user.
https://docs.microsoft.com/en-us/connectors/office365users/#myprofile_v2
EDIT:
Ignore this, my expectation doesn't work, because apparently "Current User" in the documentation doesn't refer to the currently executing user, it refers to the design time user i.e. the Flow Developer only ! Odd.
Super!
It worrks fine!!! Thank you very much!
Yours!
Javier
Hi @comecome,
You could add an "Get user profile" action of Office 365 Users Connector in your flow, and input the email address in the input field of the "Get user profile" action, and then you could get the "DisplayName" dynamic content of the "Get user profile" action, and insert it in a column in the excel table.
The screenshot of the flow as below:
Best regards,
Alice
stampcoin
79
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1