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
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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.