cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Get A Row - Status code 400 - "Max Id columns count for a single table exceeded"

Hi. Thanks for any assistance with this issue, which I just cannot understand.

I have built a flow that takes a Forms submission response (an alphanumeric string) and attempts to find that string in an Excel table column. The column contains some blank cells, but I've also tried putting values in blank to see if it comes up with the same error - it does.

The error returned is status code 400: "Max Id columns count for a single table exceeded", followed by the request ID, etc.

I'm further confused by the fact that the connector seems to work in reference to one column (with the same sort of data) but not for others.

My Excel table has over 500 rows, and 35 columns of data.

I have also experimented with the "List rows present in table" connector, but I understand that has a limit of 256 rows - my table has more than that, and could grow to 1000s of rows.

I'd appreciate any technical details of how the "Get a Row" connector works, and what data issues or formatting issues may be preventing it from working.

Thanks in advance!

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Get A Row - Status code 400 - "Max Id columns count for a single table exceeded"

Hi @PaulHollis ,

 

Could you please share a screenshot of the configuration of your flow?

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Regular Visitor

Re: Get A Row - Status code 400 - "Max Id columns count for a single table exceeded"

There's not much to it: the Get a Row action takes the form data and looks up one value in a table, then that data is to be used to set string variables used in later actions. This all follows a condition action. And it’s part of a complex flow, but this is the only part that’s causing the issue - independent from the rest of it.

Capture.JPG

Highlighted
Regular Visitor

Re: Get A Row - Status code 400 - "Max Id columns count for a single table exceeded"

Hi @v-alzhan-msft 

Did you have any suggestions on how to avoid this error? What issues may be causing it? Any workarounds?

Thanks for any help. This is really bugging me, and preventing a major productivity improvement for my team.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (10,186)