Hi @Anonymous ,
I am not sure if this helps you, but Excel as a Data Source, particularly as the list gets bigger presents challenges not seen in other data sources, due mainly to the fact it simply is not a Database. Until relatively recently, Excel had no Delegation ability at all, meaning you could not access anything beyond row 2,000, but improvements have given it some limited ability. Firstly covering your filter
Filter(
Tabela1,
StartsWith(
Nazwisko,
Trim(TextInput7_4.Text)
) &&
StartsWith(
'Numer umowy',
Trim(TextInput7_5.Text)
) &&
Value(Data_liczba) >= varDataFrom22 &&
Value(Data_liczba) <= varDataTo22
)
Providing the Last Name and Contract Number (I needed some Polish Google Translate here), are both text fields, you will probably find they will work on their own in isolation (you might try this as a test also leaving out the date), but Excel simply is not accepting Delegation on the combined filter (I hope I am wrong here).
Now to your date field. You obviously have this stored as Text and Excel simply will not accept Delegation on turning all records into a number and then running through them all comparing it with your Variables. You may have some chance if you stored the value as a number, but again as a combined filter it may present issues.
If you had all of this in SharePoint in two text fields and a date field, all of your filter would be Delegable and work as expected.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
