For some reason, Power Automate has stopped showing all available variables, ie only shows a subset, at the end of a sequence of actions. I'll describe briefly and then show you the screenshots.
The action sequence starts with a bunch of variable initializations. Then, these vars get set. The last 3 actions in the sequence are as follows (in order):
1- set json_object_0 var to some json object { ... }
2- use Parse JSON action to create an instance of this json object (and I do provide the JSON schema)
3- use a SQL Insert Row action: this is where the problem arises: upon clicking on each field (as you'll see in the screenshot) the JSON object fields are nowhere to be seen in Dynamic Content; as a matter of fact, even the var json_object_0 does not appear!
Now, I have done this a couple of weeks ago, and the Dynamic Content not only would show the var json_object_0, but would also let me select the JSON object fields.
So what has changed, I ask?
In the last screenshot, the SKIP10::jump to data action that appears in the Dynamic Content list is in actuality followed by another action in the flow. And as you can see, this action does not appear in the Dynamic Content list.
Another related issue is when I use the mouse wheel to scroll down the Dynamic Content list or simply click in on the vertical bar and drag it down, the Dynamic Content list just suddenly vanishes. I don't think it's should be doing that, now should it?
