I've encountered an issue with a fairly basic task for my client's app, filtering gallery items by the current user. In their powerapps environment, both the User().FullName and Email are different than the CreatedBy.DisplayName and Email respectively. For example, the outlook email and display name will show as "John Doe XYZ Company" and "JohnDoe@company.com", while the Microsoft account info is "John Doe" and "JohnDoe@xyz.com". This is a canvas app using a SP data connection. This is just how the Microsoft accounts are set up, but unfortunately, I cannot filter the gallery of SP list items by the current user using the Filter function that I am used to. Does anyone have any other ideas on how to limit the gallery to only show those items created by the current user? I've read about changing the list item permissions to unique permissions but I would like to avoid that if possible.
