Using the IN() with LIST() and SELECT()

[AdemarN]

IN(
    [E-mail Address], 
    LIST(
            SELECT(Linked Emails[Linked Email], USEREMAIL() = [Login User Email])
           )
   )

It only returns results for the first row it finds in the select statement and ignores any additional rows from the select results. Any thoughts on how I could make it work?

Thanks

[1minManager]

Does SELECT(Linked Emails[Linked Email],TRUE) return all the emails?

[AdemarN · Accepted solution]

I realized after a good night sleep that it actually doesn’t return all email. It didn’t include the USEREMAIL() so I added it as a row and that fixed it. Thanks!

[Aurelien]

Hi @AdemarN

in this expression:

IN(
  [E-mail Address],
  LIST(
    SELECT(Linked Emails[Linked Email],
           USEREMAIL() = [Login User Email]
    )
  )
)

the LIST expression seems superfluous to me, as SELECT already renders a list.
You may want to prefer that instead ?

IN(
  [E-mail Address],
  SELECT(Linked Emails[Linked Email], 
         USEREMAIL() = [Login User Email]
  )  
)

[AdemarN]

Ok yeah I was trying all sorts of things and thought the LIST() would resolve it. But now I know that SELECT is already delivered as a LIST. Thanks!