Once a week check records, send email if missing

(0) Share

Report

Posted on by susannarae

138

Hi all,

I have two lists: ELCStaffRoster that has the roster names of staff, and ELCProductivity where staff are expected to add a new weekly productivity summary every week. I'm trying to build a Flow where once a week (on Mondays) Power Automate checks the Productivity list to make sure every user has added a new record. If they don't have a record, their supervisor gets sent an email alert.

I've tried a few different ways to build this thing, but for whatever reason nothing I've started seems to work properly, so at this point I'm ready to just start from scratch. Any advice is gladly welcomed!

All responses (2)

Answers (0)

susannarae 138 on at

Like (0)

Report

Re: Once a week check records, send email if missing

Would I need to build a separate Flow for each staff submitting a productivity report? I certainly can do that, but I was hoping to be able to link the Flow to the roster list. Below are photos illustrating what I have so far; I incorporated your suggestions as well as my roster but unfortunately the email didn't get sent. Any suggestions?
abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: Once a week check records, send email if missing

Hi @susannarae

Here are the steps you needed.

The expression I used above for the IF condition is as follows:

length(body('Get_items')?['value'])

Note: Here I was filtering by Created By field of the record. So the filter query is Author/EMail. Here EMail is case sensitive.

Thanks