SharePoint Lookup Columns Filter Delegation

(0) Share

Report

Posted on by admin123413124

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?

Categories:

Using Apps Using Formulas

All responses (1)

Answers (1)

Verified answer

SebS 4,149 on at

Like (0)

Report

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.