If I only know the first and last name of a user in my organization, is it possible to use that information in Power Automate today, to then find their email address?
Here's an scenario - A project manager uses Microsoft Form that is available for the whole organization to fill out. On that form, is a dropdown list of people that play key roles (listing their names). Once a selection is made from this choice list, the user will submit the form, and Power Automate will pick it up through a trigger.
It's at this point that I am curious how Power Automate can find the user that was selected on the MS Form, so that I can add a connector to email this selected individual in the flow process.
I'm new to this. How would you solve this scenario?
Many thanks!
Can you be more specific than a documentation link to a huge page that possibly somewhere shows how to get the email? How do I get the email?
If "Search for Users" is used, the results come back in multiple and every time you use the values from that connector, an "Apply to each" is tacked onto the connector. For example, you only have the first and last name of an employee. You use the create a variable and set it to concatenate the "first" and "last" name followed by @And then your company domain. You use "search for users" based on the set variable email created. Every time you bring up the user id from the "search for users" connector, it will automatically apply a "for each" because it thinks there are multiple values and it needs to cycle through each. Bottom line: can't get and use profile info when you only start with a first and last name.
HI @kensley
Yes, it's possible by using "Get user profile (V2)" and then searching by the person's characteristics (surname, given name, etc).
Here's the doc to guide you:
https://docs.microsoft.com/en-us/connectors/office365users/#get-user-profile-(v2)
Hope this helps you.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional