How can we send azure database table to users by using email. With schedule time.

Question

How can we send azure database table to users by using email. With schedule time.

Answer 1

@NN Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

Based on the information provided I understand you want to run specific queries on the database table and send the query results in the email using logic app at different scheduled time frames.

If yes, you need to create a workflow with the following actions.

1. Using Recurrence as trigger to run the workflow at schedule time.
2. using SQL connector in logic app and execute query action run the queries on the specific database table.
3. Thereby pass the output of the sql action to the outlook connector and using Send email action you can send an email to the user with the respective data,

You can refer to this thread of similar issue and let me know if you have any further questions on this.