cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EriSto
Helper II
Helper II

Button visible "If" user email in SP List.

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!

1 ACCEPTED SOLUTION

Accepted Solutions
PTBBSolutions
Solution Supplier
Solution Supplier

Hi @EriSto ,

 

Try something like this:

 

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

View solution in original post

2 REPLIES 2
PTBBSolutions
Solution Supplier
Solution Supplier

Hi @EriSto ,

 

Try something like this:

 

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

That worked! Thank you!

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,480)