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 / Multiple filters witho...
Power Apps
Answered

Multiple filters without delegation warning

(0) ShareShare
ReportReport
Posted on by

Hi all, cant seem to find an answer i understand in the other questions that have been asked - simply put i need to ilter a sharepoint list with two criteria , heres my current formula that produces a delegation warning but isnt actually showing anythign anyway :

Filter('PO Request North', 'Assigned To :'=User().Email And Status, "Pending")

 

Table is - PO Request North, i want to only view the "assigned to" column that is the current user, and the "status" column where it shows pending.

 

any help appreciated

Categories:
I have the same question (0)
  • Akser Profile Picture
    1,546 Moderator on at

    Hi @hstep,

     

    Is 'Assigned To' a people/person column in SharePoint? If yes, then it is considered a 'complex column' and it is not delegable. Any chance you can add a text column in your list that will store the email address?

     

    EDIT: Actually, SharePoint complex columns will work with Filter (Source), so not sure why you get the delegation warning. Any chance you can share a screenshot of the formula and the error message?

  • hstep Profile Picture
    on at

    No assigned to is just text , however the status is a choice column - that could be the issue?

  • Akser Profile Picture
    1,546 Moderator on at

    If it's a multi-choice column that will give you an error but that's not related to the warning you get. According to the same source, a Choice column should not give you any delegation warning when it's used with Filter, so I'm a little lost.

  • hstep Profile Picture
    on at

    as requested screenshot attached

    error.JPG
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @hstep

    ... && Status.Value = "pending" 

  • hstep Profile Picture
    on at

    Perfect worked a treat thankyou

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 839

#2
Valantis Profile Picture

Valantis 533

#3
Haque Profile Picture

Haque 412

Last 30 days Overall leaderboard