Show icon based on logged in user

(0) Share

Report

Posted on by Tango

1,168

Hi,

I have a Sharepoint list called Users that contains, fisrtname, last name, email & a series of yes/no columns that will be used to allow access to certain features.

Trying to allow access by using the visible parameter on an icon by using the following but it is not working

If(User().Email = Lookup(MySPList, ColD=true),true, false)

Thanks in advance for any assistance

Todd

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

EddieE 4,650 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Tango

Try

Lookup(MySPList, Lower(email) = Lower(User().Email), ColD)

EDIT:

Also, it's always way better to stay away from Yes/No columns if you are going to use them in PowerApps. Use Choice columns with choices Yes/No instead - these work a lot better in PowerApps

Was this reply helpful? Yes No
Verified answer

cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Tango

Try this code for the Visible property.

User().Email in Distinct(Filter(Users,ColD=true),Email)

The code above will check if the current user's email is in the list of distinct emails that are filtered using the ColD condition. You don't need true or false here as the statement itself will return only true or false.

If in case you the opposite result, you just use the exclamation point function.

!(User().Email in Distinct(Filter(Users,ColD=true),Email))

Was this reply helpful? Yes No
Tango 1,168 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @cha_cha @EddieE for your responses. Much appreciated

Was this reply helpful? Yes No