Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Summary mail

Hi guys,


I want to create flow with 3 sql tables :


First table : personal

Secondary table : Date with ID Personal and ID Medical check

And Last table :medical check


I want to send mail once a month with summary of all the dates in a same mail when Date is below 3 months.


Can you help me ?







Community Support
Community Support



Could you share more details on the tables?

What columns are there in each table?

I assume that in secondary table, there are columns date, and ID personal and ID Medical check. How about the other two tables?


Best regards,


Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yamao-msft


In the first table, i have name of person and in the last table, i have name of medical check.


when the date is 3-month-old compared with the today's date i want to send mail  like this:


Jhon  21/10/2018 Medical chech-up

Steven  21/11/2018 Medical chech-up







Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,554)