Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Node Count Limit Exceeded in SQL Get Rows oData filter query

(0) ShareShare
ReportReport
Posted on by 636

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.

  • 55552 Profile Picture
    55552 636 on at
    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
    55552 636 on at
    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
    55552 636 on at
    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
    Anil_g 668 on at
    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
    55552 636 on at
    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
    Anil_g 668 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard