SOLVED

Filter SharePoint list items by logged user

%3CLINGO-SUB%20id%3D%22lingo-sub-2936097%22%20slang%3D%22en-US%22%3EFilter%20SharePoint%20list%20items%20by%20logged%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2936097%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20everyone!%3C%2FP%3E%3CP%3EI%20created%20a%20task%20manager%20list%20(which%20also%20became%20a%20PowerApp)%20where%20I%20assign%20tasks%20to%20people%20with%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F241535%22%20target%3D%22_blank%22%3E%40company%3C%2FA%3E.com%20email%20address%20and%20guests.%20In%20my%20case%2C%20the%20guests%20don%E2%80%99t%20have%20access%20to%20PowerApps%2C%20where%20I%20would%20know%20how%20to%20make%20this%20filter%2C%20so%20Is%20it%20possible%20to%20filter%20the%20list%20view%20then%20a%20user%20can%20see%20only%20the%20tasks%20assigned%20to%20oneself%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2936097%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2937745%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20SharePoint%20list%20items%20by%20logged%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2937745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1210158%22%20target%3D%22_blank%22%3E%40WilliamAzevedo%3C%2FA%3E%26nbsp%3BIf%20you%20are%20trying%20to%20filter%20SharePoint%20list%20view%20based%20on%20currently%20logged%20in%20user%2C%20you%20can%20use%26nbsp%3B%3CSTRONG%3E%5BMe%5D%26nbsp%3B%3C%2FSTRONG%3Efilter%20on%20person%20or%20group%20columns.%3C%2FP%3E%3CP%3EFor%20Example%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22filter%20list%20view%20%5Bme%5D.png%22%20style%3D%22width%3A%20391px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F325063i3FE76C3DE63462B5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22filter%20list%20view%20%5Bme%5D.png%22%20alt%3D%22filter%20list%20view%20%5Bme%5D.png%22%20%2F%3E%3C%2FSPAN%3E%3CSTRONG%3EDocumentation%3C%2FSTRONG%3E%3A%26nbsp%3B%3CA%20title%3D%22Use%20filtering%20to%20modify%20a%20SharePoint%20view%22%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EUse%20filtering%20to%20modify%20a%20SharePoint%20view%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%20%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%20%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2958790%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20SharePoint%20list%20items%20by%20logged%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2958790%22%20slang%3D%22en-US%22%3EHi%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373269%22%20target%3D%22_blank%22%3E%40ganeshsanap%3C%2FA%3E.%20Should%20I%20apply%20these%20settings%20in%20every%20logged%20account%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, everyone!

I created a task manager list (which also became a PowerApp) where I assign tasks to people with the @company.com email address and guests. In my case, the guests don’t have access to PowerApps, where I would know how to make this filter, so Is it possible to filter the list view then a user can see only the tasks assigned to oneself?

 

Thank you in advance!

3 Replies
best response confirmed by WilliamAzevedo (Occasional Contributor)
Solution

@WilliamAzevedo If you are trying to filter SharePoint list view based on currently logged in user, you can use [Me] filter on person or group columns.

For Example: 

filter list view [me].pngDocumentationUse filtering to modify a SharePoint view 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Hi, @ganeshsanap. Should I apply these settings in every logged account?

@WilliamAzevedo No, you have to apply these settings only once and any user visiting that list view will see the same results (filtered list items based on their account).


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.