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 / Search Users (V2) from...
Power Automate
Answered

Search Users (V2) from First and Last Name (combined)

(0) ShareShare
ReportReport
Posted on by 4

Hi, 

 

I'm building a flow that is extracting rows from an excel document. One of the columns related to the "Owner" and provides the value of first and last name (i.e. John Doe). How can I use the full name of a user and search using the Search Users (V2) action. 

 

Thanks!

Categories:
I have the same question (0)
  • Mitanshu Profile Picture
    1,656 Moderator on at

    The search term applies to display name, given name, surname, mail, mail nickname and user principal name.

     

    So you can enter concatenated first name and last name from the Owner field and put under the Search for users (v2) action.

     

    This will give you an array of users that match the search term

    happyume_1-1691512753519.png

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

     

     

  • cczaniec Profile Picture
    4 on at

    Unfortunately simply concatenating the first and last does not work and yields no results. Display names are formatted as "Doe, John"

  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @cczaniec ,

     

    You could use this expression to format the 'John Doe' to 'Doe, John'.

     

    concat(split('John Doe',' ')[1],',',split('John Doe',' ')[0])

     

    Best Regards,

    Bof

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard