Share
Report
27Hi
In my app, I have the following:
A Global Variable: Set(CurrentUser, User())
And a Sharepoint List with the following fields (lots more, obviously, but these are the pertinent ones):
User (People Picker)
Access Level (Choice field)
Various screens are visible or not, depending on the user's access level. All controlled by Look Ups on the 'visible' control.
e.g.:
Audit Screen, Visible =
If(LookUp(UserList,'User'.Email=CurrentUser.Email,'Access Level'.Value)="Full" ||
LookUp(UserList,'User'.Email=CurrentUser.Email,'Access Level'.Value)="Team", false, true)
This works for most people.
However, there are 2 different listed email addresses in user's outlook profile: An 'Email' and a 'Chat'. For most people they are the same, but for some they are different, e.g.:
Email: Joe.Bloggs@company.co.uk
Chat: ha1234@company.co.uk
CurrentUser.Email picks up the Chat address. User.Email picks up the email address.
So for Joe Bloggs above, the lookup doesn't work, because it can't match the CurrentUser.Email with the User.Email. As a result, poor old Joe can't view the page.
How can I extract this 'Chat' email address? Or, set the CurrentUser variable to show the 'email' rather than 'chat' address?
Any help gratefully received
All responses (
Answers (
