cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CBI_Oshin
Helper II
Helper II

Excel Update Row Error Message: Max Id columns count for a single table exceeded (2)

Hi,

 

I am trying to build a flow that pulls data from multiple CDS entities. I have to look up using 'List Records' and then update the row on an excel spreadsheet. There are only 8 columns on the excel spreadsheet table but I keep getting the Max ID Columns error above in the subject.

 

It seems odd that there is only a max of 8 columns supported on an update row action.

I can't use sharepoint lists or CDS because I have to use a custom GUID to compare the key columns. 

 

Please help!

 

screencapture-emea-flow-microsoft-manage-environments-Default-7e349229-c2d1-4aab-9638-503f03c3af06-flows-shared-f4ebb6aa-5cae-429a-a423-2198d6fff40c-2020-02-20-15_24_20.png

3 REPLIES 3
vikulkar
Community Support
Community Support

 

Hello @CBI_Oshin,

 

You should be able to update a row with more than 8 columns using the update row action.

To update a row, the flow does require the key Column and value.

 

-Regards

 

 

Jcook
Super User
Super User

Hello,

Can you please share the error message.
And a picture of the excel connector. It’s hard to see the connector so zoomed out
It sounds like the key column is the one with the error.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Hello,

 

This is the error code:

 

{
"status": 400,
"message": "Max Id columns count for a single table exceeded (2).\r\nclientRequestId: d5cdfa22-e69c-4523-afee-31f7e470d8bc\r\nserviceRequestId: e0467bda-2b50-4314-8a53-890e23173f2b",
"error": {
"message": "Max Id columns count for a single table exceeded (2)."
},
"source": "excelonline-we.azconn-we.p.azurewebsites.net"
 
Here is the excel connector attached:
 
}Annotation 2020-02-24 084905.png

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,041)