Power Automate Error

[Girish_Kumar]

Max Id columns count for a single table exceeded (1).clientRequestId: 6eefe442-c15d-484f-ad34-3cea4a3419bcserviceRequestId: 31544c6f-4e1f-447d-becc-1cbb65781e4f

when i tried get two columns data then its working fine. But if try get three column data then its showing an above error

{ "status": 400, "message": "Max Id columns count for a single table exceeded (1).\r\nclientRequestId: faeac57c-a8cc-40b3-afc0-dd890b4546ea\r\nserviceRequestId: 2fb524dd-5434-4832-bd8b-9500e872ba4d", "error": { "message": "Max Id columns count for a single table exceeded (1)." }, "source": "excelonline-wi.azconn-wi.p.azurewebsites.net" }

[CFernandes]

Hey @Girish_Kumar 

The problem I assume that the maximum number of columns in your excel table has exceeded. Try to get the columns below 20 and see it it resolves your problem.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!