Fill Person Field

Nicole

• Created May 02, 2022 15:48

Hi Matthias_Walter,

I have 2 fields of person or group. 

I want to insert  them all automatically in 3rd field of type person or group, as summarize of the 2 other fields.

Is this possible?

Kind regards

Nicole

0

• 

  Matthias_Walter

  • May 03, 2022 14:56

  Hi Nicole,

  you could use the following Calculated Function Expression on the 3rd person field:

  var users = [];
  users.push([[singleuser1.Email]]);
  users.push([[SingleUser2.Email]]);
  return users;

   

  This should work on New- and EditForms.

  BR Matthias

  2
• 

  Nicole

  • May 03, 2022 19:05

  Thank you Matthias_Walter. it works :)

  0
• 

  Dan Thale

  • May 31, 2022 20:00

  Matthias, 

  I have a similar scenario. I need to copy a user(s) from a source list's lookup field into another person field on the destination list. A simple Set Field as well as Update an Item actions only are bringing in the first person in the source field and not all people listed. How can I make this happen? Thanks!

  0
• 

  Nicole

  • June 02, 2022 08:18

  Hello Dan Thale

  click on the field set calculate value and use this funcion from Matthias. It works for me well. no set field and update item needed.

  var users = [];
  users.push([[singleuser1.Email]]);
  users.push([[SingleUser2.Email]]);
  return users;

  0
• 

  Dan Thale

  • June 02, 2022 16:06

  Nicole, 

  Thank you for the reply. I have tried this code and while in the test it does show both users from the lookup list, the target field is still only populated with one user. I'll follow up with support directly. Thanks!

  0
• 

  Nicole

  • June 02, 2022 17:22

  Hi Dan Thale

  have you allow multiple selection in the settings of the column person or group?

  Kind regards

  Nicole

  0
• 

  Dan Thale

  • June 02, 2022 17:30

  Nicole, 

  Yes multiple selection is enabled on the target field. 

   

  0

Please sign in to leave a comment.