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

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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,547)