Hey Randy, Running into an issue on this one. The following function works perfect for me and as intended. It works for a lot of other people too. However for other people in the organization they cant see any records in the gallery. Here is the code:
If(
Filter_Query.Selected.Value = "1.) Request's I have Approved",
With(
{_usr: User()},
Filter(
'datasource',
Manager.Email = _usr.Email && Status = "Approved"
)
),
If(
Filter_Query.Selected.Value = "2.) Request's I have Created For Others",
With(
{_usr: User()},
Filter(
'Odatasource',
'Created By'.Email = _usr.Email && Not(Traveler.Email = _usr.Email)
)
),
If(
Filter_Query.Selected.Value = "3.) Request's I've Made For Myself",
With(
{_usr: User()},
Filter(
'datasource',
'Created By'.Email = _usr.Email && Traveler.Email = _usr.Email
)
),
If(
Filter_Query.Selected.Value = "4.) All Of The Above",
With(
{_usr: User()},
Filter(
'datasource',
'Created By'.Email = _usr.Email Or Traveler.Email = _usr.Email Or Manager.Email = _usr.Email
)
)
)
)
)
)
All of the users are in the same tenant but have different endings to email addresses. Is there something off the top of your head that could be causing this?
All of the users also have the same permissions in the Sharepoint list.
Like I said, this works perfectly for me but for some end users this code is not working.
