Help on Disabling button if User Email is not found in SharePoint list

[echodapogi]

Hello Everyone. I have a situation that. i have 5 users in SharePoint list called "tblUsersEmail". I need to disable a button in PowerApps if the current users cannot found in any of the email data in tblUsersEmail. How can i do that? 

Thanks in Advance. 

- Echo

[mdevaney]

@echodapogi 

Put this code in the DisplayMode property of the button.

If(User().Email in tblUsersEmail.your_column_name, DisplayMode.Edit, DisplayMode.Disabled)

Note: you will need to replace your_column_name with the actual column name from your SharePoint table.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[echodapogi · Accepted solution]

@mdevaney  i tried this "If(User().email = tblUserEmail.Title, DisplayMode.Edit, Disabled)" and stillnot working. Sorry i am newbie.

[echodapogi]

@mdevaney  i made it worked. sorry my bad. i replaced the "=" to "in" i should follow the code you gave me. thank you thank you

[mdevaney]

@echodapogi 

You used the EQUALS sign for your code but I used the IN operator.  Use this code.  Make sure the "E" in "Email" is Uppercase.

If(User().Email in tblUserEmail.Title, DisplayMode.Edit, DisplayMode.Disabled)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[echodapogi]

@mdevaney  Yes. Thank you again. 😉