You’re offline. This is a read only version of the page.
Announcements
39
I have a list of 12 employee names from an outside table based on customer assignment.
I'm using Office365Users.SearchUsers to derive the email from these names:
First(Filter(Office365Users.SearchUser({searchTerm:Trim(Last(FirstN(Split(Substitute(UpdatedSP1.Selected.Result,"/"," "), " "),2)).Value)}),Left(MailNickname,3) = "IND")).Mail
Is there a way to write a loop or ForAll to cycle through UpdatedSP1-UpdatedSP12 and add all the unique emails to a collection?
Collect(
CurrentSPEmail,
{
Email: First(Filter(Office365Users.SearchUser({searchTerm:Trim(Last(FirstN(Split(Substitute(UpdatedSP1.Selected.Result,"/"," "), " "),2)).Value)}),Left(MailNickname,3) = "IND")).Mail
}
)
Share
Report
All responses (
Answers (
