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!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
susannarae 138 on at

Like (0)

Report

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?

Was this reply helpful? Yes No