web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Resolve SharePoint lis...
Power Automate
Unanswered

Resolve SharePoint list Name to GAL email address

(1) ShareShare
ReportReport
Posted on by 36

Hi Folks,

 

I have a shrepoint list that has approvers names, what I am trying to work out is if there is a way to take that name and resolve it to an email address from the GAL.

 

Example input from the sharepoint list could be John Smith, I want to resolve that into SmithJohn@domain.com 

 

I can do this with a bunch of variables, splitting and concatenating them to piece together the end result, but surely there has to be a more 'simpler' and effective way to do this.

 

The end result will be to use the name in the approver and backup approver fields from the sharepoint list as recipients in an email. The approvers will be internal domain and could even be a shared mailbox like PartsMarketing which would resolve into PartsMarketing@domain.com 

 

Any help you gurus can provide would be greatly appreciated. 

Categories:
  • sandeepstw Profile Picture
    312 Moderator on at

    Hi There,

     

    To solve the names from your SharePoint list to email addresses in the GAL, use the Office 365 Users connector in Power Automate. In your flow, add the Office 365 Users connector. Choose the Search for users (V2) action. Use the name from the SharePoint list as the search term. The result will provide a list of users matching the search term, along with their email addresses. From the results, retrieve the email address of the matched user.

     

     

    Please give kudos and mark as solution if it helps.  

      

    Thanks, 

    Sandeep Mishra 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 229 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 223 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 136 Super User 2026 Season 2

Last 30 days Overall leaderboard