Table of Users to have access with Show if including access to specific rows that contain specific text

I am currently using this formula to solve the Show if from a table on useremail
IN(USEREMAIL(),SELECT(UserTable[Email],IN([accesslevel], {1, 2})))

What I need as a next step is IN(USEREMAIL(),SELECT(UserTable[Email],IN([accesslevel], {1, 2} Useremail can only view data based on Col3 = specific text in usertable on that email))

If I am doing this for a UX view of a table how can I make it so a useremail can only see only certain rows that contain specific text in those rows. For example useremail can only see rows that column name contains โ€œJohnโ€ and this is specified inside of the Usertable.

0 16 1,562
  • UX
16 REPLIES 16
Top Labels in this Space