Hi all,
I am working on a power app with the following filter:
SortByColumns
(Filter([@'RPA Hospital Medicines Formulary'],
TextSearchBox1.Text in 'Medicine Name'),
"Title",
If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))
It then gives me a warning that I have exceeded the data row limit for non-delegable queries (which I have changed from 500 to 2,000 as the maximum). However, my data source is over 2,400 lines. What should I change in the filter to enable more than 2,000 rows?
I understand "StartWith" is not, but this will not allow me to search the medicine name when it is a combined medicine
For example, I will need a search function where I can type in "lami" or "zidovu", the second drug will come up. If using "StartWith", typing in "abacavir" is the only option to allow second drug to be shown up.
abacavir 300mg vs
abacavir 300mg + lamivudine 150mg + zidovudine 300mg
I hope this makes sense. Any help is appreciated!
