Answered

how to filter SharePoint list with the user own records who is signing using the shared link of list

(0) Share

Report

Posted on by Audi86

142

I have an asset management list in SharePoint. This list is prepopulated with all managers name and email with the assets name they have assigned to users under them. I am looking for a way for when i share the link of the list to a manager, the manager just see his own records from that list and give me feedback if these assets are still assigned and active for users.

the goal is when manager signs in the link i share for list, they just see their own records and other records are hidden.

thanks

All responses (19)

Answers (1)

Audi86 142 on at

Like (1)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

@PowerAutomate15 yes, as with the solution for this question I created public view using @Me where user can only see their entries only associated with their directory name and deleted the default All items view for the list. Then we create private ALL item views for every owner for them to manage list.
PowerAutomate15 22 on at

Like (0)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

Have you found a solution to that?
Audi86 142 on at

Like (1)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

Thanks for your additional help 🙂
eliotcole 4,260 Super User 2025 Season 1 on at

Like (1)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

You see, the reason it isn't working is that this isn't the People/Group type of column, it's just a string (text) column.

Also, in fairness, I'll make sure to edit my previous replies to correctly reference the column type as:

Person

or
Person or Group

That should have been more precise.
Audi86 142 on at

Like (1)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

hi @eliotcole i created a new column from list settings, before i was creating from column tab which was not giving me Person Type for column. so now i will move the data from imported column to this new column. For some reason imported column dont allow the person and group type.
https://techcommunity.microsoft.com/t5/sharepoint/i-can-t-set-quot-people-or-group-quot-in-a-column-in-sharepoint/m-p/2373950
Audi86 142 on at

Like (0)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

@eliotcole the one difference i noticed is the type which is "Person or group" on your end and my has different options? Not sure how can i change that type!
Audi86 142 on at

Like (1)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

hi@eliotcole
1- Its a new experience
2- i created a test view and also add my name in the column but its not even accepting the [Me] option
eliotcole 4,260 Super User 2025 Season 1 on at

Like (0)

Report
Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

Hmm, would need to see the setup of that ~~People~~ Person column, to be fair. In the list settings, then the column setting (click the column name) ... get us a screenshot of that there.

The type of information in that column should be:

Person or Group

Plus you will need to have updated at least one record in the list with you as the person.

Also;

... not that it should matter, but is your list a 'New experience' or a 'Classic experience'?

... is the view that you're editing a brand new, test, view?
Audi86 142 on at

Like (0)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

@eliotcole when i am trying to add [Me]. It saying error on top: Filter value is not a valid text string.
Audi86 142 on at

Like (1)

Report

Re: how to filter SharePoint list with the user own records who is signing using the shared link of list

@eliotcole Ok let me try and follow up.