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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (3,378)