Answered

help with sharepoint person field, powerapps user field display name

(0) Share

Report

Posted on by tscott07

I need to disable a set of fields based upon the name listed in the sharepoint personfield. I want to use the user field but the sharepoint fields display name is lastname, firstname. user fullname is firstname lastname. how do i split the sharepoint name then where do i put these steps?

I am not sure where to start with using the split and where to put it.

I set the displaymode on the field that i need to be view only to: if(user().fullname, edit, view)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Vijay Tailor 2,961 on at

Like (1)

Report
Copy link

Link copied!
Hi @tscott07

If you are using the form for this requirement, then you can use like below.
for this requirement CLick on Advance in Property tab and Unlock the Datacard First.

Split the Name Like below -
First(Split(ThisItem.ApproverName.DisplayName," ").Result).Result //For First Name
Split the Last Name - Like below -
Last(Split(ThisItem.ApproverName.DisplayName," ").Result).Result //For First Name

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @tscott07 ,

Do you want to transfer person field display name from "firstname lastname" to "lastname, firstname"?

If you want to directly use person field in one item, you could try this formula:

Last(Split(ThisItem.personfield.DisplayName," ")).Result&","& //lastname, First(Split(ThisItem.personfield.DisplayName," ")).Result //firstname

If you want to select person for this field in combo box , display the selected value as "lastname, firstname", you could try this formula:

Last(Split(personfieldcomboboxname.Selected.DisplayName," ")).Result&","& //lastname, First(Split(personfieldcomboboxname.Selected.DisplayName," ")).Result //firstname

Best regards,

Was this reply helpful? Yes No