I'm trying to filter based on if the user has submitted an evaluation. I only want the current user to be able to provide an evaluation if they have not yet. 5 staff maximum will evaluate the same person (Hence UserSubmit1 - UserSubmit5). When adding in the coding for && UserSubmit's I get errors, see below:
With(
{
wGroup: LookUp(
CharterProjectSP,
EmailAddress = User().Email
).GroupCode
},
With(
{
wList: Filter(
CharterProjectSP,
GroupCode = wGroup && UserSubmit1 <> User().Email && UserSubmit2 <> User().Email && UserSubmit3 <> User().Email && UserSubmit4 <> User().Email && UserSubmit5 <> User().Email
)
},
Filter(
wList,
EmailAddress <> User().Email
)
)
)
Can't get the right syntax. How can I fix this?
Thanks in advance.
