App not seeing Managers as Managers for User - AD Email issue Upper / lower Case discrepancy

[ClarkyPA365]

Hi,

Not sure if I've raised this in another message but have now identified what seems to be the cause of why the PowerApp that uses Office365User connector to establish the Manager and Managers Manager who designated for the use in SAP and AD 

The app relates to our HR department for job role changes, salary increase and other HR processes.
The manager or managers manager have to raise the query for the user who they manage.  If your not then an error message is displayed.

The issue is some managers are gettign this error message even though in SAP / AD they are the manager??
The only discrepancy I could see was in AD the Email field had the email in upper case.  So AAnother@test.com.  Those that didn't have this issue the email was aanother@test.com.  
To test this theory I had the Email, field in AD, amended to be lower case.  And they could access the app with no issues. 
How can I make the app see upper case AD Email as loser case AD emails?

I've tried  

 and

But it doesn't change the format??

I'm also trying to get the AD side to default to lower case Emails but I'm not holding my breath for that 😊

[ClarkyPA365]

Hi,

I think I've tried that?

One of the formulas that have been // uses the lower function

This is the Global variable which in the App - OnStart.

So would it be
Set (
_useremail, 
Lower(User().FullName
) 
)

[Pstork1]

That would give you the user's full name in all lowercase, not the email.  That alone also wouldn't change the values in the datacards.  If the manager's emails come in as mixed case they won't equal a lowercase email.  Everything needs to be the same for equals to work.

[ClarkyPA365]

Hi,

This is the formula for Datacardvalue8 (Managers Email)

This is the formula for the error message becoming viable

For the Global variable how would the formula look??

[Pstork1]

1) the code you showed me for _userEmail in the previous reply stores the user's fullname, not their email.  So if you are comparing against that it will be false.

2) I would add something temporarily so you can see the actual values being used for the comparisons.  The code for the one datacard should work, but i'm not sure about it isEmpty and the global value you are using.  

If _userEmail actually contains the lowercase version of their email then the two equals should work.

[ClarkyPA365]

Hi,

Is there away I can use the function 'Or' to resolve this??

So if the email is in upper or lower case, as I'm not sure if when a new person joins their AD account, email format it will be created with....

This is the value of datacardvalue8. As yo ucan see it is in lower case

[Pstork1]

Using an OR is just going to make it that much more confusing.  There is also no guarantee that the email will be all upper case or all lower case.  If its mixed case it still isn't going to work.  But as I mentioned I'm not convinced the case of the email is the actual issue.  I've shown you how to convert it to lower case.  You just have to make sure you convert them all.  I would still add some labels temporarily to see what the values actually are that are being used in your logic.

[ClarkyPA365]

Hi,

I think, it's resolved??
I tested it with one user and it worked.  So asking the remaining to try, which I'm slightly confident it will work for them.

I think the version I was using for testing wasn't exactly the same as Live so, once made them the same and removed some old code it worked.  

Lesson learnt 🙂

Thank you for all you help