Hi, I am having issues filtering my gallery based upon who the current user is. That is, it is not fetching the expected results (or any results at all).
My OnStart function is as follows (Which works)
Set(currentUser, User().Email)
My nested IF within my Gallery is as follows:
If(
currentUser = "email@email.com", Sort(Filter('ListName', BU.Value = "Some BU Name"), Created, SortOrder.Descending),
currentUser = "Email2@email.com", Sort(Filter('ListName', BU.Value = "Some Other BU Name"), Created, SortOrder.Descending),
currentUser = "Email3@email.com", Sort(Filter('ListName', BU.Value = "Some Other BU Name"), Created, SortOrder.Descending),
// Else if none of the above conditions are met - do this
Sort(Filter('ListName', 'Created By'.Email = currentUser), Created, SortOrder.Descending)
)
Problem with AD/Windows, some org emails may be lowercase or upper case. Has anyone got any suggestions about another way to tackle this?
