how to select a single column?
| id | section | memberUser |
| 1 | ICT Accounting CSE | abc xyz cyz |
| 2 | Bilogy Chemisity maths | hagos axum alamata |
memberuser is a person colum which could have multiple user in each row.
Now i want to display section on level, if the current user is memberUser.
each memberUser contains unique users.
if MemberUser column was a single value I would use something like this on my label or textbox to show section name
Lookup(mysharepointlist, memeruser=User().Email,section)
so how do i display the section name of the current user, if the column is person with multiple users?