You’re offline. This is a read only version of the page.
Hi
Facing the below error while filtering the data, I have a SQL View where 16 columns in single table/view. when I applied more than 4 filters at a time and tried to filter the data but encountered with error as :
Error when trying to retrieve data from the network: OData query syntax tree has exceeded nodes count limit of '100'. Please try to simplify OData query parameters expressions. inner exception: The node count limit of '100' has been exceeded. To increase the limit, set the 'MaxNodeCount' property on EnableQueryAttribute or ODataValidationSettings. clientRequestId: ee189797-54d6-4ca0-87b1-ac5ee02e8338.
Hi,
I also ran into this same problem.
My data source is a SQL data table.
I have over 30 conditions. PowerApps will begin to cry foul on me if the 21st condition was added to the Filter.
I found that if I were to add a condition pointing to a bit column in SQL table, PowerApps will NOT cry foul and the Filter WILL Work!
Filter (SQLTable,
Condition1,
Contition2, ......
Condition20,
"true" in ABitColumn,
Condition21,
Condition22)
I don't know if this is bug or what. It seems to work for me!
dchan
Share
Report
19
All responses (
Answers (
