Answered

email id based screen access

(1) Share

Report

Posted on by Jawaharprem

255

In power apps i have a screen named "Assign tracker" this screen should access for only users table name called user_accesses in dataverse, i didnt get any error in code, 
but i removed my mail and other person id and check its opening or the button should hide for other users expect id's given in that table. how can i perform this...

abc.vc@gmail.com

mnn.mn@gmail.com

in App on onstart - "

Set(varUserAccess,LookUp(User_Accesses,E_mail=Office365Users.MyProfile().Mail))"

on button in visible

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

The code you are using in App Onstart is probably retrieving your email address, not the user's . Change the code to the following

Set(varUserAccess,If(Coalesce(LookUp(User_Accesses,E_mail=User().Mail).Mail,"N/A")="N/A",false,true))

Lookup will find the record that matches the email. Then Coalesce will either return that email or "N/A" if its not found. You can use that in an IF to set the boolean variable.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Jawaharprem 255 on at

Like (0)

Report

Hi,

Thanks for your time.

if updated the below code in app on start "

Set(varUserAccess,If(Coalesce(LookUp(User_Accesses,E_mail=User().Email).E_mail,"NA")="NA",true,false))" no errors

and in button on "Visible" "

If(!IsBlank(varUserAccess),true,false)"

button not visible for me, i getting as below.

Table - i added my id starts with "prem" but the button is not visible.

Was this reply helpful? Yes No
Verified answer

Jawaharprem 255 on at

Like (1)

Report

Hi, this works

On App onStart -

ClearCollect(Alloweduser,User_Accesses);

Set(userAccess,!IsBlank(LookUp(Alloweduser,Lower(E_mail)=Lower(User().Email))))

and in Button Visible - "userAccess"

Was this reply helpful? Yes No