web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : aoOP6efA1njZBa+S+JH0wX
Power Automate - General Discussion
Unanswered

Node Count Limit Exceeded in SQL Get Rows oData filter query

Like (0) ShareShare
ReportReport
Posted on 21 Jun 2024 13:29:40 by 673

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.

I have the same question (0)
  • 55552 Profile Picture
    673 on 16 Jul 2024 at 12:20:14
    Re: Node Count Limit Exceeded in SQL Get Rows oData filter query

    The stored procedure method worked!  Need to supply a comma-separated list to the procedure (@ProjectList) with no spaces after the commas: 23-058,23-052,24-004,22-028, etc.

    Runner55552_1-1721131938426.png

    Runner55552_2-1721132363197.png

    The only trick within PowerApps, where I return the queried table records, is that the JSON from the stored procedure call has a table within it. So in PowerApps, the records are buried one level inside the table, and I had to adjust my Power Automate run call to pick up this table.  

    FlowNameHere.Run(ProjectList_Flow.Text).Table1). I was not able to insert a JSON schema into the PowerApps response call to pull out the actual table data to PowerApps, although there is likely a way to do that.
     

    Runner55552_0-1721131502882.png

     

     

     

  • 55552 Profile Picture
    673 on 27 Jun 2024 at 16:33:13
    Re: Node Count Limit Exceeded in SQL Get Rows oData filter query

    I am going to try a stored procedure, then just call the procedure and pass in my dynamic project list as a parameter). I think that would not be limited by this being an on-premises database.

  • 55552 Profile Picture
    673 on 27 Jun 2024 at 15:51:45
    Re: Node Count Limit Exceeded in SQL Get Rows oData filter query

    That was a great idea but I got this error. This is an on-prem SQL Database. 

    Runner55552_0-1719503495871.png

     

  • Anil_g Profile Picture
    668 Moderator on 27 Jun 2024 at 15:22:09
    Re: Node Count Limit Exceeded in SQL Get Rows oData filter query

    @Runner55552 

     

    Instead of get rows you can use execute query in which in operator would be supported

     

    cheers

  • 55552 Profile Picture
    673 on 27 Jun 2024 at 12:16:07
    Re: Node Count Limit Exceeded in SQL Get Rows oData filter query

    Thanks, but unfortunately, within the oData query property of the Get Rows action, the 'in' operator is not allowed. I tried this and it returns an error. Let me know if you have used this successfully.

    Runner55552_0-1719490555534.png

     

  • Anil_g Profile Picture
    668 Moderator on 21 Jun 2024 at 19:25:28
    Re: Node Count Limit Exceeded in SQL Get Rows oData filter query

    @Runner55552 

     

    You can try the below


    Project in ('22-040','23-052') add all upu need in that

     

    cheers

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 736 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 396 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 339

Last 30 days Overall leaderboard
Loading complete