EDIT: I CAN'T MAKE THIS POST INCLUDES THE ENTERS THAT I MAKE. IT LOOKS AWFUL ALL LIKE IN ONE PARAGRAPH.
Hi, this is my first post so please apologies if it is not located on the right section. Let me know and I promise to learn where to put upcoming ones.
I have a SharePoint 2013 List. The SharePoint List has several columns, but three of them are "Person/Group" columns. One is configured to show the Name of the person, other the Office of the person, and the third one to show the Department of the person.
My job is to make it simple to the user imputing the information, and avoid him to write three times the name of the person in each Person/Group section. I modify the List form in InfoPath 2013, and tried to connect the other two Person Picker controls to the first one (The one who shows the Name of the user), but if I put more than one values, the other two columns only retrieve the first one.
I searched online and even in forums here, and some options were the Double Eval, but this led me to other issue. It "worked", I wrote several users, and the other two Person Pickers did duplicated the values once I clicked on "Check Names", but it showed them as "i:0#.f|membership|
[email protected]". So then I looked for a solution to remove the "i:0#.f|membership|" part and only show the "
[email protected]", and I found the "substring-after" solution, but I don't know how to write or combine this two formulas (Eval and Substring-after) in order to get the issue solved, or if they are even "mixable".
What I want is that when I write:
First PP - user1 ; user2 ; user3
Second PP -
Third PP -
And then when I click on "check names" it appears:
First PP - UserName1 ; UserName2; UserName3
Second PP - UserName1 ; UserName2; UserName3
Third PP - UserName1 ; UserName2; UserName3
Is there a possible way to make several Person Picker get the values from other? O if not, a way to duplicate the values?
Sorry for the long post, but thanks in advance for your comments!
Have a great day.