Answered

Match email in table to set displaymode

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

After much searching on here and on you tube, I thought I'd best ask a question as I wasn't able to find the solution.

I'd like to change the DisplayMode on a button from Disabled, to View, but only if the User().Email is contained within a table of users; essentially what I'm trying to do is lock down some 'approval' buttons so that they only appear if the current user is held in a table.

So I've tried setting the DisplayMode formula to be if(LookUp(User_table, Email = User().Email) <> "", Displaymode.View, DisplayMode.edit)

However, this doesn't appear to work, so I was hoping one of you smart folk would be able to steer me in the right direction.

Thanks in advance,

Dan

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Dan,

I would try the following formula to see if that works better.

If(LookUp(User_table, Email = User().Email).Email <> "", DisplayMode.View, DisplayMode.Edit )

If not, I would add a label and set the text property to this:

LookUp(User_table, Email = User().Email).Email

You can then use the result to debug/diagnose the result of the condition.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Fantastic! That worked. Thank you for your help. The tip on a using label to check the output is great too!