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!
Hi @PaulHollis ,
Could you please share a screenshot of the configuration of your flow?
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.
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.
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.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!