I just tried creating and using the connections you mentioned and didn't have any issue. Can you post the specific error or help request if this persists?
I am experiencing the exact the same error message when I try to submit the values on a form to an Excel-file stored on a OneDrive. The issue has existed since yesterday (no updates were made to the app, so I am guessing that the issue is caused by something on Microsoft's side...).
The error was apparently caused by a change in the formatting of one of the columns in the Excel-file, which required the "Patch"-function to treat the value being patched as a number. Would be nice if we are able to receive an error message that was a bit more nuanced.