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

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

SharePoint Lookup Columns Filter Delegation

(0) ShareShare
ReportReport
Posted on by 2
Hi, 

I am building an app to filter to exclude status = Draft.

I use this formula

 
Filter('Meeting Request',ReqStatus.Value <> "Draft")



but turns out it has delegation warning on .Value <> Draft



I checked on my other apps, it was not a problem there



Any idea why this happens?

I have the same question (0)
  • Verified answer
    SebS Profile Picture
    4,452 Moderator on at
    SharePoint Lookup Columns Filter Delegation

    Hi,

    The ReqStatus.Value is a Choice column, which is considered complex in Power Apps. As a result, many functions, including In, Not, and <>, are not delegable operators in SharePoint. This is a common pitfall, as people often use these operators without considering how to reverse-engineer the filter logic for a Status field.

    Typically, you'll have a limited number of statuses, such as Approved, Rejected, Draft, Complete, or Started, depending on your design. Instead of filtering out records that are "Draft," why not reverse the logic and filter for records that match the other statuses?

    In your case, assuming you have three statuses Approved, Rejected, and Draft you can filter your ReqStatus column like this:

    Filter('Meeting Request', ReqStatus.Value = "Approved" || ReqStatus.Value = "Rejected")

    This approach will effectively exclude items with the status "Draft" by focusing on the other statuses you want to include.
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 663 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 398 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 235

Last 30 days Overall leaderboard