Button visible "If" user email in SP List.

[EriSto]

Hi! 
So I tried doing a "visible if user().Email=" code in the button itself, which works great as long as there are 7 or fewer emails.

It can't handle more than 7, as soon as I add an 8'th it stops working. 

So I thought why not make a SP table, with a list of all of the email's that the button should be visible for.

Problem is, I'm stuck....I cant figure out how to tell PowerApp to check emails agains the table in my SP list..

When specifying e-mails directly in the button, I used the following:

If(User().Email="aaa@zzz.com",
User().Email="bbb@zzz.com",
User().Email="ccc@zzz.com",
User().Email="ddd@zzz.com",
User().Email="eee@zzz.com"
)

Which work's great as long as there are 7 or less.

How can I specify to check against a column in a SP list? 

Thanks for any and all input!

[PTBBSolutions · Accepted solution]

Hi @EriSto ,

Try something like this:

!IsEmpty(
    Filter(
        Sharepoint list,
        YourColumn in SP List = User().Email
    )
)

[EriSto]

That worked! Thank you!