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 / Retrieving User Phone ...
Power Automate
Suggested Answer

Retrieving User Phone Numbers to Populate a Word Template

(1) ShareShare
ReportReport
Posted on by 10
Hello 
 
I am trying to pull a user's phone number into a Microsoft word document. The phone number will change based on the user. First I am getting items from a SharePoint list, then adding a search in the user directory.
 
When I get to the FarmUWphone field, I cannot figure out an expression to say: lookup the FarmUWemail from the SharePoint list and generate the phone number based on that user. I will repeat this to fill HobbyUWphone and HomeUWphone.
 
Considered adding phone number to the SharePoint list itself, but would like to avoid adding columns if I can.
 
20240903-flow.PNG
Categories:
I have the same question (0)
  • David_MA Profile Picture
    14,352 Super User 2026 Season 1 on at
    It is hard to tell from your explanation, but is your FarmUW field a people field? if so, pass the e-mail address from this field through a Get user profile action. The user's phone number will be returned. If FarmUW field is not a people field, what does it store and how would it relate to looking something up and where do you want to look it up from?
  • Suggested answer
    Nandit Profile Picture
    1,568 Moderator on at
     
    You will need to limit the search results in your flow to 1, like this - 
     
     
    And then add a compose to get the Phone Number of the user by using TelephoneNumber Dynamic Content in a Compose function. It will introduce a For Each loop but that's okay as the previous step will only produce 1 result. - 
     
     
    You can now use the Compose output for the steps after this. 
     
    I hope this helps.
     
    Kind regards,
    Nandit
     
    If this answers your question, please mark this response as the answer.
    If its helpful, please leave a like. Thanks!
     
     
  • CL-30071415-0 Profile Picture
    10 on at
    Thank you both! I will try each method this week and see if I can get them to function. 
     
    David_MA, confiming the farm UW field is a people field.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard