Answered

How to avoid delegation why filtering or search through a choice field

(0) Share

Report

Posted on by Community Power Pla...

How to avoid delegation why filtering or search through a choice field at the same time searching with a single text column of sharepoint. See below script doesnt work 😥

Sort(
Filter(
DATASOURCE,

StartsWith (EID,txtSearch.Text),
(ComboBox2.Selected.Value = Sell.Value || ComboBox2.Selected.Value = Blank())

), ID, Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report

hello @Anonymous ,
Choice column should not give delegation warning. it could be lookup column to give delegation warning.
Could you paste the screenshot of warning and formula?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I am talking about search that is >2000 records

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Anonymous ,

The point is, as @theapurva said, SharePoint list Choice column is delegable, except you have incompatible data types in filter criteria, selections in Choices column are of type text:

So, please make sure it's a delegation warning but not the incompatible warning. In addition, please check the column type of Sell and share the Items property of your ComboBox2.

Best regards,

Was this reply helpful? Yes No
Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like (1)

Report
thanks a lot @v-jefferni . I will also keep this in mind that people may get confused between delegation and Icompatible warning. 🙂

@Anonymous : please paste your warning like @v-jefferni had pasted.

Try below if its Incompatible type warning.

Sort( Filter( DATASOURCE, StartsWith (EID,txtSearch.Text), (Value(ComboBox2.Selected.Value) = Value(Sell.Value) || ComboBox2.Selected.Value = Blank()) ), ID, Descending)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Oh my initial script works however show blank on the gallery when both of the filter & searchbox are blank

Was this reply helpful? Yes No