Forum Discussion
ChayceDuncan
Qrew Captain
It's not ideal - but you'll essentially have to break out list1 and see if any of them exist in list 2 using a combo of functions. Best I can come up with quickly is:
var text list1 = ToText(UserListToEmails([user list 1]));
Includes([user list 2],ToUser(Part($list1,1,";"))) or
Includes([user list 2],ToUser(Part($list1,2,";"))) or
Includes([user list 2],ToUser(Part($list1,3,";"))) or
Includes([user list 2],ToUser(Part($list1,4,";"))) or
....
repeat until you hit what you imagine is the practical end of the number of users you might expect.
------------------------------
Chayce Duncan
------------------------------
QuintenCrum
8 months agoQrew Trainee
Thanks Chayce! Saved my brain this morning!