Error string for when an office 365 user has left the organization
Submitted byAnonymouson11-07-201802:18 AM
I'd like to make a suggestion for the addition of an error handling for once an Office 365 user has left my current organization. So the way my app works is that i have a database table of all staff users who can carry out a tour.
This table is populated by the user's work e-mail, inserted from office 365 users and i have a lookup throuygh my app connection to office365 users to locate their profile image (if they have one). The issues then arise when they leave the organization and as a result, their office 365 profile is deleted.
I still need to hold data of the tours they've carried out and just want to do a simple if statement to lookup all offfice365users via the stored e-mail from the database table, and if it doesn't find a record, to display a SampleImage.
However, after trying a range of formulas and starting a thread on here, there doesn't seem to be a workaround without getting the error message on screen load. Thus, i use the following if statement, which means the lookup for this user wouldn't even be in the true statement (as they're not set as a current employer), i still get the attached error.