How to send a SQL query output as a mail using PowerAutomate and ADF

I have a task in which i want to send a SQL QUERY OUTPUT as mail body using Power Automate and ADF.
i am creating a Lookup activity in ADF where i am passing my query as:
select * from adventure table
where Animals = 'Lion' and Jungle = 'Amazon'.
this table is available in the SQL Database.

the output of the above query i want to send in mail body not as csv attachment but as mail body only in form of table so third party can directly view the data in mail only using Power Automate Flow. this flow should run in every 1 hour daily.

 mail SUbject should look like:
    FROM: People@gmail.com
    TO : Linking@gmail.cok
    Subject: Animals Details
    Hi XXXXX,
    these are the animal details :

output of SQL query: 
in table format

Thanks
Retailer

Below is something you can try to achieve your requirement. After the lookup activity, I used Web Activity and did a post call on power automate as below.

Body - @activity('Lookup1').output.value

Flow in power automate can be structured as below.

Here is the schema generated for the sample data

{
    "items": {
        "properties": {
            "animal": {
                "type": "string"
            },
            "id": {
                "type": "integer"
            }
        },
        "required": [
            "id",
            "animal"
        ],
        "type": "object"
    },
    "type": "array"
}

sample data

[
  {
    "id": 1,
    "animal": "Dog"
  },
  {
    "id": 2,
    "animal": "Cat"
  },
  {
    "id": 3,
    "animal": "Raccoon"
  }
]

Results: