I had the below working so that only people in the Approvers list could see all items and everyone else just sees items they create. For some reason, something must have changed because approvers. can no longer see any items, not even their own. If I add myself to the group, I can see everything. Also, if I take my self out, I can only see ones created by me, so I do not understand what could be wrong. Below is my code and an explanation of some of the items. Can anyone see what is wrong here?
Approvers list is a Sharepoint list and Admin is a people lookup column where I have each user on a separate row. This list no one has access to but me. the PowerApp list all the users have edit permission in with the exception of "manage lists" which is unchecked.
Onstart code:
Set(
varUser,
User()
);
Set(
IsUserAdminSPList,
!IsBlank(
LookUp(
'Approvers list',
Admin.Email = varUser.Email
)
)
);
Gallery Items:
If(
IsUserAdminSPList = true,
Filter(
'PowerApp', StatusDrpDwn.Selected.Value = Status.Value || StatusDrpDwn.Selected.Value = "Sort By Status"
),Filter(
'PowerApp', 'Created By'.Email=User().Email && StatusDrpDwn.Selected.Value = Status.Value || 'Created By'.Email=User().Email && StatusDrpDwn.Selected.Value = "Sort By Status"
)
)
