I'm trying to build a power app that will filter a List in Sharepoint that will almost assuredly hit well over 2,000 items (I'm still in the development stage so the List hasn't actually been created yet). So delegation is going to be something I have to deal with, and I'm getting the warning message on my formula.
Here's where I'm at right now:
Filter('Test Data List', (Value(Paramin1.Text) < (Value (Parameter1)) && Value(Paramax1.Text) > (Value(Parameter1))) && (Orientation.Value = OrientationDrop.Selected.Value || OrientationDrop.Selected.Value = "") && ( 'Type' = TypeDrop.Selected.Value || TypeDrop.Selected.Value = ""))
Quick summary: I want to filter the list based on an input minimum and maximum value of Parameter 1 (a calculated column), as well as from two dropdowns (OrientationDrop and TypeDrop). I'd also like to sort those based on either Parameter 1 or another field, but let's deal with the Filter first.
I have read the article on delegation and what functions are delegable, but perhaps I'm just not very bright...I don't understand why I'm still getting the delegation warning. I know you can't use the < or > with a text or Boolean, but as I'm converting those columns to Values (numbers), that shouldn't apply, right? Will this formula delegate?
