Row filter condition, show only useremail()-related data

OR(CONTAINS([Ansvar],USEREMAIL()),CONTAINS([Eposter],USEREMAIL()))

The above is working ok, but I’d like to add another condition described below to the formula, but writing out it’s logic is beyond my skills…:

CONTAINS([Eposter], GroupAddress[GroupID]) if USEREMAIL() is the same as GroupAddress[UserEmail]

(GroupAddress is a table that contains the two columns UserEmail and GroupID generated from Google groups.)

Sorry in advance if my explanation isn’t good enough.

Solved Solved
0 13 2,223
1 ACCEPTED SOLUTION

Thank you very much. Could you please try the following

OR(
[Ansvar] =USEREMAIL(),
IN([USEREMAIL(), [Eposter]),
COUNT( INTERSECT([Eposter],
SELECT(GroupAddress[GroupID],[UserEmail]=USEREMAIL() ) ))>0
)

Please test well for your requirements.

View solution in original post

13 REPLIES 13
Top Labels in this Space