Office 365 Sign In My app allows sign in through any provider. It all work fine with just one anomaly. As Office 365 uses the Users email address to log in with a password the consequence is that both the USERNAME() and USEREMAIL() are the same.
This caused an issue with the reports that we then generate in the Access database that the data ends up in. Is the only way round this to create a user’s table with their details in it and the use a lookup to get the user name rather than call the system function? Is there another system function that can retrieve the correct User Name from Office 365? Any suggestions welcome.