Answered

Hiding fields from user

(0) Share

Report

Posted on by Lefty

1,625

I'd like to 'hide' some fields on my canvas app to certain users, I think I'm nearly there but struggling with the syntax.

I have on my App OnStart:

Set(VarUser, User().Email);
Set(Approver, LookUp(ListName, Email = VarUser))

On my field DisplayMode i have put the following:

If(VarUser = Approver, DisplayMode.Edit, DisplayMode.View)

But i'm getting a red line under = cant see how I get this to work, unless someone has a better suggestion.

The ListName I am 'lookup' has 1 email address (for now) with a coloumn titled Email and the email address is free text, (unless i can set this to person field and it would still work)?

I would like to store all the approvers in this SPO list and the columns i would set to be in edit mode only if the users were in that list.

I tried working with collections, but my items would get deleted and i would like to use this same approver list for many different apps, it makes sense to use a SPO list i can use multiple times.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Lefty

Replace this code

If(VarUser = Approver, DisplayMode.Edit, DisplayMode.View)

With this code

If(VarUser.Email = Approver.Email, DisplayMode.Edit, DisplayMode.View)

If that does not work please provide a screenshot of the error message.

---
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."

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report
Copy link

Link copied!

Hi @mdevaney

please see attached

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Lefty

Can you please try either of these code ideas? Sorry I had edited my answer while you were typing

If(VarUser.Email = Approver.Email, DisplayMode.Edit, DisplayMode.View)
If(VarUser.Email = Approver.Mail, DisplayMode.Edit, DisplayMode.View)

The screenshot you provided does not show the error message, only the red underline. 😞 Can you please supply the error message?

---
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."

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report
Copy link

Link copied!

HI @mdevaney
apologies, attached with error

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Lefty

I missed something in your original problem statement.

Your code currently looks like this:

Set(VarUser, User().Email);
Set(Approver, LookUp(ListName, Email = VarUser))

If(VarUser = Approver, DisplayMode.Edit, DisplayMode.View)

The reason for the error message is you are comparing VarUser (a text string) to Approver (a person object).

Change your code to this:

Set(VarUser, User().Email);
Set(Approver, LookUp(ListName, Email = VarUser, Email))

If(VarUser = Approver, DisplayMode.Edit, DisplayMode.View)

---
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."

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney
Ah so the function works, but the field is also disabled for me, I checked my User.().Email and the format in the SPO list is as its displayed in my text box... refreshed the data source but still the field stays disabled.
Can i use a person field from SPO list as opposed to using a free text column where a user is to type in the email address and using that column as the lookup?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Lefty
Are you saying this function evaluates to true but the field is still disabled?

If(VarUser = Approver, DisplayMode.Edit, DisplayMode.View)

Was this reply helpful? Yes No
Lefty 1,625 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney
Yes that's correct as my email address is in the SPO list
I've saved, published and gone back into the form and seems to be working
Thank you for all your help

Was this reply helpful? Yes No