Showing UPN in the People Picket Field

[AkshayManke]

Hi,

We are developing an application based on a shapreoint list where we have people column. I have two requirements.

1. When i am entering username, i am getting the 'display name' appeared. But I want that my UPN to be displayed. (e.g. Displayname: Akshay Manke, UPN: amanke). How to achieve this?

2. Once the name is entered in the above field, a display name should be shown in to a different Single line text field. How to get this?

Thanks and Regards,

[v-bofeng-msft]

Hi @AkshayManke :

Could you tell me:

Does UPN mean email address?

Does the GIF below demonstrate the function you need?

If so,please try this solution:

1\add a combox(ComboBox2) and set it's lay out to Double

 

Items

Choices(List1.User) /*List1 is my splist,User is my person column*/

DisplayFields

["DisplayName","Email"]

OnChange

Reset(TextInput5) /*TextInput5 is a textinput control*/

IsSearchable

true

2\Add a textinput control(TextInput5)

Default

ComboBox2.Selected.DisplayName

In addition,if UPN refers to the prefix name of the email address,  I’m afraid this can’t be done, the combo box control can only display the existing values.

Best Regards,

Bof

[AkshayManke]

Hi @v-bofeng-msft , Thanks for the information.

I got a solution for the below point.

2. Once the name is entered in the above field, a display name should be shown in to a different Single line text field. How to get this?

Solution:  I have added DataCardValue(of other column).Selected.DisplayName in to the Default Value and i am getting the Display Name.

Now About the first question. Let me re-clarify it. As can be seen from the below image, I have a People Picker Field where you can see my DisplayName. But instead of display name i want to display my UPN (User Principle Name) like amanke. 

What is UPN? You can see here: https://kb.iu.edu/d/atzp

Appreciate if you can help.

Thanks and Regards, 

[v-bofeng-msft]

Hi @AkshayManke :

UPN is not an existing field or value, you need to ntercept the part before the @ character in the Email field to get it.But a combo box can not display fields or values that do not exist.

As an alternative, I suggest you use the Email field.

Best Regards,

Bof

[v-bofeng-msft · Accepted solution]

Hi @AkshayManke :

In addition, I have an alternative:

I assume the person column do not allow multiple selections.

1\Add a text input control(TextInput1😞

2\Set the dropdown control's Items property to:

ForAll(Office365Users.SearchUser({searchTerm:TextInput1.Text}),{ 
  '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",  
  DisplayName:DisplayName,
  Claims:"i:0#.f|membership|" & Mail,   
  Email:Mail,UPN:First(Split(Mail,"@")).Result
})

3\Set the Data card's(User_DataCard1) UpDate proeprty to:

First(DropColumns(Table(DataCardValue12.Selected),"UPN"))

Best Regards,

Bof

[AkshayManke]

Thanks @v-bofeng-msft, I will try this and will get back with the results.

Regards,

[AkshayManke]

Hi @v-bofeng-msft, A different question. How do you create the gif's to upload to this forums? Any specific tool you use? Can i create it in Windows 10 Ent, without using any third party tool?

Thanks in advance!

[v-bofeng-msft]

Hi @AkshayManke :

I am using "ScreenToGif", you should be able to download it for free in the Microsoft Store.

Best Regards,

Bof

[AkshayManke]

Many Thanks @v-bofeng-msft , i will try it. 😊

[v-bofeng-msft]

Hi @AkshayManke :

Is there anything else I can help?
If the post helps, then please consider accept it as the solution to help others.Thanks
Best Regards,
Bof