Convert multi-select text into a List User field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hi, Can I convert multi-select text (if email addresses) into a List User field? Loading a Multi-Select Text field is very easy. However, Loading a List User field is very tedious. I'd like my users to load those formula list user fields by populating a multi-select text field with email addresses. The selected email addresses would need to receive a notification emails - hence the reason to convert to list user field.

Thanks for any help,

Chris

Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,064 Points 20k badge 2x thumb
Try this:

ToUserList(
  ToUser(Part(ToText([multi select text]), 1, ";")),
  ToUser(Part(ToText([multi select text]), 2, ";")),
  ToUser(Part(ToText([multi select text]), 3, ";"))
)

I believe you can have at most 20 users in the user list field.
Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb
Thank you.