Any updates on this issue?
I am getting the same error when trying to create a flow that adds an item to a SharePoint list.
I get the same results (inconsistently) when using the SQL Execute a Stored Procedure action to return a Request.Response. Works in Flow/Power Automate just fine.
I just realized that this issue has to be, at least in my case, with the response component. When you say to the component to generate the JSON Schema automatically, it creates a part "required":[.........]. If you erase that part the problem dissapear.
@majuarezg Thank you for the tip - it solved it on my end as well! I actually wondered about that extra part that was added to the schema when inputting a sample of the result output for Flow to automatically determine the schema and even wondered to delete it from the beginning (but sadly didn't).
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021