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).
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021