I received this error a few times, likely because my oData filter query in an SQL Get Rows action is too long.
"The node count limit of '100' has been exceeded."
Any workarounds for this or any way to shorten a query like this?
Project eq '24-045' or Project eq '23-051' or Project eq '23-058' or Project eq '24-002' or Project eq '23-079' or Project eq '24-008' or Project eq '23-040' or Project eq '22-058' or Project eq '23-087' or Project eq '24-023' or Project eq '24-024' or Project eq '23-017' or Project eq '23-052' or Project eq '24-021' or Project eq '23-003' or Project eq '21-116' or Project eq '22-019' or Project eq '23-011' or Project eq '22-040'
When I get up to about 21 'or' operators, the flow fails (some of the time). My Select statement has about 13 columns, but I need all of those.
Thanks, any help would be greatly appreciated.