You’re offline. This is a read only version of the page.
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!
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
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
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.
Share
Report
4
All responses (
Answers (
