I am on SP Online environment. I have a list with multiple columns. One of the column multi line text column (Approvers) has multiple users of below format. Approvers: User1; User2; User3; User4; User5..... using UserProfile Name.
I am trying to create Approver's view. If a user that belongs to Approver's column accesses this view, he should be able to see that item. I added filter to achieve this, Approver contains [Me], which doesn't seem to work.
After digging deep, i learnt that [Me] can only be applied to a User or group column(People Picker).
Any other ideas to achieve this?
Thanks