See attached images! Either something is wrong with my syntax or something very strange is going on.
The same thing happens for the actual rows returned for the data source. I've tried substituting the logical operators with the logical functions--same result. However, when I paste my actual logic into a text field that's evaluated for each record, it prints the what's expected. Any idea what's going on here?
Could you please share a bit more about the data source used in your formula?
How many records existed in your data source? More than 2000?
Based on the screenshot that you mentioned, I found that you have faced a Delegation warning issue with your formula. If the amount of your data source records is more than 2000, the Filter formula you provided could only retrieve first 2000 records at most.
Note: In default, if you have faced a Delegation warning issue in your formula, you could only retrieve first 500 records from your data source. You could change this limit to maximum value -- 2000.
More details about the Delegation issue in PowerApps, please refer to the following article: