Over the weekend something changed (I see MS Lists now vs. SP Lists) and my power app is set to pre-filter based on logged in user. Everything was working fine until Monday. One of the Department Values are no longer filtering. I have put myself into each of the other departments and I can see the data just fine. But not one of them. Anybody ever come up on this before?
In my OnStart -
Set(
CurrentUserDepartment,
LookUp(
Receivers,
Receiver.Email = User().Email,
Department.Value
)
)
In my gallery -
Sort(Filter(
'Receiving Requests',
Status = "In Review" || Status = "Assigned",
Department.Value = CurrentUserDepartment,
Len(cmbAssignedTo_1.Selected.DisplayName) = 0 || AssignedTo.DisplayName = cmbAssignedTo_1.Selected.DisplayName,
Len(TxtPO.Text) = 0 || StartsWith(
'PO#',
TxtPO.Text
),
Len(TxtID.Text) = 0 || StartsWith(
ID,
TxtID.Text
)
), Created,SortOrder.Descending)