cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EC_1
Helper III
Helper III

Send an email if the table is not updated during the day

How can I configure an email
that is send ONLY if the table wasn't update during the day and that says something like this
"The user user.name didn't capture any register today, please verify this"

My DataSource is SQL 

6 REPLIES 6
EricLott
Super User
Super User

You can use Power Automate to do this. You would do a Schedule trigger that runs a SQL view or stored procedure that returns users who have no entries that day. Then, for each result, send an email.

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

And how do i write that Query in SQL?

I would have to see an example of the sql table(s) you're using.

Is similar to this, but in SQL Captura.PNG

@EC_1

Sorry for the delay. Which column in that example is the employee column?

It doesn't appear on the image but the column is "User" and it has the emplyee number, and i have other column with the employee name

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,584)