Announcements
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)
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?
I am talking about search that is >2000 records
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,
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)
Oh my initial script works however show blank on the gallery when both of the filter & searchbox are blank
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 392 Most Valuable Professional
11manish 136 Super User 2026 Season 2
MS.Ragavendar 109 Super User 2026 Season 2
