所以我错过了一个返回对象的类型-
BODY结果集（& R）：给出了太多的信息，因为它看起来有可能有额外的表回来。我只调用了一个表，所以在我的列表的底部我找到了“Table 1”-在使用它之后-它给了我想要的结果-一个单一的表表示。这也将允许我分解数据，并在CREATE HTML TABLE选项下给予特定的头。
我的最终逻辑应用程序将是递归=〉执行存储过程=〉在“Table 1”对象数据中创建HTML表格馈送=〉在CreateHTMLTable中发送电子邮件馈送。

Azure逻辑应用程序- SQL表到单个电子邮件-如何
我在我的环境中复制得到了预期的结果：
我使用过For Each，也遇到过类似的问题，所以我选择了另一种方法：

输出：

逻辑应用程序代码：

{
    "definition": {
        "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
        "actions": {
            "Create_HTML_table": {
                "inputs": {
                    "format": "HTML",
                    "from": "@body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table1']"
                },
                "runAfter": {
                    "Execute_a_SQL_query_(V2)": [
                        "Succeeded"
                    ]
                },
                "type": "Table"
            },
            "Create_HTML_table_2": {
                "inputs": {
                    "format": "HTML",
                    "from": "@body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table2']"
                },
                "runAfter": {
                    "Execute_a_SQL_query_(V2)": [
                        "Succeeded"
                    ]
                },
                "type": "Table"
            },
            "Execute_a_SQL_query_(V2)": {
                "inputs": {
                    "body": {
                        "query": "SELECT TOP (1000) * FROM [dbo].[emo1]\nSELECT TOP (1000) * FROM [dbo].[emo]"
                    },
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['sql']['connectionId']"
                        }
                    },
                    "method": "post",
                    "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('default'))},@{encodeURIComponent(encodeURIComponent('default'))}/query/sql"
                },
                "runAfter": {
                    "Initialize_variable": [
                        "Succeeded"
                    ]
                },
                "type": "ApiConnection"
            },
            "Initialize_variable": {
                "inputs": {
                    "variables": [
                        {
                            "name": "ammo",
                            "type": "array"
                        }
                    ]
                },
                "runAfter": {},
                "type": "InitializeVariable"
            },
            "Send_an_email_(V2)": {
                "inputs": {
                    "body": {
                        "Body": "<p>Tables:<br>\n@{body('Create_HTML_table')}<br>\n<br>\n@{body('Create_HTML_table_2')}</p>",
                        "Importance": "Normal",
                        "Subject": "TABLES",
                        "To": "v-rbojja@microsoft.com"
                    },
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['office365']['connectionId']"
                        }
                    },
                    "method": "post",
                    "path": "/v2/Mail"
                },
                "runAfter": {
                    "Create_HTML_table": [
                        "Succeeded"
                    ],
                    "Create_HTML_table_2": [
                        "Succeeded"
                    ]
                },
                "type": "ApiConnection"
            }
        },
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "parameters": {
            "$connections": {
                "defaultValue": {},
                "type": "Object"
            }
        },
        "triggers": {
            "manual": {
                "inputs": {
                    "schema": {}
                },
                "kind": "Http",
                "type": "Request"
            }
        }
    },
    "parameters": {
        "$connections": {
            "value": {
                "office365": {
                    "connectionId": "/subscriptions/b823f/resourceGroups/rbojja/providers/Microsoft.Web/connections/office365",
                    "connectionName": "office365",
                    "id": "/subscriptions/b83c1ed/providers/Microsoft.Web/locations/eastus/managedApis/office365"
                },
                "sql": {
                    "connectionId": "/subscriptions/b83c1ed3f/resourceGroups/rbojja\/providers/Microsoft.Web/connections/sql-3",
                    "connectionName": "sql-3",
                    "id": "/subscriptions/b83c1ed3-c5b\/providers/Microsoft.Web/locations/eastus/managedApis/sql"
                }
            }
        }
    }
}