I'm running into an issue where a record gallery is not returning the appropriate record for a signed-in user.
Basically, a user will submit a form. Included in the form is a field labeled "Supervisor Email" which is auto-filled based on another field "Supervisor" where the user selects from a list of O365 users.
Then I have the Gallery on a separate screen set up to filter to only show users any submitted forms with the Supervisor email field matching their currently logged-in email.
For instance, if I'm logged in as david@google.com and there are three forms submitted with david@google.com as the Supervisor email, in that screen I will only see those three records.
This has worked for me and many others. I've done extensive testing. But for one supervisor it's not working. I've looked at the form submitted and it looks fine. I've submitted a form myself as a test putting them as the Supervisor/Supervisor Email and still nothing. I've done some troubleshooting with no fix yet. The last thing I tried was disconnecting and reconnecting the SharePoint and O365 Users connectors then republishing the app thinking that this particular supervisor might have hit "Do not allow" on one of them.
Any other ideas? You probably need to see the code, but it's not super complicated. I have on App Start
Set(UserEmail, User().Email)
and then in the Items field of the Record Gallery I have (among other things)
Supervisor.Email = User().Email)
Which again works for at least 10 other people, just not this one user.
