web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Need to filter sourde ...
Power Apps
Answered

Need to filter sourde table by user

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

I created an apps and connected SP list as a table. In this SP list  there is a user. I need to filter this table, if user in the SAp list is equal to current user.

 

Please,help

 

Categories:
  • eka24 Profile Picture
    20,925 on at
    Filter(YourSPList,UsernameColume=User().FullName)
  • PranavShroti Profile Picture
    178 on at

    Well you have multiple options available - FILTER, SEARCH etc. You have now specified the exact scenario, hence cannot reproduce it at my end and provide the exact solution. 

     

    Depending on your situation you can use the best possible method. Details - https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

     

    Hope this helps,

    Pranav

     

  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Do you want to filter your list based on current user?

    Could you tell me user field's data type?

    I assume that it is a person data type field.

    Then try this formula:

    Filter(listname,User().Email in userfield.Email)

     //please replace with your user field name

    User().Email means current user's Email.

    userfield.Email means that the Email addresses of the user field.

     

    If you want to filter items that only has current user's email, you could also try this:

    Filter(listname,User().Email = userfield.Email)

     

     

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    It works now, but returns only the firsr record in the list, while I need to see all records

  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Could you tell me:
    1)user field's data type?

    2)the formula that you use?

    Did you use LookUp function?

    LookUp function only returns the first record that meets the requirement.

    I suggest you use Filter function, which will return all the records that meet the requirement.

     

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hello,

     

    User field data type is User or Group

    Formula is

     

    Filter(ППР, User().Email in  'Личный кабинет'.Email)

     

    ППР- list

    'Личный кабинет'- user field in a list

     

  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Do you have delegation warning like this?

    3308.PNG

     

    If so, what you met should be a delegation problem.

    If not, could you tell me you put your formula in which control's which property?

     

    How to deal with deleagtion problem:

    Does 'Личный кабинет' allow multiple choice?

    3307.PNG

     If  'Личный кабинет' not allow multiple choice, it will be more easier.

    Just use this formula :

    Filter(ППР, User().Email = 'Личный кабинет'.Email)

     If  'Личный кабинет'  allows multiple choice, could you tell me how many records in your list?

    If it is 500~2000, you just need to change the non-delegation limit to 2000:

    delegation.jpg

     And you could still use this formula:

    Filter(ППР, User().Email in 'Личный кабинет'.Email)

    If your record number is more than 2000, it is a little complex.

    "in" can not be delegated in powerapps when using sharepoint list as data source.

    I suggest you save your list in collection and then filter based on this collection, because in collection there's no delegation limit.

    Or you need to consider modifying your formula to only use delegateable functions.

    Or else you will get wrong result, for example only the first one in your issue.

    3309.PNG

     

    Here's a doc about delegation problem for your reference:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

     

     

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hello,

     

    My list is much more than 2000 items. I have tried to do it thru collection, but now it returns only 4 records instead of 1, so still not correct

    My formula

     

    Filter(Collection1,User().Email='Личный кабинет'.Email)

     
     
     

     

  • Verified answer
    eka24 Profile Picture
    20,925 on at

    Please clarify, are you getting 1 instead of 4 records, if so then delegation issues raised by my colleagues could be the issue.

     

    If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Please, could you give a hint, how to bypass this delegation issue? Your colleagues sais there is no delegation problems in the collections, but seems to be there is a problem,

    So I need something  else to solve this

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard