I am exporting excel table to SharePoint list and trying to custom view based on group and people using [me] option so that each user get access to records intended for him.
Issue is, while exporting the user field in excel is published as 'single line of txt' and is is not editable in SharePoint 2010.
Please guide how to resolve it.
Customer separate view for each user, than apply condition if user name is 'user1' that column user match name. Issue - dont know how to custome view as per individual user, in list settings.
In sharepoint list itself , add an extra column with data type "people/group' and this colum get value based on entries in another column which is single line of text.