cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Showing UPN in the People Picket Field

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,

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Showing UPN in the People Picket Field

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"))

 

1.JPG

2.gif

Best Regards,

Bof

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Showing UPN in the People Picket Field

Hello @v-bofeng-msft,

 

Many Thanks for all your support. I used the below as combination of your suggested solution.

 

I have configured the below code in the field where i was needing the UPN. Just substracted the characters using mid formula. 

Mid(Upper(DataCardValue1.Selected.Claims),19,5)

 

Thanks a lot for your help @v-bofeng-msft.

 

Regards,

View solution in original post

10 REPLIES 10
Highlighted
Community Support
Community Support

Re: Showing UPN in the People Picket Field

Hi @AkshayManke :

Could you tell me:

Does UPN mean email address?

Does the GIF below demonstrate the function you need?

1.gif

If so,please try this solution:

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

 1.JPG

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

 

Highlighted
Advocate II
Advocate II

Re: Showing UPN in the People Picket Field

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. 

Snip UPN.JPG

 

 

 

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

 

Appreciate if you can help.

 

Thanks and Regards, 

Highlighted
Community Support
Community Support

Re: Showing UPN in the People Picket Field

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

Highlighted
Community Support
Community Support

Re: Showing UPN in the People Picket Field

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"))

 

1.JPG

2.gif

Best Regards,

Bof

View solution in original post

Highlighted
Advocate II
Advocate II

Re: Showing UPN in the People Picket Field

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

Regards,

Highlighted
Advocate II
Advocate II

Re: Showing UPN in the People Picket Field

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!

Highlighted
Community Support
Community Support

Re: Showing UPN in the People Picket Field

Hi @AkshayManke :

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

1.JPG

Best Regards,

Bof

Highlighted
Advocate II
Advocate II

Re: Showing UPN in the People Picket Field

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

Highlighted
Community Support
Community Support

Re: Showing UPN in the People Picket Field

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

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,905)