Show UX form for specific User Email and Admin Role

[Omar_BEN_SALAH]

Hello , I’m trying to Show a UX Form for a specific user email and Amin role using

OR((USEREMAIL() = “Agents Ext[EMAIL]”), (USERROLE() = “Admin”))

Agent Ext is a table where includes a column EMAIL but nothing happen

[JuneCorpuz]

Omar_BEN_SALAH:

OR((USEREMAIL() = “Agents Ext[EMAIL]”), (USERROLE() = “Admin”))

Try this one.

OR(
	IN(
		USEREMAIL(),
		Agents Ext[EMAIL]
	),
	USERROLE() = “Admin”
)

[Omar_BEN_SALAH]

No it doesn’t work as expected and it doesn’t hide nothing

[Steve]

Omar_BEN_SALAH:

I’m trying to Show a UX Form

Please explain in greater detail what you mean by this.

Where are you trying to use your expression?

[Omar_BEN_SALAH]

I’m trying to use this with Show_IF on UX form

[Solid_IDEA]

Try this one:

LOOKUP(USEREMAIL(), Agents Ext, Email, Userrole)=“Admin”

[Omar_BEN_SALAH]

Not working too , I want to show UX form for Agents Ext table that includes EMAIL column with show_IF

[Omar_BEN_SALAH]

Hello , @Solid_IDEA Thanks for the first reply It doesn’t work at first but i made some changes using OR and IN
OR( IN(USEREMAIL(),Agents Ext[EMAIL]) , IN(USEREMAIL(), Managers[EMAIL]))